Maverick
Last Activity: Jun 30 '07, 03:36 AM
Joined: Sep 23 '06
Location:
-
There is no query fo the form. The only quries are starup are the datasource for the controls. -
Too many controls in form?
Is there a limit to how many contols a single form can have. I am working on a search engine and have all the fields from a table as combo boxes for users to select criteria or text boxes for users to select strings. Everything seems to work fine, but every now and then I get the following error:
"Reserved Error (-1104); there is no message for this error" - the form then does not open
Now this does not happen... -
Calling a function
I'm trying to call on a function I created as follows. The stored functions is saved as :
Public Function GetCaps(masterk ey As String, id As String)
---All the code
End Function
I am calling the function from a form as follows:
Call GetCaps(Me.Text 3, Me.Text5)
variable masterkey is stored in the forms' Text3 and same for id.
When I click the button, I get the... -
Thank you. Works beautifully. Would it be possible to now do a "Save As" to the file I just created and pass the new filename with a variable? Thank you so much for your help.Leave a comment:
-
Run-time Error '1004'
I'm new to this, but I have received so much great information here, I had to join. Here is a problem am encountering with the following code in MS Access:
objSht.Activate
objSht.Range("A 25:H44").Select
objSht.Range("A 25:H44").Sort Key1:=Range("A2 5"), Order1:=xlAscen ding, Header:=xlGuess , _
OrderCustom:=1, MatchCase:=Fals e, Orientation:=xl TopToBottom,...
No activity results to display
Leave a comment: