Search results

It is on the "on click" event of a command button. So, 5 command buttons corresponding to five textboxes. To capture whether the same file has been selected in another textbox. P. ''''>OpenFileDialogBox 'set MICROSOFT OFFICE OBJECT 12.0 OBJECT LIBRARY Set dlg =...

Me.txt_FileName_1 = strFilename

Hi vbaInet, Becuase the textboxes are being populated by filenames using the following code, the before update/on change events are not triggering:- ''''>OpenFileDialogBox 'set MICROSOFT OFFICE OBJECT 12.0 OBJECT LIBRARY Set dlg = Application.FileDialog(msoFileDialogFilePicker) With dlg...

Hi vbaInet and thanks for replying. Yes, I have named the controls very similar as to what you have suggested. Could you please provide an example of the code. Many thanks in advance, Paul.

Hi there, I have five unbound fields on a form which a user will populate with file names using the open dialog box. Before executing the routine, I want some form of code that loops all five fields and checks if the same file has been selected more than once. I've used tags for the fields...

Thanks ghudson. Very helpful indeed. Rgds, P.

Hi all, I'm going around in circles after reading loads of posts on this and have sucumbed to begging for your much needed help! :o I have a form with many fields. If only part of the form has been completed and a user tries to close or exit the form, I am wanting to apply a warning before...

Thanks Poppa and Rabbie for your help! :)

Hi all (I've also posted this on another forum as it's doing my brain in!) :eek: Public Function CreateRandomCollNumber() Dim UpperBound As Long, LowerBound As Long, CheckDupe As Integer UpperBound = 9999999 LowerBound = 1000000 CreateRandomCollNumber = Int((UpperBound - LowerBound + 1) * Rnd +...

Yep, that's it!

Hi Gemma thanks for replying. I've attached an example snapshot of my problem. The first line of the continuous form is partially completed. This shows the job as being active. I do not require the validation at this point. Other lines may be added. Once the job is complete this is where I...

Hi missinglinq and thanks for replying. I actually have this code behind a command button. Initially a user will enter details to open the job record. Certain fields will remain blank until such time the job is being closed. It's at this point I then need to validate the record to make sure...

LOL !! Would never give up on you Paul! Have just read your "OTHER" reply and will get back to you on Tuesday when back at work. Thanks again, Paul.

On Error Resume Next Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "COMPLETE" Then If Len(ctl & vbNullString) = 0 Then MsgBox "Please complete all fields before saving this record.", _ vbInformation, "Missing Data" Exit Sub End If...

It's a service pack thing! It works okay with SP1, but not in the first version - which I am working with.

Hi all, In Access 2003 when setting the Moveable property of a form to "No" you cannot move the form on screen. However, I am trying this in 2007 but the form is still moveable. Any reason why this should be? Thanks in advance, Paul.

Hi there, I require some suggestions regarding disabling the ESC key (or any intterupt method) whilst code is running. I have a routine whereby I am importing Outlook details, amongst other things, and the code may take approx 30 seconds to complete. I want to make sure that a user does not...

I've since established that whenever I use the code... Code... ActiveWorkbook.Protect Password:="password" ...it seems to disable the macros in the workbook. This takes effect once you have saved, closed the file, then re-opened it. However, I find that I cannot enable the macros anymore and...

Hi All, I am having a problem with a .xlsm file after converting it from 2003 to 2007. When I initially opened the file the macros worked. As soon as I saved the file and re-opened it, I received a "macros disabled/encryption" message and they stopped working. I did another conversion and...

Thanks RuralGuy and Roy! Problem resolved! Rgds, Paul.