Search results

I am having a spot of bother with getting locked out of Access if any of the references to tables as DAO recordsets is wrong. It starts off with the normal "cannot find xxx" but when you click OK I get a new box "Object variable or with block variable not set" You can hit the OK button till you...

I am tentatively exploring a potential new project which would need SQL as a back end on the main clients web hosting server I think and needs to have a web based front end. I have done Access front ends to SQL before but this one would work best if I have full control rather than installing...

Two things spring to mind. Firstly licensing and secondly version control. For people to use the database and make changes they need a licenced copy of MS Access. If just data changes I think run time version would be adequate. Secondly you are likely to have a disaster on your hands unless you...

Thanks Bob That is what my instinct said, but it is good to have it confirmed!

Thanks Supercool I might explore the timer route since if I can set it up to record without too much sweat then it might prove a useful diagnostic tool - without slowing things down further hopefully! Best wishes

Thanks Rabbie That is effectively what I have been doing - I call them temporary tables since they hold no permanent data but the structure stays there. I thought this would be likely to cause less bloat but wanted to check. Hopefully you still celebrate Hogmanay even from exile? HNY

I have a complex reporting process that I worked out using ten temporary tables - and I know it works. My question is am I better to use permanent tables, deleting prior to the reporting, then appending the relevant records or would I be better creating make table queries? As a general rule I...

Thanks Andrew That article did not in fact sort it but it did prompt a wider search and I found the solution. It turns out I had used "new line" at the end of each address line (to suppress extra spaces) but MailMerge only suppresses blank lines if it is "new paragraph" at the end. Solution was...

I am trying to generate letters from ACC2003 db into Word2003. Reason for Word is so client can edit letters if required. I have set up a maketable query to generate a temporary table in the Db and the mailmerge master document all formatted and pointed at the temporary table. I still need to...

Now sorted thanks Changed to doing a dcount of the recordset and and incremental counter which seems to have solved the thing (after a few false starts!) Thanks for the help Best wishes

Thanks for input. You are right there is more going on. I need to print sticky labels in a very specific order off a roll of labels. Fundamentally first out I need one dispensing label and two bag labels for the last issue in a sequence, then the same for the penultimate and so on until this...

I need to sequentially process a recordset from bottom to top and then once all records completed I need to go back to the first record and set a flag within the record. It works fine until the last bit. On investigating I have found that assuming 4 records it runs through the records four times...

I am upgrading and optimising an application. I am wondering if I am running queries the best way. Currently I am using DoCmd.SetWarnings False strQryDef = "qupdSsnScrOp" DoCmd.OpenQuery strQryDef, acViewNormal, acEdit DoCmd.SetWarnings True Might I be better using...

Please excuse if being thick but do you mean characters 75, 199 and 200? If so you could use the InStr function quite nicely but would probably need to test first that the string is > 200 characters.

I have a hunch that the OnFormat event may not be the right one to use. What happens if you move the call to OnLoad? Might be worth experimenting a bit HTH

Umm its a bit ugly but you could devise a series of reports - with one frame, two frames, three frames etc. Then use a DCount to identify number of pictures to go into the report and then a SelectCase to print the correct report so that if the DCount is 3 it uses the report with three frames...

If you use a logon screen or a main control panel you could build in a message box in the form's OnOpen and ask if table contents to be deleted - and if answer is yes then delete. Your problem would be finding a neat way of ensuring someone does not log out to go to lunch and then when they log...

Not sure if this is right group. I have done a web interface to SQL before and used HTML-Kit to set up the ASP pages but found it a pain in the neck to use. I have heard Visual Studio easier to work with but it has quite a cost. Any recommendations about easier routes to doing this? Scenario is...

Thanks Premy Worked a treat and since it is the line immediately after the recordset update I think it should be pretty bombproof. Best wishes

I have created a table tblMeetings where records of contact with clients are logged. The form is pre-populated with the client's name and then takes type of contact (e.g. email, face to face etc), the person dealing with it, the date, duration and any notes. Once the user clicks OK it appends a...