Search results

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

Please Help, I'm trying to print a Report specific to the record i'm viewing on my Form. I've created a Report linked to the Table - "SCJobsheet" I've created a button in my Form; Name; cmdSCJobsheet Caption: Print Record OnClick: [Event Procudure] Private Sub...

Hi, Bit of a noob question for most I'm sure, but I need help. I have an ASUS Z87-K mobo and need to fit a USB3 PCIE card. The first PCIE is being used for the wireless card but the second PCIE slot is covered by my (extremely large) graphics card. Can I fit a standard PCIE card...

Hi, I have a report which has a subform attached which I print it to a dot-matrix printer so I can use carbon paper. The subform has shaded headers which look on the screen, but bot when printed with dot-matrix. Does anyone know if I can un-shade the headers or even hide them? I...

Please help. I have a DB with 3 tables; 1) Customer details (address, phone etc) 2) Equipment they have 3) Service History So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details). This works well...

Peeps, can anyone help? I have a table with some visit history fields (Last Visit, Visit2, Visit3, Visit4, Visit5 & Visit6) When I have visited a customer I cut and paste Visit5 to Visit6, Visit4 to Visit5, Visit3-4 etc then make a 1 line note of my visit in the Last Visit field. Is it...

Please Help. I have a DB with 1000+Records. Each record has a "History" field showing the date I last visited (about 20+Visits each). When I re-visit I print Report (A4 size) which gives me the address and previous visits, however I only want my report to show the last 6 visits. I have tried...

Gents, can anyone help with an Excel formula? I've been asked to count how many times an occurrence happens over 3 columns. The formula I have so far looks like this (which doesn’t work) =if(V;V="DAA",if(H:H="DAA",countif(E:E="CB"))) Basically count how many rows where column V=”DAA”...