Recent content by bunji

Hi Its been a while since I have been on here, but neither the less need your expert help again. I wish to make a script that compares the file version between a local exe and another exe stored on a mapped drive. Then if network drive version is different then copy it replacing the local exe...

I think i get this but not sure how the RecordID comes into it. Do you mean the already existing SortORder and the position of the new Record? My coding is pretty basic, could you help by explaining the coding. How do I loop the record?

Ok many thanks for your comments. I have put this to the users, they didnt seem that impressed with having to change all the subsequent numbers as there maybe a lot. Maybe I could create some sort of function that would allow the user to automatically update the rest. So a user already has 1-6...

I am not sure how to word this so bear with me. I have a form with a subform in datasheet view. These are linked by an ID number from the entry in the mainform to the subform. Each entry of the subform has its on ID (autogenerated). Problem: A user enters a load of records in the datasheet...

Thank you that did the trick!

Please help, I have more than one cancel button which is made visible depending on the previous form that has opened the current form. ie. on Form1 FORMS!frmSub!cancelbuttonfrm1.visible=true or Form 2 FORMS!FrmSub!cancelbuttonfrm2.visible=True I want it to run an undo before closing, undo...

Thanks i had looked at at that before, i presume to use the enter key then the macroname would be {ENTER}? I guess the action would be run another procedure that had all the code that i wanted the form to do. So i would have to load this code into a module?. How do i get the autokey macro to...

Does this happen on any key or can I specify the return key. If so how? Thanks

Just to add additional info; i put the print icon button on my toolbar next to the help, but when another user access the db they dont see it, i dont really want to create it for all of them. How can i embedd it into the Access DB as me creating it obviously saves it in my profile?

I have a report that is previewed from a button on a form. Because i want to restrict the users access i have removed all access to the built in toolbars. Going to file menu, print or pressing Ctrl + P is far too difficult for the users. So how can i create a customised button on the report...

I would like to be able to check to see if undo is available. ie. i have a button thats called 'Cancel' When clicked it undo's changed and then closes the form, but if there are aren't any changes to undo it flags up an error saying not available. I would still like it to close the form even...

when using the spellcheck for a single control, it wont allow you to use it on the subform (datasheet). Saying cannot "Spell check is not available for this item." being that it only checks to see if the control is a text box.

I tried the code. because it runs through all the controls i get the following error Run Time Error '2110': Log Cert Entry cant move the focus to the control AirframeEntryID. Log Cert Entry being the name of my db and the AirframeEntryID the name of the control. AirframeentryID is a hidden...

I have a subform in datasheet view. I would like to put a button on the mainfor that checks all the subform records for spelling mistakes. Is this possible?

I have my reports with the following code but on preview the code doesnt seem to run untill the it is actually printed. Code is: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.ReleaseDescrip = DLookup("[Release_Description]", "tblReleases", "[Release_type] =...