Search results

Hi tokash, thanks for posting your solution. In the end we opted to export the report as a pdf and open it in a browser control as we were running out of time. I will take a look at your solution as it's nice to know the answer. Thanks for taking time to answer this old post.

Hi All, I've failed this afternoon to find a solution to this problem. We have an Access application that works fine in Access 2010 but fails in 2016 when we open a form with the Crystal ActiveX viewer on. When I say fail there is no error code it runs but the viewer is blank. From various...

Hi all, I've been reading around the web and here but generally getting confused trying to work out what I should be doing. I want to make moves forward to limit the possibility of the traffic between my Access client and remote SQL server express R2 being compromised. These users make 4-5k...

The data is supplied by various charities and they choose to record in differing fields for contact names. Therefore one may collect Firstname and Surname and another might just have a fullname field or an initial and lastname, and so on. Add to that the same charity might send their their data...

Hi thanks for the reply. Hopefully this will clarify a bit more. There are the following contact name fields dat_Title dat_Initial dat_Firstname dat_Lastname dat_Fullname dat_Salutation_Letter dat_Salutation_Envelope Depending on who has sent the data not all of these are supplied and the...

Hi, I have an Access 2010 with an SQL Server 2008 back end. A couple of times a week I have cause to append from a local table between 100 and 6000 records to a table in the SQL Server The SQL server table has a number of fields and each append requires different combinations of these...

Thanks again for your support. Sorted another out this afternoon. Now this office had the problem a while ago and the only way I got round it was to reinstall his Access 2003 run-time. I guess what happened was the Office SP3 was not applied to this new install until the next time they had an...

Office No 2 sorted Ran a support session with another office. They had the Office SP3 install on the 4 Aug and noticed the problem the day after... Bit of a clue there... Hotfix sorted there issue out too. Dan

In the simplest form. If you want to produce a draft email with one or more email address pre populated then you could use the followhyperlink method. This will create a new email in your default email client. Application.FollowHyperlink "Mailto:email@address.com" You can then get you list of...

Sorted!!! Hi guys thanks for sticking with this one. Here's my update of the fixed problem. Further back I mentioned finding and article on the effects of of OFFICE SP3 on ACCESS. Here it is again if you missed it. This was my first port of call in sorting the problem and it proved to be the...

Today is the day... I also had an email from another office with the same application. They have the same issue. interesting as this application has been solid for a number of years and now 3 offices have the same issue... I shall let you know once I do.

Quick update. I haven't had the opportunity to progress this further as yet. Something exciting for me on Monday morning to look forward to...

I see that these seemingly daft questions can be learnt from. My first Access Application was written in '94 for a guy in the office where I worked at the time. We went through all his needs and I kept him abreast of the development at key stages, showing him how it worked and he was very...

relinking The two main issues I had to content with (as do most) are the re-linking of tables and managing any code references. I built tools to help me with both. Attached is a database with a form you can almost throw into any applications to make life easier for re linking tables if you...

Banana, yes that will be the final way to do it. I would like to find out why first ,if at all possible. Then if there is something I am still doing wrong after all these years then I can correct my ways, or at least stand a chance should I fall down this very same hole again. (That and the...

Aha! I haven't tried it yet but I see that in the above mentioned article the hotfix should fix the problem I have experiences. So this looks like becoming my new game plan for tomorrow AM. I want to try it now but I think in haste would be foolish on tired eyes n brain! I'll let you know how...

RG, yep I have had one delivered to me by my lovely wife which is all good. However stirred by your comment on service packs I have just had a quick look at what has recently been installed on this machine. MS OFFICE 203 SP3 and this article relating to it with reference to Access 2003. Though...

cheers RG, Yeah I thought the same and was something I had considered earlier and whilst in the process of writing down my fault finding process I neglected to write that down. Something along those lines makes more sense in my mind. I shall definitely post back. Nothing more frustrating than...

it is isn't it. No there aren't any local tables in the front end. It was purposely kept simple due to it's distribution to about 30 offices. It's behaved well for the last 3 years or so with minor issues. There are references that get set on first run (word & Office) but apart from that it's...

Hi thanks for the reply. Seeing as the code is the only thing I can get at (If I start in another module and search ) I have just checked and no I don't have a line like that. I do have DoCmd.Close acForm, "frmContacts_EDIT" I have tried removal all the code and the same problem occurs. I...