Linking Access With Pascal Or Other Programming Languages
Sep 7, 2005
Hi, I am just about to start the implementaion of my A2 computing project, hopefully using both access and pascal to create a bar ordering and stock control system. My question is how and how easy would it be to link both the pascal side of the system and the access application so that they are sychronised? The access application would be used as a front end to my system, and a store of inforamtion where as the pascal code would be used to carry out the necessary calculations.
I am new to these forums, and am an idiot in Access. i work for a small nonprofit and manage a project through our state Division of Rehabilitiation Services in providing Assistive Technology Services tp their clients (DORS is an agency which provides services to people with disabilities to gain meaningful employment, increase their independence or be successful in pursuing educational goals).
I have been trying to create a database to track the authorizations/clients I serve, some of them have worked but are a bit too complicated in which i am sure can be put together easier (more efficiently) and basically I am afraid to implement it as it would probably fail. Mainly a merger between a number of templates avaliable for free.
What my question is, is how much does it cost (in general) to hire someone to create the database for me. I am basically looking for a database that will be able to store client information (name, contact etc... information about their disability and their goals (employment, education etc...) who their counselor is and their contact information (multiple clients per counselor).
Now each client may have multiple authorizations (I.E. An Authorization for an Evalutation and then for training). So I need service records related to the specific authorization and then the ability to store invoices and reports related to that authorization as well. I would like it to link to a report as I create them in word and save them on a server. I would also like the ability to have the reports sent to the counselor via e-mail from the database.
Hope this makes sense, if anyone would have a generalized going price for somthing like this in terms of hiring someone to complete it that would be GREAT. Thank you,
I am new to programming. I have to design a form in access which contains basic text fields, a combobox and some datefields. I need to use this form to input data to access table and and retrieve data from access table. Can anyone help please.It is very urgent. :confused:
I am new to Access programming. I read in some web page on googling that Access is for developing Desktop database. Books inform that Access projects can connect to Server database.
I would like to know if Access can also be use for Server side programming.
I want to retrieve some parameters from file, So for that i want to implement File Open Dialog in One of the form. File Open Dialong is available in Micrososft Common Dialog controls.
When i choose Microsoft Common dialog control from extra toolbars, it gives me error saying that "You don't have licence for using Common Control ActiveX.
I have a multilingual database. currently I set a public code when a user logs on setting the language to be used on form Labels and report Labels. I use the on load event in forms and on Current event for reports to set the labels caption eg if gbllanguage = "English" them me.label1.caption = "English language" if gbllanguage = "Deutsch" them me.label1.caption = "Deutsche Sprache" etc
Now the database is rather big and more and more languages are to be added. It is quiete cumbersombe to update the VBA modules.
Does anyone have an idea how to set the label values in a table and when a form is opened the relevant labels will appear in the corresponding language/value.
Obviously I don't want it to slow down opening the forms etc as the program is rather big
I have inserted two combo box in the form with lookup in the table. Now I want to select values in these boxes and filter the records having those values on click of a command button placed on the form.
How can it be done without using VBA? Is it possible with use of macro?
The following code is only for testing the usage of control variable. I want to use set statement to assign the textbox object reference to the varialbe myControl.
When I clicked the button, the system always tells me 'the object reference missing'. It seems the set statement doesn't work, but I don;t know the reason. could anyone of you please spot it out for me?
Many thanks
Option Compare Database Public myControl As control Public frm As Form Set frm = Forms!Form1
Sub Command4_Click()
Set myControl = frm!Text0 myControl.SetFocus
End Sub
Sub Command5_Click() Set myControl = frm!Text2 myControl.SetFocus End Sub
I know this topic has been discussed, but i could not find one thread on the general purpose of exporting an excel table/form to excel.
I would like to place a command button on my FORM, and let the user click this button and export the data into excel.
I tried using the transferspreadsheet method, but could not corrrectly, if at all get it working, and the help section within access2003 onlu covered importing into access from excel.
Please, if anyone has any links to sites/tutorials/ threads i misssed actually covering this topic/or thier own help, it would be greatly appreciated.
There are multiple employees on a table, each with a period of time for which they worked. I am trying to gather these times together to see how many complete records I have for the time period of 4/1/1999 to 12/31/2004. So, for example,
Employee 1 works from 4/1/1999 to 12/31/2000.
Employee 2 works from 1/1/2000 to 12/31/2004.
(From these two records, there will be 1 complete record of 4/1/99 to 12/31/04 AND 1 remaining record for the year 2000 left over.)
Employee 3 works from 1/1/2000 to 12/31/2004.
(From these three records, 1 complete record + 2 2000 + 1 each for the years 2000-2004.)
Employee 4 works from 1/1/2001 to 12/31/2003.
(= 1 complete + 2 2000 + 2 2001-2003 + 1 2004)
Employee 5 works from 4/1/1999 to 12/31/1999
(= 2 complete + 1 2000 + 1 2001-2003)
And this goes on for all the employees. I need to find out the end amount of how many complete records and remaining dates all the employees have worked. I hope this was at least, somewhat clear. I remember doing something similar to this ages ago in programming class, but since then, my mind has degraded. =P Any help, insights, or advice would be greatly appreciated on how to get this done. =)
I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and column space so that the output can be better tailored to his needs. I have inserted combo boxes on the form to get these parameters from the user, but how am I going to insert these parameters in the report layout through programming. What should be the approach?
I can create simple databases with Access but I've recently identified the need to create something a little more complex. My entire relational database revolves around a central table of contacts.
I have a list of contacts in MS Outlook (searchable by name, phone number, etc.), which should be the same. I want to avoid the risk of data redundancy so I was wondering if it is possible to link Outlook and Access databases in some way, so that, for example, if I was to add a contact in Outlook, it would update my database automatically and vice versa.
I'm sure this is far from simple but I'd love to hear any suggestions you may have.
Okay, I've heard that this isn't possible, and searching the forums for AutoText didn't yield any results for me, so I thought I would ask here.
Is there any way to link the AutoText in word to the entries in the database? I am thinking along the lines of exporting database entries to a template in the AutoText format.
Obviously a similar effect would be to use a mail merge and insert the relevant data in from the database, but I'm proposing that Word should somehow lookup the information as it does with the AutoText, which seems a more elegant solution. However, I'm not up to the job of figuring it out myself.
Anybody like to show me how very clever they are? :o
I'll try to summarize the situation as best as I can.
I have an Access 2003 FE linking to an SQL 2000 BE using a DSN-Less Connection String. Both are running on my local machine for development.
I created a LinkTables method (see below), so I can select different Connection Strings for use in different locations (ie. onsite at client, at my office for development). I have no problems getting it to work on my local machine. I even took it to another office where SQL was running on a server, and the Access FE was on a workstation. The LinkMethod worked perfect.
Onsite at the client different things happen. It links fine while on ther server. However, when I try it on a workstation, it doesn't link correctly. It says everything linked successfully, but when I try opening a table I get the error:
Connection faled : SQLstate : '28000' SQL Server Error : 18452 [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(NULL)'. Reason 'Not assoccated with a trusted SQL Server Connection'
Then it opens a Login box asking for a login. If I enter the correct Username and Password, all the tables open. Its almost as if the UID and PWD in the Connect String are being ignored.
Any idea's what the problem is?
Thanks.
Public Sub LinkTables(gLocation As String) Dim DBPath As String Dim td As TableDef Dim p, i As Integer Dim s, c, e As String
On Error GoTo Error DBPath = Left(CurrentDb.Name, InStrRev(CurrentDb.Name, ""))
On Error Resume Next If gLocation = "" Then Exit Sub c = DLookup("ConnStr", "Settings", "ID = '" & gLocation & "'") If c = "" Then Exit Sub On Error GoTo Error
' For Testing c = "ODBC;DRIVER=SQL Server;UID=audituser;PWD=audituser;SERVER=CORPMAT; DATABASE=AuditTest"
i = 0 For Each td In CurrentDb.TableDefs s = td.Connect If Left(s, 4) = "ODBC" Then ' Check for SQL Link td.Connect = c td.RefreshLink i = i + 1 End If Next Set td = Nothing If e <> "" Then MsgBox "Error Linking Tables:" & cr & e, vbExclamation Else MsgBox CStr(i) & " Tables Linked Successfully. Please re-open the database." Quit End If leave: Exit Sub Error: MsgBox "Error Linking Table! " & td.Name & cr & " Error: " & Error$, vbCritical Resume leave End Sub
Is there a way to link a ACC table to an Excel spreadsheet so that when changes are made to one it automatically changes the other?
And - How do I link (or join) two (or 3) Access tables so that the above happens - when a change is made to one it's made to the other.
Example: I have an overall big table with 7 fields. I created a query from it that has 5 fields. Or create another table that has 5 fields. Can I join/link them so that changes made to one is made to the other?
Example: An ID number changes or a wage salary changes.
Does anyone know if this is at all possible. When I wish to process a payment for a customer within my database, rather than visit paypal and entering payment information, is there a way by way of API or similar that I can automatically go to the site and have the payment amount entered for me using data from a form within my database?
It may be too much of an ask but I thought I would at least ask the question..
I have an excel spreadsheet that i have linked to an Access database. I need to append and delete records from the spreadsheet into an existing table in my Access database. I am able to append specific records from the spreadsheet into my table but then i want to delete the records from the spreadsheet. When i run the delete query i get the following message; "Deleting data in a linked table is not supported by this ISAM" Is there some way i could get this to work?
I have records in this spreadsheet that needs to get into the database but once it is appended to the database i need those records deleted from the spreadsheet. I am kinda using this spreadsheet as a temporary table so one employee who does not use access can put data into his spreadsheet and then the other employees can pull want they need from this into the database.
I have a table which is being populated with data when I click a button in a form. Now I want the data of the table to be shown in an excel file but the problem is that I want that data to be refreshed everytime I insert new data in the table.
When linking in a table under Access 97, any long integer fields are being converted to TEXT format. This I understand is due to the version of the Access database engine.
It does not happen in Access 2000.
Anyone have any idea's of how I can force access 97 to use the jet 4 engine installed already ?
( i have abused the registry - and it didnt like it at all )
i have a form and was wondering if it was possible to take some of the fields and drop them into a template word document from inside access. so as to create a button that when clicked opens up the template and transferes the wanted form data.
any idears how to automate this process would be greatly appreciated
I have converted my MS Access database tables to MySQL Server tables. I am trying to use the MS Access front end to cooperate with the MySQL Backend database. I have created a system DSN, without problems.
My issue is when I Open MS Access --> Open File --> Files of Type: ODBC Databases, nothing happens. It does not give me the option to connect to the MySQL database I just created. I also tried to import data by linking tables (again, choosing the ODBC databases option), and it does the same thing. Does anyone know what I may be doing wrong?
Any help on this matter would be greatly appreciated as it is a problem that we have been living with for a long time.
Heres the problem....
I have an Access database that stores our customers details, aswell as the details of the products that they are ordering from us.
We process all of our payments over the telephone, and use a Payment Service Provider called Protx to process their card details. The process is quite straight forward, we simply log on to a secure website, then copy and paste their name, address, post code, and credit card details into the web form. Our database and the webform have exactly the same fields.
However it is quite a time consuming process, having to keep switching between our browser and database windows for 5 different fields, and when it's done 50 times a day it adds up to alot of time spent.
Does anyone know if there is a way of cutting down this process, for example being able to copy and paste all of the fields in one go from our database form, into the webform? Or possibly know of a programme that can allow me to do this?
I have spoken with friends who have told me that it may be possible to use our access database as an internet browser, would enabling this allow the problem to be fixed somehow?
Any help on this matter would be greatly appreciated.
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 ?
I'm formatting an Access table and need help linking 1 field to another. I need to specify that Field B will state "N/A" if and only if (back to good old geometry) Field A states "Yes." I've tried using the ValidationRule and Default Value functions but they don't let me refer back to Field A. Any thoughts would be hugely helpful.
