Search results

I have got rsw.edit in the code where rsw is the current record set of the subform so not sure why it's not working. I did include a count to test that it was going through the record set, it's just not updating any values! Arghhhhhhhhh

Hi, I do have rsw.Edit where rsw is the current recordset, so don't see why it's not working! Afterwards, I have the requery just to force it to update so I can confirm the changes were made! Argh!!!!!!!!!!!!

Hi, On clicking a buton in Access Form, I want to update the status of the subform (which a based on a query of two different tables). However nothing happens. When I include an rsw.update instruction I get an error saying: The most recent error number is 3020. It's Message text is: Update or...

Hi Sorry, I didn't included them as I didn't think they were relevant (I am beginning to hate SQL/VBA with a passion - I could handle Filemaker Pro on my old classic Mac!) .... here's the full code for the recordsetwrapper: Private m_rs As DAO.Recordset2 Public Function...

I'm not sure if I'm making it too complicated. I have two tables; Ticket Details and Sales Details. Once I add a TicketID item onto the Sales Details table, I want to look up the TicketID and update the Status field in the Ticket Details table. I thought it should be simple (as the...

MACRO COMMAND ---------------------------- SetProductStatus(Me![cbTicket], 3) FUNCTIONS ------------------------------ Public Sub SetProductStatus(TicketID As Long, ProductStatus As TicketItemInvoiceStatusEnum) Dim rsw As New RecordsetWrapper If rsw.OpenRecordset("Ticket Details"...

Hi Adam, Sorry, tried to add the tabs for formatting, but when I posted it removed them all!!!!

I am editing the sample database Northwinds, using the recordsetwrapper functions to edit data in Ticket Details once invoicing orders in the Invoice Details table. However, nothing is getting updated in the Ticket Details table. The procedure is run from a macro button form when saving the...

The problem is that when the price or rates change, you won't have the old rates stored in the database and thus the query will spit out the wrong price for the product! Hence you need to store the current price in the table, so that it doesn't update when you change any of the prices!

Hi, I'm new to writing databases in Access (used to write basic stuff in Filemaker years ago) but can't seem to fathom Access lookup codes! I am trying to build a form that looks up the unit price, royalty rate and haulage rate of a product and posts an entry into the table to store the unit...