Search results

First I have a lookup form called AddressLookup. Then I have a form called Services and I also have a form called ServiceEvents. Every Address will have a service. and for every service there is an ServiceEvent. The user will go to the AddressLookup form and search for an address. Once the...

the reason I asked is because. tbl_Service is the only table should be related to vAddresses. tbl_ServiceEvent, tbl_OffStreetService and tbl_Cart should be related to tbl_Services. I just have to remove the AddressID from those 3 tables.

does every subform on each tab has to be related to the main form in order for it to work?

yes each subform is linked by the AddressID to the main form

should the tables just be related by AddressID? Because everything is based off of the Address. I'm sort of a newbie so I'm trying to get this relational database and database integrity stuff down.

ok, that worked as well....now how do I update records on the subform

also I need to be able to update the record on each tab.

ok, that works like a charm. My next thing is. I have another form called AddressLookup which gets the address. It is a form that has a dropdown box with the street names and a list box that displays the addresses based on the street name chosen. When the user double clicks an address I...

thanks I will give that a try!

Ok guys I need major help!!! I need to create a form with a tab control that has about 4 tabs. I have an address view, 3 tables. The reason why I have to use vAddresses as a view is because it is the city's main address database and everyone that uses it in their applications has to use it as...

ok, how do i use DCount()

I have an access form that allow users to enter some data. for instance, they will enter a FileNo, date, FileName, etc. When they enter the file no I want vba code to see if that file no has already been used. If it has been used send a message back to the user that it has already been used and...

I need code to increment a value using a counter. I have a form that the user enters information when a customer purchase a brick with an inscription. The customer can buy as many bricks as they choose to. if a customer purchase more than one brick with different inscriptions the user need...

ok i got it working now. i thank you from the bottom of my heart for all of your help!!! i added the following code to the click event on the form itself. Private Sub cmdUpdate_Click() Me!Status = "Closed" ' Change the value Me.Dirty = False ' Commit the change MsgBox "File Successfully...

ok, i'm no longer getting the write conflict error but it's not changing the status to closed. here's the updated code: Private Sub cmdCloseFile_Click() On Error GoTo Err_cmdCloseFile_Click Dim Result Dim rst As ADODB.Recordset Dim adocmd As ADODB.Command Set adocmd = New ADODB.Command Set rst...

ok here is a copy of the database with local tables

yes i will try and do that...

ah crap!!!!! well thanks for trying

ok, again i really appreciate all your help

let me know if you can't open it.