Recent content by crazy_ivan_1

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.