Search results

Thank you very much

Hello Access experts, I try using query below to find the unique items in a Field but it doesnt work. Can someone help me with this query? Thanks very much in advance. In (SELECT [project_item] FROM [Table1] As Tmp GROUP BY [project_item] HAVING Count(*)=1 )

Alan, you're truly wonderful ;-) I cant tell you how much I appreciate it! Thanks a zillion!!

Hello Alan, sorry I forgot to tell you that the summation should only work for Part_Number with suffix 'W'. In my 2nd example the Part_Number has suffix 'B' and in deed in my database the Part_Numbers have many other suffixes, eg. R, T, CR, BX, 176500FA, etc. I tried to amend this line as...

It's alright I can only use SQL view. It works fine and now I can use it to my huge database. I am using Access 2003. Alan, Thanks again.

Hello Alan, I tried but without luck. It says: MSAccess cant represent joint expression [past_record].[Part_Number] Like'*'+[Table1].[Part_Number]+'*' in design view. When i try to go to datasheet View, it says: Undefined function 'sum' in expression. If the original query worked when you did...

Hello Mdb Gurus, I have a huge database but this is only a sample. Basically, I want to combine the monthly_qty, annual_qty_used and months_of_use for the similar Part-Numbers (ie. with or without the 'W' suffix). Example, part numbers 0010-20524 and 0010-20524W should be treated as alike. The...

Thanks Ghudson. I realized the problem was I pressed Shift+Enter, but when it asks for database password, I have released Shift key. Thanks a million :-)

Hello Access experts, I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display...

Hi great helpers, These files have to be in G:/Reports/Data StorageLocation 11.txt StorageLocation 12.txt StorageLocation 13.txt StorageLocation 14.txt StorageLocation 15.txt I have a db (XP Office2003) that have a macro that do "transfertext" to import the above text files to the specific...

Hi Access experts, I have this Access problem with the file to be imported having different filenames and one way to know its latest copy is by looking at the file's Modified Date from the Windows Explorer. (I am using network WindowsXP and my Explorer path has its Target at...

Hi, I have 2 Access macro questions I hope somebody can please help me. Iam using Access Office XP. First, I am creating Macro Action "TransferText", and under the FileName Action Argument I typed the following LAN directory path but it doesn't work. G:\\Amat-asia-ams1\Planning\IPP\Monthly...

Hi the experts, I was creating a Macro and face this SaveAs problem.. I illustrate with example below. 1) I already have a standard Excel file in C:\ as "Template.xls" 2) I recorded a macro on my excel "Template.xls" and copy-paste all the formulas as values and saved it as filename "Status...

After I executed my RunMacro and I subsequently want to open an Excel spreadsheet from Access application. I use RunMacro to select macro Action "RunApp" and in the Action Arguments Command line I typed "C:\Stocking Status\template.xls" /excl I execute the RunApp and received this error...

Hi McAbney, I'm sorry as m new in Access and need your further help. Assuming the table name is called "MyTable" and the Field named PartNumber is in the first column of this table, I'm not sure I'm doing it right in the following steps: -create a New query in Design View -Add "MyTable" to...

I got help with the Public Function below that will loop through a column of PartNumbers values and it strips the left characters out until it runs into one that isn't a zero. I don't know how to call this Public Function in a Query ? Would somebody be nice please show me how to do this (may...

Hi the expert, I have a column named "PartNumber" in my table and I want to remove any letters that are found in the PartNumbers so that it would looks like in table 2. I can use Edit\Replace with...Match any part of Field, but I must use a query to do the job of removing the Letters at end of...

Thank you so much to all of you here who offered me the help... Thansksssss !

Hi the Excess experts ! I am looking up from Table1 to Table2 to match the OrderQty for the PartNumbers in Table2, using Join Properties. I insert another column and rename its Field as [W-PartNumberOrderQty]. I want PartNumber in Table1 to look up for OrderQty in Table2 for only those...

need a query on looking up for strings ended with "W" Hi the Access experts! Hope to have a query to solve this old pain in my neck.. I am looking up from Table1 to Table2 to match the OrderQty for the PartNumbers, using Join Properties. I insert another Field and name it as...