Search results

Hi - thanks. If i convert the backend .mdb to .accdb in 2010 prior to upgrading, would it still operate as a multiuser backend ? I don't know why but in the back of my mind i seem to recall the backend needing to remain in .mdb when the frontend was changed to .accdb. Also the current 2010 is...

Hi - long time since i posted & would appreciate a little advice prior to upgrading from Office 2010 to Microsoft 365. We have a database to manage our customers, quotes, orders etc which stores all the backend data in .mdb files on a raid NAS box. The front end is on 10 other computers in...

I have aquired some VBA that gives me the option to remove headers from a word document prior to printing. The is because sometimes i want to print to PDF using the header logo already in my document template, yet other times i want to print to our preprinted letterheaded paper. It works OK...

I have aquired some VBA that gives me the option to remove headers from a word document to enable printouts to be printed on letterheaded paper. It works OK but i would like it to remove footers as well as headers. Could anyone guide me in altering this code to suit. Many thanks Private...

Brilliant thread - answered so many questions for me this has. I've been banging my head against a wall trying to workout how to re-write my database to work from a browser instead of access forms !! Now i understand the differences and why folk have been suggesting i 'bin' access in favour of...

Thanks - i will look into it & post my findings.

Hi all, long time no post. Just tweaking a few things in a database and stumbled across an error. I've been using this code:- Dim mySTR As String mySTR = DLookup("MapLocation", "tblFileLocations") & Me.ContNo & ".axe" Application.FollowHyperlink mySTR, , True on a couple of...

Hi Darbid Thanks for your reply. Printing to pdf is not a problem - i use fineprint pdf & pdfFactory for that. The problem is that the quote document is saved as a .doc with a header & footer size to suit the pre-printed letterheaded paper. What i am looking at doing is taking the text...

Hello again AWF :o I have a problem i hope someone can help with. I have an access database that handles our customers, orders, quotes etc. and works quite well. It has become so relied upon in the office that others are now making suggestions they'd like to see on the development. Thats...

Guys i need help ! :mad: I have a real frustrating problem that i can't fathom. I have an database with a simple form with a listbox. I am trying to add an option group of 2 options that will change the rowsource of the listbox to look at 2 different queries. Seemed simple enough, but...

pain this year then but at least next year will be OK ! :p

Brilliant ideas - wasn't expecting anything that in depth but you've hit the sweet spot with that 1. Many thanks and best wishes for xmas & the new year.......now i'm off to find all the scraps of paper with addresses on them :)

Hi all I'm after a bit of advise on creating an access database - i've been thinking of doing this for years but this year I WILL :o. I want to put all my names & addresses into a database & print the addresses out onto some sticky labels - it will saves hours in time not to mention the...

aaaaaahhhhhhhhhh - spotted it - nice 1 - thank you very much perfect :) thanks

Hi all I am hoping someone can help with the attached sample database. I have created a query (qryHistoryPD) which pulls information from several other queries, some of which are union queries. In there it shows a date for "Last Calved" which is a date created from another query. I only...

Guys between you you seem to have answered my question. With the DCount it was kind of working but for some strange reason missing dates on 'some' records, with no obvious pattern as to why !!! Much head scratching later & brian you saved my fingers from many splinters ;) That is a very neat...

Thank you both for looking at this - i will go and look again after my tea ! I did get so far before i left the office and was getting somewhere near..... I have created the totals query OK and altered the original query to add the dcount function. However it was only showing the calculated...

Yes i need to display ALL AIDates but only have a calculated date for the most recent for any given animal ! Does that make sense ?

I have a query that lists AI dates for animals. The same animal is often listed twice with different AI dates. I want to add a column to the query, where, for the most recent AI date for any duplicate animals it puts a date 280 days from that AID date ie My query returns:- DATE...

I tried leaving out the DOB (A) and doing a report to see what error came up so i could trap it but no error came up. !!! Was this intended ?