Search results

Thanks crazy, Thanks for trying, we have 6 computers on a network here, none of them work. But be something at our end Thank again.

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

thanks for the fast reply. Thats works a dream :)

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

Thanks, I think i've got the SentOnBehalf sorted :)

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

That is perfect. Thanks

Hi, ok, I think i've managed to do a small database. Hope this is what you want. Thanks so much for this.

Thanks for the help. I'm not sure I could pop up a small database. I'm not that good with access. I'll have to find another way around it. Thanks anyway:)

Thanks for the reply's, I'm not all that knowledgeable with Access, But I'm ok with VBA. I do have a table with the Postal rates on, they fill a sub-form on the main form where the report button is. The parcels are all very similar sizes, its just parcels of papers. I guess I'm more...

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

unfortunately there may (and usually are) multiple files the 'Ref' part of the file name is the only constant for each client. The files could be :- A1234 15.xls A1234 16.xls A1234 16 Amended.xls A1234 17.xlsx

Sorry for the delay, just got back in the office. We (Accountancy Firm) have an Access DB (2010) that controls 1000+ clients, there names, details, an event log for each client for work done. When A Client phones up we get there details up on Access, a lot of the time the client wants to talk...

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

Thanks for the replies, I've sorted them now, using instr worked a treat. :)

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

okay, thanks for all the help :)