Recent content by smpayne

Perfect! Thanks so much for your assistance.

Thanks Actually, I downloaded your file and found that I could use it. However, is there a way to have it default and over to a specific directory location?

I have a form in which I want to place a box that has a specific file directory displayed at all times for the user to open files from. Please help!! Really new at this. :)

Thank you! Excellent! Much appreciated.

I have a simple form where a user selects a query from a drop down list. I need to have the query apply a date range that has also been selected in the form. Would I call to the date form fields from the query as a variable somehow?? If so, could someone show me the syntax? I am extremely...

I am new to Access and need to perform an update query. Basically I have my Main table that has 2 fields (Name and Account). On a daily basis, I want a Test table to update the Main table with the account number changes. Like I said, I am new, so if someone would kindly send me an actual...

I have a table in my database called AcctTask. In this table I have fields called 'task', 'status', 'start_date'. What I need is a module that will run through the table and kickout a total of a specific task and status for each day in March. eg: TASK STATUS START DATE TOTAL...

Perfect! Thanks for your assistance!

I have an access table where I want to copy the contents of an interger field called "Loan_ID" to a text field called "cLoan_id" within the same table. Is this possible? If so, could someone show me how to do such a thing. I was thinking of an Update Query, but am so new to Access, I...

I have a table in Access where the first field is an Interger field called "Loan_id". I have added another field to the same table which is a text field called "cLoan_id". I want to copy all contents of the Loan_id field into the cLoan_id field so that I have the same information in both...

This is probably pretty simple, but I am very new to Access. I have created a table and there are duplicate account numbers in the first column of the table. How do you remove the duplicates from the table?? Is there are query I can use? Any assistance would be appreciated! Shawn.

This is probably pretty simple, but I am very new to Access. I have created a table and there are duplicate account numbers in the first column of the table. How do you remove the duplicates from the table?? Is there are query I can use? Any assistance would be appreciated! Shawn.

Update I just noticed that my Macro name has changed in the Excel workbook. I named it Update, but when I just checked, it renamed it Team1!Update.Update??? Guess that would throw a wrench in it huh??

Update Ok, I got some values. In the following statement where I get the MissMatch error 13: Set rs = CurrentDb.OpenRecordset(strQuery) It says rs=Nothing and strQuery="01_HRS_POOL_TEAM" Does this help??

Errrg This may sound stupid, but when I try to step into the code with F8, I get that annoying 'Bell' sound. It just won't let me. When I hover the cursor over the highlighted area in debug, nothing comes up. I have attached the complete code for both the Form and the Module: I really...