Recent content by soulpiercing

This was actually a multiple post and I think I am making some progress off suggestions from the other posting located HERE. Thanks - I'll probably still try to catch you on MSN sometime.;)

I was just looking at that. In the query design view, properties of the Office field - change to combo box... etc Right? Then the main form uses this box to set the query? Is there a way to set the box to a blank entry? Also - now that I have this somewhat figured out.... Can I have...

I understand and yes - that is what I want to do. What I am trying to get at is avoiding having multiple queries that are identical other than the 1 filtered item. Another thought..... could I do a mass query of all of my data fields with the one filter in place, then base my other queries...

additional note All of the sub office forms will be the same - only the filter criteria will change. I think the drop down is more efficient, but the user seems to like the functionality of the tabs. Thanks :confused:

I am working on my DB an have another new issue at the request of one of the users. For user friendliness... My office structure is for example Main Sub1 Sub2 Sub3 But at another staion: Main Sub1 Sub2 or another Main Sub1 Sub2 Sub3 Sub4 The user wants to be able to have a tab...

I am currently working on a criminal justice tracking program for the US Army. The structure of our legal office is set up in a way that we can all use a centralized database which will make reports and tracking at all levels easier but there is an issue I am trying to resolve. Our office...

I am currently working on a criminal justice tracking program for the US Army. The structure of our legal office is set up in a way that we can all use a centralized database which will make reports and tracking at all levels easier but there is an issue I am trying to resolve. Our office...

I am currently working on a criminal justice tracking program for the US Army. The structure of our legal office is set up in a way that we can all use a centralized database which will make reports and tracking at all levels easier but there is an issue I am trying to resolve. Our office...

new attachment - searching multiple tables I posted the new .zip file of my DB after fixing a lot of issues now I am getting some new errors.... Could you look at it if you get a chance and provide ANY input. http://jag_clad.tripod.com/ or the file directly...

update on auto checking field to associate form I got some answers in adding the field in the query and inserting the string: me.fieldname = -1 into the before update property. I am still having some trouble and now getting another error.... I posted the new .zip file of my DB after fixing...

I have recently done an overhaul on my DB combining several tables into one then basing my forms off of Queries rather than tables (thanks for all the guidance on that issue). Anyway - I am trying to find a way to set up my query filters to only show the portions of the main table relevent to...

Sorry - didn't get the file attached - trying again

control number info there is a controlnumber field in the table and it is referenced on the form (but I plan to protect the field so that the info cannot be manually typed in). The number should increase each time the box is checked but no duplicates and preferably no unassigned numbers...

trying I have both set up but only the click is working - the timer is not.... Any ideas? I am also tring to play a .wav sound and have the code posted here entered - nothing seems to be working..... Here it is with my main menu and some other things deleted out....

I am sure there is an easy way to do it - but anyway... does anyone have a sample of code to set the display time for a form then automatically close it? I want to use it for a splash screen form I am using. Otherwise - anyone got a good sample of a splash screen? Thanks