Search results

I'm a beginner to VBA but want to have a statement in a form that will flag a message when the value of two fields = x and y (on before update event) If Me.Location.Value Like [location 1] = True and me.testdesc.value = "test1" Then MsgBox ("Your Test and Location are not correct!!!") Why...

How do I make a query that shows me the differences between two tables with relation to the fields.

I started a two threads each asking differnet questions but one got locked because phil thought it was redundant. (one asked about code not working and one asked about .enabled=false making the text fuzzy). So it was not the same question.

I want to have code that disables fields based on the value of the contents of one of the fields. I wrote this code which goes on and on but it doesn't work. Can someone help? Private Sub Form_Open(Cancel As Integer) Dim Item_Number As String If Me.Item_Number = "300123C" Then...

I have a form that has code tied to the 'on open' event that is going to be accessed by users where we want them to only have access to certain fields which we want them to fill out. The fileds that will be locked will change based on the field called 'Item Number'. The code will be long...

Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair. I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db. I...

I work at a Phamaceutical company in the US (based in London) and have a database that tracks atypical events. It has normally about 10 concurrent users and continually (once a week sometimes more sometimes less) corrupts. I have spent a lot of time validating the database writing the user...

Our company Access database got screwed up today. I did the normal /repair to try to fix it and it the repair came back that it had successfully repaired the database. I did a compact and it came back with an error message at the end about not having rights to the database ( I was logged in as...

I want to put a splash screen on my database. Good idea? I named the .bmp file the same name as the db, but it comes up with the NT WorkStation Company Name Product ID This info uglys up the splash screen. How do I get rid of it. Do you guys have a good splash screen you want to give me?

If you have a split database already, is it hard to migrate the back end to SQL Server? I work in the pharmaceutical industry and the database is validated so I want to see how much qualification/testing I have to do for this. Will the database be noticibly quicker? Everyone accesses the...

Something that would jazz up a database used by my company. I thought a whirlling tornado with data coming in the funnel would be cool. Data signified by 1's and 0s. Any other ideas for a cool splash screen to use in leiu of the MS Access one? email: daverb@verizon.net

I have a problem that everytime I want to roll out changes to a front end, its impossible to get all the users out of the db. Can someone suggest something to help me with the following: 1) Alert users via a message generated from the application and only useable by a member of the group...

Background Multiuser database (10 users concurrently, 120 total). Split db. both on same server. Users access database via a shortcut that has the workgroup file built in. We have had the same the following problem occur probabaly 5 times in the last few weeks. Problem: :mad: The mdw file...

I have an access database at work that is split between the forms/reports/queries (front end) and data tables (back end). Both are located on a file server. I have a shortcut (read only) that is accessed by the people wanting to open the database. The MDW/Security file is located in the same...

I am going to execute a lengthy validation protocol that I wrote for my company this Friday. The protocol involves printing out the 'before' tables and then running append queries to transfer the records to the new database tables. A compare will be from the electronic records in the new...