Recent content by chubby

See, what I'm trying to do is build a report which shows each compartment (on a single sheet of paper) listing all 41 Discrepencies with checkboxes. An inspector, inspects an compartment by checking the discrepencies instead of writing it out.

I have two tables that must not change. Table 1 has 41 discrepancies codes, Table two has 1230 compartment names. So, how can I build a query so that I can build a report that contains each compartment listing all 41 discrepancies under it. List all 1230 compartments each one listing 41...

I'm using the QBE and I try this and it did not work.

I'm trying to add "*" the beginning and ending of a field that contains 1233 record. Field: comparment Table: tbl_compartment listing Update to: * Criteria: At the begining and end of each record Example: 4-77-0-C What I need *4-77-0-C*

Are there any all in-one barcode programs with wand that I can use under 200 bones with Access?

I was wondering is there a way to randomize a report so each time the end-user opens the report it's different. I have an "Zone Inspection Database" containing 500 rooms broken down into 16 zones. Each week, one zone is picked for inspection. How can I make my report randomize between zones...

I have a report that I need a complex autonumber issue to the end user after he/she puts in a troublecall. Is there an easy way to just make autonumber system output: 100-1 100-2 100-3 or 1001-1 1002-1 1003-1 or any number combo with a dash in between the last number?

How can I count YES or NO check boxes in a form? =count([fieldname]) does not work...

Is there any way to turn off or change the shift function on ACCESS? I would like to use another key to open my database to the design view.

Man-0-man you're awesome!!! I wish I would take a class or something learn VBA and get half as good as you. Thanks!!!!

Thanks a million. I love it! But there's one problem. It will not open up the form after I entered the correct pass word. It comes up with the password box, I type in the and that's it. Did I miss something? How do I get it to open up the form.

I have a form that has a button on it that opens another form containing cartoon pics. I like would to password the button so only me and three other adults have access. The staff don't want the kids to have access to all the pics...

I tryed that!!! You can't access the database at all. Doesn't anyone have any other ideas. I really need this database... PLEASE HELP!!!

OS:windows 2000 Ver: Access 2000 Network: YES Security: I use the Wizard (have the one-step secuirty wizard report) Problem: I built a very important DB on my C/ drive. Then I used the security wizard to security it. Then I placed it on the network s/ drive for use. Now I'm totally locked...

One task I've been repeatedly asked about is if I know how to create a PowerPoint from an MS access report. Attached is a ".bas" file for importing as a new module into MS Access 2000. This module contains many procedures which work together in order to take any MS access report...