Search results

In a form I have a button that sends out a report based on information for that part number. In the report that gets e-mailed out there is a link to another form that uses the same tables as the first form. Currently the person that gets the email clicks on the link which brings up the form...

I have a macro that sends out 22 different reports, 2 per person. The reports get to the people, but my problem is when the user clicks on a command button on a form to send these 22 reports a chose profile box pops up each time and she has to click ok or hit the enter key. After 22 times this...

Dumb question. Under Tools and then Startup I've deleted the checks in; Allow full menus, Allow default shortcut menus, allow built-in tool bars, and Allow toolbar/menu changes. How do I go back and put a check in those boxes?

One database has a report that is sent through e-mail that contains a link to another database. when you reveive that report through e-mail and click on the link it opens the database it is suposed to but opens it twice. How do I fix this. could it be the format of the report?

I have a database that is on the company server. Throught the day many different people use the database often at the same time. Also those people may have either Access 97 or 00. Since you can still open the database in 97 I'm sure that no one has converted it from 97 to 00. The database...

Two forms in a database are linked by a field called "Quote" . On the first form all of the data peraining to one record is fine. But when you click on a button that brings you to the second form that has the same Quote number all of the fields are filled with "#deleted" This is the only...

thanks!

Uh???? I don't know if it's just my computer bieng slow or what, but I closed out of the database and opened it back up and all of the fields in the form that use Dlookup displayed the values automatically without having to click on them. Why would it show them and tnen not? I didn't change...

Where do I do that? In the actual field on the form or through VBA code? If possible can it be done without the having to code in VBA? I really don't like writing VBA code! thanks!

I have a form with a box that uses the Dlookup function in it. The function works great. My only problem is that when you open the form the box does not display the look up value until you click on it, even if the input value for the function was previously entered. How can I make the values...

Open the table that the two fields come from. In the design view click on one of the fields that needs to be fixed. Then, go to the bottom of the screen and change the FieldSize property to Double, format to what you want, and decimal to what you want. Do the same for the other field. Save...

I've got a database at work that is used by users of both Access 97 and 00. I don't think that someone has tried to convert the database from 97 to 2000, because one can still open the database in 97. The problem is that it will not open in 2000 at all. Even tried saving it as a different...

I have a form in which many different departments fill out information and then hand write their initials on a printed out report. I would like to set up the form so depending on who is filling out the information they can pick from a list or type their initials, or enter a password that could...

I have a database that people will enter and sign off on engineering change information and I would like to do away with physically having everyone sign off on a printed form. If i have a list of initials in a table as a lookup is it possible to set the individual password for each person so...

I have a report where a cycle time of a machine is multiplied by the hours run in order to get a total pieces. Is it possible to put a total of each detail "so far" in the details section? putting a sum in the footer is no good, I need an idea of how many total pcs are added with each record.

In one report I summed up multiple DETAILS to come up with a total cost of the product in the footer. I needed the total to show up on other reports so I made a copy of the report that calculates the total and shrunk everything except the total cost. Next I drug a copy of that report and used...

Is it possible to start auto number at a given number? Also I have two different types of data that I will track by different tracking numbers, is it possible to denote an auto number with a leter such as E or I? Thanks.

I have a report where all the details are summed up and at the footer of the report margin and other things are added. I have no problem calculating this, but I would like to take the total and use it on another report. Is there any way you can take a calculation form the footer of one report...