Search results

So, when I try to create data access pages in my front-end, it freezes. Wizard, design mode, anything--freezes. It's not my version of access, b/c I can create them in other dbs...it's not my computer, because other users have the same problem.. any ideas? it's an a2k2/3 front end linked to...

so i have a button on my switchboard that prints a report... the problem is that when it's clicked, the database window -- which should be hidden! -- is revealed. the code is (it's just slightly modified wizard code): Private Sub cmdPrintAlphaRoster_Click() On Error GoTo...

thank you! I can't believe i missed the options buttons. My problem turned out to be simply that I didn't have a necessary footer. Thanks to everyone who offered up tips! BP

Thank you, Col, however I noticed that this counts all the records. I need it to only count the records on the lowest level of the hierarchy (specifically, the names). So if my first header is COMMAND SUPPORT, and there are 5 names before the next header, i need to display the # 5. same for...

and here's the design view... it's easier than explaining how i set it up :) the wizard set it up like this

here is a shot of the report in preview mode

Col - If you're referring to the grouping -- I already have the report grouped, but I need to count up the records... I didn't see anything like that in the wizard, was that what you were referring to?

Yes, I'm grouping in two levels: Work Section and Position: Personnel Office Executive Staff John Doe/4867999 Jane Doe/4867999 Arsenio Hall/6639399 Total employees: 3 Finance Office Money Grubbers...

Afraid i'm having a bit of trouble understanding... there's numerous iterations of each group.. what kind of function would i use to count the records in only one iteration of the footer level?

Is there a way to count just the records in one iteration of the detail?

Hello everyone, I have a report in which I have numerous records in a sort of step format, sort of like this What office they work in -> Position/Job title ->->Name/phone# etc. Now this , as you can tell, generates several groups of 'stepped' records. what I would like to (okay, love to)...

Sgt -- I'm assuming you're assigned to Yokota? I'm at Ramstein myself! Anywho, I finally figured out what was wrong -- thanks to whoever suggested examining criteria that would eliminate any records with blank fields -- I can't believe I missed that! THanks to everyone who took time to assist...

aye, there's the rub I appreciate your suggestions, guys. Bob -- we fortunately have other software to maintain personnel data, so I don't have to maintain a precise history. Sgt - thanks for your pointers; that sounds exactly like what i'm trying to do (you sound like you work for the same...

Thanks! However, i'm a gui kind of guy, so that code would be impossible for me to implemenet into my already existing tables without learning some of the syntax and how it translates into gui actions -- mind briefing me? such as nz and that sort of thing. thanks bp

okay, so i hvae two tables, we'll call them "a" and "b". A has a series of names. B has a series of what we call "position numbers". For resource mgt purposes, we have to slot each individual into a position #. Now two people can belong to one position #, but one person cannot be in two...

so i have a table with like 5 email addresses, and some code that docmd.sendobject's a report or sometimes a query, and i want the to box to be populated with every record in the aforementioned table. i searched the archives but no simple answer leaped out at me -- is there one? thanks to...

isn't there a special kind of query you can run for that? check the help files for somethig about duplicate records or something bp

i can't believe that was right in front of me. boy, are my cheeks red. thanks, Ken!

so i have a field in a report, and i want it bold if it has a certain value. 1. where do i put that sort of code? 2. and what property controls fontweight of a text box programatically? thanks, bp

i don't know how, or why, but problem solved all i did was close it and open it again. ah, well, thanks everyone