by: highway of diamonds |
last post by:
I have a form based on a query. I would like to generate a msgbox and
close the form should the query return no records.
TIA
R.
PS I would even be happy to lose the form and just do the...
|
by: BerkshireGuy |
last post by:
We have a table with the data looking like this: (only going to include
2 fields here)
Each row is a record
PolicyNumber AppStatus
---------------- ----------------
Z9999999 ...
|
by: NewUser |
last post by:
I try this:
A first "group" query (sorry if this isn't the right name) count the records
from a table with a criteria (field1="A") and return counter1=10 records.
A second "group" query count the...
|
by: scottmachado |
last post by:
I am currently running a marco that run a query and emails the results
as an attachment in excel format. If the query has no records, I would
like to email "no records found" in the first cell in...
|
by: Alex Chun |
last post by:
How can I make a Query that combines tables, so that if table1 has records
"apples", "pears" and table2 has records "apples", "cherries", the query
result will be "apples", "pears", "cherries"?
...
|
by: ryanvmcgee |
last post by:
Hello,
I am fairly new at doing advanced databases outside of excel.
I am trying to combine records in a database I will be using, none of the, CONCAT Queries or scripts I have found seem to...
|
by: jeevalokesh |
last post by:
hi
i had created two table
1. Enquiry table
ENQUIRY_ID (PK)
ENQUIRY_NAME
GENDER
ENQUIRY_DATE
QUALIFICATION
|
by: padmaneha |
last post by:
I executed the below query for getting the details of dishes which are tagged to the festival 'Durga Pooja'
select fg.tagname, fg.foodid, f.dishes, f.dishtype
from foodtag fg inner join food f ...
|
by: newnewbie |
last post by:
Hi,
Short version: trying to export more than 65K of data from Access 2007 into Excel 2007 (important) through VBA. Access gives me 65K row limitation error, though I thought that was no longer...
|
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: 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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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: 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...
|
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,...
|