Search results

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!

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

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?

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

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

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

I know this must sound so simplistic, but I need to be able to set an Autonumber field beginning at a certain number, say 10900, and then index from there, but retain the entire value. I have been able to get the number to appear as "10910" but it is truly recognized (like when doing a search)...

How can I have a report, when it is opened, to prompt the user for a value (which in my case is a Job #) and then the report use that as the filtering factor to show only those records? I assume that it will take some correlation between a Macro, a query, and the report, but can't figure out...