|
by: Patrick Gonzalez |
last post by:
Is it possible to use the built-in filter functions (ie. "Filter by
Selection", etc..) when a form's recordsource has been set to a
recordset object during the load event. When I try to do this, I
receive the message "Cannot apply filter on one or more fields
specified in the filter property".
here is the code for the recordset creation:
...
|
by: Steve Miles |
last post by:
I've got a form with a combo box and begin/end dates. When any of the
three are changed I set a subform's recordsource so the records
returned are filtered based on the three fields. The syntax I'm using
is:
Me.{subform-name}.Form.RecordSource = "Select * from tbl..."
....including the three fields in the SQL Where clause. This method...
|
by: Lauren Quantrell |
last post by:
I am using a stored procedure as the recordsource on an MS-Access2000
form:
Forms!frmName.RecordSource = "dbo.myStoredProcedure"
The stored procedure creates a temp table #Contacts and then inserts
matching KeyID values contacts into it. Then I use a union query in
the same stored procedure to create the actual recordset.
What I want to...
|
by: Sunil Korah |
last post by:
I am having some trouble with opening recordsets. I have used code
more or less straight from the access help. But still I am getting
some errors. I am unable to work out what exactly I am doing wrong.
I had posted this earlier along with another problem. I got answeres
for that, but not this one; so I am reposting, hoping someone would...
|
by: cefrancke |
last post by:
I have a form (no underlying record set) that has two separate
sub-forms on it.
Each sub-form has data from two different tables.
Above each sub-form there is one unbound combo box with a SQL record
source that returns an ID field and a Text field.
Next to each combo box is two buttons, one that 'Applys' the filter of
the sub-form to the...
|
|
by: Alan |
last post by:
I'm having brain fade today...
Can the recordsource in a Form's properties do more than one select
statement based on criteria?
On a popup subform I'm trying to display matching records from a table if
MarketPlaceID on the parent form (frmCustomerOrders) matches MarketPlaceID
from this table (tempOrders). If there are no matches I want it...
|
by: Alan |
last post by:
With earlier help from this group (thanks Ben!) I've ended up with this
OnLoad code for my popup form:
Private Sub Form_Load()
If IsNull(!!) = True Then
Me.RecordSource = "SELECT .* FROM WHERE
!OrderID = Null"
Else
Me.RecordSource = "SELECT .* FROM WHERE
!=!!"
|
by: abolos |
last post by:
Hi,
I have an unbounded form with an unbounded text box. In the event On Open I have this code: Form.RecordSource"select last(kmprice) from tblmilageprice".
The question is: How can I fill the text box with the result of thid code?
Thanks,
Abolos
|
by: fastPace |
last post by:
I created an SQL statement, left joining three tables. When I use the statement as the recordsource for my form in datasheetview, I cannot input data into any of the fields. Can anyone help me with this?
Here is my SQL statement:
strSQL = " SELECT tblAccounts.sNumber, tblAccounts.sName, tblAccounts.sType, tblUnAdj.sngUnAdjDR,...
|
by: franc sutherland |
last post by:
Hello,
I am using Access 2003. I have a query which shows a list of club
meetings sorted by date. This query is displayed in continuous forms,
in a subform. I would like to select a month on the main form which
is then used to filter the results for the meeting dates, perhaps by
using monthname(month()).
I have struggled to find the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|