Search results

  1. A

    IIF statement that returns TRUE a field in a textbox

    Hi All, I have a form that runs a sequence of queries that returns a number value (1,2,3... in sequential order). I want to take that number, and turn it into an IIF statement, that returns the TRUE field to be a text box that the user can input text into to 'custom' name that particular...
  2. A

    Best Practice for Data Files - Link to Raw File or Import into Access?

    Hi All, Question on best practices. I have four raw files that feed a customer_master database. I will be updating these files at least once a week, and potentially within that week, as necessary. I have a spot on my C drive that I always save the most current file, that I use to currently...
  3. A

    VBA to open back-end and remove tables

    Hello, I need to do two things to my back-end DB. I need to remove the tables, and run a compact/repair to stop the annoying "this table will be deleted..." and to keep the filesize down since just a dual-run can cause the 2gb limit to be reached. 1 - From my front-end, access the back-end...
  4. A

    Need Help controlling the size of my Access Form DB

    Hi All, First Post. I am creating a form that contains a 6 inputs PER CRITERIA (4 listbox, and 2 textbox) that feed into different queries that run in sequential order to create a listbuild for marketing purposes. The master file is created in DatabaseA and exports into DatebaseB. DatabaseB...
Back
Top Bottom