hi to all,
I have a software which links itself to a fox pro database/tables. Now i want to link some of these free tables or database from fox pro to access. Whenever there is a slight change in the fox pro tables/databases they must reflect directly into access database. Is this possible and how?
thanks,
ashley
I'm looking for some sample VBA code that dynamically creates a link to Visual FoxPro 9 table. Our group has a number of end user FoxPro applications, and as FoxPro is reaching the end of its life in January 2015, we need to replace it.
A lot of the processing we do uses tables with a date embedded in the name, e.g. MyData_20131211.dbf. We'd like to be able to let our users to use Access queries that point to these tables without having to manually create the ODBC link each day. Is there a way to set up a link once, then use VBA code to dynamically change the table it points to?
For example, we set up an ODBC link table to MyData_20131211.dbf, and rename the link table in Access to MyData_Today. Then tomorrow, the VBA code would change the link to point to MyData_20131212.dbf.
An alternative would be to dynamically recreate the link each day.
As the tables are large, we don't want to import them into Access if we don't have to.
Hi there - I have a database for a conference. I have an attendee's form where I enter their personal details. Then I have another form called Options Form (which I've set up as a command button to open the form) where I can enter the workshops/sessions they sign up for.
As attendees send us their completed options forms, I need to enter their choices into the options form.
TheProblem: If attendee 103 sends in his form, I enter his choices and close out of the options form. If attendee 67 sends his form, I do the same. BUT when I go back to these attendees and open their forms, those choices I had just entered have disappeared.
The Options Table (that I set up and designed the Options Form off) has the following fields:
AttendeeID
FirstName
LastName
Workshop 1
Workshop 2....etc
When I designed the form, I formatted the AttendeeID, FirstName and LastName field to use this same info from these fields in the Attendee Form (ie, =Forms!Attendees!AttendeeFirstName). However, when I tried to find out where these options 'went', I had a look on the Options Table and they are there, but there is nothing in the AttendeeID, FirstName or LastName field - these fields are blank.
Originally when I first started entering the options, it just seemed to Autonumber the choices I entered, so even though I may have entered them for Attendee 103, in the Options Table is showed in the Attendee column as 1, then if I entered info for Attendee 86, the Options Table showed it as 2 and so on, so whatever order I entered the information it put it in numerical order as opposed to the actual AttendeeID number.
What I need: I need to be able to enter any attendee's options (whether they are attendee 1, 26, 200, or 105 - ie not necessarily in numerical order) on their options form and for this info to be saved.
I hope this is not too confusing for anyone and someone is able to help. I would really appreciate it, or if you need further clarification, please just let me know.
(My guess is it has something to do with making sure my fields are formatted correctly, ie on the Options Form the AttendeeID field was set on Autonumber which is why it may have been putting the choices in numerical order instead of whatever the AttendeeID number is. I'm also wondering if I need to set up some kind of relationship between the Attendee Table and the Options Table - but I'm not sure what type of relationship it should be on. I've tried several options and none of them seem to work)
Many thanks
Kath Price
Auckland, NZ
I have been running queries and reports with data from our company database (a third-party system based on FoxPro2.6) by linking tables into MS Access 97 for years. We have now upgraded to XP and Office 2003, and suddenly I can no longer do this but get a message "Could not find installable ISAM".
I've tried to locate the required file on the Internet but no luck so far. Can anybody help me? I am currently using an old pc with Office 97 on it to run the reports, but it's in a different office location and makes the whole job very tedious. Are there any work-arounds?
Any help much appreciated!
CC99
I'm trying to import a few tables from a FoxPro database into an Access Database using VBA code. I know I have done it before and I remember struggling with the format last time.
DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Hiremate;SourceDB=data-wwappshmfox32datahiremate.dbc;SourceType=DBC;E xclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu ll=Yes;Deleted=Yes", acTable, "hires"
My situation is as follow
I have an Access datebase, where main tables are built and saved.
Also, I have 2 Access modules, which access informations in main tables in an Access datebase (I used Linking to table) and process information in query.
Questions: Linking to tables in another datebases will make perfomance of the module worse ? If the answer is Yes, then in which scale ?
Hi,
I have two databases in Access.
One of the database acts as backend i.e it has only tables including some Linked Tables(which are linked to some third database)
Other database is an executable in which all the tables are linked to the bakend database.
I am not able to link to the linked tables in the backed database. Is there a way of doing that?
I have a form in a DB and I would like to make it work so that when a user user chooses a job department (choice of 10). When they choose the department I want the next field on the form to only show the job classifacations(5 in each department so 50 if all show) in that department. Right now all I can do in make it so they need to choose from many job classifacations (50 of them as explained above where 45 have nothing to do with the department first choosen) and most of them don't relate to that department at all. Is it possible to do? I have limited macro knowledge and no code ability.
Thanks
I have a code for linking tables. It works on Access 32 bit.I modify the code for 64 bit (include PtrSafe after all Declares, etc...)But it doesn't work.When I try to chose database in dialog window, my program closed.
Code:
Public Function GetDbPath(path_name As String) As Integer
Dim i As Long
i = MsgBox("The path to database is incorrect" _
& Chr(13) & "Chose new path?", vbOKCancel + vbExclamation)
If i <> vbOK Then
DoCmd.Quit
Exit Function
[code]...
Hi there,
was wondering if there is way to link tables in Microsoft Access, if the primary key is not matching 100%, for example lets assume that we have two table, with fruit type as their content.
Table1
FruitType
ORANGE
APPLE
PEAR
Table 2
FruitType
ORAN
PPLE
EAR
as you can see the content in the second table is somewhat incomplete or corrupted "Orange" is missing an "E", "Apple" is missing an "A", and "Pear" is missing a "P".
Thanking in advance
I'm trying to use a template to track assets-specifically this template:URL....Is there a way I can link an excel doc to my database that provides all of my data, that is thereby linked to other tables within Access?I want my data to be updated as it is manipulated within the independent excel doc when I open access.
View 6 Replies View RelatedHi, this dilemma really has me in a bind - say I have table1 and table2, when I enter data/update table1, I need to also enter the same data into table2. I know this sounds royally weird, but if there is a way to do this I would appreciate any and all help asap!
Thanks in advance.
I am trying to create a database which will act as a timesheet and management system.
I have several tables set up. some are:
01-Staff details containing Staff ID, Names, etc
11-Timesheets containing Timesheet ID, Staff ID, Timesheet Period ID
17-Timesheet Periods containing Timesheet Period IDs, Start Date and End Date.
13-Hours containing Hours ID, Timehseet ID, Project ID, Hours
etc.
I want to set up a Combo that lists Names from Table 01-Staff Details, and when the user selects their name, enters the Staff ID on a new row in the tabll 11-Timehseets.
I am able to create the Combo to list the names from 01-Staff Details, but am not able to get the selected name to jump into 11-Timesheets. The field is not available in the Control Source.
Could you please assist? I am not an Access expert, nor have I done any programming, so a step-by-step solution would be greatly appreciated!!
Many thanks in advance
Sunil
p.s. I would then like to ensure that users can't edit data in certain tables (eg. they shouldn't be able to create a new Staff ID/name, etc)
My next task will be to create a sub-form (which I am able to do) where the user can select a project from a combo-box and enter the hours worked on it. I would like the project and hours to be entered on a new row under the table 13-Hours
I look forward to your reply!
Many thanks
Okay,
First I was thinking to write a little app in Access to work with a DBF file, that I assumed was a DBIII database. It was exported via a 3rd party software, and the primary interface up until this point has been Visual FoxPro. My problem is two fold:
1st:
When I tried to import it as a dBase III file, Access just closed. I mean, disappeared, no longer running, closed. I didn't even get an error message or anything.
So I tried to import via ODBC, using a "Machine Data Source" Microsoft Visual FoxPro Database (or table, either works) and selected the directory of the dbf file and selected the table listed once it scaned the directory and all imported fine.
So: If the Visual FoxPro Machine Data source worked, though I am confused why the DBIII driver just booted me, I am now concerned as to how I would write a connection string via DAO to access that dbf file at run time.
Basically I want to go to a static location on a network and access a dbf file, and perform query manipulations upon it. My connection will be READ ONLY to the actual DBF file and i would subsequently use MS Access to create any other relevant tables/queries based on the table in the dbf file. Since the Visual FoxPro MDS diver worked, do I need to write a connection string to access it, and if so, how would I do that?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
Guys, i have a recovered Foxpro table, the problen i have is the numbers have the wrong format. To be exact, 63 should be 0.63, 1200 should be 12.00, 4250 should be 42.50. In other words i need to put in a decimal place two places to the left of each number. How do i do this on import ? Do i have to run a query and make a new table? If so what function and expression do i use?
Many Thanks:)
I have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
Currently trying to build a database for customer management and order placement/tracking. Want to set a couple of rules so that if I for instance click yes of billing and shipping address the same that the database will automatically fill the shipping address with the data I inputted for the billing address in the same table.
The other issue I can see I'll run into is, I want to be able to select one of the company ID's (made up of a three letter abbreviation of the full company name) in the product ordering table and it will automatically fill in the rest of the customer data (phone, email, address etc) data into that form.
Guys, i have a recovered Foxpro table, the problen i have is the numbers have the wrong format. To be exact, 63 should be 0.63, 1200 should be 12.00, 4250 should be 42.50. In other words i need to put in a decimal place two places to the left of each number. How do i do this on import i? Do i have to run a query and make a new table? If so what function and expression do i use?
Many Thanks :)
I am doing a project where we are collecting home owner data and information on all the dogs in the household. The data for homeowner has an autonumber primary key because no field is unique or has been consistently collected. I am struggling to link the data for the dogs to the owners because an autonumber primary key will not work since not all homes have dogs. I need to have this set up so that people who are not tech savvy can look up each homeowner (or dog) and get the dog (or home owner) information. And to make things even more fun we need up to 15 potential dogs per household each of whom will have 18 different pieces of data collected.
It looks a little like this (and you can see my not matching ID issue):
Homeowner table
ID First Name Last Name...........Total Dogs
1 Max Maximus 5
2 Min Minimus 0
3 Mus Musculus 1
Dogs 1-5 table
ID Date Dog 1 Name Dog 2 Name .......Dog 5 Name
1 (Max's) 4/11/14 Bobby Billy Betty
2 (Mus's) 4/11/14 Jojo
Min will have no dog records at all, just home information.how to link the dog's to the homeowners .
I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.
I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.
Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.
My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?
I will be splitting the database once completed and then making a ACCDE file for my techs to use.
hi to all,
does anyone know the code to close the access program.
That is when i select the close button on the switchboard, the whole of MS access is closed.
Thank
Hi!
I am a newbie in Access. I am running Access 2003 and would like to be able to create links to Visual Foxpro9 tables using the VFP OleDB provider and not the ODBC drivers.
A few of my clients want to use the VFP9 tables in their reports but so far I have not been able to find a way to do it using OLEDB (except in a module with VBA code which I don't want).
I can do it using the ODBC but the problem is that ODBC driver does not recognise the VarChar fields in the tables.
I tried creating an Access project and then 'File --> Connections' but it does not display the 'Provider' tab to select which provider to use and by default assumes that SQL Server is the source database.
How can I get Access 2003 to allow me to select the OLEDB Provider?
Any help will be appreciated. Thanks.
Erm Hi everyone I'm new.
Sorry about the rather striking title, but I have an assignment with the deadline tomorrow and I need to find out how to perform numeric calculations in access with different fields (i.e. adding numbers, minusing etc.)
Well, I had to make a project at school for my GNVQ ICT, I chose the advanced sales database, since its a project we have to add in our own features and find out about them ourselves. Well I thought I'd create one for my company inside school, I wanted to create a database that would print invoices and monitor all the resources we have. The project has to be in on monday!
However all was going well until I came upon a slight problem, I'm not sure how to do calculations in Microsoft Access!
Well basically this is what I'm aiming at, its nothing too complicated really.
I have a table called RESOURCES which keeps track of all of the stock the company has (e.g. how much paper, how many mugs, tshirts etc.). I want the database to be able to automatically take 1 away from the selected resource when a form is used to file a new order.
E.g.
I have a form asking me the details of the design, In the resources table I have set the quantity of mugs as 100, i.e. I have 100 mugs in stock and available.
I use the form and tell the database that I am making a design which will use 1 mug.
The database then goes to the resource table and takes 1 away from the available stock of mugs making the total mugs available 99.
I then the database to be able to do this automatically, when a checkbox is ticked, when the form is submitted I want it to see which text boxes are ticked and take the correct consequent resources from the RESOURCE table.
I have Access 2003, I have attached the file incase anyone needs it, note that the Forms have NOT been made only the resource, customers and orders tables have been created.
If someone could tell me how to do this I'd be extremely greatful, this is very URGENT I have to hand in the project on Monday!!!
I know I'm asking alot but I'd be really really greatful if someone could help me out!!!
Hi
Please answer ASAP, this would be urgent!
I have two tables that need to be updated in tandem from a single access-page, by entering previously non-existent data.
One contains a contractor ID, and the name of the contractor; The other contains details of contracts, with the name of the Contractor selected from a drop-down box that draws its contents from the other table.
I have a data access page with an always visible drop-down box that shows contractors, and if I select one, it displays all contracts entered. This unfortunately means I cannot easily add new contractors, since they have no pre-existing contracts to display the details, and allow entering, and I cannot make the details fields permanently available.
Right now, I can add new contracts to those contractors who have at least one in the system already, but I'm unable to add new contractors. My aim is to have a single page add the contract data, and new contractors. Having a hyperlink open a new page that allows the adding of new contractors is also acceptable, but no coding, please, cause I suck at that...:(
Thanks in advance for your help!
Please help...
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xcac Thread 0xcc0 DBC 0x1090064 Jet'.
The code: example.asp
Code:<%fp_sQry="SELECT count(*) FROM TEVPDATA where ((datediff('d', '" & date() & "', DT3PROF1) between 0 and 30)) and (COL2 = 'PROF1/SLM')"fp_sDefault=""fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records returned.</td></tr>"fp_sDataConn="Fabos"fp_iMaxRecords=0fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Truefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_iDisplayCols=1fp_fCustomQuery=TrueBOTID=1fp_iRegion=BOTID%>
Global.asa:
Code:'--Project Data ConnectionApplication("Fabos_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=data/Fabos.mdb"FrontPage_UrlVars(4) = "Fabos_ConnectionString"Application("Fabos_ConnectionTimeout") = 15Application("Fabos_CommandTimeout") = 30Application("Fabos_CursorLocation") = 3Application("Fabos_RuntimeUserName") = ""Application("Fabos_RuntimePassword") = ""
i'm doing my final year project and i have restricted the toolbar in access. I need it back as i need to make changes to the forms and switichboards, but i can not access them. Does anyone know how to get it back???????????
Please .......
Pamela