Activity Stream

I could be wrong, but think vlad meant one extra field existingID-db1......NewID in new db 1.........................db1-1...

Give a try to this: SELECT id, Sum(-(>0 And <6)) AS , Sum(-(>5 And <11)) AS , Sum(-(>10 And <51)) AS , Sum(-(>51)) AS FROM tblNums ...

I just setup a test table just to be sure, that explanes the silly names ;) I have tested your code and it works fine. Thanks for your reply. ...

First 1 and 2 are pretty silliy names for variables?, which do not appear to be declared anyway? You need to concatenate the syntax and have only...

https://blueclawdb.com/access-database/tutorials/docmd-openreport/

I know of no other info to direct you to. It seems basic to me (not trying to be condescending here) so I don't know what else to say. Can you post...

Hi Vlad, thank you for the very detailed guidance. I have now created the new access file with the three main tables (Customers, orders and...

Is your db split?

Well so much for that....tried to edit the code some and now when the editor opens it just freezes and beeps at me...can't even edit it anymore now....

You cannot pass an empty string ("") as a report name. If you want to pass nothing to an optional argument, you leave the value of an argument blank,...

Ok, got my code to work....for the most part... This works, until I try to add acHidden Private Sub ExportReports_Click() Dim db As DAO.Database...

Thanks a million, I will try to fix it and update for the results.:)

Hah, that makes perfect sense.

Short Text and Long Text are newer terms for Text and Memo. SQL was not modified to use Short Text and Long Text and never used Memo, only variations...

Don't confuse the values of properties ("Short Text" / data type) with SQL keywords/statements.

Note that "Date" is a reserved word in Access and a built in function. Maybe use "WorkingDate" instead (no spaces).

So even when I design view the table and it shows a type of Short Text, the ACTUAL type is text?

... Alter Column Text(n)" where n is a valid number?

it won't be recognising 'short text' try just text or 10 see this link for the names for various datatypes ...

No, I am not confused, just maybe poorly phrased reply. There is no technical problem having a single field table and using that table as source...

The 2GB limit includes overhead. If you attempt an operation that requires the use of some of that overhead then your issue will likely remain. Not...

Hello, Again, I have done as you suggested above -- taken all the attachments out of the database. Also, I had been getting an error when I tried...

There is some confusion as to your intent. Can you give us a description and/or an example to help clarify? . A lookup table, often used as a...

Can you elaborate please. I am new to access in first column of query i add the id field. In the second column i add the field that has all the...

A lookup table is a table of values, usually for a combo or list box. @June7, I think you are confusing that with a lookup field, which I don't think...

What if that value can can change? Eg 'Date Expected' becomes 'Date Promised'?

You will need to add a \ to sFolder. before you can concatenate MyFileName ? See if that fixes it, but you should start inspecting variables, not...