|
by: Carl |
last post by:
Please can anyone tell me how I can create a macro to save the results
of a query as an excel file? The query is called Student List and I
would like to save it to "My Documents".
We have had some problems with our database crashing. We would
therefore like another way to have access to basic student data and
thought we automatically save the results of this query when we close
Access.
Any suggestions on how we could do this would be...
|
by: GERALD SHAW |
last post by:
ACC97...
I have a database which is connected to an excel spread sheet using MS
query..
Using Access, I am used to setting up within a queries criteria, the
following
is Null Or this allows me the option to either pick
|
by: campwes |
last post by:
Hey, all! We're having trouble displaying SQL Server data in a web site as
XML, using a transform. The query is a simple SELECT statement. When
running the query, we get the following error from the web site:
<error>
Microsoft.Data.SqlXml.Common.ISQLXMLCommandManagedInterface.ExecuteToOutputStream() +0
Microsoft.Data.SqlXml.SqlXmlCommand.innerExecute(Stream strm) +137
|
by: Jim Davidson |
last post by:
i am running a small vb / vba macro imbeded in a report to
update an oracle database -- at times (%70) i get the
error above when connecting to an oracle data sourse to
update a table.
I am using the microsoft ODBC for oracle driver
can anyone help with this intermitant problem, as it is
completly stumping me
|
by: kscheu via AccessMonster.com |
last post by:
I am using OutputTo to export a query to excel, prompt the user to save as
and then open the excel file. See below:
DoCmd.OutputTo acOutputQuery, "q701ExportFields", acFormatXLS, , True 'Opend
Excel Automatically
Now I want to add a row to the opened spreadsheet at the top and add a title.
How do I accomplish this? I am new to excel formatting, but I created a
macro and the code to do this is:
Rows("1:1").Select
Selection.Insert...
|
|
by: austin1539 |
last post by:
I am trying to run an Access query from Excel. The query, called "ProdActs1" works in Access and is run from using information from a table called "Queries". When a button is clicked in Excel, data currently in the table is deleted and new data is sent based on cell value on the Excel worksheet. So far, I can delete the old records and add new data. I just cannot seem to return results from the query "ProdActs1". Also, is it possible to specify...
|
by: Remaniak |
last post by:
Hi All,
I use the code below in my form to filter data.
But I also need to export the data to excel. So I'd like to create a temporary query based on the strWhere and export that query to excel.
Could anyone modify the code for me?
cheers
Michiel
|
by: CoolFactor |
last post by:
MY CODE IS NEAR THE BOTTOM
I want to export this Access query into Excel using a command button on an Access form in the following way I describe below.
Below you will find the simple query I am trying to export to Excel using a command in an Access Form.
RowID strFY AccountID CostElementWBS
1 2008 1 7
2 2008 1 7
I want to...
|
by: pkj7461 |
last post by:
Hi,
I was using Docmd.Transferspreadsheet to to populate query data in Excel.
My code so far
Dim xlApp As Excel.Application
Dim xlWb As Excel.workbook
Dim xlWs As Excel.Worksheet
Set x1App = New Excel.Application
xlApp.Visible = True
Set xlWb = xlApp.Workbooks.Open("C:\Daily Open Report Template.xls")
|
by: lindabaldwin |
last post by:
Hello everyone,
I am fairly new to VBA. I have a worksheet in Excel, named "Data Sheet" from which I am trying to query data. This worksheet contains the following data: unit (column A), date (column B), time range (column C), day of the week (column D), event (column E), and occurrences (column F). I want to be able to identify records that meet user set criteria. I then want to add the number in column F to another number in a different...
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|