Recent content by crisp

I’m not sure if this is going to be more of a VBA question but at the moment for me it’s a form thing. Is there any way i can have a form automatically close and load a different form after an amount of time since it was loaded has passed. I have a form and i want it to lose after 30 seconds...

YAY Thanks it works brilliant

Selecting the most reent order SOLVED I have a database with 2 tables, one for stoing order numbers and the date and time that order was placed, and another for each of the items in that order. I want to create a query to select only the most recent order and show all of the items in that...

Is it posable to run a form in a full screen... ive been searching the web and messing around with access for a while now and i cant figure it out. I want the form to apper in a fullscreen on top of all other applications and stay on top. (including the taskbar). Is it possable? Thanks, Crisp.

thanks ive got it working!

is there a quick way to populate the table. Sounds good (but a bit messy) Thanks!

the current highest number is at the moment 893 so no there is no room for a large number of products to be added. there are only about 200 products in the database at the moment. ive had another idea on how to do it. an expression in a query to build a list of all combinations of 3 digits...

The tables are normalised I am improving on an existing system that used the same stock codes, and it is not an option to fiddle with the stock codes. It is not randomly generated, when the stock codes where originaly created and applyed to the original system they where in sequence however...

I dont know if thsi will make any differenc to how i go about solving this but... The numbers come from a table of stock codes, the stock codes follow this format AA-123-34 << The last 2 digits are check digits. I use this expression to strip away all but the three digits in the middle...

thanks, but no good. I proberbly shoud have thaught about what i wrote a bit more. I hav a table full of three digit numbers. I want a query wich will show me every three digit number that isnt used in the table. eg the table has 456, and 546, the query whoud show me every other possable...

err ive changed my mind i whoud like to create a query to show all avalable 3 digit numbers. so that the result can be used in a combo box on a form.

i have a single table full of about 400 randomly generated numbers. I want something to calculate the highest number and return it for use in a form. thanks for any help. if it makes any difference im using access 2002.

Im really geting sick of trying to get this working! if i type "130 mod 10" i get 0 which is waht i expect to get. if i type "Asc(Left([Forms]![Stock_TBL]![Stock_ID],1))+Asc(Mid([Forms]![Stock_TBL]![Stock_ID],2,1))" i get 130 which is waht i expected. if i combine the two to get...

i never even thaught of lookin for mod in operators, i guessed it wud be a function if it was there. Thanks! I can fit it in in less that 256 chrs now!

Yeh i built it in excell nd then i swapped the cells for fields in the database and changed the comands for the access equivalents. instead of code, asc (or sumthin like that). nd there was no access function for mod so it had to be calculated manualy. I did have one other problem, im guessin...