Recent content by SteelersFan

Beginners don't always know how to ask the question. You don't seem to get that notion. I've been following this board for awhile and you seem to get your kicks out of writing saracastic, condescending replys. People seem to have this strange personally change when the are 'talking' via the...

You reek with sarcasim. I see you hovering over this little bb waiting to pounce on anyone who asks a question that is not worded to your liking. Location 1 is an example only. "where is my wildcard" is a good start to helping me out. Dave in Philadelphia, Pa

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...

duh, I changed the form background and that did the trick.

Not bad.. Except I want them there for their information. Dave

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...

Thanks for the response. My forms are linked to queries. What do you mean by 'un binding them'? The USA is a great place (except the hicks in the south) and of course our dimwitted leader George Bush.

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...

Why not just delete the record and re-add it?

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...

We have a logon screen which keeps the splash screen up unitl the user logs on. Gotta have some sizzle with the steak :) :)