473,322 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

sql query run ok but in the form I got #error flickering

It is made of 2 tables and a query and a form
The sql is as follow:
SELECT Client1.TableID, Sum(NZ(Client1.Seat,0)) AS USeat, (NZ([Tables Event 1].Seats,0)-Sum(NZ(Client1.Seat,0))) AS VSeat, [Tables Event 1].Seats, IIf([Reserved]="YES","R",IIf([VSeat]=0,"F",IIf([USeat]=0,"V",IIf([VSeat]>0,"P","?")))) AS Status
FROM [Tables Event 1] INNER JOIN Client1 ON [Tables Event 1].ID=Client1.TableID
GROUP BY Client1.TableID, [Tables Event 1].Seats, [TablesEvent1 Extended].USeat, [Tables Event 1].Reserved;
In the forms the control source of the field Status is as follow: =DLookUp("[Status]","[TablesEvent1 Extended]","[TableID]=[Form]![ID]")
what I am missing here?
Jan 12 '11 #1
3 1543
Rabbit
12,516 Expert Mod 8TB
It's Forms!FormName!FormControlName
Jan 12 '11 #2
Thanks for your reply
I Changed the source control to =DLookUp("[Status]","[TablesEvent1 Extended]","[TableID]=Forms![TablesEvent1]!ID") and still having the same result.
please any other suggestion
Jan 12 '11 #3
Rabbit
12,516 Expert Mod 8TB
The query runs fine? And you're trying to DLookUp something from the query right?

What's the recordsource of the form?
Jan 12 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Mike Cocker | last post by:
Hello, I'm quite weak at PHP, so I was hoping to get some help understanding the below code. First off, I'm trying to create a "query form" that will allow me to display the results on my...
0
by: Jonas Gorauskas | last post by:
I am having this one problem on an app I am writing where it shows the following error on some error trapping that I did: Query failed: Error Number: 1064 Description: You have an error in...
3
by: Harvey | last post by:
Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says...
3
by: shreedhar | last post by:
If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be...
1
by: Dalan | last post by:
I'm experiencing a Query Syntax Error with an Access 97 Db. Actually, the query performs as expected when adding any new records or editing existing ones and even deleting records, EXCEPT when the...
1
by: Dman | last post by:
MS Access 2002 - query form control returns funny symbols like I am running an append query on a form. Access is having trouble with the calculated fields and comboboxes. Example – referring...
0
by: raf_z | last post by:
Hi, I think i'm doing something simple, although i may be wrong. I was able to load a Crystal report file up until today, and even now, its only 1 report that's misbehaving. I'll confess that i...
1
by: Able | last post by:
Dear friends My app load the startup form and all of its controls step by step and its indeed not nice. Do somebody know how to hide the form until the painting is finished? Regards Able
10
by: FNA access | last post by:
Hello to the world of the wise, I am a CSOM student at TRU. I am trying to design a database to improve my understanding. The problem I am having is with setting up a query. I have a Query...
1
by: Zvonko Bi¹kup | last post by:
Hi, I am trying to execute rather complex query, and I got query processor error. I read the Microsoft support page and it said I should install SP4, and I did, but the error is still there. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.