Search results

I have modified a database that included a switchboard. All references to the switchboard have now been deleted but when I open the database I get a message stating that the switchboard is unavailable or that it has been mis-spelt. How can I prevent this message from appearing? Thanks in advance.

You need to create an additional field in your table for people who have retired, Then just filter them out with a query.

Your question is a little confusing. I think you have copied your original report and writen a new query to select the customer. Are you sure that your new query is referenced on your report? if it is, run the query on its own and see if that works.

Your report should be based on a query. In the criteria of the date part of your query add: Between [Enter Start Date] and [Enter Finish date] You will be prompted for the dates when you run your report. Sorry, didn't see the previous reply by DavidR. Keep to the same post please Jacqui...

Access doesn't do complicated charts very well. Stick with Excel.

In the criteria add >Date()-14 Sorry, I did not read your post correctly so please ignore me! [This message has been edited by saintsman (edited 03-06-2002).]

Is the £ sign being inserted into your number field? (or is it attempting to).

Are you sure that they are the same data type? I've been caught out several times with this and found that I've had a text and a number field. So obvious that you become blind to it.

Try using the wildcard '*' in your box and see if that helps.

Assuming your report is based on a query (which it should be) your problem will lie there. If the report is blank it is because the criteria in the query is not selecting any records. A table can be full of information but if you don't ask the right question you won't get the answer you are...

It's early in the morning but try this. You can have the same form in appearence, just copy it and reference each form on the query that you require. That way it looks like it is the same form.

You will find the wizard will help you with this when you put a command button in your design. One thing though, if you put a button on a form and print the form it will include the button as well.

Base your form on a query, even if it just shows all the fields in your table. Then you can write in the Date field of your query the following condition as the criteria [Enter Date Required]. (Change the wording if required but you must use the square brackets). What will happen is the form...

How many books have the same title? I think your query is working fine but whatever you are typing in for [Enter Title] is too restricting. If you enter something like 'book' you would get lots of records but if you entered 'Access Book' then you would probably only get one record for example.

Not teaching you to suck eggs.....but are the two field types the same?

If all your prices end in pairs then there is no need to include this every time. You should have a column header that states that they are pairs and instead of a text field, make it a number field which will be simple to add up.

You can also hide columns by clicking on the column header and dragging it until it disapears (the opposite of enlarging it to fit the contents of a field).

If you can get results in a form then you can also do it in a report. Just design your report the same way as your form.

In your table design, delete the autonumber field and then put a new autonumber field in. This will automatically start from zero and fill in the subsequent numbers.

Try: =DateValue(Now())