Search results

Thank you for your advice, June & Plog. I managed to sort it out.

Hi there I have a continuous form, frmBuyerDetails with a list of Contacts and a subform called frmInvoice. The forms are linked as follows: Link Master Fields: CurrentOwnerID (tblContacts) Link Child Fields: ContactID (tblInvoices) In the After Update Event of the combobox on the main form...

It saves the pdf file but the last section of the report is not included but it's there when I run the report.

Hi all I'm running a report consisting of up to 10 pages from VBA. All pages are printing correctly with the DoCmd.OpenReport, however, leaves the last section of the report out when it exports the report to pdf. I've added a pause in between with no luck. Does anyone know why this is...

I've done all of that, Arnel. I have full rights and the values of all the variables are what they should be. I did, however, found a database that I got when I did my training some time ago. There are the two modules and I got it working with this line only CheckFolder NewFilePath It's just...

Hi Arnel, I've just created a button to create a directory. It creates a parent directory and if I extend it with a subfolder I get the Path not found error. I also get an error on your Public Function Compile error: expected variable or procedure, not module I've done a compile and got...

When I single-step through the code my paths are all correct. I replaced all the concatenating strings with the variables and they all work. I also closed the path definition. I also changed the code to check if the directory exists and it returns a False which means the directory should be...

I appreciate your reply. I've set the breakpoints and it had a value of "" for NewFilePath. I then added two more lines DogPath and DogIDPath and they all show the correct paths. The Docmd.OutputTo also shows the correct path I'm thinking the problem is somewhere in the Function...

Hi All I'm creating a report for each dog which I need to save in each dog's folder eg. C:\Dogs\DogID\Documents. My code does not create the directory and I, therefore, get a run-time error '5' Invalid procedure call or argument on the following line DoCmd.OutputTo acOutputReport...

Will do, June. Thank you for your help 😊

Ok, I see what you mean. I'm in Australia, and our format is dd/mm/yyyy. Can you tell me how to handle the different format?

I tried it June, but it's still not selecting a date

I installed the Microsoft ActiveX Data Objects 6 Library, and it seems to be the right one. I do however have a problem with the dates, it is not selecting a date. I think it has to do with formatting. Attach is a sample of my database.

Is there another method to do this? Any help is highly appreciated 🙏

I'm using Office 365, so it might be different. I googled ADO Library, and it came up with Microsoft ActiveX Data Objects, and there are seven different versions when I go into my References. I do have a Microsoft DAO 3.6 Object Library.

Hi everybody, I have two reports that I have to print all at once for each day over a six week period. I've created a temp table with all the dates, ReportDate, tblReportDates. The reports have a field called CheckListDate, which defines the date of the report. I'm not good with recordsets yet...

I changed it as follows: [forms]![frmLocalitiesSelected]![StateCombo].

Thank you for your help, June. It will only be one user working on this and it will only be used until all the localities are linked with a council. I have done the changes as you suggested and it's all working except for the 3061 error which still comes up. What would the code be for a...

Hi there I have a form with two listboxes plus a subform. What I'm trying to achieve is to update the CouncilID field in the tblLocalities to the CouncilID selected in the subform. Because there are a few thousand records in the first table I use a SearchAsYouType Listbox to find the Locality...

S Sorry for the late reply, June. I did a compact and repair and it fixed itself. Thankyou for your help, I appreciate it🙏