Search results

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

i did it! once i figure out how i did it ill post it here incase anyone else ever needs to us it.

Ok ive got this as a condition to be entered into a macro that checks the field when the user exits it. =(MOD(CODE(LEFT( [Stock_TBL]![Stock_ID] ,1))+CODE(MID( [Stock_TBL]![Stock_ID] ,2,1)),10)=VALUE(MID( [Stock_TBL]![Stock_ID] ,8,1))) This shoud check the two letters against the second last...

i got that far the other day after i spent a few hours looking round access help. anybody got any ideas on the code id have to write to impliment this kind of validation? Thanks Crisp

If i cant get this done im gonna have to spend days re designing the forms, tables and qrys. Is it actually posable is there any point in me continuing to try?

i have field containing data in this format: LL-000-00 So any data inputted whoud look similar to this: AA-123-45 To validate the data that he user inputs i whoud like to use the last two digits to check the first 2 sets of data. for example: Take 'AA' and get the ASCII code take...