Search results

HI guys.. I have this error message that appears many times (30+) after I've entered new records or move through the record set I have a main form with many subforms including text and number data with objects (pdf) linked through an object control. I can't work out why this is happening...

Yes guys everyone has the same version of access and yes the database is not split. However this has worked fine for about 2 Years or so the problems has only arisen since i moved the database. but i have done some work on it too. Does anyone know what causes these problems? Cheers paul

Hi Guys, I have a problems that I don't quite understand. I have a database that sits on a server as an MDB file. We're having some server problems at the moment so I moved the database to a shared folder on my pc and everyone opens the mdb file from here. However, after some time the...

Thanks Rich

Hi guys, I have a master report made up of several subreports. If one of the subreports has no data in it I want a label named "No data in Database." to display (.visible = true). Where can I set the condition and/or whats the code? Hope you can help Cheers Paul :)

Thanks I am working on something at the moment that i can't get right but i'll post it if i do. Paul

Hi guys, I starting to do a lo of exporting to word now. problem is i've forgotten how i did i before. I can open a word doc and export items i need through code. but I kow that I can export full reports to word using DoCmd.OutputTo acOutputReport, lettersource, acFormatRTF but the...

Hi guys, I need a new installation copy of Access 97. Does anyone know a good place where i can get one from that isn't expensive ... Thanks Paul :cool:

Your site! Err yes ... Bit of a buff about certain aspects (including access when necessary) Paul :)

Complex query SQL ... Err... the SQL is larger than the 10000 characters that the forum allows so heres some of it ... The whole thing is in the attchment ... but this might give you some idea.. you know how to take on a challenge.... Cheers Paul SELECT Data_Dynamic_Properties.PropertyID...

Complex queries... I have no joins at all... But the whole query is a collection of calculations ... When you say too many .. how big can a query be ? and if i need one to be larger what can i do (make two smaller ones then summarise the fields in a simple query ?) Surely access (xp) can...

Query is too Complex! Error message : "Query is too Complex" what does this mean ??? I've been given it a couple of times can i get around it ? Cheers Paul

Guys I know one way that i can do this through code using recordsets but is there an easier way... I have a table which is passive and stores settings for various operations. SO it has one record only and the various fields store with different parameters. I would like to pull the value from...

missing variables Many Thanks Pat! Paul

Still Loosing A Variable Somehow? gUYS, mANY THANKS I'VE CORRECTED ALL THAT YOU RECOMMEDNED.. THANKS iVE CHECKED THE CODE AND THERE ARN'T ANY ERRORS WHEN IT FIRST RUNS THE ERROR ONLY APPEARS WHEN IT RUNS A SECOND TIME AND THE VARIABLE IS "". i CANT TRACE WHEN THE VARIABLE LOOSES ITS VALUE...

Hi guys I have a code module which declares public variables when the database opens… Option Compare Database 'set variables 'set public variable Public OffersDataSource As Variant Public SetPropertyID As Integer 'For OUTLOOK AUTOMATION OF APPOINTMENTS Public ASTARTDATE...

No, I mean report and subFORM. I can insert a subform into a report but to save creating a subreport which is the same as the subform i already have can't I reference controls on the inserted form on the report? Cheers Paul

Hi Guys!!! :D I'm using a form (A) which checks information from a settings page (B) which is a subform on A. This all works fine. I then created a report (C) and want conditional formating to use the same subFORM (B) as the report (A). I have the subform (B) inserted into the report (C) but...

Hi huys, This is a bit of an unusual one. But I have two requirements : 1) Access97 database to support and 2) AccessXP database which I'm currently developing. I have both installations on my computer and both appear to work most of the time. The probelm is is that I know one database uses...

**- - - - To late or to Early Bind - - - -** Hi guys, Here's one query that I've just never got round to asking but I do some much Automation now that I doing a lot of repetition. If I'm running a lot of automation code which uses a great many variables (Hundred or so). Which is better...