Hello All
I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.
John
Is it possible for me to give them access to part or all of the database so that they can run queries to target venue mailshots etc if so how would i do this?Secondly my concern is that the database is valuable and I want to protect myself from potential theft of info, ie what stops them taking the database and using it for there own purposes?
View 2 Replies View RelatedI want to build a web site that people can access over the internet. I want the user to have the ability to run one of my Microsoft Access databases just as they would if the database was loaded on there PC. Is Microsoft Frontpage the answer or do you have any other recommendations of a web building software package?
THANK YOU IN ADVANCE - jOHN
I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no way to relate the to accurately. I would like to be able to parse out the XML and have it update my table as it goes so I have less "junk" in my DB. I just can't figure out how to call out the XML tag and tell it to copy that info to the correct field.
View 1 Replies View RelatedDear all,
Does anyone know if ti is possible to link an access table to one stored on an intranet site? This is used for logging help desk calls and various locations need to look at it at the same time.
I have tried it and seems to work but I get a "Not a valid file name" message
thanks for looking
I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.
View 1 Replies View RelatedI 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".
After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.
I have a query that gathers information from the tables in my database and returns something like this:
Code:
Field Pest
1 Insect1
1 Insect2
1 Insect3
2 Insect1
2 Insect3
2 Insect4
Field and Pest are fields in two separate (but joined) tables. Field exists only once in its table, and multiple pests are attributed to each field. I'm looking to create a table or query in which the values would be listed as follows:
Code:
Field Pest
1 Insect1, Insect2, Insect3
2 Insect1, Insect3, Insect4
The purpose for this is to create a legend for a map used by another program based on the information gathered in the database. I do have other criteria for which fields and pests show up in this query.
hey all,
I would very much appreciate any help or ideas on how to do this as I am stumped.
I need to develop an access database to track documents but also link to them.
I’ll explain what it needs to do;
Every day there is a numbered (and titled) Word format document that is sent.
Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name.
Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls
The first would signify it is a Word document by D (being short for Document) and W for Word.
The 2nd would be D for document and E for Excel, and then a number which is 101.1.
They are saved in a folder on the hard drive.
Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc.
There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields.
So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content.
That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.
All this so far I can do with no problem.
It’s this part that’s making me crazy.
What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database.
That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.
The people that will be using this are not very computer literate to say the least.
I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table.
Any ideas would be very much appreciated……………..
reb0101
I found the way to make my app absolutely (???) secure. But there is one problem I can't find a solution: how to prevent anyone to sneak in my app?Of course it is possible to hide the VBA but I found nothing about the Access objects.
View 13 Replies View RelatedHi,
I would like to link to an external data source (table) from MS Access 2003. I attempt to use the 'Import' feature to do this, and select 'ODBC Connection'. I am trying to connect to an application called 'Action Remedy'. I make the connection fine, but when Access attempts to import the table, it does not like one of the Action Remedy field names, and the Import aborts. The name is something like "Call Status-History.Closed.Time". Obviously, Access does not like this field name. And the chances of getting it changed (on the A/R backend are slim to none). Thus, my question: Is there away around this ?
Thanks !
I have a database that contains a series of tables & queries that feed a formatted Excel sheet(s). The problem is it is not very portable.
It works fine on my local computer, but if I give the database to someone else and when the open the Excel template and try to refresh the data from the database they get an error "could not find file C:documents and settingsusername...
If I make a file for them off of documents and settings with my username and put the database in it, it works fine.
So I guess the question is, how do I change the path in Excel to reference the users computer without re-doing all the external queries?
Hi There,
I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not seem to work in Access 2007. The linked table option now does not permit data entry or amendement. The other "Get external data" options create a table in Access which also does not update my source Excel document. The idea is to enter data in Access using a form. This data is placed in an excel spreadsheet. Excel gets some lookup values, and then enters these in a Word mail merge. Without the functionality of a linked table and data entry, I cannot produce new reports.
Can anybody help please?
Regards
Mark M.
Can you import from a .txt file on Notepad into an Access table or will it have to go via an excel spreadsheet to begin with?
View 1 Replies View RelatedI'm looking for a form system that will interface with Access.
At present, we collect information from clients and store it in an Access 2003 database. I have designed my form as an Excel spreadsheet. I use Excel as we are missing the reference files that will enable Access to work with Word and some other programs. The Excel form is emailed to the client, who fills it in & emails it back to us.
To restrict entry of certain fields to a list of values, I use lists in the Excel Workbook, which emulate the lookup tables in Access. I am expecting to add more values to the lookup tables, which would mean that I have to constantly update the lists on the Excel spreadsheet, with the lists eventually becoming quite large.
I have written an import program in Access which imports the Excel worksheet/s into the relevant Access tables. This all works, except the entire process is very manual.
What I would like is to use an external form program that would do the following:
1. Allow me to design something that looks nicer than a spreadsheet
2. Can be updated with my lookup tables so I don't have to manually edit the lists (as in Excel)
3. Can be imported into Access (export to an xls or csv file would be ok if not into Access)
4. Is portable, self-contained & can be emailed to the client so doesn't require them to log into any of our systems, including our web site. The user can fill it out with the data being validated at the same time & then return it to us.
code that will allow me to take data [All Fields] from a Table in my Database and Insert them into another identically structured Table in another MS Access accdb Database.I would also like to filter for records older than a month [MyDateField]
I have tried the following code I found on line. It doesn't throw an error . . . but it doesn't perform the Insert either.
Code:
Dim ws As DAO.Workspace 'Current workspace (for transaction).
Dim db As DAO.Database 'Inside the transaction.
Dim bInTrans As Boolean 'Flag that transaction is active.
Dim strSql As String 'Action query statements.
Dim strMsg As String 'MsgBox message.
[code]....
We have an older system that generates txt reports. I take these txt reports, then using Excel, I append the report headers to each record... creating a datatable. I then import this table to Access. I have not been able to figure out how to have Access perform this. In Excel, I use an "if" statement.
View 9 Replies View RelatedI'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 2 Replies View RelatedIn previous versions of Access (i.e 2003 and prior) I could use the following code in the On Click event of a form's command button to open an external file:
Dim stAppName As String
stAppName = "C:Program FilesCadroTransPost PlusTransPostPlus.exe"
Call Shell(stAppName, 1)
However, I'm now using Access 2013 and it wont allow me to use this anymore, it gives me the following error:
Runtime Error '5"'
Invalid procedure call or argument
Why this doesn't work in Access 2013?
i'm running a module from an access db. how do i import a table from oracle into a closed access db, not the one where the code is running from?
View 1 Replies View RelatedRunning Office 365 (Access 2013). Recent problem occurrence. When I do an 'External Data' command, either from another Access database or an Excel file, the import completes, but I don't see the new table immediately in the navigator section. If I import from another Access database, the new imported tables appear as '~TMPCLP....' tables. If it's from an Excel workbook, the new table doesn't appear at all. It's only after I exit the database and reopen it do I see the new tables correctly named.
View 1 Replies View RelatedI 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.
I want to run an external application (a batch file) ... and want to run it by clicking on a command button on a form. That part is all fine, using the Shell command. I can determine the start time of the application (also fine with now() function) .. but want to find out how long the external application ran and log that "run time" into my database.
The part I don't know about is the .. really the ending time. How do I determine how long the application really ran for / ended ? I imagine I can use datepart to determine the difference in the start and end times. Or would I use a timer control. (but I cannot find the timer control in Access 2010).
I want to hide external data and databasetools tabs only from my access program. How i do it ?
View 3 Replies View Related[URL]
I have a button on a form, when it is clicked it opens a video file located in a folder on the local computer. Each time the button is clicked a security pop up appears that says "Opening file://C:lahblahyadayadaFile.mp4 Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?" options are open or cancel. How can these messages be turned off?
I have already played around in the trust center of Access 2010 and changed the "trusted documents", "trusted locations", and "message Bar" tabs with no results. Do I have to play with regedit in windows to get rid of these pop ups? Or can I somehow use VBA code to disable them?They are just a nescience.
i want to hide external data and databasetools tabs from my access program.
how i do it ?