dataentry

  1. A

    VBA - Userform Data entry - Prompt if VLOOKUP error (#n/a)

    I have a excel file that is designed for entering drawing numbers to use as a register. The file is design to search a part of the drawing number and relate it to a client # on a different sheet. I want my userform to prompt the user if no return is found relating the newly entered drawing...
  2. G

    Access 2013 Macro Tools SetProperty if DataEntry mode is Yes

    I am trying to figure out how I do an if statement with Macro Tools that looks at what DataEntry value is set to and then change the visibility on a combobox depending on what is returned. For instance I have cmboLookup on frmRaters. on my switchboard I have 2 buttons. One to open frmRaters in...
  3. A

    Keeping the same record when moving between forms

    Hi all Hopefully this is a fairly simple one. I have a form called DataEntry which has a field called ID which is an autonumber field which produces a reference number. Once the details are added there is are two buttons that can be pressed depending on the user. If command button 1 is...
  4. L

    Sum of DataEntry Form

    I'm Using a SubForm with Dataentry=Yes to type and see only the new records. in every row in the sub form I write the Number of the row in that batch using: n=recordset.recordcount+1 (at before update event of the form) now I want 2 things: 1. After Update, To summarize one of the fields (but...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top