Search results

  1. G

    Undo and tab forms

    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...
  2. G

    AddNew and variables

    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...
  3. G

    SQL and Like

    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...
  4. G

    Split Database and lost Permissions

    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...
  5. G

    Split Database and lost form permissions

    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...
  6. G

    Dynamic Query and Report Header

    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...
  7. G

    Dynamic query for Report

    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...
Back
Top Bottom