Search results for query: *

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!

Hi, I'm having problem with using TEXTTRANSFER with macros. I have a text delimited file, namely file1. I tried to creat a macro and use textTransfer to automate the import process. However, the file imported is NOT in correct format. The text delimited filed all stick together!!! What...

All I want is a text box (or a label) displaying data on my form. I want sth (a control) to display data from a specific field on my table. How coudl I do that? Thanks in advance! ciel

Hello, Would anyone please give me some help on how to display field info. using text box? I have several tables, wich has a column namely timestamp. TIMESTAMP --------- 08M02Y O8M02Y The timestamp is same across each table. I have a form and I want to have a textbox or a label showing the...

Hi, I have a .mdb file with few tables in it. For some reasons, the size of my .mdb file is huge. Originally, I have a 8MB data table in my database. I duplicated this table (within my database) and I find that the size of my database growths to 16MB. I then deleted the duplicated table...

Hello! Could anyone tell me if that's possible to report & select data using CHECK BOX on form? I have a table with column 1, 2 and 3. And I also have a form with check box 1, 2 and 3. What I want is, if user check CHECKBOX 1, the data on COL 1 on table would be reported. And CHECKBOX 1,2...