Search results

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...

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...

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...

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...

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:

Hello, I am attempting to update a TransNumber field in a table. The TransNumber field will be a grouping number, which will be based on a GLDate field. Therefore, this number will be the same for all the transactions unless the GLDate field changes. At which point I would need to increment the...