Recent content by cchaalan

sql Hi, I just created an access table & linked it to the sql tables. But I am now attmpting to created a datasheet form that pulls data from the linked table & adds/updates records but it's not working. I am unable to modify linked table data or insert new records. Do you know what maybe...

DialogBox Import Hi , I created a Button w/a click event w/VB code to open a dialog box to choose a file to import into an Access Database. It works on the original Access database. Now I want to use the same code in another Access Database, & just change the Destination of the table that...

Hi Geko, I need to create a button for users to click on to open a dialog box that will allow them to select a file (xl or txt delimited) & insert into a predefined Table in Access. Here's what I have so far, but it's not working! Your help is appreciated! Private Sub BtnSelect_Click() Dim...

Hi, Thank you for the quick answers. Both suggestions worked, but using the DCOUNT gives me a total sum of all the tables, not each individual one, so I can't use it. The UNION I can use, b/c it gives me an individual record count for each table. But it doesn't treat the sums as individual...

Hi, I am trying to get a count for the # of records in 5 queries by creating the count in one query, but the only way I can do that is if I create 5 additional queries for each count. Is there any way to use multiple count statements in SQL. Example: Query Q_Duplicates: SELECT COUNT(*) AS...

Counting records in multiple table in one query Hi, I used the info in the previous record to count the # OF RECORDS in one table in my query. Is there anyway, to count other table records in the same SQL Query? This counts the total records for table 1: SELECT Count(*) AS TNAME1 FROM T_name1...

Counting records in multiple table in one query Hi, I used the info in the previous record to count the # OF RECORDS in one table in my query. Is there anyway, to count other table records in the same SQL Query? This counts the total records for table 1: SELECT Count(*) AS TNAME1 FROM T_name1...

Hi, Thank you again fro your help. I am just not that good with this, this is what I put in & I get the dialog box & I choose the xl file, but then I get a Run-time error stating: The action or method requires a Table name argument. See code below: Private Sub cmdSelectExcelFile_Click()...

Am I able to use this code without putting the xl File name I need to import? I want to be able to have user browse through their directory & import their file directly to a specified table name. Please let me know & thank you very much for your help.

Hi, I used all the information in your previous messages to create a Browse button to select an Excel file to import into Access, & everything works. In the code how do I specify that I want the imported data to Automatically import into a certain table? Please let me know. Thanks

Hello, I really need some help as soon as possible...I have two tables A & B, that share a primary key (emp#), I need to create a chart that shows the percentage & # of records that match & not match btw 2 tables. Ex: Table A contains a 1000 records & table B contains 400, I need my Pie chart...