Search results

I don't see an undo event in the form's event tab listings. I am using Access 97. Is it perhaps not available in Access 97? Thanks..

Would like to be able to reset a combo box when a user hits escape and so resets the text boxes. So for example, a user selects a value from a combo box, then enters a value in a text box, but then decides doesn't want that value, so hits escape. On the 'on escape' event I would like to...

Perfect! Thanks..

I have some code as: Dim ctl As Control For Each ctl In Me.Controls ctl.Locked = False Next ctl Which doesn't work I assume due to the fact that not all the controls on my form have the 'locked' property (some are lables, some command buttons).. So, wondering how to select...

ok, thanks to all your contributions, i;ll give it a shot..

I have a form that if field 1A is populated, then field 1B must also be populated. If Field 1 isn't populated, then field 2 can be either populated or not (null).. There are 24 "A" fields and 24 corresponding B fields. So for example, if field 1A is populated, then field 1B must also have a...

That worked! Thanks so much for your help!

Thanks, that works. Also I think I'm having an issue with code placement with this. The form that has the variable I want set opens the form that sets the variable. However, the next line of code is supposed to continue based on the decision made and selected in the newly opened form. In...

I have code that I would like to set a variable in an open form from another open form. I get an error when using the code pasted below: "Application Defined or Object Defined Error.." Can someone tell me if you can set a variable dim'd in another form and if so what the syntax is...

Yeah, I can appreciate reasons for that. Actually, this project is an overhaul of a previous database I created that didn't use temp tables. It did work, but I didn't like what I had to do relative to some of the processes in the database. So, I thought of giving each user their own table and...

Thanks for that Speakers 86.. Actually, I figured it out. In my code, I do a count to see how many records there are in the temp table. In doing so, I create a recordset where I set the object variable "r" to the temp table. I have to release that object variable from the table since it is...

I understand what you are saying, however, I cannot change the way I have set the database up.. In that light Are you saying that you do not know why I am getting the error? If you don't know/cannot help me, then please let me know..I fully understand that you do not approve of the methodology...

I have to delete the table, it is a temp table. Allowing it to exist would unecessarily clutter the database. I cannot change this. Do you have any ideas why I cannot delete the table?

Its the standard in our company. All of our datawarehouse tables use 12/31/9999 for expiration dates as a way to say there is no expiration date.. Not sure why that has anything to do with why I'm getting the error?

Thanks, I'll take a look at Lebans..

I have some code that exports a table to a users temp drive as an excel file (using transferspreasheet) then, I want the table that was used to be destroyed.. However, after the transferspreadsheet command is run, I get an error saying that the db engine couldn't lock table tblname* because its...

I have some code which inserts data from a form into a table. The data inserts into the table fine. However, upon inserting the date into the field exp_dt, even though the date is inserted into the table field, I still get another "error" table created. When I open the error table, it shows...

ok, never mind I figured it out..using the Scripting.FileSystemObject is much better.. As to my first issue, the file name in the transferspreadsheet was out of whack and also when i corrected it found out that.. It appears you have to set two different variables for the file path. One...

I tried this using what you suggested as per the below code.. It does create the directory, but when it tries to execute the transfersopreadsheet command, I still get a runtime error (3051) which says: the ms jet db engine cannot open the file 'c:\temp\maaps'. it is already opened exclusively...

Thanks, any idea about the other runtime error issue? Note, that I set up some more code as a test and it worked. This is really confounding me.. other code that works: MkDir ("c:\temp\testdir\") Kill ("c:\temp\testdir\*") RmDir ("c:\temp\testdir") what's the difference?