Recent content by Axworthy

Jet SQL requires DELETE * FROM instead of DELETE FROM that works for most other versions of SQL.

Are you looking to merge multiple PDFs into one? I have always used an external program called PDFTK.exe that I call using command line parameters to get this done. Hopefully someone has a more elegant solution.

If it is a specific form that is causing the error, you can try to export it to text and re-import it: application.saveastext acForm, "frmFormname", "C:\Temp\frmFormname.txt" then application.loadfromtext acForm, "frmFormname", "C:\Temp\frmFormname.txt

A little long, but you could write it like this: [City] & iif(len(nz(City, "")) > 0 and len(nz(State, "")) > 0, ", ", "") & [State] & " " & [Zip] This will only show the comma if there is both a city and a state.

I believe you will need to put parenthesis around the second join: from ((Group_Reason_Table and then R.PID = F.PID) so it looks like this: SELECT R.PID, R.Total AS RTotal, L.Total AS LTotal, F.Total AS FTotal, J.Total AS JTotal FROM ((Group_Reason_Table AS R INNER JOIN Group_Reason_Table AS...

If [SubTaskComplete] is a checkbox, you may want to change the expression to [SubTaskComplete]=True

I've been using a pop-up calendar I got from Access 97 Developer's Handbook and continue to use it in Access 365. It seems to work well for me.

This seems to only happen with users running Access 2010. If a form has a subform that is a datasheet, and that datasheet has an Order By set, it sometimes shows with no records. Alternatively, sometimes it shows the records in the datasheet (which is based on a query) but when I change...

Laurie, I develop in Access 2003 mostly. Clients use 2007, 2010 and the one that I most want to do this on uses 2013.

Here is my problem. The client want these 3 reports to default to this printer, these 12 reports to go to that printer and these 4 label reports to go to the label printer. Sooner or later they get some new printers and want them all defaulting to other printers. To do that, I have to go into...

I have run several systems with a 2003 back end and front ends in 2003, 2007 and 2010 with no problems.

To change the server, choose Connection under the File menu.

I just leave them there. Maybe once every few months, I'll go in and delete them. I copy them into a subfolder and then run from there so every so often, I can just clear the folder.

What I would do is have the users start the system using a vbs script that copies the front end to a new mdb (you could use their username as the name of the new front end) and then run that front end. Even if you do this in the same directory as the front end and back end, any corruption can be...

What I've found is that 64-bit Access wants the keyword ptrSafe, which 32-bit does not recognize. Here's one way I have been able to maintain one system that works on both versions: #If VBA7 And WIN64 Then Private Declare PtrSafe Function .... #Else Private Declare Function...