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

Thanks for the suggestion. Not seem to be working. Has anybody used the direction property with the QueryDef object for a return value and input parameters? Thank YOU

Thanks for the reply! I tried you suggestion and got another error. Error 3065 - Can't execute a select query. Any more suggestions? I'm lost! Thank you.

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

THANK YOU!!! That was it. Your wonderful!!!

It goes to the main menu correctly with out the error.

Thank you for your reply!!! Yes, the target is pointing at the correct database. I created the short cut from explorer by right clicking on the actual mdb and using the create shortcut menu. Any suggestions?

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

Thank you!!! That did the trick!!!! [bigsmile]

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

Thanks for your suggestions! They helped alot. I had the subform name spelled wrong. I did use your suggestion concerning loading the form with minimum set of data.

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

That's exactly what I needed. Thank you for your help!!!

I use this make table in a datasheet on a form. It does not matter and not likely if records have the same TotalCumOThrs. Thanks again!!!

SELECT Tbl_Employees.Last, Tbl_Cumm_OT_Hrs.[Total Cumm OT Hrs], autonumber() AS Emp_count, Tbl_Employees.Dept, Tbl_Employees.Group, Tbl_Employees.Shift, Tbl_Employees.Area, Tbl_Employees.Clock, Tbl_weekly_Manpower.Mon_E_Sch, Tbl_weekly_Manpower.Mon_O_Sch, Tbl_weekly_Manpower.Wk_End_dt INTO...

I already tried that. I get an error message Undefined function in expression.

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

Hi Jeff, Things are working Great now!!! Thanks a million for your help!! Karen

Hi Jeff, Thanks for the reply. The primary key for tbl_employees is clock. There is a one-many from tbl_employees to tbl_weekly_Manpower. Does this make a diference?

Hi jeff, Thanks for your suggestions!! I reviewed them and I still can't get it to work. Here is the SQL for the dataform. SELECT [last]+", "+[first] AS empname, Tbl_Employees.Shift, Tbl_Employees.Area, Tbl_Employees.Clock, Tbl_Cumm_OT_Hrs.[Total Cumm OT Hrs]...