Modules & VBA :: Get External Data Dialog
Feb 8, 2014
I am asking my users to interact with the Get External Data dialog, and I'm trying to restrict what they can do.
Code:
DoCmd.RunCommand acCmdImportAttachText
I really like the mapping feature Access uses so I want to use that part of the Wizard, but I don't want my users to import data to the wrong table.Can I skip the first page of the 'Get External Data' Dialog series? Invoke the 'Import Text Wizard' without the previous dialog?see: AWF2. I can get the file path from a File Picker dialog.
Can I set the combobox to a default selection?
View Replies
ADVERTISEMENT
Oct 20, 2014
I have an Excel file with a name range "DBIAS" which identifies all database data.
Then I have an Access file with a form to import that database (better, that named range) into an Access table. While importing, I have to filter some records or grouping by some field.
I cannot run correctly a VBA code to get data (filtered and/or grouped) from that name range and save those records to an existing or a brand new table.
I could get those data as DAO.recordset and printed out with "Debug.print" on immediate window, but I cannot complete the final step: writing those records to a table.
View 3 Replies
View Related
Mar 11, 2005
Hi everyone,
I have a client I'm currently working for that has dumped Access on me. I'm not originally here for Access and am sort of learning as I go along (I'm here to setup, run, and maintain servers, etc.)
The problem is they have a large contact database in Access, and want the forms to pop up a dialog asking if data changes are okay before actually updating. I know that Access normally just does the change, but there is an issue with someone that doesn't understand computers at all making a mess of it (adding in one client 15 times, each with one different piece of information, erasing things in an attempt to search, etc, etc.)
I've been going all over the place trying to research the issue for hours and have had no luck finding a solution. Any help would be beyond appreciated. Thanks in advance for any help!
-Walter
View 8 Replies
View Related
Jul 28, 2015
Users of the db I am working on print using a regular network printer 95% of the time. 5% of the time however, they need to change that printer to another one, or to a PDF printing program. All of the printers they need are installed in their Printers folder.I can think of two possible courses of action here:
1. load the printer dialog box (preferred)
2. provide them with a custom interface to select a temporary printer
I don't want them to have to load the printers folder and switch the printer temporarily.how to load the printer dialog.
View 4 Replies
View Related
Jun 7, 2005
I have a program that uses Access 97 as a backbone. When I open Access to get external data my only options are
Microsoft Access
and ODBC Databases.
I have never hade to add or config odbc opjects in the past.
Any help??
Thanks in advance
View 2 Replies
View Related
Jun 5, 2006
I have 2 tables both which I need to import data into. I have 2 xls spreadsheets per day and I need to import all the data and build it up over a period of time so that I can use the database to analyse the data. There are around 2000 records per file but I can't seem to import the data unless I select the option to create a new table each time or unless I copy and paste the data. I need to be able to timport one after the other into the same table but I keep getting an error message just saying an error occurred file not imported.
How can I import this data??
View 2 Replies
View Related
Jun 5, 2006
I have 2 tables both which I need to import data into. I have 2 xls spreadsheets per day and I need to import all the data and build it up over a period of time so that I can use the database to analyse the data. There are around 2000 records per file but I can't seem to import the data unless I select the option to create a new table each time or unless I copy and paste the data. I need to be able to timport one after the other into the same table but I keep getting an error message just saying an error occurred file not imported.
How can I import this data??
View 1 Replies
View Related
Aug 22, 2013
Is there a way to get information in the print dialog box (File -> Print)? Like when i click ok or cancel? Or any other way that i will be able to know that the report is sent to printer or being printed.
View 2 Replies
View Related
Jun 10, 2013
I have this function and I can't get rid of this error:"Compile error! External Name not defined"..This is just doing some calculations. I am just calling the function on the after update event on my form.
Code:
Dim fHrs As Double
Dim Ttl As Double
Dim Ttl1 As Double
Dim Ttl2 As Double
Dim Ttl3 As Double
Dim Ttl4 As Double
Dim Ttl5 As Double
Dim Ttl6 As Double
Dim Ttl7 As Double
[code]....
View 3 Replies
View Related
Jul 22, 2015
I use the following code behind the BeforeUpdate event of a control, to validate input.
Code:
Private Sub StockPrice_BeforeUpdate(Cancel As Integer)
'strings used for the MsgBox
Dim strTitle As String
Dim strMsg1 As String
Dim strMsg2 As String
Dim strMsg3 As String
[Code] ....
There are two different forms that use that control and this code behind the BeforeUpdate event.
It works on one but not on the other, allowing to input anything in the control with checking and without bringing up any msgbox.
Searching what's the problem in the immediate window, brings up a message saying "External Name not defined'.
View 7 Replies
View Related
May 7, 2015
The code below sets my printer to "Cute PDF writer" and then opens a report in print view, which creates a PDF version of my report. So far so good. But just before the last step, it brings up the Save As dialog box, asking for a filename and location.
Three points are important:I always want to call the PDF document "Specialty Report".I always want to save it to C:Documents and Settings80435 Desktop. I always want to overwrite the previous version.
Is there some code I can insert that would achieve this automatically with no further user interaction i.e. user clicks a button and the PDF file is created/overwritten?
Code:
'Produce the report
Dim defPrinter As String, NewPrinter As Printer
defPrinter = Application.Printer.DeviceName 'Get the default printer name
Set NewPrinter = Application.Printers("CutePDF Writer") 'Create a new printer object
Set Application.Printer = NewPrinter 'Set the default printer to the new printer
DoCmd.OpenReport "Specialty Report", acViewPrint 'Open the report in print view (which will PDF it)
Set NewPrinter = Application.Printers(defPrinter) 'Reset the printer back to the default printer
View 3 Replies
View Related
Feb 11, 2015
I have the following code which successfully opens the dialog box with filters however when I add a function with an Excel import, the filters do not work at all (no files are shown even though they exist in the directory that's opened within the dialog box). If I manually type in the filter (i.e. *.x) it still shows the files.The function at the bottom was provided by cheekybuddha from another form, I'd be lost on getting the Excel file imported into Access.Here's the VBA code (the Function is also included at bottom):
Code:
Private Sub Command0_Click()
On Error GoTo PROC_ERR
Dim strpathtofile As String
Dim strTable As String, strBrowseMsg As String
Dim strFilter As String, strInitialDirectory As String
Dim blnHasFieldNames As Boolean
[code]...
View 2 Replies
View Related
Oct 16, 2014
I wish to export a report to excel, but I wish to prompt the user to be able to choose where to save the file at. How can I have the "Save As" dialog box pop up, with the filter set to "*.xls"?
View 2 Replies
View Related
May 11, 2014
Code:
Function dialogFolderBrowse() As String
Dim fp As FileDialog
Dim vrtSelectedItem As Variant
Dim VarX As String
'this next line is an optional warning to the user so they know what is about to happen
'MsgBox "LOCATE THE DESIRED FOLDER!!", vbOKOnly
[code].....
THE UPPER code is to locate the user desired folder path and name in order to do further process. However, my problem is that no matter I press <OK> or <Cancel> option in the normal MS Folder dialog box, the process still going on. Is that I miss some on error or on exit code??My idea is that when user press <OK>, the process goes on and when press <Cancel>, no process will be done!!
View 3 Replies
View Related
Sep 12, 2005
Hi
Im having a real problem. Im trying to import a query into Excel so a fancy graph can be made.
In Excel when I go to Data-> Import External Data then connect to my Database. A list of queries and tables appear however the query I want is not in the list but it definately exists in Access why is this??
Really Frustrating
Cheers :confused: :confused: :confused:
bikeboardsurf
View 3 Replies
View Related
Apr 24, 2006
I have a fairly complex database that will have many users. I am looking for a way to sort of link the data in a text box to an external database or text file of some sort to know who created a new record in it.
For example:
The database is on a network drive. Each person who will have access to it has a small file in their C: drive that contains their name. Whenever a new record is created, the name on that file is added to the record to know who is it that added it.
How do I do that?
Thanks
mafhobb
View 1 Replies
View Related
Apr 28, 2005
Hi experts. I want to learn how i can insert data in to external db using vba.
For example , i want insert table names in to the external db.
(A command button in a form )I be happy if some one show me how. Thanks
View 2 Replies
View Related
Oct 23, 2006
I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred trying to import file 'C:....xls' The file was not imported." And this error pops up after I have gone through all of the importing steps. Did I exhaust Access's resources? It's not a format issue, and I've restarted, etc. I'm at a loss.
View 10 Replies
View Related
Jul 9, 2013
I have a table onto which i would like to add new column based on a set of if statements. (to assign weekly dates)this is only a portion of the code, but when I clicked on run, it gives me "external name not defined error".
Code:
Option Compare Database
Option Explicit
Public Sub AssignWeekly()
'declares weekly column as a new variable
Dim Client_Weekly_1213 As Integer
[code]...
View 7 Replies
View Related
Feb 10, 2015
This for an app being used in Access 2003. I'm trying to (sort of) automate naming a PDF report. After the user selects a printer from the print dialog, if the printer name is like "*PDF*" then I want to put the PDF file name in the clipboard so it can be quickly pasted in the file name of the PDF printer's save dialog.
Something like this:
Code:
Dim strSelectedPrinter as string
DoCmd.OpenReport "rpt1", acViewPreview
DoCmd.RunCommand acCmdPrint
[Code]....
but that returns the name of the default printer, not the selected printer.
View 6 Replies
View Related
Apr 27, 2015
I am trying to display an open file dialog window so that the user can pick up a file. I wish the window to show a specific folder. How can I do this? The code I am using is below. The parameter InitialFileName has no effect on the outcome.
Code:
Function GetFileName(strPath As String, imtype As String) As String
On Error GoTo Err_GetFileName
Dim Dlg As FileDialog
Dim sfl As FileDialogSelectedItems
Dim sflitem As Variant
Set Dlg = Application.FileDialog(msoFileDialogFilePicker)
[Code] .....
View 11 Replies
View Related
Jun 17, 2005
Hi all
I just to know what the command or code is to generate the External data wizard is ?
I want to import a spreadsheet, the thing this there will be a new spreadsheet everyday with a different name. I guess the easiest way is for the user to select the file themselves. instead of the user going to file, get external data, i thought i could add the code to invoke this wizard on a button.
Thanks in advance
View 1 Replies
View Related
Mar 12, 2006
as i know, i can import data from excel. but is it possible to make data permanently at excel? i mean Access as a system n excel as data storer..
if possible plz tell me how...
thanks
View 3 Replies
View Related
Dec 23, 2006
We have saved image in the database as OLE Object. It is showing “Microsoft Photo Editor 3.0 Photo / Package” in the table. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.
Thanks in advance
View 1 Replies
View Related
Sep 9, 2005
I have a table that needs to be refreshed with new data monthly. The table has extensive relationship links to other tables. The new data comes to me in a spreadsheet.
I am tying to import the data from the spreadsheet into this existing access table, but errors halt the import. The fields in the spreadsheet are the exact same as in the access table. I am trying to accomplish this task with the Get External Data, Import wizard.
The strange thing is I can import the excel data into a new table without any problems. I then override the old table with the newly created one. The problem with is I have to severe all the relationships before doing so which is a real pain and a cumbersome process
If you can offer any advice, it would really help out
View 10 Replies
View Related
Oct 20, 2014
I have a front-end/back-end database that another programmer has done some work on for me. He worked on his own copy which wasn't linked to our data. Now I'm ready to integrate his work. What I would like to do is take his improved front-end and link it to the existing back-end tables. All the table names are the same, and none of the fields have changed. Is there an easy way to do this?
View 4 Replies
View Related
