Search results for query: *

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...

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...

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...

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

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...

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...

Hello, I'm having troubles with selecting data on different columns. For instance, PERSON Year 1 Year 2 Year 3 ------ ------ ----- ------ A 110 112 115 B 90 92 95 C 100 102 105...

Hello, Would anyone able to give me some hints on how to combine data across multiple rows using query? Here is what on my table: Person Group_ID Sales ------ -------- ----- A1 00 2 B 01 3 C 02 1 A2...

Hi, I'm creating a form for 'importing delimited text files'. My first question is, how can I create a browse button for browing & selecting files? I don't want to use 'get external source --> import'. Another question, I create a macro using TEXT TRANSFER. The delimited test file imported...

Hi, I'm creating a form for 'importing delimited text files'. My first question is, how can I create a browse button for browing & selecting files? I don't want to use 'get external source --> import'. Another question, I create a macro using TEXT TRANSFER. The delimited test file imported...

Hi, I'm a user of Crystal Report ver 8.0. I'm having troubles on connecting Crystal Report with MS Active Directory Service. Could you please help on the followings? These are the steps that I did in order to access Active Directory Service through Crystal. Could you please verify if they are...

Hi, I'm a user of CR8.0. Could anyone one tell me how can I merge 2 tables (from different database) in CR? I know it's possible but I don't know how to actually do the 'join'. Please shed seom light on this. Thanks.

Hi, I'm using CRW8.0 professional. I'm having troubles on using CRW with active directory. Could you please anwser the following questions? 1) Can Crystal join data from 2 diferent database? 2) Can Crystal generate data from Active Directory? 3) Can I join Sybase dat with Active Directory...