|
by: moses40 |
last post by:
I need help importing an excel spreadsheet into an existing access table using vba. However I have a few requirements.
1. It needs to prompt the user to specify where the spreadsheet is
2. It needs to import into an existing table.
|
by: Wayne |
last post by:
In an attempt to get around the extremely painful "reinstall" routine
that takes place when using Access 2007 on machines that have earlier
versions installed, I have tried the free "Altiris Software
Virtualization Solution" software.
Whilst not a perfect solution, it does offer some improvement over the
situation we have been left with by Microsoft when trying to run
multiple versions that include Access 2007. When Access 2007 is...
|
by: elias.farah |
last post by:
Hello Everyone,
I'm having some very weird behavior on a couple of Access forms. (Not
all forms, just some of them).
The forms have been working for years, under Access XP/2003 etc, and
last week upgraded from Windows XP/Office 2003 to Vista x64/Office
2007.
Under Access 2007, a couple of forms are now taking 60 seconds to
|
by: Suzanne801 |
last post by:
Hi,
I am new to VB and trying to get Excel output from Access 2007-Report
using:
DoCmd.OutputTo acOutputReport, rptName, acFormatXLSX, OFileName, True
I keep on getting:
Run-time error '2282':
The format in which you are attempting to output the current object is not avaialabe.
|
by: masonic35and7 |
last post by:
I work for a school district, and I have just imported 6 Excel
worksheets into Access 2007. Now I have 6 different tables. In each
table all the fields are the same. I need the easiest way to merge
all the tables into one huge table. There are at least 2,500 records
per table if that makes a difference.
I am unfamilar with writing any type of code, so please don't suggest
that unless you can also tell me how to do that.
Thanks
|
|
by: mguy27 |
last post by:
We have about 2 dozen security officers who patrol about 120 buildings. They find defective or unlocked doors and write a "Trouble Report" on the door. This card gets turned in, where I have designed an Access Field and Table to enter the information and store it. They then get emailed to their respective supervisors so the problems can be dealt with.
As of right now, we have a big list on the wall of the buildings and their supervisors....
|
by: Peter |
last post by:
Hi,
i've got an older Access program, which is written in the version 2000
and i'd like to use it with my new office 2007, so access 2007.
In the program, there is an replication written with the Jet Replica
Library, and i read on a microsoft site, that replications in jet
schould still work in access 2007, if you still use the old
extension .mdb
|
by: ARC |
last post by:
I think I made a major blunder, and now Access 2007 no longer opens. I made
the mistake yesterday of using the "test" option in wise installer for my
Access 2007 runtime app. It actually installed the Access 2007 Runtime SP-1
(I did have full office 2007 SP-1, however).
I didn't notice a problem until I had to use Access 97. Once I re-opened
Access 2007, I got the usual message about the Installer (as it tries to
repair every time you...
|
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 an issue in Access/Excel 2007. Any hope?
Long story:
I have several databases with 400+ queries that I export into a folder as Excel files (with VBA). I then have some Excel macros that run through all the exported files and format them into...
|
by: Ulf Malmros |
last post by:
Hi
I have an application that is developed in ACCESS 2007 but runs in the ACCESS 2007 shell (Access 2007 runtime).
When I run it in the development environment it runs without any errors but when it runs under the production environment it returns error 3709.
I have tried this with several databases but with the same result.
|
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: 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: 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: 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: 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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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.
|