Search results

thanks for the response gumby!! i pretty much gave up hope that anyone would respond the report is looking ok now just gotta figure out how to get a page footer on only the first and last page

ok - i realize lots of people have blank page questions and i have tried to search for the solution to this, but i have not been successful i have a report with 7 sub reports not all sub reports will always have data and i have set the can grow/shrink properties all to yes i want each sub...

THANKS!! thats exactly what i wanted to hear!!

i am hopeing that the database that i am currently working on will be able to be accessed by multiple users at the same time i'm planning on leaving it on a shared drive where 6 computers will have access to it my question is - how dangerous to the database is it if people edit and add records...

sure is! im going to assume that you'll use two list boxes (combo boxes are the same) list1: contains the stores list 2: contains the names of employees on the table with employees, you should have a field that specifies which store that employee belongs to go to the properties of the...

oh dear, i'm learning so much from everyone!!! i rememmber the start of this summer when anything that had anything to do with VBA made me cringe - and now i almost understand it ive got the two list boxes: listcat and list2 ok, so i have this coding so far: Private Sub...

hey! thanks for all the help so far ive been thrown around to different projects and now i have time to get back to this database i have it working to cascade the boxes where the second list is overwritten after each click of the first box i see the logic of your code now - its soposed to...

will the code that hayley proposed do the job that i just described? or will each click replace data in the second list box?

yes i would want members of both categories to be displayed and what i meant by retaining was just that they both are on the list at the same time what i am intending to do is have a table that has records of letters - so each letter would have multiple categories that it was sent to i'm...

sorry sorry for being vague but i am ultimately trying to create a form that allows me to do the following: i have names and addresses in a table and those records are categorized list1 displays the categories double clicking an item on list1 will result in all records under that category...

wow - you're fast thanks for the super quick response hayley! i have been looking at the site for a bit but cannot find a walk through of how to make a list box retain things any idea where i can find info on it? or does anyone have an example?

is there a way for me to compile a list using cascading list boxes? for example: everything category that i double click on list1 will result in every member of that category being displayed in list2 i'd idealy like to be able to mail out letters to different groups of people - so i would...

Thanks!!! Thanks so much for taking the time to reply! the example you did for me looks really good - i think the coding in it is exactly what i needed sorry about the late reply, i was pulled away from my computer the last few days at work and havent had a chance to look at any of it...

i'm an intern working with access and i've been learning a lot, however, i still have no idea how to do MANY things ive tried looking for cascading combo box examples in the forums but i come up with nothing what i want to do is be able to sort people in my mailing list database by category i...

ok, i've got one list box of categories and a second list box that i want to display members of that category what code do i need to get members of selected categories to be displayed (i want them to stay as new members are selected too, not be cleared) i'm sure someone has asked this before...

IT WORKS!!!!! woooohooo!!!!!!!!!!! thanks so much lloyd - worked like a charm! seems like its the only post that actually helpped even the microsoft page didnt work, but that bit of code you posted did!

ok - maybe you can tell i'm new to access but i just learned that you can replace the regular microsoft access splash screen (the annoying one that pops up everytime you open access) with a custom splash all you need to do is name the bitmap image that you want as the splash screen the same as...

you could just make the form a data entry form to get it blank whenever you open in and use macros to open the form and go to last record or possibly throw in command buttons for each situation you might want to do and link them to near identical forms (some based on query and some on just the...

the relationship needs a primary or indexed key in order for it to be a one to many relationship (primary key on the one that you want to be the one table) then u can make as many other "many tables" to be sub forms as you like

I'm pretty new at this,so could someone help me do the following: make a search for that has a text box for the user to type what they want a list box that does a wild card search for results (clicking results opens form with the selected record) a combo box that allows the user to change...