Recent content by Jackie

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