Recent content by merciless32

Toolbar pain in the...... I made the mistake of removing one of my toolbars in my database. Now I have multiple toolbars opening sometimes, and NO toolbars others....!!!! I have to keep telling Access which toolbars i want to see on reports or forms or whatever. How do I go back to the...

Thanks I out together a few macros based on queries that run the reports in sequence. I used the Where Condition field in the macros to set the criteria for each report. I appreciate the help!

I have 3 different reports that contain information on vacation travelers. One has their personal data (Personal), one has their financial info (Financial), and the last has their travel data (Travel). All three reports have corresponding tables and a common field in each called Record#...

I have a code that activates a search query behind a form. How do I requery the form based on that queries results?

OK, I have 15 different tables and forms in my databse. I would like to build ONE query that will be attached to a button that filters the records according to a status field. This button would run a query that will display all records with an 'X' status. I would like to be able to put...

I have a form that allows a parent to select and login their child. I am tracking the login information in a table called Student_Log_Temp. I need a module that will scan the temp table at login to ensure that the parent hasn't already logged the student in previously. Please help.

Ahhh... Didn't think abut that way.. I'll try it! thanks.

I have 15 different tables. All 15 have 2 common fields, (Date, Status). I need to a cummulative count of record status by date. I am trying to either: 1) Append the data from these fields into a new table representing a combination of all 15 tables. -OR- 2) Count each table seperately and...

I have the following code in the control source block of the text box: =([Field1]-[Field2]) In the format block I have this code: ;\0 This places a "0" in the text box when the number is negative.

Never Mind.... Got it...in the Format portion I set the code to ;"0" This returns a '0' when the number is negative. Sorry to bother you guys.

I am calculating field values in a report. How do I set a field to return a '0' if the value in that field is negative number?

Got it...thanks... I decided to create a form and Dcount each table in unbound fields. Then I just totals those fields on the form. Also made it easy to create a report from the form. Thanks to everyone who posted! God bless!

Gonna try a crosstab query to update a seperate table. maybe then I can pull in my counts.

Nope...they are all different. There is no constant in them except for the Status field.

Each table is a seperate data entry form. The powers that be want it structured that way. In each for is a field called "Status" that records where the form is in the process. I need a rollup of each form based on this field. Make sense?