|
by: Lee Falataco |
last post by:
I have the tables set up in Access, viewing in column format on ASP
pages but now the company wants the schedule reports to be in a
wall-calendar type format. I've searched and found calendar scripts
but I need one that's creates a table resizable to a report size
format. Using the existing MS Access db I've written is also a plus.
Any...
|
by: ezelasky |
last post by:
We are using the bcp utility (via APIs) to export data from a SQL table
in a fixed format text file. BCP is inserting spaces for a field if
the field contains a NULL. This is fine with us except at the end of
the line, there are no spaces for that field just the end-of-row
terminator prematurely, so it looks like that field is not present...
|
by: bwhite |
last post by:
I have a temp table with one row of data that I need to export into
Excel. I created the export to create the xls file as follows ...
Dim FileName
FileName = !!
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_delete FCL"
DoCmd.OpenQuery "qry_temp FCL"
|
by: surya |
last post by:
hello all
i want to create a phone table and it contains two fields empid ,ph.
the phone table following format:
Phone table
------------------------------------------
empid ph
----- ---------------------------------
office Mobile home
--------- -------- --------
|
by: AA Arens |
last post by:
I placed a radio button combination with label text: Mr or Mrs.
I the table it then adds 1 or 2 depending what I choosed.
How to have the values Mr / Mrs added in the table insterad of 1 and 2?
In the table properties I added "Mr";"Mrs" under Row source but that
won't help.
Row source type: Value List
The display control is Combo Box
|
|
by: thewilldog |
last post by:
Hello, I've reviewed the archives here to address the issue, but I'm still running into problems. I've got a table field populated with the record date in text "YYYYMMDD"
To convert it into a recognizable date format, I've done the following:
Query 1: References Source Table; Isolates Year, Day; creates MMDD field
Acc Open Year: Left(,4)...
|
by: ARC |
last post by:
Hello all,
General question for back-end database that has numerous date fields where
the database will be used in regions that put the month first, and regions
that do not.
Should I save a date format in the table design, such as: mm/dd/yyyy?
What I've done for years is to store the date format in date fields, then on
the forms, based...
|
by: sshafer1 |
last post by:
Hi.
I have a query that I would like to run periodically to drop the data in an existing table and re-write the table with the query information.
However, when I do this, some of my field formatting for calculated query fields are dropped.
For example. In the query, the FIELD1= $4,500 but when the make table query is run, the FIELD1 =...
|
by: yogarajan |
last post by:
hello friend
this is my code
TableCell c1td1 = new TableCell();
DateTime dbdate = Convert.ToDateTime(dr);
string strhr = dbdate.ToString("h:mm tt");
c1td1.Text =" "+ strhr;
|
by: balucec |
last post by:
i need to list the contents of a very huge table. now i use the query SELECT * to do it. but the result is not understandable. rows are overlapped in the result.
kindly provide a solution for doing this. is there any other way rather than using SELECT *??
NB: I want the whole table to be displayed using a single qery. and not like using...
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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...
|
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: 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...
|
|
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.
|