Search results

Hi, Does anyone know of an way to pass parameters to Form Instances on Open, for example if I was using just the single instace I would pass a paramter with the OpenArgs, but with instances this does not seem to be available does anyone know of a way to do this. Also I would like to ideally...

Hi, Found a work around which is to display the info in a List box and have the listbox update a button, works much easier than a continuos form, would have prefered a continuous form, but this will do the job! Gavin,

Hi, I am trying to create a continuous form that will have a list of labels with Hyperlink Addresses, my problem is I cant find away of populating the correct Hyperlink addresses to the labels, my first thought was to use the On Current event, but that doesn't fire until you enter the record on...

Error Trapper Code only running in Debug Mode Hi, The function below works fine when I run in Debug mode, but when I run the code normally it fails with an Error 13 - Type Mismatch which the error trapper should stop, I have even added a debug.print statement to see if the Error Trapper is...

Thanks for the help, in the end I found an easier way, I updated the orignal view, and used a select query in a datasheet form, not as eligant or as good for performance, but as the form is used once or twice a month it was not worth spending the extra time on it.

Hi, I have an form with a large textbox (varchar 4000), stored in a table on SQLServer 2000, but when I access the data in access through the form when I have any reasonable amount of data on the form, I keep getting data coruption on the control. for example I create a record with about 1500...

an ADP, makes it a pain as I could just reference a function in MDB

Sorry just noticed that you are using SQL2000.

Hi, Are you sure you are using access ADP's and not MDB's as this sounds like the issues you usally get with MDB's? If you are using ADP's, the only thing I can think of, is what version of SQL Server are you using, if you are using SQL 2005 are there any new drivers available as from prior...

Hi, I have a Stored Procedure spOtherQuals which takes 1 Parameter (Year) and returns a data view, what I am trying to do is find a way in Access 2000 to pass the parameter and open the SP in a Table like view (like what happens when calling docmd.openstoredprocedure), does anyone know how this...