Tag Info

New answers tagged

0

It's too easy. STEP 1 -- make an import of the data using the standard Access "Import XML" option. Structure only. STEP 2 -- Go to each table and add a field that will take the missing key. STEP 3 -- Use VBA. Add the Microsoft XML, v6.0 library. Even this spare bit of code tells me it will be simple to write the key to each table as needed. Dim ...


0

You can use a VBA script to separate the document into individual files. There are also various PDF print drivers such as PDF Creator that can either print individual PDF files automatically, or split them into individual files after they are printed to one giant file.


0

I don't know for MS Access in particular but a generic version of the query might be alter table <table_name> add <column_name> varchar2(30) update <table_name> set <column_name> = case when <interest_rate> >= 7.5 then 'HIGH PRIORITY' else 'LOW PRIORITY'


2

The answer was Privacy Options, not "Options". It's critical that people answer questions accurately...though it would certainly help if corporations like Microsoft didn't keep redesigning the GUI of their software every two years purely for the sake of change. Go to File / Privacy Options. Click on Current Database on the left panel menu. Scroll down to ...


0

The menu does not hide for any other accdb files, just this one in particular. Check the file extension of the troublesome database file. If the file extension is .accdr then Access will open it with the same settings as the Microsoft Access Runtime. To restore the normal Access menus for this file simply rename it to have the .accdb extension.


1

There's no single magical command without using SQL. The easier way to do it is per this Microsoft KB article: How to reset an AutoNumber field value in Access


1

Firstly I think you could simplify a lot of the code in your macro by using Mail merge from the Access database instead and just instigating that via macro. The field code for your IF field as it appears here should work. Make sure that you have surrounded the code with special field brackets by clicking CTRL + F9 and not just regular brackets.


1

Since this is just a ACCDB not an encrypted ACCDE, you should be able to customize your ribbon to bring up the External Tools ribbon as part of the Main Tab: Go to File, Options, Customize Ribbon Navigate to External Data Click Add to have it show on the right side If you correctly added External Data to the right side, it should appear as a ribbon ...


1

You can do it like this with DAO in VB: Public Sub ListTablesDAO() Dim db As DAO.Database Dim tdf As DAO.TableDef Set db = CurrentDb For Each tdf In db.TableDefs If (tdf.Attributes And dbSystemObject) = 0 Then Debug.Print tdf.Name End If Next tdf db.Close: Set db = Nothing End Sub and like this with ADO ...


1

You can run the SQL you have in a query, because that is what it is. Create a new query in query design, not with the wizard. Close the table window. Change the view to SQL and enter your string. Click RUN.


1

A database must exist FIRST in order to accept the exported table. The export function does not create a database file (as you found out). Create the database you want the data to go to, when you click Export then Access, choose Browse... to select the database when exporting.


2

A somewhat indirect answer, more of a work-around. I created a new blank database. Right-click on the empty table and choose import. Find the accdb database file that contains the table. When you finish it gave me a list of tables that I could import. Select the table to be imported. Close the new/empty table to delete it. Save and link it to the front end ...


1

Source Introduction to importing and exporting data This article shows you what kinds of data you can import and export by using Access, and shows you the basic steps to get started with an import or export operation. ... Types of data that Access can import, link to, or export A quick way to learn about the data formats that Access can import ...



Top 50 recent answers are included