Recent content by DanWallace

Thanks guys! I'm dumb. You rule.

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?

I'm not sure what that is. I'm a little new. lol

Perhaps "client" was a poor choice of words for me as I was referring to our customers. Network latency shouldn't be an issue as the whole process works on the server at run-time. @BeerSnob: That idea has been tossed around for a while now. What I'm primarily concerned with is the learning...

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

Looks like it doesn't support 2007 unfortunately. Most of my stuff is in 2007.

Re: It's a start Thanks for the response! How would I define the database names? Will it just check the directory that it's running from? If I have a database called data1.accdb and a database called data2.accdb in the same folder, will it find the right one if I pass those names? Do I need to...

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

Hey Simon, thanks for the reply. I can do it in code. I know that. I just want to see if anyone knows a solution involving queries only. Thanks

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

Thanks. Rabbie's solution seems to work perfectly. I was really just after the final number to put into a spreadsheet and it seems to match up with what I was hoping for. Thanks for the help.

Ahhh that'll do perfectly. I just couldn't wrap my mind around it this morning. haha... thanks!

That's what I tried, except they can still have matches in Table2. I just want to find the ones with no "WA" matches in Table2.ARCODE. For example, Table1 has one record where ACCOUNT is 15. Table2 could have 3 different records for ACCOUNT 15. One where ARCODE is DA, one where ARCODE is TT...