Search results

I tried this this but this way the object only remains defined while the code is running. After the code stops - when I run the code again the application is open but the object's value is nothing. I put this code in a module and call the sub from the immediate window. Option Compare...

I am using objects from a statistical package from Access VBA. The problem is that each time the code runs I need to create a new Application object (start a new instance of the statistical program) with Set StatApp= New xxx.Application and starting the application takes a relatively long time...

I finally made it. The trick was to check the Count of the common part. SELECT MeasureInst.InstrumentHeaderID, @ReportInstrumentHeaderID FROM InstrumentDetailScorableItems ReportInst INNER JOIN InstrumentDetailScorableItems MeasureInst ON...

I have an item pool from which I draw items to create Instruments. Each item has a ContentID. In an instrument items can be scored differently so I have a ScoringTypeID. This makes up a table like: InstrumentHeaderID ContentID ScoringTypeID InstrumentHeaderID and ContentID togather uniquely...

Hi all, is it possible to write editor scripts to format code in the debug window to automate tasks like: - commenting/uncommenting multiple lines - properly quoting multiple line SQL strings etc. For the later I wrote a small macro in Word. I paste SQL code from the Query building grid to...

Rich, you said how could you do that? SWK

I am calling an SQL Server stored procedure from Access - works fine. The stored procedure will take a long time to run (could be 30 minutes) doing a large number of iterations. How could I get back some indication of progress to Access and display it on a form? Thanks for the help SWK

I am creating an Access 2002 project in Access 2000 file format, using SQL Server 2000 as backend. When people want to use the frontend with Access 2000 they get an "MSAccess has generated errors and will be closed by Windows error". They don't get the error if they set a breakpoint and step...

My project is about prototyping an internet application so I need to keep the interface very light and separate the functionalities of the application as much as possibble. I think having the functionalities on different form could have an advantage even with the wizards as ideally it would...

Thanks Raskew, that was a very useful link. dcx693 - I need to create wizards and a wizard creator in my application that would guide the user through the steps the user needs to carry out certain functionalities. OK. I made sure from the beginning that I have my functionalities in separate...

Is it possible to store multiple statements or whole subs in a record and later execute the stored code from the application?

That is very helpful. Many thanks to both of you. I didn't go for the CHR$(39) solution because of the need for parsing the field, so I chickened out and used rst.AddNew instead of insert. But I will try this DQ method. It looks very nice. Thanks again. SWK

I am creating an SQLstring that would insert a text into a table. My problem is that the text which will be inserted includes the ' character so when I execute it I get an error message. (In my case Me.StoredString contains an ' character.) This is the syntax I use now - how should I be doing...

I knew that I have already done this once but now I couldn't find out how it was. Many thanks for the help. SWK

Anyone knows how to make a combo box display the first record of its recordsource? Thanks SWK

I think I found a solution but I am very interested in your opinion. It uses the Scripting Runtime library (I don't know the heart and soul of these beasts - I mean different languages or wet chickens - but but it sounds very similar to what you said DocMan that I need to look at scripting...

hi pono1, I think the major problem with your method is that you end up storing the values of the variables in the database while they are specific to the application - which makes this approach difficult in a multiuser environment. Isn't there a collection of which all public variables would...

Thanks Fofa and Dunstan, that was very useful for me. SWK

hi pono, as Einstein said: "There are only two things infinite - the universe and human stupidity and I am not sure in the former one." No I didn't make a bet, so only the profound bit remains - could be, here is what I am trying to do. I have a large number of functionalities in the...

Rich, I don't think I could use DLook. The value of the variable is not stored in the table just the name of the variable.