Search results

Ahhh...there's the problem. Thanks. I have 4 subforms that are bound to other linked tables. Once I enter a subform, the primary record is saved so that the link can be created. The result is that undo doesn't get rid of the data. My intentions are to determine if there is a linked...

I've built a tab form to handle a large amount of data entry only, no updates. A total of 11 tab pages. I 've also placed an undo button on the form that uses: me.undo Sometimes it works, sometimes it doesn't. How can I ensure that if the button is used the record is removed, so that the...

Thanks for the reply Pat. The term, many tables, may be misleading. I have to this point 3 relatively small tables that are similarly composed. 2 fields - one autonumber for a primary field and the 2nd for the specific data. The 3 tables will be used with others for a medical QA system...

I am trying to make what is essentially a template for a series of forms. Each form will basically do the same thing but work with a different table. My intention is to have a series of variables to hold the name of the table and fields so that I can easily make each form fit it's specific...

Got it figured out. Thanks for the ideas.

After working with this a bit, I realize that Dlookup may not meet my needs. DLookup does work to find a single record, but there may be multiple records that fit the criteria. The user may enter Chest Pain. I would like them to see that Chest Pain - Cardiac Chest Pain - Trauma Chest Pain...

Thank you Wayne. I appreciate the response. Time to reconsider how this form will work. Should be easier with yuor help.

I have a table of medical complaints. I am trying to give the user the chance to see if a similar term has been added prior to them adding a new complaint. Ex: The term "seizure" exists and the user wishes to add "seizures". I have taken the term the user has entered and trimed a few letters...

I have a secured database that I built. I've used the splitter to put the backend on the network with the front ends to go to various other persons computers. I secured the backend with the same workgroup as the front end. Now I have some forms that will not open because a group does not have...

I have a secured database that I built. I've used the splitter to put the backend on the network with the front ends to go to various other persons computers. I secured the backend with the same workgroup as the front end. Now I have some forms that will not open because a group does not have...

This is the way I close one form and open another. DoCmd.OpenForm "FormName", acNormal DoCmd.Maximize DoCmd.Close acForm, "OtherForm"

I couldn't quite get it to work the way you suggested, but I did find another way to make it work thanks to your help. I created a public function and then assigned it to a textbox in the header. This may be like reaching around your back to scratch your elbow, but it works. Thanks

What better way to learn than to try and do it myself. However if I encounter some learning difficulties I'll get back to you. Thanks

Thanks for the the direction. I am a self taught user, so it is time to dive back into the books. But at least I now know: 1. It can be done 2. The way to do it. Now all I've got to do is get through #3. 3. Do it. Thanks

The query is built, the proper report will open and use the info. Each report will give different totals and summaries based on what was chosen to be used. If, as I build the dynamic query I build a string that explains in everyday language what criteria was chosen, is there a way to place...

Thank you. Seems that I was so caught up in writing this in code that I managed to forget something basic.

I have created a dynamic query based on input from a form. Now that I can filter and retreive the proper data, I need to place the info in a report. How do I tell the report that it's data source is a not from a saved query but from a built SQL query based on the form? The dynamic query is...