Search results for query: *

You can create a macro with the action "sendto" Fill in the action arguments... form, form name, etc. On your form create your button under the button "on click" event procedure 'Declare variable Dim stDocName As String stDocName = "MacroName" 'Save Record to table DoCmd.DoMenuItem...

It totally worked. Thank You SOOOO Very Much!

I tried this do until loop, but it stops after the first record is updated. It won't move on to the next record(s). Me.RecordsetClone.MoveFirst If Me.RecordsetClone.RecordCount > 0 Then Do Until Me.RecordsetClone.EOF If COMP_CODE = "01" Then DoCmd.RunSQL (STRSQL10) DoCmd.RunSQL (strsql11)...

Here is the SQL statements I have in the onclick event procedure of the button. So for each record on the continuous form I click this button to execute these statements. I am working with 2 tables a.) DBA_SD_SOLN_CODE_DETAIL_ACTUAL b.)updates (query underlying the form) 'COMPANY 01 SQL...

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

I just looked at the code behind the switchboard, each button calls a function by the same name HandleButtonClick(1)-HandleButtonClick(8)on any switchboard within the main board. I see where my problem is. I put my prompt for password in the 'on click' event for the (ex.) 1st button...

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.

Thanks anyways, I figured it out. I forgot to define the data types in the import specs. Oops. -kenadys

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