Search results for query: *

Hi, I was trying to import 40 Queries into .asc file once. I failed it (I wrote the code.) I don't know if you are aware of that Queries. Can the Query be read into modules or Table only? Maybe I did wrong? Thanks, chsu

Hi Steve I was trying to do your code. It doesn't work. I am working on using ACCESS 2000. (I am also trying to learn how to do the code. I am not expert for that so I would like to learn more.) Ok you are right about eliminating records. Ok I already created the tables, queries, marcos...

Hi everyone! I am trying to get rid of the line. For example: (what I need that) AME00000101XXX - keep AME00000102XXX - keep AME00000199XXX - keep AME00000201XXX - keep AME00000202XXX - keep AME00000203XXX - keep AME10000101XXX - keep AME10000102XXX - keep ... ... ... AME30000101XXX - keep...

Thank you, RVBASIC

Hi Mike You mean I should find the registry from VB 5.0 CD. Like I should re-install it? I am just new with it. Please HELP! Thanks, chsu

Yes I did but the error message popped up "License information for this component not found. You do not have an appropriate license to use this functionality in the design environment (Error 429)" If you know about it, please help. Thanks.

Hi I was trying to set up for Common Dialog Control. It won't let me put on the form. What happen? Please advise. (I am still learning how to do.) Thanks for your help.

Hi I am struggled with the code like back and forth. Maybe I am tired or Friday of 13th? Anyway, I am trying to set up the field like below: AME00USD101000!AME00000101000 AME10USD101000!AME00000101000 AME10USD101000!AME00000101000 AME10USD101000!AME10USD101000 - I don't want that. How to...

Hi everyone! I am testing on the module. And I am writing the code: 'WORLD - BULOCP Set rsStruc = dbStruc.OpenRecordset("REGBULOCP", dbOpenSnapshot) rsStruc.MoveFirst Do Until rsStruc.EOF strBU = Right(rsStruc.Fields("BUSINESS_UNIT"), 3)...

Hi I am trying to elimiate the multiple fields. REDUCE FROM MANY TO ONE! What I got: AMEXXUSD1 AMEXXUSD1 - remove AMEXXUSD2 AMEXXUSD2 - remove AMEXXUSD4 AMEXXUSD4 - remove AMEXXUSD5 AMEXXUSD5 - remove AMEXXUSD7 AMEXXUSD7 - remove AUSXXAUD1 AUSXXUSD1 AUSXXAUD2 AUSXXUSD2 AUSXXAUD4 AUSXXUSD4...

Hi I am struggled with modules so I need one field not multiple fields. i.e. AME00USD1 AME10USD1 AME20USD1 AUS00AUD1 AUS00USD1 AUS00USD1 - how to delete? AUS00USD1 - how to delete? AUS10AUS2 ... ... I wrote the modules. Here it is: 'WORLD - AMEUKEXXXXXP Set rsStruc =...

Hi Larry Sorry I just found your message late so I was already taking the Intermediate ACCESS courses at my local computer training. I had been learned a lot so I rather to study more about Visual Basic. Is it similar to Access? Yes your request does help :) CHsu

Hi PaulF I did put the critera in my query what you gave. It is not working because it appears like 0, 1, 2, 4 ,5, 7, and 9. I just want only 1, 2, 4, 5, & 7. Thanks, chsu

It is hard to explain you all. I already created the tables, queries, marcos and modules. i.e.: Fields BU (business unit: AME,ITL,UKE,etc. P (practice): 0,1,2,4,5,7,9 PPP (product): 059,100,200,400,500,700 I am trying to get rid of Practice "0" and "9" into Query. I...

I am trying to learn how to use the actions. I am familiar what I am doing on tables, queries, reports, forms (some of it). I wanna learn more about marco. Sometimes it makes me confusing. Please advise. Thanks.

Yes I need to learn more about SQL and Visual Basic both.  Any suggestions?  Thanks Kelt!

Hi everyone!?<br><br>I hope you can help me out.&nbsp;&nbsp;I am looking for Advanced Access programming like script.&nbsp;&nbsp;I am not quite sure which the training is better. Let me know.&nbsp;&nbsp;Thanks.