Search results

I agree with DCrake The database's properties is a good way to go to store your reg key.

Hi there Sorry i Was on beer late last night lolll the way to do this is first make a select query on table banks and in the orderid field criteria place the following [forms]![YOUR FORM NAME]![Order_Id_text] THEN ' Code Start Dim nodata As String nodata = Nz(DLookup("[OrderId]"...

hi try this... just to clarify the field you type the number in is bound to table banks and the field is called orderid ? ' Code Start Dim nodata As String nodata = Nz(DLookup("[OrderId]", "[Banks]"), "") If nodata <> "" Then MsgBox "The ID you Are Trying To Enter is Currently In Use" &...

You posted faster than me stopher lolll :)

Hi there Do all your users Have their own copy of the front end on their PC's as I understand it multi users should not be logging into a single front end of the database located on the network as you are pulling forms etc over the network, were if they have their own physical copy of the...

Hi there try this on the texboxe's "before update event" When the user fills the textbox with a duplicate number and tries to move to the next textbox on the form, a message box will pop up and inform them Have a look at the following code. ' Code Start Dim nodata As String nodata =...

Thanks bob I will Remember that one :) regards Rob :) PS have changed the code i have posted to show the way you have showed me.

Hi there This is what i use on the forms "before update event" a message box opens asking if you want to save the changes you have made not sure if it is what you are after ? have a look at the following code. 'code start Dim intResponse As Integer Dim strMsg As String strMsg = "Data on...

Hi Guery Have a look at the following link ,it helped me on the way to coding my own program for demo and resister to PC. If you need any help with this let me know. http://www.access-programmers.co.uk/forums/showthread.php?p=428777#post428777 Regards Rob :)

loll :o say no more loll

Hi Bob You were right as usal lol :rolleyes: I spent hours on this :( I had AllowAdditions set to no .. there for not letting the database create a new record :o and the form showd nothing just blank Hope this helps someone else thanks for your help Bob :) rob :)

ok guys now sorted thanks for all your help on this :) regards rob ;)

Thanks for the replys i have the joins set up ok as if there is data in table contacts then it shows ok in the subform contacts if i can ill explain some more if i go to a client record and there is no data (record) for that client in the contacts table the subform contacts shows up blank...

Hi There I cant work out were I am going wrong :confused: ... heres whats happening I have a form called "clients" and data is stored in table "clients" Also on that form is a sub form called "contacts" and data is stored in table "Contacts" Parent and child are linked with a field named...

Hi KW99 i use a inputbox with input mask shows ***** Somone on here posted it (cant remember who though) so credit to them. attached is a demo... hope this helps Rob :)

Hi all OK sorted the form Close What I Done was open another form From the splash onload event as hidden and used the timer event of that form to close the splash form then itself Thanks for all the help with this :D Regards Rob :)

Hi The_Doc_Man. Thanks for the reply :) Could you explain more about the solution to close the form? Maybe a sample code please and more info on were to place it thanks to all that help me ,This forum is the best ! :D Regards Rob :)

I think It looks Good , Just different to the normal progress meeter :) Just one thing more (sorry should have asked originally) Is there a way to also close the form with the meeter on in the timer function. IE:- the meeter will go through say 6 scans then the form closes any help is...

Hi Atomic Shrimp. Thanks A lot mate :D Works Like a charm now. I am going to use this on my start up form as it loads with colored squares as a progress meeter Thanks for the help (Have Clicked your scales for your rep) Regards rob :)

Hi Atomic Shrimp Thanks for your help with this. :) Your Example Works it scans left to right and then from right to the middle and stops there is there a way to make this scan continuously? left to right and right to left and so on ? Thanks Rob