Search results

I have a copy command button on a form as shown below (see VBA). I want to replace my "Message Box" note with an actual command to that will make sure this checkbox is 'null' after a copy of a record. Please help - thanks Private Sub previous_record_button_Click() On Error GoTo...

another error see attached print screen

reply error message An expression you entered is the wrong data type fpr one of the arguments see code below Option Compare Database '------------------------------------------------------------ ' Macro2 ' '------------------------------------------------------------ Function Macro2() On...

reply Option Compare Database '------------------------------------------------------------ ' Macro2 ' '------------------------------------------------------------ Function Macro2() On Error GoTo Macro2_Err DoCmd.SendObject acQuery, "Final Effective Changes Rpt"...

reply I tired modifying the VB I displayed but still no luck. Did I miss some syntax?

reply I type the addresses into the macro. I need to send it to 8 people.

I forget to post that it did work.

On the send object TO: line, I cannot get Access to recognize sending an email to multiple addresses. I have tried a comma and a semicolon. I have tried single quotes and double qoutes. When I convert the macro to VB it displays as follows. "myemai@123.com;myemai2@123.com" It picks the first...

thanks - works great I am not a good VB guy but I undertand this and it worked

I wish I could send it but I cannot. I prety much need VB to be able to create the file name dynamcially. Maybe based on text in another table/field? thanks

I have a form with multiple checkboxes. The user clicks the box for the type of report to run. The issue is that when the user clicks a box they have to click the mouse to the next record so the checkbox actually writes to the table. Is there a way to change this setting? thanks!

My categories such as shoes are stored in a table where a Yes is stored from a check box entry from the user. This table is joined to a master table on category name which has the value shoes stored in a field. Therfore, when the user picks shoes then all records (20 columns) with shoes in the...

I have a form that exports to excel in datasheet view. To run this report a user opens a form and clicks a checkbox to detremine what category of records they want to export. In other words, their is a list on the screen such as clothes, shoes, belts etc. If the user checks shoes then the...

I am having the same issue. Can't seem to find a solution to my problem here or in a few reference books I have on my shelf here at work. I inherited several access databases from my predecessor a while back and although I’ve fixed most of the pre-existing problems and re-programmed most of...

I tried both both replies it is not working for me? any other ideas

I figured it out! thanks BOB as always..........

still no luck see attached

does not work no luck see word attachment - thanks

I have a text date as follows: 09192002 I want to convert to a date and be able to filter by date ranges. I have searched this forum for about an hour and nothing is working. I am using this: New Effective Date: CDate(Left([pho_dir]![EFF_DT],2) & "/" & Mid([pho_dir]![EFF_DT],3,2) & "/" &...

Send Object Issues -------------------------------------------------------------------------------- I am trying to send a query to 3 e-mail recipients using send object in a macro. I use the TO: line and separate each email with a comma For some reason, it only emails the last email on the...