Recent content by anissw

Hi everyone- I want to apologize for the delay in responding. I have been putting out fires on other projects. The check boxes are independent and wasn't necessary before except to categorize each if we required to look at previous choices, but now that I think about it, this can be utilized...

Good morning - Is it possible to have a query that will requery value of a check box based on which check box is selected? I have a form that has 5 check boxes and a text field for populating a unit price. When someone clicks a specific check box, the text field should display the unit price...

Hi- I wanted to know if it's possible to open a form in another database based on login? I am setting up multi-user front end forms on a server into each user folder. The main form contains 2 drop down lists to select report and site name. Once the click submit, login screen appears. After...

Hi namliam- I was able to setup the function after I went through the script again. Thanks so much. Just one question. My script will copy files into the archive folder without problems, but I would like the file in the temp folder to be renamed to a different name. Since my file name will...

Hi namliam- I was able to setup the function after I went through the script again. Thanks so much. Just one question. My script will copy files into the archive folder without problems, but I would like the file in the temp folder to be renamed to a different name. Since my file name will...

Hi namiliam- I am really, really lost. Where would I code the import specification. I am looking for syntax examples and can't find any. Any assistance would be appreciated. Thanks again.

Hi namliam- Thanks so much for replying. I am in the right direction to utilizing the DIR function as the function goes out to look for the files with the name and it recognizes and reads it in completely into the error message. However, my message comes up saying Microsoft Access cannot find...

Hi namliam- I apologize for the delay in replying. Thank you so much. I am going to try the dir function. Just a quick question, instead of having the file delete once I import in, can I have the file copy into a stored folder? The temp folder is currently using a software (RAMP) to import...

Hi- I need to daily import files that start with same name, but the remaining part will be Bill of lading ID (e.g. TEST_BOL 1234.csv). The next day will be TEST_BOL 1235.csv) and so on. I need for Access to import the file based on the "TEST_BOL" into my database and then delete the file from...

Hello- I have a database that calculates totals on entry forms and reports. Sometimes when entering data or generating reports, the total fields, which are not associated to a table, will be blank, however the data from the tables will display. The total fields I have are for display purposes on...

Thanks so much. I'll test and give you an update. :)

Hi- I have a report with command buttons to export to PDF when pushed. However, I need to include script to read if data from another table exist with client ID that equals to client ID on the report, then a message box will instruct them they need to clear out data from table before proceeding...

Hi- I apologize, I just realized my second question to you was redundant and the solution you provided worked perfectly. :) Sorry for the confusion. The SELECT TOP 1 link worked perfectly!! :) Again thank you-

Hello- I have an export query that has number of distribution and CM distribution for invoices generated. The objective is to count the number of invoices based on the account number for each customer ID. Since the table has no primary key, the I assigned field number of distribution to 0 in...

Hi - I was able to identify the unique locations and assign accordingly, however, is there a way that based on the first unique location, I can assign area field once so that I can calculate my area to charge one location for all item IDs that are in the same location? I have attached a sample...