Search results for query: *

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

I am having trouble duplicating the problem. I will be in touch when I can get the problem to recurr. Thank you for your help.

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

My question is "Why does the "Order by" property get filled in after the user does a "Find"?

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

Is there a method for labelling the form navigation buttons located at the bottom of a form?

What is the syntax for forcing a cursor to a specific field on a form?

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

Yes. However, an error is generated on the backend and displays a window asking if the error should be sent to microsoft.

yes. I checked the references. I have been able to run a previous version without error. Is it a safe assumption that the data tables are corrupt?

This message is displayed when viewing the data tables,selecting a column (especially date fields), and selecting the sort icon.

Thank you. The message appears when the query is run. I think the problem may be when with the tables linked in the backend .mdb.

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

Here is the syntax that worked: =[Forms]![frmPermits]![sfrmInspections]![Permit] The tab control did not have to be referenced.

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?