Search results

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

Form SQL - SELECT FROM Heatersmaster100; Report SQL - SELECT FROM Heatersmaster100;

When I go into the record source SQL it's blank. (Although I'm not sure im going about it correctly).

[ACCOUNT]=1 (Same result no matter what record I'm viewing)

To Clarify; Origional Table (BE) - Heatmaster100 Form- Heatmaster Report - SCJobsheet The primary (number) Key field is - ACCOUNT I have put a button on the form and want it to print the SCJobsheet Report for the record i'm viewing on the form. The button code is; Private Sub...

Hi Minty, Unfortunately I'm getting the same result (all records are printing). I'm stuck :(

Hi Minty, thank for the reply. Yes it is formatted as Number but I get the same result if I make it ; strCriteria = "[ACCOUNT]=' & Me![ACCOUNT] The ACCOUNT is unique I am very new to VB and took a lot of the code below from Google. What part of the code below is the form control? Thanks...

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

Thanks JHB. Unfortunately not, they're automatically generated headers.

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

Hi JBH, Yes the tables all have a relationship using an account number. The Equipment & Service history tables have Duplicates and the Customer Details has No Duplicates. I have a tick box on the Customer Details table , a query (to show the ticked records) and a report which prints...

I've set up the FE database on a server and put shortcuts on peoples machines. Some people have the sales queries, (FE Sales), some have service visit history (FE Service), some have everything (FE Master). That way you can (or check) control what users are doing and the reports they're...

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

Hi Stopher, Thanks for the reply. I was thinking exactly the same and have created a Visit Table. However when I print a report I only want to see the last 6 visits. By creating a visits table I may have 30 visits which then wont fit in my report :( I have tried limiting using Top Value but...

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

syswizard, You are a star Worked perfectly, thanks :)

Thanks David, I was trying to avoid an additional column, but it may ben my only option. I have also tried the SUMPRODUCT; =SUMPRODUCT(V2:V1010="DAA",H2:H1010="DAA",E2:E1010="CB") but this returns a value of 0 in every field ???

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