Hi
Given a form with a date formated text box on it, which will serve as an
input box for dates, how can I write a VBA sentence in order to apply a
filter with that input?
Suppose text box is "TEXT13" and the table field is "Data of birth".
When I run a code like this
DoCmd.ApplyFilt er , "[date of birth] = " & "#" &
Me.[Text13] & "#"
I get no trustful results.
Thank you.
A_Rodrigues 3 9484
"A_Rodrigue s" <am************ *@netvisao.pt> wrote in
news:ne******** ************@ne wsfront4.netvis ao.pt: Hi Given a form with a date formated text box on it, which will serve as an input box for dates, how can I write a VBA sentence in order to apply a filter with that input?
Suppose text box is "TEXT13" and the table field is "Data of birth".
When I run a code like this DoCmd.ApplyFilt er , "[date of birth] = " & "#" & Me.[Text13] & "#" I get no trustful results.
Thank you. A_Rodrigues
I much prefer to set the form's .filter and .FilterOn properties in
code.
me.filter = "[date of birth] = #" & Me.[Text13] & "#"
me.filteron = true
Hi
Unfortunatly, it works fine but for one particular date (February 1st 2002).
Does someone have any idea?
Thank you.
A_Rodrigues
"Bob Quintal" <bq******@gener ation.net> wrote in message
news:a0******** *************** *******@news.te ranews.com... "A_Rodrigue s" <am************ *@netvisao.pt> wrote in news:ne******** ************@ne wsfront4.netvis ao.pt:
Hi Given a form with a date formated text box on it, which will serve as an input box for dates, how can I write a VBA sentence in order to apply a filter with that input?
Suppose text box is "TEXT13" and the table field is "Data of birth".
When I run a code like this DoCmd.ApplyFilt er , "[date of birth] = " & "#" & Me.[Text13] & "#" I get no trustfull results.
Thank you. A_Rodrigues I much prefer to set the form's .filter and .FilterOn properties in code.
me.filter = "[date of birth] = #" & Me.[Text13] & "#" me.filteron = true
What are you actually putting in the text box? To use # delimiters like
that, it must be in mm/dd/yyyy format, or some unambiguous format.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(No private e-mails, please)
"A_Rodrigue s" <am************ *@netvisao.pt> wrote in message
news:ne******** ************@ne wsfront4.netvis ao.pt... Hi Unfortunatly, it works fine but for one particular date (February 1st
2002). Does someone have any idea? Thank you. A_Rodrigues
"Bob Quintal" <bq******@gener ation.net> wrote in message news:a0******** *************** *******@news.te ranews.com... "A_Rodrigue s" <am************ *@netvisao.pt> wrote in news:ne******** ************@ne wsfront4.netvis ao.pt:
Hi Given a form with a date formated text box on it, which will serve as an input box for dates, how can I write a VBA sentence in order to apply a filter with that input?
Suppose text box is "TEXT13" and the table field is "Data of birth".
When I run a code like this DoCmd.ApplyFilt er , "[date of birth] = " & "#" & Me.[Text13] & "#" I get no trustfull results.
Thank you. A_Rodrigues I much prefer to set the form's .filter and .FilterOn properties in code.
me.filter = "[date of birth] = #" & Me.[Text13] & "#" me.filteron = true
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: panche |
last post by:
I'm developing a fairly simple user control that has two textboxes for
date/time entry (a from date/time and a to date/time). One of my
requirements is that there should be no button that sets these values (i.e.,
no button to cause a postback). The problem I'm having is that I need a
number of validations to be performed on the data entry, but I don't know
how to do this without having the user control/page posted back to the
server. ...
|
by: |
last post by:
Hello,
Does anyone have an idea on how I can filter the data in the gridview
control that was returned by an sql query?
I have a gridview that works fine when I populate it with data. Now I want
to look at that data and filter it based on what is in it.
I know that this could have been done with data sets and data views in
asp.net 1.1 but how is this done now in asp.net 2.0?
|
by: Jimmy |
last post by:
Hi!
I'm looking for a library with methods for filtering user input in a
web application. I mean, some API which gives more functionality than
the traditional .NET validation controls.
Any ideas?
Thanks a lot in advance!
J.
|
by: joesin |
last post by:
I recently found a vulnerability on my website that allowed sql
injection. I have been trying to write some code that would clean user
data but have been running into problems. The validation still works,
however so does the injection methods I have used....
These are the examples of code I have tried to use to fix the problem.
1. FrmUserName=replace (FrmUserName, " ' ", "")
2. function stripQuotes(FrmUserName)
stripQuotes =...
|
by: Jonathan Wood |
last post by:
I'm new to C# and ASP.NET, and wondered if anyone could give me some
pointers on this.
I want a serious of boxes on the left side of my master page. Each box will
display a graphic image followed by any number of links. Each box needs to
correspond to a category in a database. So the number of boxes is not known
in advance.
In addition, the links displayed in each box will be the items in that
category. So the number of links is not...
| |
by: Brave |
last post by:
I'm hoping someone can help me with a small issue.
I have an asp page that displays informaton from an Access database.
I want to create a form that allows users to display only data that
matches their search criteria.
I have made many forms like this in Front Page with the Database
results wizard, but I want to manually code it.
Here is the code I use to display the data from a database.
|
by: parshupooja |
last post by:
Hi,
I am working in Asp.Net 2.0, SQL Server, C#.
I am trying to create a User Input form which has lots of fields such as :
salutation;
Firstname:
lastname:
address:
Zip:
Phone:
|
by: TheSteph |
last post by:
Hi !
I have a DataGridView with a Date (DateTime) Column.
When a user edit the cell and change the date I woulk like to allow him to
write "081501" and programmatically transform the entered date to
"2008/15/01"( using a custom method called TransformDate(string ARawDate))
But I can't find any DataGridView event to call the TransformDate method and
replace the user input by the computed value. I always get a "DataError".
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |