Recent content by Casperov

Hello, I am trying to figure out why I am getting different results, when I run some queries. The first one I am summing all the positive values with a sum of 7061.13. SELECT Sum(tblClass.Amount) AS SumOfAmount FROM tblClass HAVING (((tblClass.Amount)>0)); The first one I am summing all...

Hi Ken, The query totals up the values (neg and pos) and it balances out to 0...but how come the value isn't being supplied to txtJournalBalance field properly? The problem isn't the values that are being loaded into the system, it's how the system is handling the data. The form that the...

I have this piece of code, which up until today was working. However, today the txtJournalBalance does not equal 0, even though it is actually displaying 0.00 on the screen. If Me!txtJournalBalance <> 0 Then Me!cmdSubmit.Enabled = False Else Me!cmdSubmit.Enabled = True End If When I debug...

Hello, I have been reading on admin and user groups. Is there a way to setup the security to allow everyone to able to run a runtime version of my access system? I created the system with the intention of allowing the user who logs into a specific pc to be able to run the system. Or must I...

thanks Thanks Pat, I am thinking, that is what I am going to have to do in order to get the darn software installed. I used to install the runtime package for Access 95, but I think that Access 2002 has taken security in this case a little more seriously. Therefore, I may have to talk to our...

Hello, I have installed an Access runtime package on a user's machine under my userid. However, when she logs into her pc, she receives the following message. "Install program as other user - Some programs will not install properly if you do not have Administrative privileges on this...

Hello All, I have just deployed a runtime version of an Access system to a test machine. However, the messages "You are about to run a delete query" etc. is displayed when my queries are run. These messages are not coming up on my machine. Is there a way to turn these messages off on another...

It's Working!!!! Okay, So what I realized that caused my reference issues was the fact that I imported from an older system to a new version of Access. So I took the query that wasn't working and created a new database in Access 2002. What do you know...they query worked. So I checked the refs...

refs Hi Pat, There have been other suggestions regarding the references. However, if I am installing a runtime version of Access 2002, how do I ensure that the references are all up to date? Do I download all the updates and service packs for Access on my pc before I create the runtime...

references are the same Okay, I created a new module and it allowed me access to the references...but they are the same. What should I check next? Thanks, casperov

I cannot at the moment check the references, since I am remoting the test pc. However, if the references don't match, how would I get them in sync? Thanks for you help, casperov :)

Hello, I have created an Access system and released attempted to run it on another pc. However, when a specific query is run, I am getting the error message "Function is not available in expressions in query expression 'LTrim([tblF006.Business Unit])'." Does anyone know why this is happening...

new errors... I have gotten past the initial error regarding the system being open. For now I am receiving another error message: swstub.exe - Application Error: memory could not be read. what am I missing here? :confused:

Got Dev Tools for XP, but... ...I am getting errors. The Package and Deployment tool keeps closing down. I have both Access 2002 and Access version 7.0 on my pc. I am supporting both apps, that is why I have more than one version of Access on my pc. :confused: Does anyone have any...

Heeeeeelp, I read this, but I do not know how to go about obtaining this: the developer's edition has the Package and Deployment wizard, which will allow you to make package which will install the Access Run-time engine and your database on the user's machine. Thanks, casperov :eek: