473,378 Members | 1,400 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,378 software developers and data experts.

set recordsource to query ==>> error 2467

Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"

the problem is after typing sub75. I get a list of possilities, but
after form. I don't.. I know nothing about access, so can anybody help
me?

Greetzzz
Nov 12 '05 #1
3 5546
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
Nothing obviously wrong with that - but error 2467 would suggest that
Form_patient is either closed or doesn't exist. Where have you placed this
code?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour
Fletcher
Nov 12 '05 #2
"Fletcher Arnold" <fl****@home.com> wrote in message news:<bl**********@hercules.btinternet.com>...
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
Nothing obviously wrong with that - but error 2467 would suggest that
Form_patient is either closed or doesn't exist. Where have you placed this
code?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour


I tried it in 2 ways:
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
in another module
and Form_patient!sub75.form.recordsource="MyQueryName"
in another form.
But if Form_patient would not exist, Forms!Form_patient!sub75.
wouldn't give a list, or am I wrong. Either way, the form isn't
closed, it's just not the active form, it is underneath another one. Fletcher

Nov 12 '05 #3
an**************@hotmail.com (Annelies) wrote in message news:<c7**************************@posting.google. com>...
"Fletcher Arnold" <fl****@home.com> wrote in message news:<bl**********@hercules.btinternet.com>...
See inline comments:

"Annelies" <an**************@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...
Hi,
I want to set the recordsource of a subform to a query with this
syntax :
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"


Nothing obviously wrong with that - but error 2467 would suggest that
Form_patient is either closed or doesn't exist. Where have you placed this
code?
the problem is after typing sub75. I get a list of possilities, but
after form.


This is standard behaviour


I tried it in 2 ways:
Forms!Form_patient!sub75.form.recordsource="MyQuer yName"
in another module
and Form_patient!sub75.form.recordsource="MyQueryName"
in another form.
But if Form_patient would not exist, Forms!Form_patient!sub75.
wouldn't give a list, or am I wrong. Either way, the form isn't
closed, it's just not the active form, it is underneath another one.
Fletcher


I partially solved the problem myself.. I had to set the subform's
source to a random query so it had a recordsource..
Now I have error 2455...
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Stijn Goris | last post by:
I get an error when trying to insert a new row: query error- 5 - Duplicate entry '80.200.213.102 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Avant Browser ; MyIE2; .NET CLR 1.0.' for key 1...
2
by: Jim Hatfield | last post by:
I'm using: "select min(objid) from table_name where objid > $objid" to select the next row in a sequence where there may be gaps. It works fine unless the where clause results in an empty set. ...
5
by: ColinWard | last post by:
Hi. I have a contacts form with an unbound dropdown box and a bunch of bound controls relating to the contact. When I load the form, I want all the controls to be empty until I select a name from...
1
by: Dalan | last post by:
I can't seem to find a workaround of Query Syntax Error. Actually, the query performs just fine, except when the last record on a related subform is deleted, then it generates a Runtime Error 3075...
2
by: Glenn Davy | last post by:
Hi all I'm using access 2003 against sqlserver 2000sp3 and I need to export a 'query' to a csv file. The problem I'm having is getting TransferText to see the query. I've tried views, stored...
2
by: Jean | last post by:
Hello everyone, I was having the following problem with a query, and after failing to find a similar solution on these newsgroups I decided to post here. I am quite new to Access, so would...
3
by: jallegue | last post by:
I am working with MS-Access 2002. The two tables that I am working with are: dbo_IDX_FRS_account_bal_by_month ==> this is a linked table to SQL == local table The query that is executed is...
4
by: franc sutherland | last post by:
Hello, I am using Access 2003. I am having trouble trapping the "can't append all the records in the append query" error message when appending data to a query from a table which is linked to...
7
by: kbbauman | last post by:
Hi, I was wondering if anyone could possibly help me wih this issue. I have an access database. In this database I have a massive table that I have created a query off of in order to be able to...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.