Recent content by daniela

I am using the following criteria to test if an order is Current. The problem I'm having is that I am getting duplicates. Ex. If an order is Current it can't be "Repair" This worked fine until I added one more condition: [supplier_status]='55' Any suggestions??? Thanks! Current...

I could but... I can't because sometimes I get 15 reports other times 50, the all get imported to the same table. So if I do that for all 50 when a file(s) is missing one morning it will error out. Do you know a way I can get all the files in the folder with out specifying each one? Thanks...

Hello, I need to import multiple excel files located in a specific folder. I am able to import one and then delete it from the location (see code below) but I want to be able to do the same thing for all the excel files in that folder. I am a VBA beginner and have search all over this forum...

Thanks Gromit & llkhoutx thanks, I selected the properties in the query and the form in which I am displaying this query and set the format to fixed and the decimal place to 2. I love to make things harder than they are : )

Hi, I have this query and I would like to have the avg display with only 2 decimal points. This is my SQL and I think I have to use this code but I'm not sure. FORMAT(CountOfStudent Attended,'.00') If I ad this after the SELECT statement my query will not work. What am I doing wrong...

Selena perfect! Thanks, D

Hi, I have a form in which I want to simplify data entry. Depending on what is entered in the subject text box I would like the MT code to be entered automatically. This is the code I am trying to use. Thanks I'm new : ) I know there is a problem with the or but I don't know how else to...

Thanks Alastair! Works perfect!!

Hello, I have a button that runs a macro to delete records in 12 tables. I want to create a message box before that macro runs warning that you are deleting records in 12 tables and are your sure you want to run the macro. I need a message box with an ok and cancel button. Where do I put the...