Re: Microsoft Access Database Helpppppppp…
Re: Microsoft Access Database Helpppppppp.....
so confusing.... I already have the query. but just need help in form to add macros.
Re: Microsoft Access Database Helpppppppp…
so its open like this add this code to unbound drop down combox. but I want only work group: AP, GDO etc..
then type permit number
then command button search record.
then automatically display…
Re: Microsoft Access Database Helpppppppp…
okay @S08. Let me see if I can help you a bit. Can you please go to the link below and let me know if this is what you are looking for? I am using this for general idea not an exact match.
filtering microsoft access records based on combo box predefined values - Stack Overflow
Re: Microsoft Access Database Helpppppppp…
ok guys i am youtubing… 
its getting there but not so close 
-
I created a form based on query.
-
Made macros and created a command button to search by “permit number”. I searched it display the information but there are different types of “Work group” but same “permit number” s
See For Example:
Work group Permit Number
AP 12
IW5 15
IW6 12
APCF 16
GDO 12
how do I do that you see common number “12” permit number.
Re: Microsoft Access Database Helpppppppp.....
Merge the Work group and Permit Number so you have a unique key, identifier?
Re: Microsoft Access Database Helpppppppp…
btw, this is the macros I used.
Re: Microsoft Access Database Helpppppppp…
Re: Microsoft Access Database Helpppppppp…
Re: Microsoft Access Database Helpppppppp.....
How do I do that @Sidra54?
Re: Microsoft Access Database Helpppppppp…
OP, Are you going to share your salary with Sidra54? 
Re: Microsoft Access Database Helpppppppp.....
af course ;0)
Re: Microsoft Access Database Helpppppppp.....
Man! I really wish we could have a lync, webex or gotomeeting type of meeting to resolve this issue once and for all.
Re: Microsoft Access Database Helpppppppp.....
HI S08, I am not familiar with Access. This is the solution I saw online.
Create the combination with the expression builder in a query using the "&" to join the fields.
Re: Microsoft Access Database Helpppppppp.....
guys, I posted all the screenshots and explanation aur kia. @us1415
@Sidra54 please share the link here.
Re: Microsoft Access Database Helpppppppp.....
guys, I posted all the screenshots and explanation aur kia. @us1415 @Sidra54 please share the link here.
I cant troubleshoot until I have the actual database. I am not very good with remote assistance. I need to be able to change things and see what happens.