Search results

Wow...that works perfectly. Thanks I was having a look at your code. If I wanted to do an additional set of comboboxes unrelated to the first, would I need to recreate the public function with the alternate combobox names?

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...

I figured out how to do what I want. You're example got me thinking. I made the instrument name field in the count details subform an unbound listbox connected to instrument name which then filtered the second instrument subform to browse instruments. I just need to do some buttons that...

Hi Arnelgp This is my current working database. The names of some of the forms are not ideal as im just working with them at the moment The main count form is called "frm_instrument_count" which has the count_date and the staff_ID in there is the "frm_instrument_counf_info" which is based on...

Thanks for that arnelgp It works well. I was hoping to a subform based on a query where the staff can browse through a series of records and place values rather than through a drop down. I'll attach a few forms files tomorrow (its 10pm in australia) that I've been working on to show what I'm...

Thanks for replying but I am not following what you mean...

no its 1 staff member that will count all instruments in 1 day

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 figured out what was wrong. I accidentally deleted the query from the row source so it was not generating the query. Sorry for all the hassle. Thanks for all the tips.

Thanks for the replies. I got the "All" to work The filter doesnt work in VBA for any other category. I still get an input prompt

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...

Thanks everyone for your input and there are no feelings of criticism. I think that feedback is always helpful as there are often times we might overlook something. I am a dentist by education and I am doing these databases to help me with my clinic management. I will take all the suggestions...

Hi June7 and jdraw, I did what June recommended and actually found the weblink jdraw mentioned. I found that using the composite indexes actually created more issues and I realised that I didnt need that many unique fields. So I restricted the PK to just the autonumber in the main table In...

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...

thanks all i tried DoCmd.RunCommand acCmdSaveRecord DoCmd.Close Forms!Main_nav_frm!Navigationsubform.Requery still couldnt get it to work. I maybe the way I have done something in the setting up of the DB. I'll keep tinkering, but for now ill use the browse to function.

I'll try some of the other suggestions tonight. Thanks for everyone's input so far. Ive learnt a lot so far about form syntax

DoCmd.RunCommand acCmdSaveRecord DoCmd.Close main_nav_frm.navigationsubform.form.z_lab_summary.form.requery I tried it but i get an error saying object required. so I may not be drilling down far enough or I have drilled down too far

Thanks...that makes sense. I am still learning VBA syntax and could not find an example of the syntax that essentially drilled down so far. I'll give that a go later today and report back as to how it worked I am assuming that the VBA code from the modal save and close button would be...

This is an example of the main_nav_frm in form view. The summary tab is the first form in the main_nav_frm button The 5 subforms (only 4 are visible) are set in z_lab_summary_frm which is what display when the summary button is pressed. So when i click the tick button in "Return" in Due this W...

I tried this technique, but they forms would not refresh or requery. The 5 subforms are in a form that is loaded from the prebuilt in access navigation tabs hence the browseto code that I am using at present that seems to work. Like I said, I cannot figure out why the other options mentioned...