Recent content by newstrom

Could someone give me the expression to set a validation rule that the entry must be a multiple of 16.

I've read all the replies to similar questions and tried various ways suggested but can not get this to work. I want to open a word mail merge document from a command button linked to a macro. I'm using RUNAPP with "H:\USERS\Susan\Label Templates\File Folder Labels\File Folder Labels Mail...

I have a main filing table and three look up tables (file cabinet, topic, and subtopic). In the three look up tables I have created short codes to identify the name of the field. I want to create a main filing code that takes the codes from each lookup table and combines it into one field...

Cascade combo I think I'm making progress on this. I used the FileLocationTable to associate the file locations. On the Main Entry Form I was able to create the drop down for FileCabinetLocation using a SELECT on FileCabinetLocationQ query. I tryed to create a query (FileTopicQ) for the...

thanks Nick, thanks for your reply I will work on implementing your suggestions. I'll keep you posted. I'm sure I'll have more questions as I get further into it.

I don't understand VBA coding or complicated event procedures. If anyone is willing to take me by the hand and walk me through this so I can get it done I would appreciate it. I am having to set up, from scratch, a filing system for the boss. The problem is he doesn't think in names and...

Still confused regarding cascading combos I am unable to unzip the examples that users have submitted and I can't seem to understand if I use some of the code examples as macros or properties. The best I've come up with is creating a macro as below: IIf ([form]![Main Filing Entry...

I have the form and look up table set and working. What I would like to do is when I enter new data in the form field and it is not on the lookup table I want it to automatically add it to the table. It this doable?

I am trying to figure out how to create a macro or code so that when I make a selection from a drop down box it will bring up a corresponding lookup table drop down box in another field. Example: In field "File Location" I select "Boss Files", and in the next field "File Topics" it lists all...