Search results

Thanks Edgar. Appreciate all your efforts to figure this out. Good news is the last two from Post #21 returned the results. https://api.procore.com/rest/v1.0/projects/999111/rfis?filters[created_at]="2023-05-15T12:00:00Z...2023-05-29T12:00:00Z"...

Good to know about testing directly in the browser. I tried your suggestion of running in the browser and with both of your examples, it returned all the records (I copied partial result from first record) which is the same result I got in my variations in vba.

Thanks Edgar, Post #16 works. Between the time of my last post and seeing your response, I was able to find a code example of how to use Curl directly - grabbing bits from 2 sites as commented in the code block: Sub devstackcurl() 'https://www.devhut.net/vba-send-email-using-windows-10-curl/...

I tried the suggestions from #5 and #10 and both gave the message: Regarding #14, I did look at a bit of that before I posted my original message. Maybe because I had done a lot of searching prior to that, I wasn't able to focus or locate the portion relevant to building the string. Since...

Thanks Edgar, I'll review your messages on Tuesday as they are letting us leave early for memorial day so wrapping things up. Appreciate everyone's help and was not expecting responses so quickly right before a holiday.

I tried inserting into the code and replacing the long numbers with the actual numbers, perhaps how I've done it isn't what you guys meant? Still get an error. Then again, I'm not sure what the line that says code is because in the original curl statement Procore gave me, there was no code...

here is the link they provided: https://developers.procore.com/reference/rest/v1/authentication?version=1.0

Probably took on more than my current knowledge. Read a few threads here and did searches and read other sites. Have gotten close, still missing something(s) since haven't been able to get the code fully functioning. I had some help setting up the account with someone from Procore API...

Here is a demo of how to work with the QBE to graphically map fields for append queries. It is in a zip file that includes instructions on how to use.

This? https://learn.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa219371(v=office.11) OlDefaultFolders Or maybe you could use some variation to loop through the folders? Sub Which_Account_Number() 'List the account number for each email address useful 'to find out...

Sorry, late to work due to car encased in Ice. Here is the code with some slight edits. It called a few other functions which you may not need, but included in case of use. If I missed any other helper functions, let me know. The part that searches for previous messages is under...

I have some code that may work. If I understand your question, you are looking for an email that was already sent and match/select it based on the subject string. The message will contain the previous message text and new message text. If so, then I will edit the code to remove some personal...

Sorry for adding, only thought in case someone else read the thread looking for ways on how and might be able to find the code option of use.

Not to wade into the normalization issue, as there are some cases when reporting may need to adjust data or receiving a download from a third party that needs to be refined in order to import into a normalized schema, here are functions from Allen Browne that may work for your situation...

Maybe this as a starting point? Search term: vba to add fields to a form in access https://docs.microsoft.com/en-us/office/vba/api/access.application.createform https://docs.microsoft.com/en-us/office/vba/api/access.application.createcontrol

Ok, here is a version with one text box to show the file size and a textbox for the message. If that still isn't what you wanted and maybe you were looking for a messagebox instead, then you can change the textboxcode to a messagebox. I hardcoded the filename and removed the space as I assume...

I can put another example together tomorrow. You don't need multiple text boxes. My example had it because I copied from my database where I purposely had the files displayed so that the user would know which database was affected. Since your case doesn't seem to need that information, it...

Here is a stripped down ugly example. I hard coded some values in the file name text boxes, so the code would work. However, those would be changed to unbound text boxes and the names would be passed to them from your actual files.

Another way of going about it. I put a text box on the form and then have a color code depending on the file size going from Green to Red and then after a particular size if user still hasn't compacted, then displays a message requesting to compact. Uses a vba function FileLen instead of...

Something I usually do when finding suitable code is copy the weblink and the date I put into my database. That way even if the code itself didn't contain the notice (which I keep as well if it is included in the code), there is still a reference from where it came from (of course that does not...