Search results for query: *

Is it possible to loop through records on a query-based form to execute sql statements to update a linked table? I have a continuous form with a on click button that executes the sql statements. This process works fine, but I have anywhere from 1500 to 3000 records that need to be updated...

Hi, I've been looking through the postings for password protecting switchboard buttons. All the postings have helped out a great deal, but I have encountered a problem. On my Main Switchboard form there are 3 buttons (one for each dept.), this is where I put the prompting for passwords...

I have set up a form in Access that pulls data from a PB database through ODBC. I am receiving an error "the recordset is not updateable". Any idea on how to correct this. thanks-kenadys

I have a form with five command buttons. Each command button is linked to a macro. Is there a way to disable the button after the macro runs? So, the user cannot run the procedure more than once during the process.

When I import the .csv file into Access the data in 2 of the fields is missing. I tried importing the data into an existing table and also into a new table. I also checked the data types. Any ideas on why this is happening? Thanks. kenadys

I have a query based on a date range. How can I code it to retrieve the date range I enter and the same date range for the following year. So the report will contain both.

I am working with Infomaker on an existing report. The report pulls data by entering in dates. The data extracted consists of customers and their contracts. The report lists each contract number, but each contract may have serveral of the same invoice numbers depending upon what services...