Search results

Sorry. I should have mentioned that I was trying to retrieve this data from Access using Excel VBA back into Excel.

Tried this: Set dbs = DAO.OpenDatabase(MDBFullPath, False, True) These two commands did not work so commented out 'strDdl = "GRANT SELECT ON table MSysObjects TO public;" 'CurrentProject.Connection.Execute strDdl strSQL = "SELECT MSysObjects.DateCreate FROM MSysObjects WHERE...

Using MS Office 2007 and 2013. I'm trying to get the date that a table [T1] was created in an Access database. So, I'm trying to get the value of the 'DateCreate' field in the 'MSysObjects' table where the 'Name' field is equal to 'T1'. I'm also committed to using DAO. Problem is I'm getting...

Thanks. Each table represents a weeks worth of data. The data comes from an external site once a week. The system has been in place forever and changing at this point is not an option. Too many programs would need to be re-written. I found something though on the internet that was plausible...

Thanks for your reply. As a test on a copy of the database, I deleted all of the records in the 'specs' and 'columns' tables. One of them, I forgot which, had 1998 records and I thought there was perhaps a 2000 record limit. Anyway, even after deleting the records, I still got the error...

Access 2013 (or 2007). Recently got a 'Property Too Large' error when I was trying to run an updated make table query. Is there a size limit to the 'mSysIMEXColumns' table? I am regularly importing an Excel file, each time with a different name, into a new table but I do not save the import...

Thank you.

I have two tables, T1 and T2. T1 has field F1 with values A, A, A, B, B, C, D, D. T2 has field F2 with values A, B, B, B, C, D. I need a query that will give me a count of every F1 value that is in F2. If I just join the fields, I get F1: A(3), B(6), C(1) and D(2). In other words, I'm...

Thanks for helping. I think I now have it working. Created the link spec and then reuse it with different .txt files.

I need to allow the user to select a .txt file, whose location and name may change, and create a table linked to that file. The .txt file is pipe delimited. I can create a link to the file okay using acLinkDelim, but the only way that I can see to delimit the fields is by first creating a...

Thanks. Here's what I did following your suggestion. First I created a select query and called it Q1: SELECT T1.ID, F2*F3 AS F1, T1.F2, T1.F3, F5-(F2*F3) AS F4, T1.F5 FROM T1; Then, to update the database, I used this update query: UPDATE T1 INNER JOIN Q1 ON T1.ID=Q1.ID SET T1.F1 = Q1.F1...

Thanks for the quick replies. I didn't present the problem correctly. I should have said that I first want to update F1 to F2*F3, and also update F4 to F5-F1 in the same query. It looks like my query works on a small data set. UPDATE T1 SET T1.F1 = F2*F3, T1.F4 = F5-F1; Any reason to suspect...

Not sure if this can be done but here's the problem. I'm updating a field (F1) in a table (T1) by multiplying two other fields (F1 = F2 * F3). Can I then use the updated field (F1) to update another field (F4) in the same table? As in: F4 = (F1 = F2 * F3) Thanks.

Here's my query so far: SELECT Table1.[FLD1], Count(Table1.[FLD1]) AS HowMany FROM Table1 GROUP BY Table1.[FLD1] HAVING (((Count(Table1.[FLD1]))>1)); This produces a report for each FLD1 where its value occurs more than once, and the number of times that value occurs. Is there a way to also...

So if I have a query that selects Fld1 = AAA records, and another query that selects Fld1 = BBB records, then what is the syntax for joining Fld2, Fld3 and Fld4 and using those queries as my record sets? Thanks.

I'm a bit weak on anything but simple queries. Can you be more specific or give an example? Thanks.

Let's say there is a table (Tab1) of 500,000 records. In Tab1 there are fields Fld1, Fld2, Fld3, Fld4. For 100,000 of the records, Fld1 contains "AAA". For the rest of the records, Fld1 contains "BBB". So for example, some of the data looks like this: Rcd# Fld1 Fld2 Fld3 Fld4 1...

Blazingly fast! Thanks a heap.

This delete query runs forever and I have to kill it. DELETE * FROM Table1 WHERE Table 1.Field1 NOT IN (SELECT DISTINCT Field1 FROM Table 2 where Field1 is not null); Table1 has about 5,000 records and Table2 has about 300,000 records. If I first create Table3 of distinct Field1's and then do...

Hello. I want to create Table1 from a subset of the records in Table2, but I want to include the 'ID' auto-number that the Table2 records have. I can do the create table okay, but the 'ID's that are in Table1 are newly generated ones, not the existtng 'ID' numbers in Table2. I get the...