Re: Microsoft Access Database Helpppppppp.....
Thank you so much everyone :)
Re: Microsoft Access Database Helpppppppp.....
Thank you so much everyone :)
wait wait wait.. looks like you solved your problem. Now tell us how :ASA:
Re: Microsoft Access Database Helpppppppp.....
Sid,i haven't resolved my problem yet, will keep you posted on that :)
Re: Microsoft Access Database Helpppppppp.....
Guys, I can't copy the query in excel it has 44,000 record. just really need help in macros.
@PrinceMS I can't find "ID" and "Name" in Permit Type drop down.
Re: Microsoft Access Database Helpppppppp.....
Sorry. I have never worked with macros.
Quick question though: If you select the permit type and enter the permit number, should there be only 1 record or multiple records for the results? I can probably help you with the query if you can zip up this database and PM it to me. Looks like you need to relate the correct field on the form to the input of the query.
Re: Microsoft Access Database Helpppppppp.....
@us1415
should be only 1 record. guys I need help in form from query which I already created it. Thanks
Re: Microsoft Access Database Helpppppppp…
Using Access for any kind of data archiving is a bad idea . . . I don’t even agree with the basics of this thread 
Re: Microsoft Access Database Helpppppppp.....
Helppppppppp :(
Re: Microsoft Access Database Helpppppppp.....
I am still here but I dont have any way of helping till I can see the actual database. :(
Re: Microsoft Access Database Helpppppppp.....
I am still here but I dont have any way of helping till I can see the actual database. :(
This is really very easy query. SO8 needs to post all tables(with all fields in each table) instead of just one screenshot of schema.
It will be matter of a minute, if I know what PK and FK in schema... but unfortunately... SO8 is not getting that point.
Re: Microsoft Access Database Helpppppppp…
I don’t need help in query. form mein help chahyeh
Re: Microsoft Access Database Helpppppppp.....
Re: Microsoft Access Database Helpppppppp.....
@mahool there are 70,000 records in each table aur woh nightly updates hotae hain. 4 tables. how do I send you those?
Re: Microsoft Access Database Helpppppppp…
I am not asking you to post data… what I am saying … structure of database…
Table…
Fields in that table… not the data value or record of that table..
Table: penr_permits
Fields:
File_ID
Session_number
Src
… and so on… I can not see all fields. because you need to do scroll down to show all fields in your posted screenshot on previous page…
Re: Microsoft Access Database Helpppppppp.....
jistarah...
Table: Penr_Properties
Primary key field is Property_ID
Primary key has a key on left side.. if that field appear in other tables.. then field in that table is called foreing key... jaisay property address table main property_id hai...
Table: Penr_Property_Addresses
Foreing key field is Property_ID
Re: Microsoft Access Database Helpppppppp.....
Ok let me send you that. btw, I am not using all the fields from the table.
Re: Microsoft Access Database Helpppppppp.....
Ok let me send you that. btw, I am not using all the fields from the table.
Yeh woh azeem query hai... jiski badolat apka atka howa task complete hojaye ga...
SELECT F.FACILITY_NAME1, PERMITS.PERMIT_STATUS, F.ADDRESS_DESCRIPTION, F.CITY, F.STATE, F.ZIP_CODE
FROM PENR_FACILITIES F
INNER JOIN PENR_PERMITS PERMITS ON F.LOCATION_ID = PERMITS.LOCATION_ID
WHERE PERMITS.PERMIT_NUMBER = here you will provide permit number from text box... in your macro code
AND PERMITS.WORK_GROUP = here you provide permit type from drop down in your macro code
Re: Microsoft Access Database Helpppppppp…
Re: Microsoft Access Database Helpppppppp.....
@mahool where do I enter that?
Re: Microsoft Access Database Helpppppppp…
Search Record button will hold this code.
I believe that is macro programming in access…you need to search tutorial how to place query behind that search button.
Unfortunately, I don’t know much about access. But this query is still good for your task.