Search results

Hi, I'm trying to create a rating system of sorts. I have 5 fields with a combo lookup. Each lookup has values 1-5 I am trying to get the comboboxes to update based on the values of the other fields. E.g. Cmb1 has number 4 selected So cmb2 to cmb5 will only show numbers 1,2,3 and 5 Then...

Hi all, I am trying to create a form to count instruments at my workplace. I have a table of instruments that is queried to reduce the list to the countable ones. I am trying to set up my forms so that I can have a a point to list the date the instruments were counted and by whom, the actual...

Hi All, I have been browsing here and stack exchange for help with syntax and getting my combo boxes to work on my form. The first combo is ins_filter_cmb. This gets it record sources from a query but there is also a UNION to add an "All" at the top of the list. This is a list of instrument...

Hi all, I am currently building a labwork tracking database. In my main tracking table I have a. ID(autonumber) - PK patient_appt (date) - PK patient_name (text) - PK clinician (text) - PK laboratory (text) - PK I may not need that many primary keys, but I am new to access and I think they...

Hi everyone, I have been having a terrible time trying to get my forms to requery and refresh. In summary I have a Navigation form called main_nav_frm Within this there is a tab called Summary The Summary Tab is made up of a form called z_lab_summary_frm The z_lab_summary_frm has 5 different...

Hi, I'm a super amateur access user. My actual job is in health services as a clinician in a private clinic. I have been programming in access to help streamline clinic processes such as staff roster and timesheets, hr monitoring etc. It's great to see a community like this and I'm hoping to...