Search results

Your statement worked well. But now people wanted to have a report to show (a) the count of how many items have zero qty and (b) the count of how many items have qty. It seems not working if I removed the criteria of "qty <>0". Any suggestion?

Hi all, I have a database table which holds part number, its usage qty and some other stuffs. I wanted to create a selection query to have a new column to count how many parts which do have a qty <> 0. For examples, if there are 3 records having usage qty <> 0 in the table of 5 records...

I will give it a shot. Thanks for the tips.

Hi, I have a big table in which same product numbers may have multiple records with different reference number(s) in the table (For example, if the part has n reference numbers that it has n records in the table). I want to keep only one record for one part in the table by choosing the hgihest...

The new field works like the way exactily I'm looking for. Thanks very much!

My table has a "PIR Valid-Frm" field in TEXT for data of "valid-from date" . I want to create a new column to have the data in date format so I can do some calculations. The data in "PIR Valid-Frm" field are TEXT format in MMDDYYYY (e.g. 12152009, 09102010, 03082011). The New fieldname is...

Thanks for your codes. I do have a question of where to put the query's critiera to select product center(s) and/or prouct key(s) in your codes. My current way is to run the same queries over and over to export data by 22 product centers so actually I would have splitted the table into at...

Hi, I have a super-sized Access table. I created 4 select queries to select data by individual product center from the table: 1 st query to get all data (if the data is not over 50000 lines) and the other 3 queries are to get data by product center (e.g. PL, SG) by product key (some product...

It worked like a charm! Thanks very much!

I always wanted to download the table def. like that. I copied the codes & put it in a module in Access 2007. When I tried to execute the module, a window of "Microsoft Visual Basic" was popped up with a message of "Compile error: User-defined type not defined". What i should do to run the...

You might want to try this in the Access Database. a) Link the excel file in Access b) Create an update query to update the excel file's "mgr mgr ID". c) Pull original table A and excel file in the query d) Link table A's "mgr.ID" with excel file's "employee ID" e) Update excel A's "mgr.mgr...

Did you check the field's property -> format in the query if it is same as the PC's date format?

Hi all, I have 2 tables. One table has a part column with leading zeros and another table has a part column with no leading zeros. The two tables are downloaded in different sources. Currently, I go in the table with leading zeros to find & replace in order to get rid of those zeros. I...

It worked. Thanks very much!

hi, Sorry I should mention that the close action is in my existing codes which includes a bunch of other actions as well. i am still new to VBA code. I think your code would work. However, how I revise your code to include in my existing code? I tried to copy & paste your code in my...

I have a macro to export an Access table to a text file. Then I use an Excel macro to open the text file and copy/paste to an Excel template. In the Excel macro, I write a code below to close the text file: Activeworkbook.close The Excel prompts a standard massage with 3 buttons: save...

Thanks everyone's comments. The Chr() function really does the trick for me. Thanks!

Hi, I use a msgbox for a message in a macro. The message is something like this: "Hi user, please make sure you have updated the run date first". The msgbox will have this statement on one line in the pop up window. I wonder if there is a way to split this statement into two lines like this...

Try IIf(IsNull([Term]),[Term],Val(Mid([Term],6)))*1

i think i figured out what went wrong. Thanks for your email.