Search results

This is what I have in the code: strusername = Environ("UserName") fileName = "Template-Please Rename" 'filename for PDF file* fldrPath = "C:\Users" & strusername & "\Desktop" 'folder path where pdf file will be saved * filePath = fldrPath & "" & fileName & ".pdf" MsgBox filePath...

Could it be a problem in other areas of the code?

So this is what I got. I attached the image. It gives the path plus the file name. So why does it says I have invalid folder path?

I would like to have it saved it the desktop

When I try the path in the windows explorer bar, it works. What could be the problem on the path I have?

Yes I didn't see anything, how do I get the correct path? When I tried the path in the explorer bar it works. I'm not sure what to look out for:banghead:

Do I run it from the button that triggers the code? I didn't see anything printed

Hello everyone, hope you are all doing fine. I hope I can get some help on this code I found by googling. This always says I have Invalid folder path. I don't know which I causing the error. Here's the code: Dim fileName As String, fldrPath As String, filePath As String, strusername As String...

How can I store the Holiday dates in a table instead of having in within the vba code?

If I understand correctly, the holidays are the dates inside the Array ()?

Hi, good day! Hope you're all doing fine, reaching out again for help. I found this Db (See attached) on this thread https://access-programmers.co.uk/forums/showthread.php?t=240120. My question is, where does it get the holidays? Is there a table or somewhere where the holiday dates are stored...

This worked thanks! Just added column headings on the property.... appreciate it!

The source are fields from a query. The query looks like this (image attached). When the query returns nothing for example there are no records found under High Priority, it shows the error #Name?.

Hello, the image is already in form view, it is a datasheet form. This is how my query looks like (image attached). I specified the column headings as the Priority field. However if there are no values in the priority, for example, there are no records classified as High priority, then it shows...

Hello everyone! Reaching out for help again, I have a form that is based on a crosstab query, and looks like this (Image attached) when the query does not have results for example in "High" column. How do I get it to show nothing if the query has nothing instead of it showing "#Name?"? Thank...

It helped and I was able to correct most of the errors, I didn't know it would stop the debugging message, I was really having a hard time figuring out what could be the errors... Thank you for looking into it. Now I have another problem... the checking of fields, I am not sure if I structured...

My only problem now is this: this part works, it asks value for the 3 fields if the waiverapprv is YES If Me.waiverapprv = "Yes" And IsNull(Me.creditamnt) Or IsNull(Me.creditmethod) Or IsNull(expinvdatecredit) Then MsgBox "Please check empty fields", _ vbCritical, _ "Canceling Update"...

Thank you I will try it! :)

I think this part of the code is not working: Dim LF As DAO.Recordset Set LF = CurrentDb.OpenRecordset("tbl_LFrequests", dbOpenDynaset) LF.AddNew LF("entryid_LFinfo") = Me![entryid_vendreach] LF("InvoiceCount") = Me![invcnt] LF("WaiverApproved") = Me![waiverapprv] LF("RequestMethod") =...

I tried putting the breakpoint on the line highlighted in Red. I tried to run it by clicking the button. Nothing happens.:banghead: I think may be there is something wrong with my VB, I never had debug errors recently, I just knew there was something wrong because it does not work.