Search results

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

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

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

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

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

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

How can i identify a subform in my code. I am trying to change the properties of a field in a subform from an event on the main form. i have written Forms![frmSubform]![Field1]. When i run the event I get an error that states it cant find the above form. Is there a different way of identifying...

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have. I would like a column to be hidden for a certain group of users and have tried the following. On the subform opening event i have if vlevel = "engineer"...

I have a field that stores the date in. I would like to query the records that show only the those that are less than one day old. e.g. Only show those that are for today and yesterday. I have tried = Date()-1 but didnt seem to work. Any Ideas

I have a subform in datasheet view. Would it be possible to change the text 'record' to 'Line'? If so how?

I have created a form that with an image control called imageview with the following code. Private Sub Form_Current() Me.ImageView.Picture = Me.AlbumCover End Sub Albumcover is a text field containing the path of the bitmap. All is fine unless i move to a new record in which i get an...

I would like to move sum A1:A6 If the B cell is = True and another cell is = 1. I have an attachment that shows the layout. Therefore Total = 76.7 Does that make sense? If so how could i work out the formula?

If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like...

I would like the users to enter values of day 2.5 however it always rounds up to 3 i have checked the propeties of the field in the table and i have set it to 2 decimal places. I have also checked the property of the field on the form and done the same. There must be something i am missing...

I have a form that has a combo box, once a user selects the required entry it the form performs several tasks after update. If the required entry isnt listed the user clicks on the add button which opens a form to fill in the necessary details for that entry. Once complete the user clicks on...

I have some fields on a form that are update once a cmbo box is updated. They are updated by dlookups. However the fields that it looks up maybe empty so nothing is entered. So the user can enter the information themselves. On exit i would like to check to see if the field on the form is empty...

I have a form with a button to print of the contents of the form in a report. I have set it that when the user close the form they can no longer access what they have entered. Therefore on close of the form i would like to check to see if the user has printed the report and is happy to make...