What is the Sendkey syntax (using a macro) for calling the Windows Print Dialog?
I would like to call the Windows PRint Dialog via a command button.
I created a macro and designated the "SendKey" action.
I referenced Access Help for the syntax but when I select the command button the print...
When the user is in form view and uses the "Find" option, the next time the user enters the database and launches the form, an error message window requesting input for a variable is displayed. The variable references a form that is no longer in the database.
When this happens, the...
What causes the Order By property to be filled in on a form?
When the user employs the Access menu find option the Order By property sometimes gets populated. The form contains a subform. The value it is populated with references a form that no longer exists in the database.
How can I...
I have a form with 2 tabs. Each tab has a separate table as the record source. A one to one relationship exists between the two tables.A one to many record exists between the primary form and the data source for the 1st tab.
When selecting a record on the first tab, how do you display the...
I think that I narrowed the problem to a specifc table.
When I attempt to import the table to a new database, the "Microsoft Jet DB engine stopped the process because you and another user are attempting to change the same data at the same time".
since I am working off of a...
What is the cause of the "Invalid Argument" error?
We have a split data base. The front-end is on the user's c:\ drive. The backend is on a network server. The user has full access to the directory and folders where the backend is stored.
Suddenly, the application is displaying an...
How do you convert a time() value to a string and not include the colon.
For example, if time() = 13:05:22. I would like to capture it as 1305.
I tried the str(time()), but got an error. I also tried using str(time() format"HHMM") but got an error too.
I am collecting the current...
What is the correct syntax for
1. converting time() to string
2. showing the value in hhmm format
3. do not include the colon separator
The result should be 1223 for 12:23.
I use =Str(Time()) to get time converted to a string, but am having trouble getting the hours and minutes only without...
OK.
Here is the syntax that I tried and I still get the NAME# error:
=[Forms]![frmPermits]![TabCtl0]![sfrmInspections].[Permit]
Main Form = frmPermits
Subform control = TabCtl0 (this is the object that contains the 2 subforms in tab format)
Subform name as in database window =...
I have a main form with 2 subforms.
The subforms are within a tab control. Each subform is a tab.
I want a field on the 2nd tab to default to a field value on this 1st tab.
What is the correct syntax?
I currently have:
=[Forms]![frmPermits]![Subform]![sfrmInspections].[Permit]
I followed...
I have a form with a subform.
The user would like to switch to datasheet view to peruse the subform data.
When switching to datasheet view allows the user to see the associated subform data by clicking the "+" sign. This displays the subform, but not in datasheet view.
Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.