Search results

do they show up in print preview ok, but don't print. Or is the data missing in print preview? Is the report based on a query? If so, does running the query make the data available to be printed? Is this 4 different reports, or 1 report?

the report footer has a property "force new page" to do that

Here's a post (#3) with a simpler syntax http://www.access-programmers.co.uk/forums/showthread.php?t=214263

Normally you would put the subtotals in the group footer. But the group footer will appear before the next group begins. My understanding is that this is what you don't want. Instead you want the group subtotals to all appear at the end of the report just prior to the grand total. So how to make...

I'm unclear on you explanation. Maybe you could show it. e.g. page 1 group 1 group 2 new page group 1 subtotal group 2 subtotal new page grand total From you description, I don't know what happened to group 2 subtotal or if there is one. Is my above example correct? Please change it to be the...

Have you made sure the fields you're trying to refer to are in your recordset? usually rs![Last Name] is the right format or rs("Last Name")

Having several junction tables doesn't seem right to me. You could have all your fields in a single junction table, but you should work hard at generifying (made up word here) as much as possible. e.g. Don't have a 'dressed date' for one activity and a 'completion date' for another, simply have...

1) Not aware of a standard, you don't even need it for the ID if you don't want, but sometimes it's easy to keep track of in queries and such if specified. 2) >>ID (if I create this table) or by its name? ID, not name >>should I put a field for all the companies in it? no, the child companies...

Your update query will need to set REV_CHANGE to 'Y' and you can set a background color based on the value in REV_CHANGE in the Format>Conditional Formatting What is the point of REV_CHANGE_CLEAR, if it just blanks out REV_CHANGE, why not just blank it out yourself. If you want to do it in...

This sounds like a record lookup. See if this helps. It goes into quite a bit of detail, so should help you if you need to modify anything. https://www.youtube.com/watch?v=EdH1aIWaD-0 Edit: I haven't used a record lookup for doing what you want (find multiple records) as it is usually used to...

Your code will need to reference the table as what it's called in Access. If you don't want it called bdo_Logusers, won't it let you rename it? Very little should be different when accessing the data. Some SQL slight differences. What is not working with DLookup?

another way of saying the same thing is DiscAmount: ([itemcost]*[exchangerate]*(1-[discount])) not better, just shorter.

100,000 records is not excessive for a query to run. My DB has 400,000 records now and works fine. If you created a field for each week, you'd have fewer records, but your forms/reports and queries would be a nightmare to create.

you're asking for a normal select query with TRUE in the criteria row of the PB field.

Welcome to the forum

I don't understand this. Did you mean that you deleted the source files (csv's) for the folder? I don't know how Excel could lock a csv file. If that is what you're thinking, then reboot the computer. csv files aren't really a spreadsheet, they are text files which Excel can open. How are the...

I haven't tried it. Here is MS's documentation. https://msdn.microsoft.com/en-us/library/office/aa220081(v=office.11).aspx

Check Paul's suggestion, but also make sure the VBA compiles ok. Also "compact and repair" the DB.

If you go through the Form Design Wizard, it'll build the master/child automatically. They only need to be modified if something changes or is broken.

Set objOutlook = CreateObject("Outlook.Application") '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Const olMailItem = 0 Set objMsg = objOutlook.CreateItem(olMailItem) Const olFormatHTML = 2 With objMsg...