Search results

Hm, will that set the inventory number TO the amount I removed? I'd like it to minus it from the part. Example: I have 10 40GB Hard Drives. I have a customer, go to his screen, click 'Parts', select the Hard Drive and enter '2', I'd like my Parts On Hand to show '38'. Possible? No? Thanks.

Wow, that sounds like it will help. I have no idea where I go to change the code like that - but I'm gonna go try. :) Thanks for the help!

The database I'm using is a modified version of workorder management template - and I haven't changed any of the fundamentals, so it works exactly like that one. I know I need to learn more about what the heck I'm talking about, but I'm more of the hardware end of the PC spectrum and that's...

Heya gang, Not very good with this stuff. At all. That said, I've got a database that controls a lot of stuff - employee hours/scheduling, a list of our parts/prices, invoicing and customer management. It's working well (which is good for me), but I've got one final thing to do. On my parts...

You're just editing the data in the tables, not their properties or their names, etc. Correct me if I'm mistaken, gurus, but that shouldn't affect your table relationships in any way.

I've got a query for a game I play. First: A creature table. This contains the unique # (just incremented) and the name of the creature. Second table is creature location. This contains the unique #, again incremented, and the area its often found in. The third is items.. basically their...

Set it to have no border, then just use the toolbar to create a rectangle and adjust it to the size you want. This works great unless you often will need to go beyond that box (ie, go to 2 pages, etc). Otherwise, the rectangle should work perfectly...

Thanks tons! I got it working, I was a total moron, heh. Thanks for all the help and patience.

Is this in design view? Basically, I'm using the Service Call Management template from Access 2000. I've edited quite a few things, but the reports are the same basically. If you have the chance to look at that template, you'll see they use a form for all date-related reports that allows a...

Does the fact that I'm using a form to input the Before/After Dates matter? By the way, I'm using access 2000. The Wizard doesn't have any spot for entering criteria, I'm assuming design view does somewhere! Thanks, Scott

Just got back into work. Trying the query method (told you I was a newbie) and will let you know! Thanks for the input!

Hey all, I'm working on an applied time report. I'm using a slightly modified version of the Service Call Management template that comes with Access. What I'm trying to achieve is a report that will display the BillableHours by Employee for the date range entered. I copied the code of one...

Heya all, I'm using a modified version of the Service Call Management template that comes stock with Access. Just like the Invoice 'report' that they use to generate an invoice, I'd like to generate a work tag with just some basic information from the workorder form, and the workorder by...