Search results for query: *

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...

The problem is we have two diffent secured databases and my end users can't access the other database without joining the workgroup. Is there some way I can create a shortcut (string) or some thing that will let the end user to access either DB without having to keep rejoining the other...

Is there a way to access two separate Access 97 databases with two diffent secured workgroups? I have an established database with over 700 client files in it. The Personnel office has a Access 97 Database that has for tracking time. They don't won't to tied the two together. The problem is...

Thanks a million your a life saver!!!! Mary....

I was wondering how can I have the date and the Endusers name automatically placed into a table each time the EndUser opens or closes a form? I tried using a Macro and Append query but it does seem to work... Chubby

Are you suggesting that these '44 other fields' are they are the 44 fields for AM , PM, AD, WE ? yes the TimeOfDay field just contains the text "AM", "PM", "AD" or "WE" The FieldName "AM Counselor" does contain someones 'proper name' Mary