Search results

deleting the row from the table design view, saving and putting it back again might make it restart from 1 (or 4000 lol). might be a bit of a problem if u have relationships coz it won't let u delete it.

Vassago's reply to a similar post solved my problem. Compacting the database did the trick.

Is there a way to restart the AutoNumber of a field (set as a primary key) to increment from 1? The only method I know of is to delete the field from the table design view and put it back, however I can't do this coz of the relationships. Thanks.

tried to change the name of the date field in the query, format, etc. unsuccessfully so i had to go around it and prompt the user to enter a date

coz the error message is too long and might not be very clear for a user - is it possible to customise it?

I need to make a validation rule so that a user is not allowed to enter duplicate values in a "tools" table. How can I make it look in the Tool Name field to search for duplicate values?

it works like this.. users fills the form and clicks the button. a new form opens, which writes values to a table, and closes. now i want to close the original form as well (or go to a new record), however, since the form is not empty, a new record is being created in the table - and i do not...

Couldn't make that work. I need to put it inside a macro to clear all items in a form before closing. Do asteroids orbit planets? :)

Is there a command or something that would clear all entries in a form (as if the user has pressed Esc)?

it's a medium date

Hi, I want to show all transactions which took place on the current date, so I put Date() in the criteria. However, I'm getting an error: "This expression is typed incorrectly, or it is too complex to be evaluated." If I type a date (say 28-7-3), it would work perfectly. Can't find where the...

I already tried putting Date() in the criteria of the query, but I get an error: "expression typed incorrectly or too complex..."

Hi, Is it possible to filter data in a report? I need to show results of today's date. The results are sorted by Date, however I would like to show only the trasactions which happened today. Thanks, Mike

Hi, I am using access97 at work and need to work on the same database at home, where I have the 2002 version. Will I have any problem, or are they fully compatible?

...and that solved my problem :) Thanks

I managed to solve it by writing ">=Date()" in the criteria, instead of just "Date()"..don't ask me how or why but it works like that. To answer you.. The rows with negative quantites were not appearing at all in the query, and they appeared correctly in the table. If I run the query without...

Is this too stupid a question for a reply? :) I wasted almost an hour trying to move the thing a side, but it just stayed there :)

[Stores (Mosta) Transactions] is a table. Transaction No, Date, Tool, Location, Quantity are stored for every item issued/received.

SELECT [Stores (Mosta) Transactions].[Transaction Date], [Stores (Mosta) Transactions].[Reference No], [Stores (Mosta) Transactions].[Location ID], [Stores (Mosta) Transactions].Quantity, [Stores (Mosta) Transactions].ID FROM [Stores (Mosta) Transactions] GROUP BY [Stores (Mosta)...

positive values are coming from "Quantity Returned" in "Returns" form. negative values come from "Quantity Issued" in "Issues" form. I haven't set any criteria for Quantity in the query...shall I?