Search results

Re: Macro - Crashing infrequently Yes... yes it is... my mistake :/ and I do know the difference The steps are the same, they go into the search form, begin typing and then crashes (random times, random intervals, sometimes it happens 4/5 times in a row but then works perfectly for the user

Always ;) I have my "live" system which has all of the features I have added which I cam confident in and then I have my test system. And of course each of those have tables which are backed up and front ends backed up. Then our Server backs everything up nightly as well. lol.

Hi, I have a Macro running as a search function. 99.5% of the time it is working perfectly, however every so often it will throw a hizzy fit and crash the system, I can't get a debug as the users who are doing it are running the DB in Access Runtime and of course it doesn't offer to debug...

Thanks guys... Will investigate and try to get an update working on the legacy records. Once I am confident the update works I will work on the method suggest above.

I appreciate that, Unfortunately without then going through and changing the 12-13k of records being imported into the DB from Excel I would be unable to do that. For that reason I will continue on the method I am doing (which does work) but will take a little longer.

It's not so much of writing out the code, tbh I can copy the previous Queries and just change it to the next letter. Each letter being sent has its own Yes/No box, so for example I have this Date Entered [loads of random address fields which aren't relivent] Letter 1 = Yes/No Letter 2 =...

Each letter have their own Yes/No box. rather than one field to control ALL letters.

Hi Guys, Me again.... So I have a DB I am working on which holds canvassing data. Now ever so often we sent a letter out to the people on the DB and it has a time period for example Letter 1 - Same Day Letter 2 - 7 Days after entry Letter 3 - 14 Days after entry This goes on for 30...

tbh with the amount I have been using access enough I should've known it :/

He Shoots, He Scores and by golly that was the quickest reply I have ever seen ;)

Hi All, I currently have a query set up which responds and filters by the date. I use the current code in the criteria on the query for todays date less 7 days DateAdd("d",-7,Date()) This works perfectly and I had no problem with it. However I need to adjust the criteria so it is less...

Thank you very much, especially for all your effort.

Ok so I made a sample DB, Sample Letter and entered some sample Data, The Sample has to be split DB (to allow word/Access access the DB at the same time) so you'll need to remap the tables whereever you save it. Also in the Letter / Merge file you'll need to go to Mailings > Select...

Thanks... apparently thought it's simpler than I thought, to get the sum of the Yes/No Box I can just use =-Sum([Field 3]) and it converts the -result from the yes/no to a possitive, then I just used =(Sum([Field 2])/(-Sum([Field 3]) and it worked amazingly Thanks for the suggestion though.

I have a report which provides me with three totals. Total 1 Total 2 Total 3 Total 1 is an easy one, it uses a count fields =Count([FIELD 1]) Total 2 is another eays one, it is a sum of all the numbers =Sum([FIELD 2]) Total 3 is a bit harder, it is the sum of all the ticks in a yes/no...

Okay, Tried it on a fresh blank DB, both with oApp.UserControl = True and without. No difference / change

I'll try with a totally separate DB tomorrow however I did try with two different files as the DB is split with a BE I was running two different front ends, one executing the request, the second handled the SQL query (different accdb files)

Nothing I can see... This comes up because the document is a Mail Merge item. Basically I created a mail merge were the source of the merge was the DB, and the query, I did not create the pop up, Word does that automatically. Can I even trace the code for that? I can't attach the word file...

Sorry, Which dialog box? the one when I open the letter normally in word (not using access) it's this one. If I hit yes here, it'll run the query and only import the data from the query (which is perfect) When I use it in Excel I get no box, it opens the document minimised on the start bar.

I get an error "Usercontrol" is a read only property and whilst the merge file loads, the SQL box doesn't appear :( Full code here Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc = "X:\Access Database - Lettings Canvassing\Letter 1.docx" If...