Search results

Is it possible to open a database Form in the Windows 10 Startup folder ? I want to power up a PC and after the 'Desktop' appears, the MS Access Form opens.

Is it possible to send a VBA text message to a cellphone SMS (Text message) ? If so, please provide sample code. Thanks ! ! ! ;)

BigHappyDaddy/Ridders/Arnelgp/Pat Hartman, Thanks to all ! ! ! I used Arnelgp's solution.

Why is no 'Actual_Name' given when no 'Middle_Name' is provided in a select query ? Below is the syntax of the statement. Actual_Name: [First_Name]+" "+[Middle_Name]+" "+[Last_Name] :banghead:

JHB, Thanks ! ! ! That worked. Also, Thanks MarkK ! ! !

Mark, I deleted the RecordSource property of the form, and delete the ControlSource property of the ListBox control, but now no data on the report. I don't understand why Query_Recreate_Survey is not receiving the Name. The query criteria is [Forms]![Recreate Totals]![Name]. Any idea why ?

Can someone tell me why the 'Name' field in the 'Gift_Totals' table is being updated with the last value of the "Recreate Totals" report that was displayed ? Only the first record for the 'Name' field in the 'Gift_Totals' table is affected. The name is selected from the 'Listbox'. Below the...

Pat/Sean, Thanks ! ! !

Is there any other way to automatically tab to the next field after value has been entered ?

What is the alternative (if any) ?

I have a form with text boxes. I want to automatically tab through when a single value is entered. I have 'Auto Tab' set to 'Yes' for the first three (3) text boxes (just for testing) in the form. The table definition for each field is set to 'Single' for 'Field Size', 'General Number' for...

Moke123, Are you saying I should continue my validation process in the 'Button' 'Event Procedure' ?

Can anyone tell me why the below code works in my 'Event Procedure' code behind a 'Button' and not when I move the code to 'Event Procedure' for 'Before Update' ? When I tab pass an empty (blank) text boxes, it does not produce the pop-up error message. The code works with the 'Button' 'Event...

Uncle Gizmo, Thank you for the thorough explanation ! ! ! I though Pat Hartman was referring 'DLookup'. During my investigation, I did create code to test for '0' or '-1'. I have to check to see if I still have the code in place. Also, as suggested, I did try to do my testing for blank text...

Pat Hartman, If you're talking about 'DLookup'. I'm not using it. What are you talking about ? I'm just referring to fields in the 'Test' table.

Uncle Gizmo, Pat Hartman, I changed the 'Data Type' from 'Yes/No' to 'Short Text'. The default value of 'No' is no longer appearing when tabbing through the form. I'll work on moving the validation code to the 'Before Update' 'Event Procedure'. Thank you for the solutions to this error ! ! !

OK, I copied and stripped down my database. I'm getting the same results as soon as I enter data and tab down. The code for 'After Update' should not cause the problem. Uncle Gizmo, 'Option Group' ? 'Test' database uploaded.

ridders, The combo box and table both have no value.

I have a 'Yes/No' field in a table with no value for the 'Default Value' of the table definition. This field is bounded to a combo box of a form. When tabbing through the form the combo box insert 'No' automatically. If I blank out the value 'No', it comes back. I can override it with 'Yes'...

Pat Hartman/jdraw, Sorry for not responding ! ! ! I've off the forum for a few days. I ended up creating multiple queries and using a macro to call the queries. Thanks for following up ! ! !