Search results for query: *

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

Whenever I need to use dates in a SQL statement or a DLookup, I use a simple function: Function SQLDate(datDate As Date) As String SQLDate = "#" & Format(datDate, "mm/dd/yyyy") & "#" End Function Then you can change your statement to this: CustDiscount = DLookup("[CustDisc]"...

I regularly open Access 2000 - 2003 databases using both Access 2007 and 2010. I have read and written data to linked tables in an Access 97 mdb but have not opened the 97 mdb.

Is the date printing in the same format? Both 2003 and 2010 should be using the regional settings and should print the same but I would verify that they are the same.

This is a shot in the dark but... Are your ODBC sources set up under System DSN or User DSN? For some reason, I changed some from System to User and a system loaded a lot faster. I've not investigated why. I assumed that they were the same for the current user.

The only way that I know how to hide them is to check off Allow Full Menus (under Access Options / Current Database) and then I choose my menu from Menu Bar (which appears when I load a 2000-2003 mdb in Access 2007. I end up with my custom menu and no ribbon.