Search results

I'm getting a circular reference warning when I open up my spreadsheet. Formula Auditing error checking points me to a cell F9, but that cell just has =SUM(F5:F24). F5 and F24 are both empty cells. Has excel gone mad?

Hey guys, I do data conversion for a software company. We receive a batch of data from our clients and have to write a set of queries and modules that will take that data and convert it into our tables. Usually, we store the client data in SQL Server 2005 and have all the tables linked into our...

Hi there, I need to write some code that will compare two (hopefully) identical databases for differences. The main thing I want it to focus on is comparing record count and columns. It needs to check to make sure the column names are the same in both databases respective tables and that the...

Exporting Reports (solved) Hi there, I'm using Access 2007. I'm having a little trouble exporting my custom reports. This is an error report on my database and I need to export this report to a single file that can be viewed by anyone on our network. Word is really the only native option I...

I have a table that does not have a primary key set. Because of this, I have records with duplicate customer numbers. I can get rid of these easy enough, but I don't want to lose the data in any of the fields. What I need to do is create a query or a couple of queries that will take all the data...

Hi, I'm trying to figure out how to write a Find Unmatched query when I have two keys. The wizard only lets you indicate one. Table1 has CUSTOMER, ACCOUNT, and a few other tables Table2 has CUSTOMER, ACCOUNT, and ARCODE CUSTOMER and ACCOUNT are both keys, meaning there could be many...

Hi, I'm a little new at this stuff, so pardon me if this is a dumb question. I have two tables, table1 and table2. Table1 has a key field ACCOUNT. Table2 has an ACCOUNT field and also an ARCODE field. So one record in Table1 could have many records in Table2. What I'm trying to do is write a...

I have the following query: SELECT NPAP001.C_CUSTOMER, NPAP001.C_ACCOUNT, NPAP001.C_PLANTYPE FROM NPAP001 LEFT JOIN NBIF951 ON NPAP001.[C_PLANTYPE] = NBIF951.[C_PLANTYPE] WHERE (((NPAP001.C_PLANTYPE) Is Not Null And Not (NPAP001.C_PLANTYPE)=" ") AND ((NBIF951.C_PLANTYPE) Is Null));And every...

Hi there, I have a long function that checks for errors in a series of tables. Basically I'm using one recordset to step through my tables and check for errors and one recordset to update my error report table. I'll usually populate my first recordset with something like this: strSQL1 =...

Ok, so I'm a little new to this but here's what I'm doing: At the beginning of my code I'm dim'ing my database (db1) and recordsets. rsTable is a recordset I use to go through each table and check for missing fields and other errors. rs2 and 3 are used to update my two error tables. At the...

Hi there, So the first part of my function selects all records in table nbif951 that have no matching record in npap001 using the field C_PLANTYPE. Now I used the query wizard to create this select statement, but it works fine when I test it on a smaller table. It's just when I try to run it on...

Hi there, So I'm making a report where I have one text box (txtTotalLabel) that says "Total:" and another textbox (txtRecords) that contains a different value for each set of records. All I want to do is, if txtRecords gets populated with "0" then txtTotalLabel should have a forecolor of...