Recent content by ciel220

Hello =) Thanks for your reply. However, the query you gave me doesn't seems to work. First of all, I got a 'syntax' error on the 'insert into' part. I fixed that as follow: SELECT Table1.Id, nz([Table 2]![Type],[Table1]![Type]) AS MostCurrentType, nz([Table 2]![Date],[Table1]![Date]) AS...

Hi, I have 2 tables: On table 1, I have Id Type Date Details -- ---- ---- ------- 1 A Aug02 ABC 2 B Aug02 CDE On table 2, I have the info. for updated entry Id Type Date Details -- ---- ---- ------- 1 A...

Hi gnt =) Thanks, here it is: SELECT * FROM [Forms]![Search Engine]![TblName]; And I got 'error in the FORM clause' @_@ Thanks!

Hi, Thanks for your reply. I was trying to use that SQL and I got a syntax error from Access. IT says "There is a syntax error on your FROM clause". Am I fdoing sth wrong or is it possible to do things like that in a SQL clause? Thanks!

Hello, Is there a way that I can run a query using a variable in a form? I have several tables: TblA TblB TblC ... I have a combo box namely, TableName, which user can browse and select whichever table that want to query with. What I want is, create a single query (instead of multiples...

Many thanks to both of you! ciel220

Hello, I have put in 'MSysObjects' and remove the "". When I use this in a query, it works (I run the query and all tables come out). But when it comes to the row source, it doesn't. Is there anything wrong w/ the setting of my combo box? Thanks so much for your help and...

Hello Jebry, Thanks so much for your prompt response! Unfortunately, I follow all your instructions and it still doesnt' work. I created a form and a combo box with it. In row source -> zoom, I enter your query "Select Name From MySysObjects Where Type = 1 And Name Not Like 'MSys*'&quot...

Sorry, i'm sort of new to Access. Jebry - how can I enter a SQL in row source? It doesn't allow me to enter 'text' but only select table/query form the build in drop down box. What is 'MySysObjects'? Is 'Name' a Key Word? Essnrv - I tried to put the code to my on_load event procedure but it...

Hello, I have a .mdb file with the following tables: Jan01 Feb01 Mar01 ... Sep02 Oct02 All tables are named under the month and year of creation. I want to creat a form, with a combo box listing all existing tables name. How could I do that? I search so long on the web and on the MS Access...

But how you know if your query suceed? There might be some 'run query error' and I don't want to prompt a success msg everytime. Is there a way that I can 1. make sure query run success (ex. if (true) then...) 2. prompt msg I am new to access VBA and I wonder how I could do that. Thanks a...

Is there a way that I could create a 'customize Msgbox' for confirmation? Thanks a lot! ciel

Hi, Could anyone one tell me how could I create a confirm dialog box to prompt user that a query has been run successfully? I'm using, DoDmd Runquery "", to run a append query. I wonder if there's a way to confirm after the append suceed. THANKS SO MUCH!! ciel

Thanks! I made a 'spec' and it works now! ciel

Thanks! I got it :) THANKS A LOT!