Search results

thanks, but.... I appreciate the help, but I probably didn't explain well enough. The A, B, C, and D are ALL different fields. I know what you are saying, but it isn't that I want two options in the same field, OR two options in another field. There are four fields, and I need either (a...

How do I set the criteria of a query to be ("A" and "B") OR ("C" and "D") where the letters correspond to completely separate fields? Do I have to do that in a SQL / VB statement, and if so, how do I write it? Thanks all!

You are awesome!!!! I CAN'T THANK YOU ENOUGH!!!! Thank you Thank you Thank you!!!!!!

Now I really am scared. I have posted this message twice with people viewing it, but no replies yet! YIKES!! I think I have inadvertantly locked myself out of Access 97 while trying to work on protecting it from certain users. It now asks me for a password when I try to open Access. How can...

While working on trying to lock certain users out of certain parts of an Access 97 file, I somehow locked myself out of Access altogether!!!! Yikes!!!! When I try to open Access 97, it shows a form with "Name" and my initials, then "Password" and I have no idea what the password should be. Is...

I am trying to insert a chart to the report footer of a report. That part is not a problem. But I need to use a value that is calculated in the report itself. Is this possible?

Hi all! How can I use a mathmatical calculation that is part of the detail of a report as an axis for a chart in the same report? I have a Sell Price pulled from a Query, then a Probability percentage of getting that order pulled from the same query, calculated to a probability sale amount on...

I have an odd problem. I have a form where the user enters data, and then another form where the user would later edit and add additional data to the original record. (Add New Proposal Form, and Edit Existing Proposal Form). If the user only enters data into the Add form, the information does...

Thank you! It works great!

What expression do I type in my criteria so that it will only show the results with the date field within the last week?

How do write the Criteria so that the user will be prompted to give a From Date and then an End Date and the query show only those records that fall within that time frame?

If I understand you correctly, it would probably be easier, and more beneficial later, to use queries to link/combine the information. And then use a subform based on that query in your main form if you need it there.

How can I enter data into a form, then hit a button that will save/copy some information that will automatically be entered for the user as it opens a new record? I am using a Job # and a PO#. I want the database form to keep a new Job # at the top, adding it to the new record, but permit new...

How can I set a command button in a form to save the current information, go to add a new record, while saving some of the information just added? For example, the person enters a Job number, then proceeds to enter items into a purchase order. When they are done with this PO, I'd like them...

Figured this one out, thanks!

I am setting up a PO form, where the person will choose a Vendor from a list box. If the vendor is not there, they click on a button to open the "Add Vendor" form. When they are finished adding the vendor information, I have the form set with a macro to save and close the add vendor form...

I am using a sub-report that is tied into the main report by a "Job #" The sub-report will list anywhere from 1 to 25 items for that one job #. I have the report set to ask for a particular job # when it opens, and it will show all the items in the subreport as it should, however, it will devote...

Thank you for the response, but no, I have checked those, as well as the entire report's properties, the subreport's properties, the detail sections of both, and none have been set to start new page. Any other suggestions?

Base the report on a query, and set the criteria for the date as (Like "*" & [Enter Date] & "*") without using the paranthesis I put in. When it opens, it will only show the records associated with that date

I am using a sub-report that is tied into the main report by a "Job #" The sub-report will list anywhere from 1 to 25 items for that one job #. I have the report set to ask for a particular job # when it opens, and it will show all the items in the subreport as it should, however, it will...