Search results

I have a simple EXIT command button that runs these macro actions: save record, close form. I also have a SAVE command button that runs this macro action: save record. If a user closes the form without clicking either the EXIT or SAVE command buttons, will the record changes be saved in the...

One addtional note. After further testing you helped me discover that setting cycle property to current record works great for tabbing. The only time it doesn't work is when pushing the page down button. Your insight was of tremendous value in designing the database. Thanks again !!

Thanks again. I sincerely appreciate your help !!

I really appreciate your quick response and expertise !! I did exactly what you recommended, then tested. I tested by going to the very last control, then I clicked the page down button. The view moved to the next record, which is what I'm trying to prevent. Am I missing something ?

I'm trying to create a security measure that would prevent a user from accidently paging down in a form and moving to the next record. I want to create an event macro that would fire if the user accidently paged down into the next record. The macro would simply move back to the previous...

I recreated the button, added the last two lines of the code, saved, but the macro does not come up in VBA. The button is called command 61. Option Compare Database Private Sub Command61_Click() End Sub Private Sub Command0_Click() End Sub Thanks for your patience, I'm trying very hard to...

This is definitely a fantastic solution, but I'm having trouble. Here's what I did. Entered button in design view, found on click event, deleted [Embedded Macro], replaced with [Event Procedure], clicked three dots, entered VBA, deleted all the code, entered the following code. Private Sub...

I've tried converting my macro to a visual basic module and changing the form name with the edit replace function. I can do this very easily. My command button event runs the original macro name before it was converted to VB. How can I correct the command button so it references the converted...

Is there a way to increase the maximum characters allowed in an expression of a macro setvalue action ? I have an expression in a macro setvalue action that adds multiple form textbox values. I need to change the form name from "RATING ENGINE 2" to "E RATING ENGINE 2". When I do this, I exceed...

I have a macro with at least 50 action lines that I selected from the action catalog. I need to edit all 50 lines for a variety of reasons. If I convert the macro to visual basic, is there a simple way to edit the 50 lines with and "Edit / Replace" option and then convert the visual basic back...

Thanks so much, this is greatly appreciated. :)

I have a form textbox with a back color of gray. I want to use conditional formatting so the back color turns from gray to red if the value in the textbox is null. I tried conditional formatting using expression "isnull", but it does not work. Any help with this would be greatly...

I've tried to execute several macro commands, which all result in error 2046. The commands are: SaveRecord, Refresh, Requery, Redo. The error explanation is that the command is not available either because the database was created in an older access version or the database is in read only. My...

I will try dlookup function and see if this eliminates the need to open a query. Thanks for your input. I'll let you know if I run into any stumbling blocks.

My understanding is that a form can maintain a maximum of 754 controls. The database I developed has exceeded this. Deleted controls sometimes artificially cause the database to exceed the maximum. I created a new blank form and copied the original form tabs into the new blank form so that...

My primary form must read a value from a secondary form. The secondary form reads a value from the query. The secondary form and query must be open for the primary form to extract the value.

I have a complex form that reads data from other queries and forms. These other queries and forms are opened automatically via an embedded macro in the on load event. I want to open the queries in a hidden mode so the user does not see the query. There are options to hide a form, but I don't...

Is there a standard MS Access function that I can use in the expression or macro builder that does not require inputing customized code ?

My primary form opens a secondary form via an onload event. Is there a way for the secondary form to be open, but hidden so that a user can not see the form at all ? In MS Access 2003, all secondary forms were hidden, but in MS Access 2010, all forms are shown as a separate tabs. How can I...

Thanks for responding James. You say to remove the value "as follows" but didn't finish your thought. Were you going to add an example of how to do this ?