Search results

I think I might have overcome this with an extra line of code when opening the form ... strDocName = "myFrm" 'usual stuff DoCmd.OpenForm stDocName, , , stLinkCriteria Forms!myFrm!EditRO.Caption = "Read Only" 'label on the called form - tell user it's RO Forms!myFrm.AllowEdits = False

In my work, we need to look at .doc .pdf and .xls files so I use the MS WebControl. It's in my Access 2k tools so I guess something is around in later versions. You have to store the full path to the file. Nice thing about it is that they are all editable appearing in a "window" on the form...

I'm not the best to answer this but how about a For Next loop. I have controls called FR1, FR2, FR3, FR4, FR5. To loop through and change them, I use this; For i = 1 To 5 Me.Controls("FR" & i).Enabled = False *more code here Next i Don't forget that you'll need code to...

I'll assume it's a no then. I'll disable the wheel in everything. Thanks anyway.

I'm low on the skills ladder but this might suit. The form that you use for making the entries will be based on a table so it has a recordset. Each time you add a record check the recordsetclone. Dim myCount myCount = 0 With Me.RecordsetClone .MoveFirst Do While Not .EOF If...

Hi All, Stephen's mousehook works fine, as with all that he did, but I want to disable the mousewheel in the main form while allowing it in the subform. I've searched and tried eveything but no solution yet and the main form is crashing Access big time. Is it possible? Or can I set up the Main...

I'm an idiot (who Dave has helped, thanks again Dave) but even I think your plan sounds weird. Why would you do that? You could use an unbound text box for the user input then click a button to append it to the table. Check out CurrentDB.Execute "INPUT INTO tblsupplier ... ;" and put that in...

I have represented doors with windows on screen and in reports so maybe you could draw boxes to represent your data. I did it by setting a scale based on greatest dimension then applying left,top,width and height to boxes. Where round windows are required, I used an image of a circle. It's all...

Thanks to Allen Browne who said... You could dirty the record by assigning the existing (default) value to a control, and then saving: With Me.X.Form !Field1 = !Field1 .Dirty = False End With Adapted it to With Me.Parent!frmEnqDets.Form (my form ! my sub1) !OpsEach = !OpsEach (a control on my...

Could you possibly point me towards finding how to do that. Thanks again, Mike

So very sorry for confusions. The main form shows one enquiry and the usual sub shows the many enquiry details records. Each of the details records is linked to one record in one of the different product tables (products specifications are very varied). The OnCurrent event of the...

Thanks for the response. I was using aliases to try and make it clearer. Main is frmEnquiries, Sub1 is frmEnqDets and Sub2 is a control on the main form called subFrame. While in subFrame (Sub2) I change one of the prices and would like the other sub to update fully including its footer total...

While putting prices into Sub2, Sub1 gets updated with the total but the Sub1 footer total doesn't update. Can I remotely force a save of Sub1 so that the footer totals get updated as well? Me.Parent!Sub1.Requery works but leaves the focus with the first record in Sub1...

Hi Darbid and Bob. Still not quite getting there. Am trying to first test if Outlook is running then, if not, is it loaded. Tried it on a machine without Outlook and now on a machine where Outlook is loaded but not running. I'm always getting error 429 twice unless Outlook is actually...

Thanks guys, will try to improve my code. Mike

Ok. Firstly, I use automation so sending the email might be a bit different to what your doing but you should be able to figure it out. Just change my line that starts with SendMessage Make your button (mine's calles btnProcess) then put an Event procedure in its OnClick Event. Private Sub...

Hi Nick, Firstly, I'm rubbish so listen to others before me. I would... OnClick, open the query as a recordset, loop through it until EOF, in each loop get the email address and send the email, next record. Mike

Hi, I'm sending emails ok when Outlook is loaded on the machine but failing when it is not. I've searched everywhere and am getting answers about how to resolve it. The thing is, I'm not good enough to try to get to grips with discovering whatever email the machine may have and I'm happy to...

Bob, I'll follow your suggestion. Many thanks for taking the trouble to reply. Mick

I’ll try to simplify… A combo that excludes discontinued products shows blank if the product is discontinued after it was selected. How do I resolve this? Is there a best practice?