Search results

In Access 2003, have a look at Tools | Database Utilities | Switchboard Manager.

OK, the UNION was a bad idea, but that was not unexpected. As to the 2 gig database, that's an interesting problem. Looking at the amount of data you're handling, I'd suggest using another database: MSSQL, MySQL, Oracle, what have you not. Your current tool is not really up to the job. Maybe...

As far as I know, no. I know of no way, but then I'm not a Word expert at all.

You will have to create 1 unique index on both columns: CREATE [ UNIQUE ] INDEX index ON table (field [ASC|DESC][, field [ASC|DESC], ...]) [WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]

In addition to what Ron_dK said, make sure the field property "Required" is set to Yes. Htht

If you're running a UNION query on those 36 tables: Yes ;). If your database is on a network drive, try putting it on a local drive.

Something like this? SELECT YourTable.Group, YourTable.RD, YourTable.Schedule FROM YourTable INNER JOIN YourTable AS YourTable_1 ON (YourTable.Schedule = YourTable_1.Schedule) AND (YourTable.RD = YourTable_1.RD) GROUP BY YourTable.Group, YourTable.RD...

Are all tables named the same each month, or is it something like Office01February2008.mdb through Office36February2008.mdb ? If they're named the same each month, you could just link to all those tables & replace the files each month. In the case of 36 linked tables, you could UNION them all...

Have a look at the VBA in the report. I don't know if it fully works (don't have enough test data to get a 2-page invoice) but it should help you along. I couldn't find it either, but I can believe it. Never met a report builder I liked. Normally I'd suggest you consider doing the report in...

Ah, I thought you were having trouble getting the list box populated. I didn't see the VBA :o. Have a look at the updated example. I don't know where and how far you want to take this. The Query Designer generates SQL for you; you can see its result in SQL View. You can also paste SQL in SQL...

That works like a charm, y'all. I'm keeping that one for future use :). Sorry about the late reply, had a bit of a breakdown :o. Much better now :D.

I once used A4 Avery label sheets with 8 labels per sheet; that was easy 10 years ago. Should still be possible now :D. Have a look at the Label templates in Word. As for the postcode, I don't know enough about your table structure and your requirements to comment on that. But you should not...

You can try doing this with Mail Merge in Word, using your Access db as a data source; Word's better geared towards printing label sheets and has lots of templates for these.

In Access 2003, AFAIK, there is no such thing as a "linked view". If there is, I'd love to know how :D. If you want the same view in different databases, you'll have to copy it. Not sure if this holds true for SQL server, but if it does, you would have to copy the view SQL to your mdb's query...

Did you try: CurrentDb.Execute "DELETE * FROM tblA" DoCmd.TransferDatabase acImport, "dBase IV", "C:\Databases\DBF-A.dbf", acTable, , "tblA", False CurrentDb.Execute "DELETE * FROM tblB" DoCmd.TransferDatabase acImport, "dBase IV", "C:\Databases\DBF-B.dbf", acTable, , "tblB", False...

ByteMyzer, I don't see anything in the thread about those dates all being at the start of the month (although all sample dates are at the start of the month). Maybe alsamren would care to comment on this. I'll check out your latest work of beauty tonight; I do want it to work :D.

Hate to be a naysayer, but after a second look at ByteMizers small & beautiful query I spotted some problems with the results. fName CountOffDate -------- ------------ Eau Noes 2 John Doe 4 Johns results are OK, but his sister Jane, your most valued customer, doesn't show up...

You can use a UNION query to combine results from two unrelated tables: SELECT t1.fldName, t1.fld2, "" as fld3 FROM t1 WHERE t1.fldDate = #1/1/2008# UNION SELECT t2.fldName, "", t2.fld3 FROM t2 WHERE t2.fldDate = #1/1/2008# That will: - combine t1.fldName and t2.fldName in the first column, -...

I can't even do that manually; Copy is disabled. I don't have a solution to that. Just a suggestion: I found Excel to be a better tool to make charts with. You could pull the data from Access to Excel, do the chart in Excel and do the Copy/Pasting to Word in an Excel macro. That way you even...

UPDATE A SET A.answer = (A.field1 + A.field2 + A.field3);SUM works on values in multiple records in a specific column.