Search results

Gemma, yep that's a typo, sorry. DCrake have downloaded your examples, will apply these and post my result. I still can't understand though why a Row Source on a chart can be the long sql thing in the properties sheet but if you click on the ... and save as a query so that the Row Source then...

Yeah, I've tried that, sorry to take up your time I think I'm having a brain breakdown, will try again tommorrow and post of my results thank you.

yep, this is wrong isn't it?

Hi Wiklendt, Your post gave me some ideas and I foun this on the Microsoft website but am unsure if this is the cause of my problem. Your help is much appreciated. "Changes to the underlying data (such as the format of the data) have precedence over other changes. However, if the RowSource...

Hi Wiklendt, PARAMETERS [Forms]![GetChart]![Year1] Long, [Forms]![GetChart]![Year1] Long; TRANSFORM Avg(CompGraphQry.Be) AS AvgOfBe SELECT (Format([Date],"dd mmm")) AS Expr1 FROM CompGraphQry WHERE (((CompGraphQry.Vintage) Between [Forms]![GetChart]![Year1] And [Forms]![GetChart]![Year2]))...

Hi All, This is a bit hard to explain and I've searched for an answer to no avail. I think this might be a 2007 bug. I have a report with a chart on it. The report is based on a query with criteria derived from a form. The chart also has it's row source (obviously) set to a query but until now...

Sorry to drag up an old thread but as this forum is so invaluable to me I like to post if I work things out from the clues obtained by searching. I was wanting to have All at the top of a list but didn't like the (All) or [All], i thought it didn't look good with the brackets so I tried in my...

Hi All, My client is trying to sync replicas and is running into trouble for some reason. last week everything worked fine but now they started getting a MaxLocksPerFile msg so I put DAO.DBengine.SetOptions MaxLocksPerFile, 1000000 in front of the db.synchronize then...

Hi All, Have been using db.synchronize for a month or so now with a client and no probs 'til now when the client got the file locking message, which I think I've narrowed down to the client having entered heaps of data to a replica then tried to sync and the whole thing went pear-shaped because...

Cheers Premy, thank you so much for your reply, I guess I was wanting to be able to concatenate it onto the actual field ie the capital J in Wingding format is a smiley face but would guess that different fonts in the one field are impossible. I'll have to think about another way of getting a...

Hi All, I've searched far and wide for an answer, I thought it should be easy but am having some difficulty. I would like to add a smiley face or a sad face to a standard comments list so that when that comment is added to a record on a form and subsequently printed, the information can be...

Thanks David for your reply, I have realised in the last week that I don't need TSI so have scrapped it and have the suggestions you made working fine, thank you ery much for your time. Kind regards, Rachael

Hi all, thanks for your time, I think I'm getting somewhere but just have one small quick question; Here's the code David helped with that I've implemented to do the synch Dim strLocalReplica As String Dim db As DAO.Database strLocalReplica = Mid(CurrentDb.TableDefs("Company1").Connect...

PS thank you David for your lenghty response to my questions...I've just been examining it in full and your help is very much appreciated...your a gem!!

Hi everyone, thanks for all your replies. I'm beginning to have some confidence with what I'm doing so thanks, but I still have some questions regarding how to structure the whole system. I have the tsi synchroniser working no problem, and distributing the synch40.dll will be ok (although I will...

Hi All, I'm about to embark on a project whereby my client needs to be able to create replicas for use with tablet PC's that can be taken out into the field then synch'ed back at the end of the days work. I understand that I need some careful planning so would like to put forward my thoughts...

I think I might make a new thread as I'm getting off the original topic. "Setting up for Replication"

Hi David, thank you so much for your time and thoughts, I must say I'm entering new territory here and agree I need to do alot more planning hence my reason for posting in this forum, I really appreciate yours and anyone else help. I guess I think I need the TSI synchronizer for the future...

Hi Davesmith202, here's my two cents worth! I have been distrbuting access db's for about 5 years, firstly in access 2000 and recently in access 2007. I don't have any problems with version conflicts as I always install the 2007 runtime as part of the install package (even if they have a...

Hi Bob and David, thank you so much for your replies. I think I do understand replication and am sure I need it. My client whom I working with at the moment needs to be able to load the database onto Tablet PC's for out in the field data entry, they also have an office network which at the...