Search results

Unfortunatly this is not the case boblarsson.. i receive the error, you can not assign a value to this form.. Thanks!

Hi All, I have an issue with GoTorecord,,,New, on a forms onload event.. Form A. Control 1 (Primary Key). Table 1. On the click event of command button “create new record” i open Form B, table 2 Table 1 and Table 2 have RI Control1/Table1 – Control/Table2 Form A remains open and visible...

Very much appriciated John..i used this as criteria and it works fine Between [Forms]![Reports Menu]![FromDate] And DateAdd("s",86399,[Forms]![Reports Menu]![EndDate]) I tried to add some reputation to you...but seems i need to "distribute" some ? Any ways..Thanks a Lot!

Hi all, In a query i am referring to form A, were two unbounded controls represent first and last date Controls DateStart and DateEnd The criteria in the query field "Date" is Between [First Date] and [Last Date] How do i refer to control “DateStart”/[First Date] and “DateEnd”/[Last Date] in...

Hi boblarsson...so i tried out eveyrthing and come to this solution StatusOpen: Abs([CaseStatus]="Open")..it works great. Thanks a lot!

Her is the query SELECT Xcodes.XID, Cases.CaseID, Cases.Category, Sum(-([CaseStatus]="Open")) AS StatusOpen, Sum(-([CaseStatus]="Review")) AS StatusReview, Sum(-([CaseStatus]="Closed")) AS StatusClosed FROM Xcodes INNER JOIN Cases ON Xcodes.XID = Cases.XID GROUP BY Xcodes.XID, Cases.CaseID...

Hi, I have an aggregated query (query / query) in Access and when i run it with my tables Linked to an SQL it does not function. This is the string SELECT XcodeCaseQuery1.XID, XcodeCaseQuery1.Category, Sum(XcodeCaseQuery1.StatusOpen) AS SumOfStatusOpen, Sum(XcodeCaseQuery1.StatusReview) AS...

I was unclear..i moved the query and form to the frontend of my database that is linked to the SQL... :-)

strange..i moved the query and form to my front end, linked to my SQL..and it works just fine. Thanks Again!

Thank you boblarsson, however..something is wrong..the form opens but without any resaults...

Hi all, I use an unbound textbox in my application menu to search the content of some forms on the “click event” of a dedicated button. I use the below code, the continuous form opens but displays no results....also..how do i centre the text in the textbox? I do not use this code in the forms...

I found it.. i replaced FOUserName with fOSUserName() Much appriciated David, thanks!

Thank you David...i receive an Compile error / Variable not defined for the FOUserName

Hi Table Signatures. Field names “Username” and “Signature” “Username” holds the system username (fOSUserName) “Signature” holds the alias related to the username Example: “Username” bertlarsson = “Signature” Bert How do i write the DLookUp function to match the current fOSUserName() with the...

Sorry for being "nosy"..but what function does the 2 have? Thanks!

Much appriciated Wayne, when you say like 4 of these constants youe mean functions such as ENVIRON(Username) / foUSERname / etc ? Thanks!

I would have done it differently, not much, but never the less, differently. I am currently upgrading to SQL 2008 and i take this opportunity to restart... It takes time to understand how to end the chess game :-).. Access and VBA is huge..and thats the beauty of it..everyone can participate...

Thank you gemma... I understand

I am a beginner, i am interested in my application that returns high value for me and my colleagues. The value lays in the satisfaction of something created by an end user. It gets the job done and it involves co workers in the daily process. It’s far from perfect, but it works. I will never...

Is it not possible to donate a sum of money?