Search results
-
W
Error: Sort aborted #1028
Hello, The database ran this same query as part of a macro that is run weekly for over three years: SELECT tlog.Num, tlog.Uniquet, Count(tlog.Code) AS CountOfCode, Sum(tlog.Amount) AS SumOfAmount, Min(tlog.tTime) AS MinOftTime, Max(tlog.tTime) AS MaxOftTime, transacts.fValid FROM tlog INNER... -
W
Creating a query WHERE Date>1/1/[current year]
I'm trying to update a dozen or more queries that have january first of 2009 hard coded into them. So that I'm not doing this same thing again this time next year, I was hoping someone could provide me with the correct syntax for criteria of 1/1/[current year]. I've searched the forums and... -
W
Best solution for preventing unintended edit to a record?
I have a form that has two combo boxes that display a persons first and last name. Those combo boxes are pulled from the names table. Based on what value the user chooses, the appropriate name ID is stored in the application table. That is fine and dandy for creating a new record. However... -
W
which event to assign code - for change in text
I created this code to change some text on my form to indicate if the name record is a current card holder or not. It's overly complicated because all cards expire at the end of the year, but if they applied within the last two months of the year then we give them a card that will last until... -
W
required entry on table level creating problems
I have an application entry form that has combo boxes to display the existing name records. Currently if someone searches through the combo boxes and hits the "add name" button upon realizing the name is not in the system, an error is thrown asking for input into the phone field. This could... -
W
Invalid use of null
I'm stuck on how to solve this problem. The onclick code below is to open the names form, and is located on the application form. I want to set the initial view of the names form to the record with the name ID currently being viewed. This code does that perfectly. However, if someone...