Search results

Hi pr2-eugin just a quick question is there a way i can modify this code so i can search in multiple tables for example right now it searches just my orders table which is assigned to the form how ever id like it to also search the address from customers table according to the customer id

oh wow yup makes perfect sense thank you so much for your time and efforts very grateful:D

wow thank you so much worked like charm i would ask what the problem was but i dont want to waste your time

thats weird isn't the database attached ?

yup course i have attached the dummy database

ok i have the following fields in the screen shot, its linked to customers table with customer details so in the form i want to just search anything name, id address and once the search is done the results are displayed in the form fields. so far so gd the search works but when you enter...

oh lord this is driving me crazy now i get the following error soo weird

thank you for the code it still searches normally for existing records but none existing still same error please see on attached screen shot

hi there Pat Hartman now i understand how it works may ask you an additional question the look up option which does the combo box how would i implement it in such way for example gets customer ids from the customer details table, the combo box is in orders so when am in orders when i...

ok after closing and reopening the database i get that same message the one in your screen shot but what does it mean i mean how could i solve this problem in the screen shot when i search a record which does not exist i get this error

nothing when i search the right information i can do a search no problem if i leave it blank and search the run tiem error comes up the same one

i did what you said but nothing comes up on the new window when i press the button

oh my am so confused right now is it possible for you to show it just a section of my code so i can understand more clearly thank you

ok thank you i will look into that but like i said i am very new to this its very confusing

hi there i have a search button on the form which does work does the search very well how ever if a wrong search value is entered which does not exist in the database i get the Runtime error "3021" here is my code Private Sub cmdSearch_Click() Dim bkmk As Variant Dim strField As String Dim...

ok am confused now haha am fairly new to this main table has customer details with primary key id for each customer i want each table to get the customer details same fields from the main table onces the id is entered into a new row so that once one information is changed in main table all the...

oh ok i understand however what i am trying to do is make forms inorder to do all the operations in a GUI format instead of going into query's and tables so what i want to do is as soon as i type a customers id into relevant form or table i want the rest of the fields in that row to be filled...

:confused::confused::confused: Hi there i am stuck on the relationships section of access basically i have a few tables which id like to link with each other and have one main table where each of these tables obtain their data for example main table is customers with customer id name surname...