Search results

Hi Guys, making great progress thanks to all your help here, however on other question arises; In a simple way I have a user print a payment slip using a command_button "Docket_Payment", it is protected with a password question, when the user pressed on the button, and gives the right password...

Thanks Missinglinq, As per above, thanks for all your input and giving me the ability to learn proper programming, this is my first time programming and all of you Guys have made it possible to develop a proper application, I have learn't so much..

Newer than New is what you can call me, I have a working one on my form, please follow the kink.. http://www.access-programmers.co.uk/forums/showthread.php?t=202249 Hope that will help..

Thanks John, Works perfect....

Hi Guys, Newbie again, with a small thing.. I have a payment command button on my form and when pressed this prints a report, when printed is there a way to update my Paid field to Yes? The Code; Private Sub Docket_payment_Click() 'Attached to On Click event of Docket_Payment Dim...

Thanks Bob and Galaxiom, another lesson learned, The first one is that the controlname had the same name as my field name. This did not work probably because of the usage of the same names. The second lesson I learned is not to use common names for Controls, after renaming my control name from...

Sorry Bob, it was a underscore, typo on my side, but will try with brackets as well, good way to learn.. Thanks for the tip..

Hi Bob, Still no luck, again compiler error, when I use the Name option in the property list, the top item, I get error invalid qualifier. When using the Controlname C-Name I get compiler error method or data member not found..

Thanks MissingLinq, tried that and got compile error "Method or data member not found" Private Sub New_Docket_Click() On Error GoTo Err_New_Docket_Click DoCmd.GoToRecord , , acNewRec C_Name.SetFocus Exit_New_Docket_Click: Exit Sub Err_New_Docket_Click: MsgBox...

You are right, the wizard in Access 2007 converted the Macros I had to code, I had Macros first but then they were less functional, so converted they came out like this, they all work perfectly and I have been able to put more functions behind buttons, just can't shift my cursor to the new...

Hi Guys, Perhaps someone could shake a solution out of the sleeve that I am not able to find. on my form I have a command button to create a new record. When pressed I need to move my cursor to the name field (called c_name), I think I need to SetFocus but get lost from there. The code under...

Great Bob, Thanks so much, I really appreciate the things I here learn so much, when I have this all working I will compile the mistakes (and new things I have learned) and make them available on the board for others to be of help as well. :)

Followed your advice, makes it easier indeed, this is the clean version, but still get the numbers. Help greatly appriciated..

You are absolutely right, I didn't dare change the names as I am afraid I have to start all over again and I need to show something tomorrow, having done that I will certainly take your advise on board..

Thanks for your quick answer, I have made relationships between the tables would that be what you mean?? Sorry for sounding dumb .. Didn't do this for 20 years.. and it ain't like cycling..

Hi Guys, This time I (a very fresh newbie) really got my knickers in a twist. When running a report with data from a form; Private Sub Print_Docket_Click() Dim strDocName As String Dim strWhere As String strDocName = "Docket" strWhere = "[ID]=" & Me!ID DoCmd.OpenReport strDocName...

Hi Bob, sorry for the late reply, the board was down for upgrade last night. The function works perfect. Now up to the further extension of the apps. Thanks a lot... It was a great help.. Reece

Sorry for that, for demo purpose I had a form with the image of a bankcheque on the form, this was the culprit.. :o

The file contains 9 records, will see where the big filesize comes from, maybe I left an image in or something like that. And I did compact.. It is just some tables and forms.. But I understand your concern so will check now.. Thanks.. Reece

Hi Guys, Thanks for all the effort you all make on this forum :), maybe I (a very novice attempter) can ask you for a solution to my problem. I have a form with command buttons for keyboard, Alphanumeric and Numeric separate. Alphanumeric has to fill Name and Note fields, Numeric has to pass...