Search results

What is THE Best way OR the best product to get a pdf into a text file from where I can process it with VBA? I do this on another application where I can copy content right off of a web page, paste it into Excel, transfer it to an Access Table, and then process it with the VBA code. This...

I added a 2nd "total" field unbounded, and IF filled in then moved that amount to the the Table field - as an override.

The "total" field is bound to the table. I am kind of "backing down" on the system requirements cause the user will not often be willing to enter all of the construction job "AMOUNT" details, e.g., the hours, rates, O/H %'s, Sub-Contractors, etc. They would be willing to simply enter JUST the...

I have a "added-up" form "total" field which is based on a bunch of prior entries. Is there a way to "IF" those prior fields are filled in, then use the formula for this "total" field, ELSE the User may just key in a "total" directly into the "total" field, essentially bypassing all of the...

I want the "rolling" value of Sliptotal field to appear on the form in an unbound text field Private Sub unitprice_LostFocus() Dim OHratex As Variant Dim OHamountx As Variant Dim Taxx As Variant Dim extendedx As Variant Dim SlipTotal As Variant Dim SaveSlipVendor As Variant Dim...

In my form vba I calculate aN UNBOUND variable which spans multiple entry records. How do I get that "rolling" value to appear in an unbound text field on the form ?

isladogs - Very Professionally designed and documented System.

How hard would this be. Change to a BATCH matching process. The records in the downloaded Table from the Suppliers would contain (among many other fields): The Customer of ours which was relayed to the clerk and keyed in by the clerk at the time of purchase A blank field (bestmatch) to be...

This keeps digging deeper and deeper into the minds of some of the smartest and most sharing access minds ! :-)

Is it easy to show the % to the right of the "name"?

I tried a bit of the Excel. My first impression is that was a bit “rigid”. I will be spending more time on the test we have been given to try.

This test database u attached is a very cool and sharing way to empower others. Thanks much!

You have the issue correctly identified. Yes, we have a Customer Table keyed by a Customer Last Name. We Have a Supplier table key by Supplier Name: Home Depot, Menards, etc. We will get an Excel download from our Suppliers with the "reference" and/or the P.O. "number" (NOTED FOR THAT...

The database design is fine. This response is exactly what I was hoping to learn about.

Home Depot supplies the contractor with a weekly download of all the specifics of everything purchased, including the customer reference that the worker relates to the clerk and which is reported back to contractor in the download.

Just wonder what ur thoughts or ideas might be on this? When a custom carpentry business worker goes to say Home Depot to purchase materials for customer job keyed in the accdb by the name “stanchina”. There is no prior p.o. Cut here! At checkout, the worker tells the clerk that the parts...

I may have found it. I ran the documenter against forms only and got 2 error msgs for forms that still had the old calendar control in them. I fixed those 2 and resent the database to the user. We'll know soon ...

I did find every possible use of old calendars in the 2002 database and removed all the references and it all works fine on my laptop, then that whole altered and fine running with no errors .accdb was sent to my remote user who had just installed the 2016 on and then that error msg somehow...

Ok I see that. It is gonna be a while b/4 I can get my user to do the same. I assume that we should each have the SAME ones checked !

Go to the VBE window - lost me there ...