Search results

FWIW: I base all my forms an a query. They key is for data entry you only want ONE (1) table in the query. I also never use multiple fields in the primary key. I only use an Auto number data type field as the primary key. I do make additional indexes based on multiple fields that are set to...

Office 2007 was the first version of Office with the ability to save to a PDF format via an add-in. Office 201o and later has the add-in built-in. see: 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS

Thanks for the update. Please let us know what you find out.

Thanks for the update. Sounds like you are making progress. FYI: It is referred to as a Break Point when you set a "marker" in your code to get it to stop execution. Sounds like a timing issue. You need your code to wait for the print process of the PDF before continuing. This is best...

Access tends to lag behind in support of the new features in MS SQL Server. I saw an article that Microsoft will be rolling out an update to Access 2016 that supports more of the features in MS SQL Server. ( see: http://www.eweek.com/database/microsoft-access-2016-makes-room-for-large-numbers...

With Access 2010 I find it best to use MS SQL Server 2008/R2 or older.. If you must use a newer SQL Server version then I would not use any new feature that is not compatible with MS SQL Server 2008/R2.

Not where I can look at the database. To find it, it will be a foreign key field that is part of the relationship that enforces referential integrity.

You're welcome. Glad we could assist.

What I have discovered is PDFCreator is really just a wrapper for Ghostscript. It merges PDFs by calling the app associated file type and telling the app to print. That is why Acrobat (or whatever viewer you have set as teh default viewer) is starting. From my research, what you are...

Classic symptoms of a shared front end or un-split database. Simple, stick with the proven basics ... don't ever share the front end. The reason web developers have to do all that extra work is because the front end is shared. Web sites that use (local) cookies are doing the same thing as...

Dave, I dug around in your original attachment. The issue is you have a default value of Zero (0) set for the field at the table level. As soon as I set it to be blank, everything worked like you wanted. Otherwise during data entry, you can select something them blank it out. This will...

Thanks for the update. FYI: The current version I downloaded was 2.5.2 I will test your code later today.

Thanks for the info. There are several great free PDF viewers and writers. I prefer a different one. I am also very interested the the automation and merge abilities of PDFCreater for use in non-open source and/or commercial applications on a terminal server. As far as I can tell does...

I would say a "bit" un-normalized for transaction data entry. Also the fact there is no grouping makes me think this is data coming from a single record in the detail section. Reporting is easier with de-normalized / flattened /spreadsheet data. The data could be coming from Excel or some...

I took this original post: to mean that the detail section has 35 controls to hold the questions. Not 35 separate detail records. If that is true then you simple place multiple page break controls where you want a new page to start.

[TIP] Page Break Control There is a page break control that works well for this. Use the visible property to turn on and off.

jco23, I have used the Access sample code in ReportToPDF for years to merge PDF files. It uses a DynaPDF v2 (https://www.dynaforms.com/en/home.html) commercial library. Unfortunately it has not been update in many years. I am starting to have issue with it running in Access 2010 and later...

There are also free CRM's that will do what you need. Maybe this: Hubspot CRM - FREE

Here is a API method that does create all the folders in the path: Private Declare Function MakeSureDirectoryPathExists _ Lib "imagehlp.dll" (ByVal lpPath As String) As Long Public Sub CreateDirStruct(strTree As String) 'Create the directory structure if it doesn't already exist...

Here is pure VBA that does create all the folders in the path: Function CreateFolder(MyPath As String) 'Created by Dane A. Miller aka dallr 'create recursive folders on a path eg. "c:\dane\fred\harry" Dim c As Integer On Error Resume Next If InStr(4, MyPath, "\") = 0 Then MkDir...