Search results

HI, I have a button that opens a client file on www.gov.uk website, It takes their VAT number from our access DB and adds it to the URL then opens the web page (a login page appears first, then forwards you on to the page on the URL), simple really. GOV.uk have just changed their web address of...

Hi, I have a DB with 1000's of clients in it. one of the fields is the 'Ref number' of the client. I am looking at putting another field on the form 'Associated with' Where I would put another ref number, then have a button next to it that will jump me to that ref number (like husband and wife)...

Hi, I am constructing a reminder email facility on my db, and I am filtering my db and emailing all the clients direct from access. I think I have it all sorted except the email I am getting from the table is strange. in the 'to' box i am getting...

HI, I am setting up an email facility on my access DB, it all works fine, but theirs an annoying thing it does i would like to sort out. The way its set up is I have client details on a form with an Email button, the button gathers info from the form and emails a 'report' to the client. But...

Hi, I have a table (Invoices Raised). I've constructed a query that extracts just the Date, Category and Amount from the table. It also groups them into years and sums the amount. There are 1000's of entries, the dates start in 2014 to date. The Category is what the invoice was raised for...

Hi, I have a report with a list of parcels and their weights, I am trying to get the report to calculate the postage cost based on the weight. I am using VBA to do it, but I just can't get it to work, this is the code I have. me.weight is a bound field and me.postage is an unbound text box...

Hi, hope someone can help I have a directory with 1000's of excel files the filenames are formatted A1234 17.xlxs The A is a checksum, the 1234 is client ref then a space then a year. I am trying to put a button on my DB that will open the folder and filter everything except this client...

Hi, i have 2 fairly simple Emailing issues. I have a button, when I click the button I want it to email something to the email address on that record (the client), I want it to open outlook but not actually send it, as small adjustments may be made. This is my code Private Sub RFIEmail1_Click()...

Hi, I'm sure this is simple, but its got me. I am wanting to extract the Surname initial from a string "Client Name" However the format of the name changes, it could be Mr John Doe Mr Doe Mr John Smith Doe I need it to work from right to left, then extract the 'D' can anyone help please...

Hi, I have a subform datasheet that lists all invoices and payments for the client displayed in the Parent form. On each row i have a'Print' button to print that invoice. This all works fine. However the print button is also displayed on the 'payment' row (each row is either a payment or...

Hi, Can anyone help please! I am trying to develop a 'Print copy invoice' form I have a continuous form with the following fields (already issued invoices) Date / Invoice / Description / amount / [Button] I am trying to print the invoice on the line then the button is pressed. (there could be...

Can anyone help? I have a table of invoices, what i am trying to do is enter a date in a text box then get the total invoices up to and including that date. Sounds simple, and it all works fine until.... If I enter a date, say 27/8/16 and the last invoice raised is actually on 20/8/16 it totals...

I created a button that triggers a website yesterday, it worked fine yesterday, but today nothing happens, this is the code Private Sub SE_Click() Dim ctl2 As CommandButton Dim UTR2 UTR2 = Replace(Tax_Ref.Value, " ", "") ' Remove spaces Set ctl2 = Me!SE With ctl2 .HyperlinkAddress...

HI, I have a multiple item form (Event_log) as a subform, listing all activity from the client on the main form. there are hundreds of entries on the Event_log. I am trying to turn the text of the 'event' field blue if the event filed contains the word Invoice. (to find them faster) I have the...

Hi, I am quite familiar with Access, but not the Navigation form. I have 2 questions, if anyone can help it be great? I am wanting the form with tabs across the top and down to the left, I have 3 tabs on the top (at the moment) and 9 down the left. When I client on the 2nd tab, the left column...