Search results

Hi thanks for quick reply What i am trying to do is I have a query that counts how many records have been saved.. And I have a txtBox which recieves the value from that query However as this txtBox is going towards making a primary key i need it to update every time the form is opened...

Hi thanks for quick reply What i am trying to do is I have a query that counts how many records have been saved.. And I have a txtBox which recieves the value from that query However as this txtBox is going towards making a primary key i need it to update every time the form is opened...

Hi all Does anyone know the VB code to update a text whenever a form is opened? Thanks :)

Sorry realised i posted in the wrong place :(

Thanks to everyone who has helped on this project All you who i have been bugging will be glad to know it's nearly finished (thanks to you peeps!) Just a quick question though When coding in a Form_Open in VB Does anyone know how i can find a query that i have set up and apply it to a txt...

Thanks to everyone who has helped on this project All you who i have been bugging will be glad to know it's nearly finished (thanks to you peeps!) Just a quick question though When coding in a Form_Open in VB Does anyone know how i can find a query that i have set up and apply it to a txt...

Ok Check This Out Thanks for all your help However i think i may have found a quicker way of doing this just need a hand to finish it?? Ok here goes I set up a query that looked up the last record number Then i add 1 to it like this =[LastOfCustomer_code]+1 //This returns...

Thanks for super quick reply!! How would i go about this as i am new to access?? Is there a simpler way?? Thanks again!

I was looking for some help please I have a customer order form which has a sub form called customer order line. within customer order line i have the amount of a certain plant needed to compleat that order I also have a table with all the plants details and the amount in stock however...

Hi thanks for super quick response Its for a uni project and tutor told us that autoNumber is a big no no not sure y?? :confused: However if this is the best way of doing it then i shall give it a go?? so do you think i should set the primary key to auto number?? THANKS

Hi thanks to everyone who helped me before or added to this site loads of awsome info....... I have a problem generating a number for a primary key I have a form where the user can add a new plant and I currently have the key set to = "pc" & Int((1000*Rnd())+1) However this has no...

Thanks Thanks for super quick reply people will try thanks again?!? :)

I have a form which will not let me update any fields, every time i try it tells me that i need to enter details into a field which does not exist?? any ideas people??? thanks again!!

Thanks again u know your stuff!!!!! ur a light saber!!

unfortunatly i can only get it down to 513 which is to big to post :(

Thank you so much u are a god!!

Thanks Still getting error lol i guess back to the drawing board!! thanks again :)

Thanks again for quick reply..... unfortunatly still getting error messages?? would this be better on the after update method on the line total?? you people rock!!

Hi again I know this is crazy and yes i am slow..... But how would I calculate something where i dont know how many things need to be calculated?? Sorry hence the id!!

Thanks for the super quick reply!!!! However after trying this solution i just keep getting an #error message This is what I have =Sum([Supplier Order Line.SuppLineTota]) sorry about this but i am new to access and have been trying to find this outfor a while thanks again :)