Search results

I have DAO 3.6 library ticked but not prioritized higher than ADO 2.1, would this cause some computers to have heartattacks depending on the access versions installed and not others (like my development machines) Just a thought! Rach

Hi All, Can anyone shed any light on this bit of code and why it would work in, so far, Access 2000, 2000 runtime, and will not work on a computer with A2002 (I thought 2002 would run 2000 mde's) I have read that the connect part might not be liked by 2002, is there a better way to write the...

Hello, I have a client who has Access 2002 and Access 2000 runtime installed. The program I distribute with runtime as a split fe/be with the fe being an Access 2000 MDE file, the be a A2k mdb seems to run on the clients computer OK. From what I have read so far would I be right in saying that...

Hi Brad, thanks for your reply, The upgrade strategy works really well. I'm comforted to know that the For Next thing won't stall if relationships aren't there. I am starting to suspect know that the client hasn't installed the last upgrade and am now diverting my attention to this. I feel...

Well, the mystery continues, its a bit like being a detective sometimes! Is it possible that if one of the tables that I'm trying to remove relationships from and delete does not have any relationships that this will stall my code and throw up an error? on some computers! I am bamboozled...

Hi All, As part of my strategy to upgrade clients back ends which involves matching version numbers, copying tables to BE, running queries etc I have a piece of code whereby I need to delete 3 tables from their BE's (these tables are causing relationship conflicts). The following code works...

Hi, I have been searching for days now for a solution along the lines of the original poster of this topic (hope you don't mind me jumping in here) I have been trying to use the code listed by rich in a report. I am wanting the previous date from a date field to display (although I will hide...

Jack, Easier said than done, I have 100 clients and a fair majority don't even know where to find files on there computer, some don't have email, and most get very confused with the whole situation, asking for a file to be emailed would be like asking for them to climb Mt Everest. Anyway...

Jack, thankyou. I had been ignoring old tables until one had started to cause trouble. It had referential integrity set in the BE (from years ago before the DB was split) and is now giving me the #%&* because it wont allow new data to be added eventhough the link is deleted and it is not...

Thanks Jack, I thought there was some problem with ADO stuff if you had previously been using DAO. Shows how much I know about things, I'm flat out knowing what they stand for, but have used them in the past to make things work. Anyway, thankyou for your efforts, this code is added to my...

Hi Jack, The New Zealanders do a good job of Sauv Blanc, I personally think its a great wine but it hasn't really taken off here as it should have, don't know why! In our cool climate we grow great Sauv Blanc. The rain, well, we are getting some but still well below average and the winter so...

Thanks Bello for your response, What I want is to make the table delete in the on-open event of my splash where there is an if statement that checks the version number and does the appropriate things according to the version number of the users BE. So, in this if statement there are usually...

Hi, Could anyone tell me the code to delete a table in a backend db from the frontend. I have successfully mastered copying tables from the fe to the be using docmd.transferdatabase but I need to delete a table and its relationships. Hope this is an easy one, Thankyou, Rachael

Hi all, you will be pleased to know that after two days trawling the net for an answer I have solved the mystery. Here's what I have learnt: Tick the Microsoft Graph library box in VB references Don't try to run the code in the report On-open as the OLE object (the graph) isn't actually open...

this is what I have so far Dim objChart as Object Dim objAxis as Object Set objChart = Me!NameOfYourGraph.Object Set objAxis = objChart.Axes(2) If objAxis.Type = 2 Then 'Type 2 = Value objAxis.MaximumScale = 100 objAxis.MinimumScale = 0 End If But I keep getting run time error 2771, the...

I want to overlay some charts (in a report) that are based on different queries but all contain a date field. So far, I have thought I could acheive this by having an unbound form with fields to add criteria including a minimum and maximum date for the chart to display. This min and max date...

Hi Keith, relieved to hear you have had the same problem, if I could possibly trouble you to find the info I would be most appreciative. For others that might be interested the Setup2go installer seems pretty good (much better than PDW BUT I don't think Runtime can be launched if Access doesn't...

Thanks everyone for your replies, nice to hear from you Jack, as always, we have had a little rain but are still in the grips of the worst drought on record. Thank god for my software income. Anyway, pcs, have downloaded the Setup2go and will try out shortly. Do you distribute runtime with this...

Hi, I have been using the Package/Deploy wizard for a couple of years and it works OK (though limited). I am now having a few problems such as it doesn't seem to work when a customer is installing on a machine with Windows ME or 2000. I have to talk the customer through a manual install (copy...

Thanks Jack, I just thought I'd post exactly how I solved the problem as wasn't quite straight forward. I used a spare field I had in the spray diary and in the after update event of the chemical I put [Spare]=DSum ("[Cost/Unit]","ChemCostQuery","[ChemID]=[form]![ChemID]") so the Dsum...