by: !TG |
last post by:
I have a table with a date field.
All I want to do it get all the records with a date before today.
I tried the following:
"SELECT * FROM StateLicenses Where (Exp < #07/26/2005#) Order By...
|
by: Norbert Lieckfeldt |
last post by:
I am setting up a database for a friend who's an Optician,
using MS Access 2002. All seems to be working well, but I have hit a
snag.
There's a calculated field both in a form and a query which...
|
by: skinnybloke |
last post by:
Hi - can anybody point me to a tutorial that explains how to format a
date field within a SELECT statement.
I am trying to create a datafeed into another system.
The date field displays as ...
|
by: Mark Rae |
last post by:
Hi,
Suddenly (at least, I think so) when I rebuild a web deployment project in
VS.NET 2005, it strips off British pound signs e.g. £10 becomes 10.
Has anyone else seen this...? Is there a way...
|
by: sparks |
last post by:
I am trying to find valid records in a table
but I must compare a date field to a date stored in the table
I can see where this is wrong (ok I guess its not text)
"= """ & Me.date & """"
so...
|
by: Finn Stampe Mikkelsen |
last post by:
Hi
I have defined a table in my database, with 2 date-fields. I have set a
default value to DBNull. I have integrated a nullable datetimepicker control
to my project and set the apropriate...
|
by: Katherine |
last post by:
I'm trying to filter the records on the mainform (MailingList) of my
database using a field contained in a subform (Donations). I was
basing my code off Allen Browne's Access Tips page (here:...
|
by: sheri |
last post by:
I have a field called date, the date is in the field like this 70925
(which means Sept. 25, 2007).
I have another field called day, it is a text field. How do I write a
query to populate the day...
|
by: JFKJr |
last post by:
Hello everyone, this one might be simple but driving me crazy!
Your help will be greatly appreciated.
Basically, I created a textbox bound to "Date" field in an Access VBA form. But when the...
|
by: RobR2009 |
last post by:
I am having trouble with a C# proxy page I am writing which allows me to do cross domain AJAX calls with Javascript.
The problem is with certain pages that contain pound signs £ that are not HTML...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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,...
|