Search results for query: *

Hello, I want to save lines of code by specifying the form name as a concatenation of two values: a constant TAB + a number. I have a main form and multiple subforms: e.g. Tab01, Tab02 .... Is it possible to refer to the appropriate subform this way rather than hardcode Tab01 or Tab02 ... e.g...

MajP, thank you for your help. I will give this a try. Unfortunately we are still at Access 2003 but will definitely keep this in mind for the future. So much easier than changing forms all over the place. Regards Alex

Wishful thinking, but is there a way to have the operator id in a table set to the operator who created the record (their signon id) e.g. using the default property, etc. I know how to do this in a form but there are quite a few forms that would require changing as well as updating the changed...

Aceman, thanks for the help!

RG, thanks for your reply. Do you have any suggestions or can this not be done? Pretty pathetic if there is no solution. P.S. you say "CF does not work this way" - how should the express be coded e.g. to determine if [Deposit} has a value of "CanH". I'm a longtime mainframe developer with...

I have been searching this site and the web for many hours for a solution to my problem and tried many things. It seems simple: if value in Control [Deposit] = "CanH", set checkbox [SentRec] to true. But I can't make it work? This is what I've entered under Conditional Formatting for Control...

Duane, thanks for your quick response. As you suggested, there was a combo box associated with the command button. The form is being deleted because it is almost identical to another form. The other form will be updated to include the additional info from the form being deleted. Alex

Hello, as a volunteer with a non-profit group, I maintain their Access DB which was developed by someone who left long ago. My Access skills are basic. I've been asked to delete a form. The form is accessed via a dropdown list which appears when a command button is clicked. I cannot figure out...

Hi, I'm trying to determine when the User has closed the find & replace window because I want to setfocus on another control. By tracing what happens when find & replace is executing, it appears that events like enter, gotfocus, etc only happen once ... each time findnext is clicked, the form's...

PHV, Thanks for this suggestion. I will give it a try.

Thanks Aceman ... I will take the suggestion under consideration. It's an old system I do not want to change drastically. This particular table is not using autonumber but the form is retrieving the last number and incrementing by 1. Thanks to everyone for all their help.

Hi Jeff, By executing the saverecord command (DoCmd.RunCommand acCmdSaveRecord), I was hoping to force the INSERT into the table to be done before The User exits the current record. At the form open, some information is already present (data retrieved from another table). During a trace, I...

Thanks Jeff, I will take you suggestion into consideration. Any idea why the saverecord doesn't work? Regards Alex

I have searched for a solution and have tried all the suggestions found(e.g. command button to save, setfocus before attempting recordsave, etc). I've tried updating and saving with a pre-existing record and SaveRecord works fine. My problem is a Data entry form in a system I inherited. I've...