Search results

Sounds like a winner to me! Thanks......Vince

I have an AutoNumber field on a form. Prior to an AutoNumber being generated the word "(AutoNumber)" is displayed in the field - is there any way to hide this. Thanks Vince

Got it -I used a "Query Form" procedure. Vince

I have a database that when the form is opened it is blank (new record). On this form ia a command button (utilities) which opens another dialog form that has 3 command buttons to perform various queries – it also has another command button (find record) which, when clicked would display a...

Nevermind - got it. Command Button run macro -Close action (closes Form) then Run command action - Exit (closes window) Vince

This dosen't seen logical but it might be possible so I'll ask ......... I have a command button (exit) on the main form which closes the form ----is it possible to have that same cb also close the access window -----so the user is left at the desttop of their computer? Vince

Appreciate it - alot of good info in that lit'l answer -Thanks and I wouldn't take offence regardless of how much I "thought" I knew - I can never know enough! Thanks Again, Vince

I've read that you should use the "Option Explicit" on almost every Function or sub to eliminate undefined variables. I wrote the code below before I added "Option Explicit" and it worked. Now, using "Option Explicit" - I get an error: "Variable not defined" ProductName = Cleared...

This is a toolbar button that runs a macro - that runs a run command action - that runs VB code. what I was concerned with is diassociating it with the before update procedure. giving that the form wants to update however it's closed. running the code you supplied -I don't get the vb windows...

I'll give this a go.......I'm not sure if this is what I want.... I want a message box to appear with 2 options delete current record or cancel msgbox - if they choose to delete - it creates a new record. Vince

I have a new record button that runs the code below: Function NewRecord() DoCmd.GoToRecord , , acNewRec End Function I also have the code below associated with the main form (so it will not update unless all required fields are filled) Private Sub Form_BeforeUpdate(Cancel As Integer) '...

Nevermind - I just read my last post Thank You!

Below is an simple example of vb associated with a command button (Print) Option Compare Database Private Sub PrintRecord_Click() On Error GoTo Err_PrintRecord_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection Exit_PrintRecord_Click: Exit...

Thanks - i wont be able to strip it down and post it until tomorrow............ Vince

Thanks for replying......But for some reason it doesnt work I'll have to keep playing with it Thank again Vince

The “Call” procedure is new to me – I’m not sure how to use it – what’s wrong with the following? I have the following in a module: Function NewRecord() DoCmd.GoToRecord , , acNewRec End Function ************************************************* And the following in the OnClose...

What I have is this: Macro from a database window (design view) I used GoToControl (field) RunCommand (Delete) for each field in the form, if certain criteria is not met (thereby eliminating the creation of another autonumber record) Is there a single action command that will delete all...

What action argument would I use to clear all fields in an active form? I created a toolbar named "new record" upon clicking - I want this to run a macro that if all required fields are not filled it will clear all fields in the active form. As it stands now, it moves to a new record and the...

Fixed! Had to use GoToControl twice .....1st to move to subform 2nd to move to control on subform -- I did try this earlier but it didn't work -- probable spelling or I put a space where there shouldn't be one Thanks Vince

In the designview of a macro from the database window - I have several GoToControls that display mesage boxes if controls are null - the last control in the series is on a subform and the messagebox works fine but the focus will not move to the control on the subform - I tried several actions...