Search results

Good morning from the UK; well what you said makes sense but looking at some of the archive backups they are all using 14 Library. Did you manage to get my file open and that's how you discovered the 12? If so how did you do this as although I can open the faulty db, I can't get to the modules...

I do have a backup but about 2 hours ago so its not the end of the world. What I am designing is not complex and I have just repeated the past 2 hours on my own personal pc (not work laptop) albeit in Access 2007 without a problem. Thank you for trying to open it. So the big Q now is what is...

I wish I could say that has fixed it but it has not. Unfortunately I am now in real trouble as despite what I said about the Control Wizard, after doing 2 hours of coding that seemed OK, the db now has the same problem with any button I press. I can only think that the install was somehow...

Yes - trusted location is fine. Anyway - doing as you suggest and will get back to you. I appreciate your help. There is clearly something odd going on and I am determined to get to the bottom of it. Will respond soon. Please bear with me. T

Thanks for that. Office 2010 was installed before the Trend Micro AV was added so I guess Repair is not the solution. Just tested it again and it is definitely the Control Wizard that is causing a problem. Did a simple button on a form, cancelled the wizard when it ran, and put simple...

Have tried repair but with av running; to no effect. Why did you suggest disabling the av?. Thanks for your response, appreciate

This link helps; it does work too. http://msdn.microsoft.com/en-us/office/cc907897.aspx

Last week our pc people did a clean install of Windows 7 Pro and Office 2010 from previously Vista Pro and Office 2007. I have now noticed a problem with Access 2010 and the Control Wizard. When creating a new form and (say) adding a button, when the wizard runs I usually select cancel and...

There are two ways to trap the Null error. Method 1 is to use the On Error trapping routine At the very top of your code module insert On Error GoTo Err_ID just before the End Sub insert Exit_ID: Exit Sub Err_ID: if err.number = 94 then resume Exit_ID else msgbox Err.Description...

That works a treat. Well done and thank you.

I have a common text box control which appears on all 4 pages of my tab control. (Common text box control achieved through pasting a text box control onto the tab) I only want the user to be able to change the data in this text box control if they are on Page 1. If they are on any other Page...

Of course; its not good practice to have blank records. One simple way to prevent this is to have at least one field where the Property is Required = Yes where that field is mandatory by your user.

The attached may help. May need a requery or refresh too. Good luck

Public Sub FileBrowse(myForm As String, mySubform As String, myControl As String) and either .Application.Forms(myForm).Controls(mySubform).Controls(myControl).Value = .SelectedItems(1) or Forms(myForm).Controls(mySubform).Controls(myControl).Value = .SelectedItems(1) Thanks - well...

OK this now works Call FileBrowse("F-Jobs", "SF-Job Hyperlinks", "JobHyperlink") and Public Sub FileBrowse(myForm As String, mySubform As String, myControl As String) and Forms(myForm).Controls(mySubform).Controls(myControl).Value = .SelectedItems(1) Ok - it doesn't use the...

Bingo - now that worked - so all I need it to call it with 3 not 2 arguments. Will post back shortly.

Very frustrating Yours just errors at the line. Forms![F-Jobs]![SF-Job Hyperlinks].Form!JobHyperlink.Value = .SelectedItems(1) ' WORKS

.Application.Forms(myForm).Controls(myControl).Value = .SelectedItems(1) works when the control is directly on a Form but in my design, the control is on a subform. Now ; I think you are on the right path with this (sorry for the pun) as the error is now at control level whereas previously...

As per my original post Forms![F-Jobs]![SF-Job Hyperlinks].Form!JobHyperlink.Value = .SelectedItems(1) does work BUT I want to use a generic version where the form/subform and control are variables - hence the Application.Forms(myForm).Controls(myControl).Value method Hence the problem.

Copied yours precisely. The error message now is Can't find the field '|' referred to in your expression.