| |
by: John Bentley |
last post by:
John Bentley:
INTRO
The phrase "decimal number" within a programming context is ambiguous. It could
refer to the decimal datatype or the related but separate concept of a generic
decimal number. "Decimal Number" sometimes serves to distinguish Base 10
numbers, eg "15", from Base 2 numbers, Eg "1111". At other times "Decimal
Number" serves to differentiate a number from an integer. For the rest of this
post I shall only use either...
|
by: Gary Wright |
last post by:
I have an Access 2K database split into front and back. Quite often the
users want to do some data analysis that I have not created a report for so
they want to export some subset of the data into and Excel spreadsheet.
Since the data often comes from many different tables, I have decided to
create a temporary Access table, put all the data into it then use the
Docmd.TransferSpreadsheet command to output the table to a spreadsheet.
In...
|
by: Jean |
last post by:
Hello everyone,
I was wondering if anybody could help with some Excel automation.
I have a form in Access, which exports the contents of a recordset to
Excel in the following manner:
objWS.Range("A2").CopyFromRecordset rstData, 1000
gobjExcel.Range("A1").Select
|
by: DavidGeorge |
last post by:
I have made a fundamental error in design and ignored security until
the end of the project. This is largely because the whole process was
a steep learning curve (helped enormously by this group) and I didn't
know when I started (and still don't really understand), how to
implement security.
I have an application in two parts:
- the first part is used by a number of people on standalone laptops
who collect information about patients. ...
|
by: David Nunn |
last post by:
Need to preface that I am not much of an Access type. Doing
I have several tables that have currency fields, which I run queries
against to compare the figures in both. The data is imported from
Excel spreadsheets supplied by different parties, over which I have no
control.
My problem is that whilst several parties supply the spreadsheets with
the currency fields containing two figures to the right of the decimal
place (ie 123.51,...
|
| |
by: paulquinlan100 |
last post by:
Hi
I have a couple of calculated fields in a report, i've set the Decimal
Places property to 0 and the format to General Number, however when
previewing the report it still comes up with a number with up to 8
decimal places!
Any suggestions how to overcome this problem gratefully received!
Paul
|
by: nofear |
last post by:
I used to export my reports as snapshot but now I have to export them
to Excel
When I export my report to a Excel Spreadsheet the report header and
footer are not included
Only the data gets exported.
How do I format a Access report for Excel the right way?
|
by: jpena26 |
last post by:
I have seven queries that I want to output totals into one excel spreadsheet. The queries have different criteria so cannot be combined. All queries outcomes have the same three basic titles (for example, Number of items, $ Amount of items, and $ Amount Commission).
I created a report to show all queries using subreports and my outcome looks just how I want it. When I exported the report to excel, it changed the format, yet when I...
|
by: brent78 |
last post by:
I'm trying to export an access report to excel and have run into a problem. One of my fields is a text field and when it is exported to excel some of the data values show up correctly and some are given by a serial number (date format). Here is my data
067-02
067-01
196-00
196-00 appears correctly but 067-02 and 067-01 are converted to a serial date number. Is there any way to prevent this from happening?
Another report generated...
|
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: 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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
|
66
