Activity Stream

I found a couple of errors in the code..... Here is the modified code. I did not encounter any errors..... (yet) :rolleyes: '...

I would add a column to the query ("qry_RentPaid") to get the month number: TransMthNum: Month() Sorting in the query does nothing (for a...

Note that "NAME" is a reserved word in Access and shouldn't be used for object names

I decided to go with the below for which I had to remember to specify the array of my combo box presently giving me the data. Private Sub...

This is something you can easily do yourself. Create a table, maybe call it "tblAllDates", with a field named "AllDates". Write a little VBA code to...

No The file name is SL-123456.docx It copies fime to SL-123456.pdf but debugs at Documents.OpenCstr(oFile) When the mouse is hovered over...

Agree with vlad - the recordset can only be applied to a form or report - so you will need to know the field names your query will be returning. ...

Something went wrong. Do you have a filename like that?

@fishhead My reply was primarily intended for @Pbaldy In answer to your question, to create the two bitnesses of ACCDE, I have a laptop with 64-bit...

I already mentioned I use a VM with 64bit Access to create a 64bit accde, having already used my main computer with 32bit Access to create a 32bit...

sorry guys you're talking over my head... from what i understand if the program is created with Access 32 bit you can not run it on a machine...

If you need to manipulate the data before adding it to your final Access table you can import it first into a temporary table in which you set all...

You're very welcome! Cheers,

In answer to the previous point about conditional compilation, there are almost no occasions when using #If Win64 is required A better alternative...

That is apparently not the update I was thinking of. One you reference was back in 2016. How can system not have a 2016 update? Here is the one I...

When i debug and hold the mouse over the oFile on Documents.open CStr(oFile) The file name is $123456, is this an extension issue to post 5 ????

Here's the whole SQL Statement: UPDATE tblInvoiceHeader INNER JOIN tblCustomers ON tblInvoiceHeader.CustID = tblCustomers.CustID SET...

A computer with 64bit Access can only run an accde created by a computer with 64bit Access. More here: ...

Should provide attempted SQL statement. Copy/paste from SQLView. Are you sure the Office Update was not installed? Have you tried the work around?...

That's a typo from when I typed it by hand. Actually, it's missing the closing ] character.The SQL statement was generated by Access from design...

Hi ranman, i am so close with this, can you kindly help? I have made a small adaption to your suggestion, the 2 documents i have tested does...

This worked perfectly. Many thanks!

Thanks pbaldy, sorry but again this is over my head. i do intend on given them a accde version - what do i do to make this work properly? regards,

Thanks for the help but this is over my head. can you tell me (exactly) what to do with this code please? regards,

How could this query run for anyone? There is an extraneous [ character in front of InvoiceNumber.

I have now added a new downloads system, Sorry to say I got so involved with other things I forgot to update this files link...

I have now added a new downloads system, Sorry to say I got so involved with other things I forgot to update this files link...

I have now added a new downloads system, Sorry to say I got so involved with other things I forgot to update this files link ...

I have now added a new downloads system, Sorry to say I got so involved with other things I forgot to update this files link...