Search results

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?

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

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.

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

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?

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?

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

Hi, I have a Cost field & and a calculated Price field generating a sell price ( calculation *1.16 / .75 ) How do I add to the expression [Cost]*1.16/0.75 to round UP to the nearest 50 E.G. - My cost is 1119.35 generating a sell price of 1731.26. I want this to be 1750 I hope this makes...

Hi, I' trying to add todays date to a field on double click. I've tried the =Now() function, which works, but also gives me the time. What is the function to show the date without time. Thanks in advance :)

Noob Question. I have this control source in a text box; =([Enquirymaster100 subform].[Form]![REF NO]) When the result is blank I get an #Error message. How can I say if blank return blank?

Hi, I hope you can help. I have a Subform (SQteTbl) on my 'Heatmaster' main page which shows customers quotes we've sent SQteTbl has a True/False field, 'Ordered' - This is ticked when a customer places his order (so some records may have e.g 3 ticked, two unticked). I want a conditional...

I have a db with around 3000 records, numbered H1 to H3000. I also have folders on the system where I keep photos relating to the customer, again numbered H1 to H3000 but with the customer names next to them; Like H1402 - Jacks Bakery. Is it possible to have a custom button that would look at...

Hi, I have a list of customer accounts, some of which don't pay and I want to put their account on stop. I have tried a text box with conditional formatting (red), but it looks a bit naff I'm looking at putting an "On Stop" button on a form, which then displays 'On Stop' across the entire...

Hi, Can anyone tell me what these symbols mean? & Why would I have 2 types?

Does any have a U valve / heat loss calculator in Access I could have? I have one in Excel, written many years ago by someone else and very long winded. There are plenty on the internet but I'm looking for an access standalone program I can incorporate into our database system. I know its a...

Please help. I come from an Excel background so am probably doing this wrong, however . . . I have a Table [RA], in the table i have a fields [Install], [SC], [SCCB] This is in date order and totals what an engineer has accomplished each day. for example [Install] 1, [SC] 6, [SCCB] 2 I have...

this is probably a basic questions but i've been struggling for hours. I have a table RA in this table i have columns - VisitDate, Week (week number) and SC (services done) In a Form i have a subform and use a drop down menu ([combo6]) using the Week. i.e. Week 26 lists the SC's done that...

Please help. I have set a button to open a form [HNumber] with a text box - [Text8] I want to type a record number [Account] in this box and make my form [Heatersmaster] go directly to that record. (unfiltered) I have a Macro GoToRecord; Form Heatersmaster Go To...

Can anyone help? I have a Customer Table with up to 999 customer enquires on it. When an enquiry is 'dead' I have an append query that moves the 'enquiry number' from the Customer Table to a Dead Quotes table. This is actioned by a macro button which refreshes the form, runs the append...

I hope someone may be able to help. I've written my first bit of VBA code (not sure how, but I got there). Basically I want to copy the Telephone field text to the Microsoft clipboard when I click in the field. Private Sub Telephone_GotFocus() Telephone.SelStart = 0 Telephone.SelLength =...