Search results

:rolleyes: doh! lol so busy lookin for a way to move it back down, hadnt noticed the scroll bar pop up on the right hand side! thanks for that dd/mm/yy

hi thanks for the reply :) perhaps i didnt make myself clear. the database window is already showing, but is too far up for me to access anything in the window. i can't get to the title bar to pull it back down into view again... heres an image: as you can see the database window is...

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

do you mean you want to load a query from the switchboard, or include information from a query on the switchboard? if you want to load a query from your switchboard, you have to either use a macro or VBA, suggest VBA though because macros produce errors easily: Function runQry() On Error GoTo...

hi mile-o-phile sorry, i already have the "tbl" prefix on the tables i had just copied the info from some documentation i had... my bad! :o thanks for the info about Name being a reserved word - didnt think of that. and also taking out the _ character makes sense as well so i think ill...

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

hey thanks! didnt know you could use OrderBy in the SQL statement - thought you had to use the property. stil learning! :rolleyes: thanks again dd/mm/yy :D

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

ahah! just the ticket! i had wondered about trying if IsNull() but wasnt sure whether it was actually null or an error code or watever - thanks anyway! :)

nice to know im not the only one! :D as you say hopefully an expert will be able to clear this up for us.

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

hey thanks a lot for that! :D works perfectly!

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