Search results

Thanks but it either tries to box the lit-1 and then opens with the error lit-1 so I tried to text it "lit-1" and then I come up with a data criteria mismatch.

No not to map her to your pc. Put both parts of the database into a network drive k:\, l:\ whatever. re link them and then place a shortcut on each of your pc's to open the databases. That way you will avoid errors when a pc reboots etc.

Why not put both on the same network drive and connect that way?

I have a report the details all jobs done. One of the fields is "Job Type" within this is Lit-1, Lit-2, Lit-3, Dup-1 and Dup-2. Is there a way to sum only one type of job in the footer? for example only sum Lit-1 job types? Any help appriciated

I am working on a production DB and part of what is requested on the report is the number of each type of job completed during a certain time frame. I have a table job log in that records the job type id. It links to a table job type that includes lit1, lit2 , lit3, dup1, and dup2. Is there a...

Thanks for the info but I am still having a brain fart and can't get it to work. How would I code the macro?

Queen Elizabeth & Dolly Parton die on the same day, and they both go before the angel to find out if they'll be admitted to heaven. Unfortunately, there's only one space left that day, so the angel must decide which of them gets in. The angel asks Dolly if there is some particular reason why...

I am working on an existing database created by another person for records management. My question is. It currently has a button on the enter records form that opens another form that will create an outo number for the box number. However on the enter records form this "box number" is input...

Thanks Pat as always you are a great help!

I have a report that calculates the number of hours worked in a given time. It also sums the weighted average per page. I need to divide the hours worked by number of weighted pages to get an "average pages per hour" However whenever I try to divide the two I always get an error message in my...

Yes and it did not work. Thanks for the help but I just found a sample db posting that should solve the problem

Please look at the attachment does anyone know how I can get the shorttime field to sum past 24:00?? I tried a modual as shown in ACC2000 but that will only sum from a table my times are calculated within queries. Any help appriciated need to install DB at client tomorrow.

Tried that can't change a primary key once data is entered and I have 74000 recoerds in there

Autonumber?? I have a DB with a records table. Somehow the autonumber field changed to a number field? Any ideas how this could have happend? Is there anyway to turn it back into an autonumber? any help appriciated.

Is there a way to add short time's together to get the total time worked over a given period of time?

I have a time clock within a production database however it alowes employees to puch in more than once a day. Which in turn destroyes the production information. Basically they go to the punch in screen and then choose their name from a combo box and then click the time in button. I have tried...

What is the table Msysaccessobjects? how did it get there? how can I get rid of it so I do not get an error message when I close the DB "table 'tempmsysaccessobjects' already exists"? Appriciate any help

Thank you, thank you Works great much appriciated.....

It is an existing database my wife uses at her company and she asked me if I could come up with monthly billing reports. To much data to change it now. I just need a way that if one of the check boxes =yes to place that amount into a new field.

only one of the check boxes will be checked so one will be yes and the other two will be no. I need it to take the check box marked yes and calculate the or enter the right dollar amount into a new field on the query