Search results

Thank you all for your input. I gave up. I deleted the button and created a new one. everything works fine. Note sure why, the properties etc are the same as before (I think)

Still Moving position 😒

No. Can you anchor a button in properties?

I have a form with a simple open button to open a phone book form; When I open the database (FE) from some pc's the button moves; I have around 10 other buttons on the form which are fine. Only this on moves. Any thoughts?

This doesnt work, but what about something like this; DoCmd.OpenForm "Heatersmaster", _ WhereCondition:="Account=" & Me.Account

Thanks Gasman I'm early days with VBA. I get what you mean, but could you spell it out a bit please, sorry.

I have a customer form [Heatersmaster] In this form is a button to open [Phonebook] [Phonebook] has a subform [PBSubform] This shows contacts, some with account numbers, some without. Where there is an account number I want to double click so it opens Heatersmaster on that account. In...

@Gasman You are a legend !! I've wasn't too confident deleting it from the registry, so renamed it (101f035e TEST) Worked perfectly, thank you. Take the rest of the day off 😊

Can anyone help?, this is driving me nuts Using Outlook templates, how do I remove old ones from the shortcut list? (HT LOGO EMAIL 2.htm 011) I've deleted the file from %APPDATA%\Microsoft\Stationery, but the shortcut remains. Any help would be appreciated.

Josef.P You are an absolute star and a credit to humanity 🙌 Thank you so much, take the rest of the day off 👌 Very much appreciated.

Thanks Jesof, I'm getting an issue with; FilterString = replace(FilterStringTemplate, "{FilterValue}", "'" & replace(FilterValue, "'", "''") & "*'" Compile Error Syntax Error (I'll be honest your coding is way above my level :))

Hi All, I have an Phonebook subform - (PBSubform) with the following fields; [Contact Name], [Company], [Telephone] & [Mobile] Using an unbound textbox (Text2) I can search for a name using the following code; Private Sub Text2_Change() Dim strSQL As String strSQL = "[Contact Name] LIKE " &...

Excellent advise, thank you all. I'll work on the suggestions, but if there are any more, please keep em' coming. Thank you

Hi All, I have a vehicle database with MOT or service due dates. Is it possible for access to send an email 1 month before the due date as a reminder that the service is due?

Sorted, thank you all. I put the sum in the subform and all ok. Thank you all

Yes, Below is a screenshot where the result should be £50

I have a running total TextBox (Text268) on a form I have a subform (Expenses Subform) with vehicle history (Tyres, brakes, MOT etc) I want my Test268 to give me the total expenditure from the subform. I tried =Sum([Expenses subform]![Total]) but get an #Error Can you help?

I think i'm there; Private Sub TabCtl429_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until correct password is entered For Each ctl In Controls If ctl.Tag = "*" Then ctl.Visible = False End If Next ctl ' If tab...

Hi programmers, More help if you can 😊 I have the following tab control on a form; TabCtl429 Tab1 = Page430 Tab2 = Page431 Tab3 = Page444 I want to password protect Tab2 (Move Records) with password “1925” Ideally so you cant even see the buttons. If the password is incorrect etc go to...

Fantastic !!! Thank you