xml exports misses recent data
Thu, 17 Jul 2008 16:19:11 +1000
Hi,
After loosing all my hair I can't figure this out.
When I export a report to xml with access 2007 it keeps missing my most
recent records - anything after about 2 months ago wont show up.
The thing is that it works fine if i export in any other format and I can
see the records in the report on the screen ...
|
importing to a web site's Access DB
Wed, 16 Jul 2008 18:56:05 -0700
Is there a way that I can import new records (from an uploaded file) into
Access (DB) without taking the DB off-line? This DB is on a web server and
suppling data for an ASP web site. Currently I have to bring the DB
locally (bringing it off-line as well as the web site) open the database and
import the ...
|
Save As Pop-Up (API or Procedure?)
Wed, 16 Jul 2008 16:19:03 -0700
My form uses a query the user can view on the screen, Print to a report, or
save as an Excel file. I woud like a "Pop-Up" window to come up just like
the "File", "Save As" option on any windows program to allow the user to
browse to where they would like to put the file, type in a name, and click
the "Save" ...
|
Linked Sybase tables & "Distinct" keyword
Wed, 16 Jul 2008 13:41:03 -0700 (PDT)
I'm hoping that someone can figure our WHY this is happening:
I have an Access 2003 application that uses Linked Sybase tables.
When I create a query like this:
SELECT Tta.TTA_IFMS_ID, Tta.INTRIGHTCOM, Tta.INTFMVCOM,
Tracts.TRACTS_IFMS_ID
FROM Tta INNER JOIN Tracts ON Tta.TRACTS_IFMS_ID =
Tracts.TRACTS_IFMS_ ...
|
Capturing html source as txt file
Wed, 16 Jul 2008 11:05:01 -0700
I am using the ActiveX "Web Browser Control" in a form.
I can navigate to a URL in the forms VB module with:
Me.WebBrowser0.Navigate "www.mysite.com"
Once the URL is loaded, in VB I want to do the equivilent of View/Source and
then SaveAs to text file.
Is this possible?
Thank you!
Tok ...
|
Imported database does not show when compose new email?
Wed, 16 Jul 2008 09:50:00 -0700
I imported all my contacts from excel format successfully into Microsoft
Outlook 2003. However, when I compose a new email they do show up in contacts
or address book. The only contacts that list when I click on "TO" to
retrieve a contact email address are those that I have manually added? When
I click out ...
|
Import Multiple CSVs with a twist
Wed, 16 Jul 2008 08:50:01 -0700
I am trying to import multiple CSV files from a folder.
Each CSV file have all the same structure whereby there is redundant data
that I don't need in rows 1 through 21, Except I need a number that is always
stored in a cell lying on Row 8 and Column 2.
Then the rest of the data I need. Row 22 is all head ...
|
|
|
attach a .jpg then merge w/word showing pict not file name
Tue, 15 Jul 2008 23:59:46 -0700
I have attached a .jpg to a file in Access 2007, but now I need to merge it
with a Word file. The merge only gives the name of the attachment and not
the actual picture. I am trying to create a pictorial directory. ...
|
error 3709
Tue, 15 Jul 2008 20:37:10 -0700
I am trying to import DBF files into an Access 2002-2003 db and I get this
error message when importing certain files. The dialog box reads that
"Search key was not found in any record." What does this mean? ...
|
Link a table from web page?
Tue, 15 Jul 2008 12:33:52 +0200
Hello,
in Excel 2007 I can get the data or a table from web page with the help of a
wizard (Data/Get External Data/From Web). And I can later even refresh the
worksheet data with the original data.
I would like to have a similar situation/procedure in Access 2007. How can I
link to a table on web page fr ...
|
