Search results

2016 on each - my laptop also has a 2002 version installed, and 2016 on my user's PC which was just installed and he had a 2000 version which is now removed - what do we need to check ??

I agree, but why works on my Laptop and an error msg on my user's PC - on which 2016 was just installed ??? It is the same database which I just sent him ??

We are moving a 2002 .mdb to 2016 .accdb. I am the developer and it is all working fine on my laptop. I have sent a copy of the database to my user, and he is having an error msg come up with a Macro which loads a form with a SUBMIT button, which executes a series of embedded macros, etc. and...

In 2106 Access, is there a place to set the week's Sunday starting day TO something else ?

Awesome- nailed it there!

I used an existing report format, and then changed the source table It is working fine, yet it still comes up and ask to Enter Required Parameter for field = cust. Group Level 1 ControlSource: Cust GroupFooter: True GroupHeader: True...

I just realized I have a button and CODE to delete an existing record. I believe I just need an UPDATE button added which will work just like the delete command ("DoCmd.RunCommand - acCmdDeleteRecord"), but only with the UPDATE option ?? That make sense ??

Attachment included

We do contractor billing. I have a form. It is populated by a query which grabs only the Contractor Uninvoiced line items from the Materials Purchased (for each Contractor job) Table. The form opens up in continuous mode, but only one record fits on the screen at a time. If I hit the "EOF"...

DoCmd.SetWarnings False countB = DCount("[Customer]", "Materials") ' IF the counts are off by one the insert was successful. DoCmd.RunSQL "INSERT INTO Materials (Customer, Job, Purchasedate, Etc, Etc) " countA = DCount("[Customer]", "Materials") If countA > countB Then...

RunSql - but messages suppressed. i may try dcount b4 and after

either way, i need first to know if insert was successful ... can't get that figured out ... in Access 2002

IF THE ONE RECORD inserted into 2nd table is successful - the next operation should be to DELETE that record out of the "work or 1st or input" table. These are SQL Statements INSERT INTO followed by DELETE FROM

Having a bit of trouble - maybe cause I'm on 2002? The above does not compile ... the Desc line. Might it be because I am using 2-3 fields as the sort sequence - for example: SortForm "customer, purchasedate,extended"

This is awesome and easy to apply!! Thanks. Only thing I may have wrong is that the underline of the 1st sorted column does not go away when I select a different column - both underlines stay on. Also, how could I bold or change font color in the sorted column ?

Gonna give this a try - Looks like exactly what I want !!

Let me ask this more speifically: On the FORM I load, how can I maybe have 3-4 buttons - each of which will re-filter.resort the data By: button 1) Amount button 2) PartDesc button 3) Inv# button 4) Purchasedate

The download from the Vendor will have ALL of the line by line Detail. Our Owner is concerned that his workers may fail at times to turn in the individual receipts and therefore some purchases and not making it onto the invoices to our customers. This process would show the downloaded receipts...

It will be no problem getting the SUMMARY into Access. As far as a AUTOMATED MATCH UP, we would have to do more DATA ENTRY of all or most of the FIELDS again from the Individual cash register receipts. As you said, "should be a cinch to filter it and append the relevant data to the actual db...

We are a Custom Carpentry Business I have a Materials Purchased table with a Cust# and Job# KEY. The other fields are: PurchaseDate LineAmount PartDesc VendorName vendorINV# From our Vendors, when we purchase Materials, we can get 2 different things: 1) the individual weekly Vendor "cash...