Search results

yeah, yesterday it was only 5, this morning we figured out it needed to be 12 (and after this i will do something similar which will probably need 15-20) I wasn't expecting anyone to do the work for me, just to find out information, but maybe looking at it would help. I removed the photos so it...

yes exactly, i just dont understand how to do this in a query where it doesn't require ALL "problems" to be true

correct, guess i was thinking about it backwards

oh sorry, i see what you're getting at. this is an inventory of doors that may have something wrong with them. there are 165 doors and there are 15 components that may have a problem. I'm trying to write a query that scans the table and shows each door that does have a problem (one of the 15...

what would be ideal is to have ONE report that represents all checkboxes, and ignores records that have NO checkboxes. is that a cleaner way to describe it? thx

ok, then lets have qryOne (and rptA) look for chkA OR chkC. if i set both to true will it return a result ONLY if BOTH are checked? right now i have chkA, B, C in qryOne but only TRUE under chkA, the rest are blank, just included to my report will show the boxes. thanks for helping me think...

as it is now, if record#3 has chkA and chkC both true, rptA will show record#3 and rtpC will show record#3. and if i print each report out one after the next i get record#3 twice overall. im trying to prevent this, and also prevent writing 14 queries and 14 reports. if one record has 5 checks...

Bear with me if I don't explain this clearly... I have a table with 5 check boxes in each record. I currently have 5 queries and 5 reports, each query checks if one of the 5 checkboxes are true. this works well, but if record #3 has chkA and chkC = true, then my reports will show record 3 two...

Yes thanks, that is exactly what I want. One slight hitch in the code which was built for Nwind is relying on a primary key for a string. my table has a CallID primary key of type autonumber and throws back a type mismatch why doesn't the autonumber work as a string? should i change it to Dim...

How can I create a report that shows ONLY the record currently viewed on my form? I want to make a cmd button to email out only the currently selected record. A report is the best way to do that right?

can anyone point me in the right direction? I have a form with a combo box to choose the main indexed field. it auto populates the rest of the fields when you select one choice. if I press "new record" it blanks all the txt boxes (good) but I can't type a new entry in the main combo box (bc...

nope didnt work, i just trashed the switchboard and made my own from scratch :D but those were great links guys and i learned a lot of other stuff that is helpful

neither. see attached. this is my second DB i have had this issue with using the switchboard manager in access. maybe i just have to manually make a switchboard? and if i change it out of continuous it is only one command long...

I'm using 2007 in vista. when i use the switchboard manager and set the properties to popup the width is normal, but the length goes all the way to the bottom of my screen. anyone else experience this phenomenon? and what can i do about it? the footer is at the bottom of the blue box on the left...

thanks for responding. so here is an overview. we have a large office complex. 175 tenants. Im making a few databases and i need to be able to have two combo boxes, one for the suite number, one for the tenant name. if someone calls and says "im suite number 358" i want the name of the company...

hey thanks, reading that MS article did help a little, but its not exactly what i wanted to do. maybe i should simplify what i mean. i have two tables, A & B two combo boxes 1 & 2 which are autopopulated from colums in tblA. The form stores records in tblB. the comboboxes do populate the...

hi all, this is my first post. I was wondering if anyone could point me in the right direction to run an "on lost focus" event. I have two combo boxes, one for SuiteNum and one for TenantName. I want to be able to have access 2007 do a lookup if someone selects "suite 100" the TenantName...