Search results

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

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

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.

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

I have created a query that deletes and replaces tables, but I do not want the Delete Confirmation message to pop up all the time, how do I turn it off?? I know there are options in the Edit section to turn off 3 other confirmations, but not the delete. I want the macro to run silent without...

I want to create a form that just counts the number of records in a given table and displays the total number of records in the table. Also, putting a button or something by the total in the even the user wants to access the table. Anyone?? Shawn.

Is this possible?? I am doing this with a 3rd party macro right now, but would like it in VBA so I can run it directly from access prior to my queries. Basically what the query below does is look at the source path for a filename that has the current date in it, and if it's todays date, it...

I am working with a system where on the accounting side, each record has an account number, but on the operations side, the records have a record number. I have created a lookup table to match the account number to the record number but I still need to reconcile. At this point, I have all...