Hi.
I have been running an access Database in Office 2003 for a while now. When I upgraded to Office 2007 one of my macro buttons has stopped working.
The Button looks up to VBA code to Import a specific Excel spread sheet from a specific location on my hard drive. This file is updated but never re-named or moved so to save time I have created the import macro to do the import steps for me.
This has been...
DAF LAD
Last Activity: Nov 19 '08, 02:32 PM
Joined: Oct 8 '06
Location: England, UK
-
VBA code to Import in Access 2007
-
the code that I have been using is as follows:
Private Sub Import_PBs_Clic k()
DoCmd.TransferS preadsheet acImport, 0, _
"z new pbs", "....\new pbscrs\newpbs.x ls", True
End Sub
where "z new pbs" is the table in access
Thanks again
Diego -
Importing Excel into Access 2007
Hi all,
I have been running a database in Access 2003 for may years now.
One of the update functions that I do imports an excel spreadsheet into a table in my database. I have this automatically working from a command button through vb code.
Recently I have upgraded my office suite to the 2007 edition. Now when I try to run this command from this button I get an error code saying that something is missing... -
thanks, works perfectlyLeave a comment:
-
Filtering a form from another form
Hi all,
I currently have a database that has a form for input, I have created another form that looks identical to this one looking at the same data in the same tables however only one thing is selectable/changeable as this is a "review form"
I would like to create a form for users to use to select a date from a list that then (by pressing a command button) takes the seltected date and filters the review form... -
Interactive Parameters
Hi All,
I have a dtatbase that stores alot of data. I have a query that brings back all the data that i need for the reports I need to produce. These reports that I produce are organised by date. I currently have a parameter set up so that when the report is run the default message box appears asking you to enter the date for the report. This will then bring back only the results that refer to that date.
However if you... -
Changing all data in a field
Can anyone help me with this.
I have recently taken over as a Membership Secretary of a local sports club. I have a current database that is very old and needs alot of work. Instead of trying to develop the current database I am re buildin it from scratch.
With membership running yearly, once a year i need to change all of the members status.
I have a field in a table that refers to a persons membership... -
Reports to web pages
Hi,
A little help needed when printing a report to a web page file to be uploaded onto a website.
For a number of years now I have used an MS Access database to produse reports and save them on my computer as RTF files. These were then uploaded on to a website that I own for people to acess. Recently I have been asked to change the format so that they are totally web based (HTM/HTML files not RTF) so that the files do...
No activity results to display
Leave a comment: