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

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

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

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?

How do you display subform data when switching from form view to datasheet view? I have a form with 2 subforms. The 2 subforms are in "tab" controls. All 3 forms contain the same sql code as the data source. The user would like to look at the form data in datasheet view. When the...

Hi, I recently took DBA Fundamentals I course. I started reviewing for the test using SelfTest Software. However, I do not have any actual experience with the tool. I would appreciate any input regarding preparing for the DBA Fundamentals I course and having actual experience. Thank You...

How do you use the TransferText action and allow the user to enter the destingation for the exported file. When a file name is not specified, I would like Access 2000 to display the "Export Query Window" that allows the user to specify a filename and distination. Leaving this...

Is there a command for copying access .mdb files? I have a requirement to backup the application and backend .mdb's to another drive. The Access documentation refers to Backup/Recovery as using Windows Explorer to copy and paste the .mdb files to another directory. My client wants to do...

How do you programmatically hide/unhide the menu bar?

Will Access 2002 application work in Access 2000? Getting ready to develop an Access application in 2002. User is running Access 2000. I anticipate employing general VBA and plan to be mindful of the Access 2002 functions while developing the application. Will running the Access 2002 be...

What is the VBA command for running a report for a selected record or group of selected records? I am writing an Application in which the user would like to run a report for the currently selected record(s) in a continuous form. Thank you in advance for your help. -Jackie

I execute the same code on two different machines. On one machine it works without error. (Both machines are running Windows 95 and Access 97). On the second machine I get the following message: The Detail Window associated with this error states, "MSACCESS caused an invalid page...

Is it illegal to include a Close command in the "Page" event? The following code is used to execute a report that creates an .rtf file for each POC. The first time the code is executed the code crashes on the DoCmd.Close acReport, "POC_Project_Num" line. The Detail Window...

How do I display the "Startup" options window when the "Allow full menus" option is unchecked? I have inherited an Access 2000 application. Only the File, Window, and Help menu items are available from the database window. I assume that the the "All full menus&quot...