Recent content by desim

that's too funny. . finished up my post, just after you posted your reply

ok, figured it out. . CurrentDb.Execute "Update Locations Set Invoice='" & Me.dInv & "', Paid=yes, Paid_Date='" & Me.ddate & "' WHERE Address = '" & Me.dAddress & "'" I really don't know how the '" & Me.dAddress & "' string works, but I figured it worked for the "Where" statement. . it...

it partially works. . I don't really want my Invoice to be set at 12242, I actually want it to retrieve from another field CurrentDb.Execute "Update Locations Set Invoice=12242, Paid=yes WHERE Address = '" & Me.dAddress & "'" for some reason, I'm unable to point to a field. I tried: Set...

liking some additional help. here's my code: CurrentDb.Execute "Update Locations Set Invoice = 33333 WHERE Address = '" & Me.address & "'" the 33333 was put there for testing. and it works, however, I'm needing "Invoice" to be set via another field "d-inv". next, I need to do the...

yes, three fields in total. question, I'm doing this code builder (obviously I know), I'm no expert at all, only done a handful of these in the past, I have not come across the CurrentDb.Execute "UPDATE TableName SET FieldName this before. besides your "TableName. and "FieldName", I should...

oh. . I see what you did. . .you didn't update the field. . you updated the table. . ok. . I'll let you know how it goes. . thanks

re reading your response, you said my form should be based on the query. . I actually did that, but I realized I was unable to update any field (even manually), because the form is based on a query. . I think that is where the start of my issues are.

this is exactly where I'm stuck. I created the form, I have my field where I'm entering the name, but I don't know how to update my form to accept the query. I tried to create some sort of "afterupdate" to go to the address field and go to record, but obviously something is missing

I do have an ID field. . .maybe you can make me think a different way. so here's the story of my database. I'm an electrical provider, working on a new residential subdivision. when the service is established, one of our clerks adds the address to the database. now, the completed services are...

that does work, but because I have like (as an example) 20 address on "prosperity", but only 8 have been invoiced, the query would update "all" addresses on prosperity which I can't have.

my existing table consist of address of new customers. the data is entered as work order tags are received. my portion of the database is to add to the existing data "AFTER" invoices are received and approved. My portion is fairly easy, look up the address, check the box paid, add the date, and...