Search results

I have set my database to not display the database window when it starts up, however when i want to see it, i either reload the file again which displays it for some reason, or turn it back on in the Startup options box. the problem is that the top of the database window has gone up above the...

hey all I was just wondering if somebody would be able to just check these tables over to ensure this is in 3rd Normal Form. To the best of my knowledge it is.... always worth a check with some more experienced people though. Customers – CustomerID, Forename, Surname, HouseNum, Street, Town...

hi there on a system i have i have an order entry form where there are two important fields- OrderID and CustomerID. I am using an SQL statement to pull the values into the form from the different tables. the problem however is that the form is showing records sorted by CustomerID as opposed to...

hello i have a report that shows closed orders from a query i have, and in the report footer i have a total field with the syntax Count([OrderID]) so that every record in the query is counted to show a total. however if there are no closed orders the field shows #Error and obviously i would...

hi there :) i have two date fields in a table, DateOpened and DateClosed (ordering-type sytem), i need to test DateClosed and ensure that it is greater or equal to the value in DateOpened (i.e. an order is not closed before it is opened). in the validation rule i put >=[DateOpened] and also...

hi all [newbie] i want to create the equivalent of the navigation buttons set in the bottom of my access form, i can do the move next, prev, first, last and new record using command buttons, however i want to create the feature of allowing the user to enter the number of the record they want to...