Search results for query: *

Thanks Ed. Got it to work.

Thanks for the reply. Now I'm getting a "syntax error in drop table or drop index" message.

Hi: The function below deletes a specific table with the user supplying the table name, and deletes it if it does. But the function returns an error "table not found" if the table name has a space in it. How can I get it to accept the space? Thanks for the help in advance. Function...

Thanks for the reply. Do you have an example of how I would run an insert statement in the backend database from a front end form? I have absolutely no experience in this. I always thought that this was not possible.

My Access database is divided into a front end with all the forms and backend with all the underlying tables. How can I get the backend database to perform a repetitive function, in this case, search for the existence of a specific table every 30 seconds, and if it exists, insert the data into...

Got it. Thanks.

I'm getting a runtime error 3061: "Too few parameters" when I try to create a dynamic query def based on two parameters. Thanks for your help in advance. S1 = "Select [User Name],[Password], [Administrator] from [User Accounts] WHERE (([User Name]= [Forms]![Login]!UID) And ([Password] =...

Hi: Thanks for responding. I found an example from another site. Sorry I didn't get back sooner. Posted the code below just for the hell of it. Private Sub Form_Open(Cancel As Integer) Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox If ctl.Name Like...

I want to disable all controls on a form open event execept of the textbox Employee ID. Is there some loop procedure I can use to accomplish that?

Thanks. Got it to work.

Hi: Here is the following simple one code I have in the "On Change" event of combo12 combo box: Private Sub Combo12_Change() [Forms]![Orders Form]!Text25 = DLookup("[Unit Price]", "Products", "[Product Description]= '" & [Forms]![Orders Form]!Combo12 & "'") End Sub I want to use the selected...