Search results

If you want the app to run strictly on the '97 runtime, I would assume all you would have to do is create the shortcut to your application with the '97 'runtime switch'. But I don't know where Access installs your version of the runtime. ----------Edit---------- I mean assign the correct .exe...

What I do when developing SQL statements to be used for recordsets is to make a test query and pull all the data I want in the design mode only, and then switch to SQL view and insert your keywords. Adjust your statements and re-check your results. Only after I am satisfied with the results and...

WOW… ok… now I see. Steff, you obviously spent some time writing those SQL statements. This is with Access 2003; the errors are a little different. Ok… going through this a little more thoroughly than what I did the first time... Just running the queries by themselves… qrySumFATim...

Chris, I didn't get it to fail for me, did you?

Good point, thanks for the added insight.

Hi Chris, That did help. I should say the earlier statement was in regards to a control on a subform, although I wouldn’t associate a label as a control I thought I would include it just incase the requery didn’t work. I should include the whole statement to make sure I didn’t perceive it...

Looks like you got Steff going RG. I found this in one of my books regarding syntax in subforms and thought I would post it, although I haven't tested it to see if it works or applies to Access 2003. This is regarding (!) vs. (.) in subforms. ----------- Using syntax in subforms you can never...

I haven't used subforms in a while, so I had to hit the books. Try using the (!) 'bang' operator instead of the (.) Dot operator in your code in/for a subform.

Maybe this will help in deciphering the structure differences between 2002 and 2003... Office 2003 Editions: Access VBA Language Reference http://www.microsoft.com/downloads/details.aspx?FamilyID=0447C5A0-5E58-4E69-B90E-C42EC7DBF887&displaylang=en ------------------Edit----------------...

Thanks for the post! Great catch.

It means that I have been up for almost twenty two hours and have had waaaaay tooo much coffee.:eek: It could be due to reloading of the site... I honestly don't know. I will leave it to the experts... definitely time for bed.

I just went through my browser options and deleted the cookie for this site, actually all of them for this site ( I think there were about six, one was bblastactivity, bbsessionhash, bbuserid, bbuserpassword, bbthread_lastview, bblastvisit ). Does this mean they also have our IP address...

Ahhhh... You have to delete your cookie. Before I deleted my cookie, everything was blank with Firefox, after deleting it, the forums show up again. Now, whats in the cookie thats has your latest info that would make the site invisible? ------------ That part of it had to be recent and...

No go with the Firefox 1.5 RC 3. Home page is ok... but the forums are blank, nada, zip. Odd it fails with Firefox, but OK with IE and Avant.

Well still blank for me with the new Firefox release... IE and Avant works OK, but just with those two...

Well... After having some spare time and doing some more testing, I found that I wasn't really compliant with my SQL statements using 'Distinct' after-all. Usually when Access gets 'tweaky' I am trying to do something illegal. I simply didn't have the SQL statements in my recordsets the way...

I know of one other guy that is having the same problem with the Access 2003 runtime (same app runs ok as an mdb but as a mde in the runtime there are issues). He is supposed to do some more testing this weekend and get back and post his results.

I haven't done this and I am not sure if I fully understand... Anyway, going through my books evidently Access 2002 adds the 'UseDefaultPrinter' property. True if the object is set to print to the default printer. False if the object is set to print to another printer. The references to...

Sam, I would try uninstalling, reboot, install again and make sure you have checked your items for a complete install. Also maybe close down any other apps that may conflict with the installation.

If you do use the runtime and have a fairly complex project, I would check your results even if you don't recieve any errors. Just dont assume that if you use the runtime that you are automatically home free.