Search results for query: *

I am working on a query that links two tables. Table 'A' is a list of employees. Table 'B' is a list of employees with safety visits. I want to create one query with all employees and any safety visits YTD. My issue is when I select the Safety visits for Year 2009. I get only the employees...

I am trying to call an oracle function via MS Access with three parameters. I am getting an error. VM_Delete_Chem is not a procedure or undefined. How do I call this as a Function to return an integer. Please help!! Thanks you!! Code: Dim db As Database Dim qryOracleProc As QueryDef...

I created a shortcut for my mdb. I get the following error when I double click on the icon, "Windons cannot find mdb. Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search". I press the OK button and the access mdb is...

Hello, I am having a problem with the following code. When the returnkey is pressed the correct procedure is called but I lose the value in the txtpassword text box. The text box value is Null. Why is this happening? Please advise. Thank you!!! Private Sub TxtPassword_KeyDown(KeyCode...

I am working on a form with several subforms that runs extremely slow. I tried to disable name autocorrect. I read the tread 702-206410 that states to unbound your form and set the record/countrol sources in the Load event of the form. It's not working for me. I'm getting a runtime error...

I have a query that envolves 3 tables. The resulting make table need to have a field with a sequential count. Please advise!!! Thank you

I have a form I am trying to develop with an subform which has a datasheet that is updateable but some of the fields in the datasheet are display only. I created a query to populate the datasheet but now I cannot update the fields. How do I acomplish this. Thanks in advance you any advise you...

I am linking to a Oracle database via VB code. I am using DoCmd.TransferDatabaseLink command to link to 6 tables in a data base. Some of these tables have indexes and some do not. On the tables that do not have indexes a MS ACCESS dialog pops up to select unique record identifiers. This...

I am linking to a Oracle database via VB code. I am using DoCmd.TransferDatabaseLink command to link to 6 tables in a data base. Some of these tables have indexes and some do not. On the tables that do not have indexes a dialog pops up to select unique record identifiers. This dialog is...

I am having a problem importing a text report file. I need to import it in the exact record order as the original report file. When I import it via import specification file the order changes. The report in chopped up in pieces. I do not have any indexes on the file. Any suggestion?

Dim dbsHOlD As Database, rstDAA As Recordset Set dbsHOlD = DBEngine.Workspaces(0).Databases(0) Set rstDAA = dbsHOlD.OpenRecordset("tbl_daa1_cleanup") I get an error of type mismatch on the set rstDaa line of code. The table is a valid table within the access project. I am working...

When I try to get into MS Access help files or VB help files I get a minimized help screen that I cannot be restore. The restore is disabled. Why won't the help files display? I have tried to reinstall Access 2000 and it does not help!!

How do I change only one column heading text on a datasheet in a subform to be italic? When I change try the whole datasheet changes to italic not just one column.

How do you make the current tab page text bold?