Search results

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

Type Missmatch?? fpendino, I am getting a Type Missmatch in the following location, any thoughts?? (I have highlighted it Red) 'Export data is another function that will export your data. 'Update the query Names to your real Query Names 'Update the Sheet Names...

You are a GOD!!! Thank you so much, I will begin work right away and get back to you with my results. Again, thank you!! Shawn

CSV Paste to Excel I actually created the Excel workbook so that I always Special Paste into Cell A1 for simplicity and the format never changes. Also, the workbook contains 4 tabs for four different queries, but again, they all get pasted into A1. Hope that clarifies, and thanks so much for...

Is this possible?? I have a few queries which I run on an Access database, then I manually Copy and Special Paste (csv) into an Excel spreadsheet. This data is then used in a pivot table. I would LOVE to automate this procedure. Is there anyway in doing this with a macro or VBA that me as a...

Thank you! I didn't even see the SetWarnings command in the macro editor. Thanks man, you saved me a huge headache! Shawn