Table with only one record

G

Guest

Hi.
I have a table with only one record: [tbl_Definitions]. I use this record to
input and edit some definitions (such as company and logo name, VAT value,
etc.) that I want to use on other forms.
However I am facing some problems linking this table to others in which I
want to use that information.

For example, when I put the table [tbl_Definitions] in the query
[qry_Sellers], in which was based a form named [frm_Sellers], the form
appears blank, with no fields at all... and if I delete the table
[tbl_Definitions], from that query, the form works fine.

Can anyone tell me how should I solve this problem?

Thank you in advance.

Acores
 
G

Guest

Hi, Jeff.
Could you explain a little bit better what should I do?
Thank you again.
Acores

"Jeff Boyce" escreveu:
Post the SQL statement of your query.

Perhaps you are using an "equi-join" that requires matching records in all
tables?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

acores said:
Hi.
I have a table with only one record: [tbl_Definitions]. I use this record to
input and edit some definitions (such as company and logo name, VAT value,
etc.) that I want to use on other forms.
However I am facing some problems linking this table to others in which I
want to use that information.

For example, when I put the table [tbl_Definitions] in the query
[qry_Sellers], in which was based a form named [frm_Sellers], the form
appears blank, with no fields at all... and if I delete the table
[tbl_Definitions], from that query, the form works fine.

Can anyone tell me how should I solve this problem?

Thank you in advance.

Acores
Click to expand...
Click to expand...
 
L

Larry Linson

I thought he just _did_ explain what you should do: "Post the SQL statement
of your Query".

If you are using Access 2003 or earlier, open the Query in design view, then
the leftmost item in the toolbar (unless you've customized it) will have
"SQL" as one of its dropdown choices. When the SQL displays, copy and paste
it into your post.

If you're using Access 2007, the menus / toolbars have been replaced by "The
Ribbon" and someone else will have to give you details of getting SQL view.

Larry Linson
Microsoft Access MVP

acores said:
Hi, Jeff.
Could you explain a little bit better what should I do?
Thank you again.
Acores

"Jeff Boyce" escreveu:
Post the SQL statement of your query.

Perhaps you are using an "equi-join" that requires matching records in
all
tables?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

acores said:
Hi.
I have a table with only one record: [tbl_Definitions]. I use this
record to
input and edit some definitions (such as company and logo name, VAT
value,
etc.) that I want to use on other forms.
However I am facing some problems linking this table to others in which
I
want to use that information.

For example, when I put the table [tbl_Definitions] in the query
[qry_Sellers], in which was based a form named [frm_Sellers], the form
appears blank, with no fields at all... and if I delete the table
[tbl_Definitions], from that query, the form works fine.

Can anyone tell me how should I solve this problem?

Thank you in advance.

Acores
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why only one record showing? 1
Error on closing a form 4
Table update form a subform 3
Separate Form 0
Deleted then added record won't show in form 1
Add new records into source table on Form 8
Message box if no records 2
Filling in fields to a partially complete record in a table using a form 0

Top