I would like to have a back-end Database on a host server and link a
front-end Database to the tables several hundred miles away. The problem is I have no experience whatsoever in doing this.
My questions are:
(1) Can tables be linked via the Internet?
(2) If they can, is this the best way to link the tables?
(3) If it is possible to link the tables by the internet or by some other way; how do I do it?
I have 5 computers on a network and have designed a form which needs to be accessible by every computer on the network. When I do try to open the form from a different computer other than the one it was created on, I get a security warning message that Microsoft Access will not open the file due to security reasons as the computer I am accessing is not a trusted source or not part of my intranet. I've tried everything. Can someone please help?
how is it that I make a table "updatable". That's the error ACCESS 2007 gives me when running the runtime version (front end) on a computer. The program has to update the tables on the back end which are on a different computer (on the same network).
Also, I just saw a thread with some code included to open the database, and then to close it. Do I need any connection code in ACCESS for this case?
This is my configuration:
- Main Machine (which has an shared external hard drive E: where the back end file resides)
- Other Machines (they contain the front end file which is supposed to be linked to hard drive E on Main machine)
Everything is shared and the path to link the front and back ends is working well.
I have splited my database... the table parts in the network (server) other part in some different computers...
I did this to allow others to enter data that ultimately will be gathered in the table-part of the database.
The problems is, when i linked the tables (using my computer) in the splited database it took the address as W:mydatabase.mdb, where W is the logical drive of the server... when i try to operate it from other computer it can't get the link because the logical drive is defined differently in other computers...
but the actual link is follows: \vbsrsdatabasemydatabase.mdb I can hyperlink any document puting this address which are accessible from different computer...
is there any way to link the tables using the actual link in my database?
I have a split database. I hope I can explain this well....
I have a network mapped drive on all computers (win xp pro) of G: I have obviously a front end that was created when it was split.
I keep that fornt end file in same folder of the backend side of things, and I simply copy that exact tile (the front end) and place it on to the desktops of the workstation PC's and my database seemed to work, obviously I do rename the front end file on all PC's to Workstation 1, Workstation 2 and so on.
The front ends on workstations all do connect to the backend and the data does appear in the front ends and new records can be added and edited.
However I have a few issues:
1) If Workstation 1 was editing record 1 and workstation 2 was on another record say '232' and workstation 2 wanted to view the changes made to record 1 then he/she would have to wait till the the user edits the edited record and wait 5 seconds to see any changes. It would appear there is a slight delay in seeing the updated data.
2) If for example the user on workstation 1 adds a new record then it does update it in the table on the backend no problem at all, but it doesn't appear in the other front end databases form until the users exit the form and go back into it - it doesn't update live.
First off, I'm a total newbie at Access. I've had it for a few weeks now and am trying to develop an order entry system for our church (we have a discounted food ministry). I've gotten pretty far with it.
Anyway, once this app is complete, how can we have 2 computers updating one database or do we have to use just one computer exclusively and to do more than that, we'd have to go to sql server?
Also, can we install access on more than one pc? We have access 2003. We don't have any problems with buying another copy, but if we buy it, we need to know we can have 2 computers, accessing one access database. Is this possible?
I have a problem in calculating distance's mileage.Eg: Distance from town A to town B is 10km, town A to town C is 20km and vice versa. I have a table named "Location" as per below:-
Town From , Town To , Distance A , B , 10km A , C , 20km A , D , 30km B , A , 10km C , A , 20km D , A , 30km
My question now is: if there are 26 locations, (Eg: A - Z), then I need to key in the distance one by one and it is very tedious. Because Town A to Town B is 10km and Town B to Town A also 10km.
Is there any method that Access will consider A to B and B to A is same distance?
Can we use crosstab to calculate?? and what is the step?
I am trying to create a query that gives me a cummulative distance based on a previous footages. For example I am prompting the user to enter a Route. Along the route are several points having a numeric value. Each of these points along the route have a footage accociated to the previous point. I want the query to display the Route, each point along the route based on the users defined start and end point, show each backspan footage and provide a cummulative distance based on the progression of the route. Below is what I have created so far. Now I want to add a cummulative distance.
SELECT PED.ROUTE_1, PED.TERMINAL_1, PED.TERMINAL_1, Sum(PED.BACKSPAN_1) AS SumOfBACKSPAN_1 FROM PED GROUP BY PED.ROUTE_1, PED.TERMINAL_1, PED.TERMINAL_1 HAVING (((PED.ROUTE_1)=[ enter route ]) AND ((PED.TERMINAL_1)>[enter start]) AND ((PED.TERMINAL_1)<[enter end]));
Before I design an application in Access, I need to know if a certain task is even possible. I have a table of Physicians containing their names and addresses. What I would like to accomplish is to be able to provide an entry screen that would allow a user to input their zip code and have Access search for the physicians with a
However Instead of entering the postal code continually or selecting from the combo box. How do I set zipcode 1 and zipcode 2 based on fields in a form. I would like to use the current FROM (Default zip based on the current job in form) and TO zipcode [Project Postal Code] that is on the form at that time. Not necessarily combo box.
Currently you have
zip1 = Me.Combo2.Value zip2 = Me.Combo4.Value
I want Zip 1 to be Default zip (however I can still change it if needed) ZipCode field is [Project Postal Code]
Here is the full code:
Private Sub Command6_Click() Dim zip1 As String, zip2 As String Dim sResponse As String Dim sLink As String On Error GoTo Command6_Click_Error zip1 = Me.Combo2.Value
Here is my sql statement that I want to get the total number of "yes" in each field. Each field is a text field.
SELECT Sum(Homeless="yes")*-1 AS HomelessCnt, Sum(NFresident="yes")*-1 AS NFresidentCnt, Sum(Self="yes")*-1 AS SelfCnt, Sum(StaffBoard="yes")*-1 AS StaffBoardCnt, Sum(FamilyFriend="yes")*-1 AS FamilyFriendCnt, Sum(CommLarge="yes")*-1 AS CommLargeCnt, Sum(ServeProvide)*-1 AS ServeProvideCnt, Sum(Physical="yes")*-1 AS PhysicalCnt, Sum(MentalEmo="yes")*-1 AS MentalEmoCnt, Sum(Cognitive="yes")*-1 AS CognitiveCnt, Sum(Vision="yes")*-1 AS VisionCnt, Sum(Hearing="yes")*-1 AS HearingCnt, Sum(Multiple="yes")*-1 AS MultipleCnt, Sum(AdvocacyServe="yes")*-1 AS AdvocacyServeCnt, Sum(AssistDevServe="yes")*-1 AS AssistDevServeCnt, Sum(ChildServe="yes")*-1 AS ChildServeCnt, Sum(CommServ="yes")*-1 AS CommServCnt, Sum(FamilyServe="yes")*-1 AS FamilyServeCnt, Sum(HousingServe="yes")*-1 AS HousingServeCnt, Sum(ILSkillServe="yes")*-1 AS ILSkillServeCnt, Sum(InformationServe="yes")*-1 AS InformationServeCnt, Sum(MentalRest="yes")*-1 AS MentalRestCnt, Sum(MobilityServe="yes")*-1 AS MobilityServeCnt, Sum(PeerServe="yes")*-1 AS PeerServeCnt, Sum(PersonalServe="yes")*-1 AS PersonalServeCnt, Sum(PhysicalRest="yes")*-1 AS PhysicalRestCnt, Sum(PreventiveServe="yes")*-1 AS PreventiveServeCnt, Sum(Prostheses="yes")*-1 AS ProsthesesCnt, Sum(RecServe="yes")*-1 AS RecServeCnt, Sum(RehabTech="yes")*-1 AS RehabTechCnt, Sum(CounselServe="yes")*-1 AS CounselServeCnt, Sum(Therapeutic="yes")*-1 AS TherapeuticCnt, Sum(TransportServe="yes")*-1 AS TransportServeCnt, Sum(YouthServe="yes")*-1 AS YouthServeCnt, Sum(VocationServe="yes")*-1 AS VocationServeCnt, Sum(OtherServe="yes")*-1 AS OtherServeCnt, Sum(Newsletter="yes")*-1 AS NewsletterCnt, Sum(EventFlyer="yes")*-1 AS EventFlyerCnt, Sum(VFIBrochure="yes")*-1 AS VFIBrochureCnt, Sum(WaiverInfo="yes")*-1 AS WaiverInfoCnt, Sum(Survey="yes")*-1 AS SurveyCnt, Sum(Other="yes")*-1 AS OtherCnt, Sum(Advocacy="yes")*-1 AS AdvocacyCnt, Sum(SkillTraining="yes")*-1 AS SkillTrainingCnt, Sum(PeerSupport="yes")*-1 AS PeerSupportCnt, Sum(Deinstitutionalization="yes")*-1 AS DeinstitutionaliztionCnt, Sum(ReferralPAS="yes")*-1 AS ReferralPASCnt, Sum(ReferralVFI="yes")*-1 AS ReferralVFICnt, Avg(MinSpent) AS MinSpentAvg, Avg(CallerAge) AS CallerAgeAvg FROM PersonalInfo WHERE (((PersonalInfo.CallerCounty)=[Forms]![CityStateCountyForm]![CmbCallerCounty]) AND ((PersonalInfo.CallerCity)=[Forms]![CityStateCountyForm]![CmbCallerCity]) AND ((PersonalInfo.CallerState)=[Forms]![CityStateCountyForm]![CmbCallerState]));
It says: "This expression is type incorrectly, or it is too complex to be evalutated. Try Simplifying the expression by assigning parts of the expression to variables."
Does this mean I can not do it all in one query, or how do I assign variables. Sorry I am kinda new to access. Thanks for the help.
I have an autonumber field set up as long integer. The field just reached the value of 32670 and I get the overflow message. I thought a long integer could be much bigger than that before running into that problem.
I got around it by re-creating the field and starting from 1, but would rather know why it's doing it so I don't have users without their system.
I am using Access 2007 and trying to set the BackColor property of a text box on a form using VBA Code in the Form_Open event with code like this:
Me.txtName.BackColor = <some global variable>
Here's the thing: In order to get the correct color numer, I first pick my desired color from the palette to see its value. In this case, a very bright red comes up as #ED1C24.
In Access 2003 and earlier, this value would be represented as a long integer, not a Hex. So, my question is how to get the HEX value converted to a long integer??
The BackColor property is supposed to be a long integer data type, but that is NOT what the design interface is presenting to me!
Why did Microsoft change the BackColor property of form and report objects from long integer representation to Hex?
I'm sorry if I'm asking relatively simple questions. I'm a break/fix guy, and our in house programmers told us it would be 6 months before they could help us out, so we're tackling this chore ourselves.
We have a database of company names along with corresponding contact information. Each company has at least one associated id number. One company may have several numbers, but each number is unique. A very simple creature. I'm using a combo down box to allow the users to search by company name. This box only pulls the distinct company names. There is also a second combo box that has every id number. These are the only two methods used to navigate through the form.
How can I set up these two boxes to "track" each other? Right now, if I select a company name, the id number box doesn't move to its corresponding entry, and vice versca. How can I set these two boxes up to follow one another as a user navigates?
Our second problem might be a little more challenging. Like I said, each company may have more than one id number. We would like to set up a query that would pull all of the company id numbers when a user selects a name using the above drop down box and insert them into a text box.
The scenerario is the following: I have a table that keeps information for weeks about some files (e.g: if the file has been sent). Then I have another table with information for days in a month (the data for every day).
What I should do is: Check wheter the week has been sent, if it has been sent, I have to show the data for every day of that week in a report. Only for one month... and I can't figure out how to build that query...
I guess I should do something like: select week from weekTable where week=week and sent=TRUE set rcset=db.openrecordset(sql) if(not rcset.eof)then 'build in here the query to select the data I need from the month table end if
but i can't figure out how the loop would be for 1 month...
I have an Access form linked to two SQL tables, I had to make a change to the field length/datatype of a field named notes. The form now tells me that the "text is too long to be edited" whenever I try to add data to that Notes field in my form. I went from char to nvarchar... how do I fix this?
Hi, i'm not sure if this should be posted under queries or forms... i have a series of combo boxes in a from based on a query. each combo box needs to display options for characteristics of each section of a motor (ie. combo box for 'Corroded' = 'slightly', 'very', 'not at all', combo box for 'dents' = 'none', 'top', etc) my table structure works like this: i have a parent defintion tbl that defines the list of combo boxes (i.e. 'corroded', 'dent', 'rub marks') and assigns then and ParentID number that links to the tbl:InfoObjectDefinitions that defines ALL the possible characteristics ('slightly', 'very', 'not at all','none', 'top') and assigns them an ObectID number. So in a nutshell, i can pull the possible numeric options (OID) and text values('slightly') for 'corroded' from the table InfoObjectDefinitions according to 'corroded's PID. I then store the OID in the column for 'corroded' in tbl:Repairs. so i need to create a form that lets people add/edit entries in the repair tbl using the text values and not the id numbers. i can create a query for the form, that joins the repairs table and the InfoObjectDefinitions table, and substitutes the numeric values from the repairs table with the text values in InfoObjectDefinitions but then the comboboxes arent editable???? (the combobox expands, and i can see all the text values but cant select a new value) The SQL that created my query 'repairFormTest' is: SELECT Repairs.FENumber, Repairs.Corroded, (select otext from InfoObjectDefinitions where pid = 17 and oid = Int(Corroded)) AS CorrodedTxt FROM Repairs; and the form places the field CorrodedTxt as the Control Source of the combo box with 'select otext,oid from infoobjectdefinitions where pid = 17' as the Row Source. And as i mentioned, the box lokks right, and expands correctly but i can select another value. Any help appreciated, i really stuck..... Thanks, Vauneen
I have written a bit of code in a Microsoft Access 97. The code basically creates a Microsoft outlook message. I am trying to add in the message that I want to display in Outlook by using the MyMessage ="" command. But the message I want to add is too long to fit on one line of code - I get to the end of the line and can no longer type any more! I have tried to add the second part of the message to the next line but all I get is an "Expected line number or label or statement or end of statement" error message. I think this might be because access keeps putting a " at the end of the first line - every time I remove it and add the " to the end of the second line it keeps adding it back to the end of the first line!
I'm having problems Using Dcount function, when I use it with a text field like the following it works fine: (but using a Surname as a criteria can have problems.... I've people with the same surname in my database...)
times = DCount("[Surname]", "Booktoscore", "[Surname] = Forms!Teachers!Surname.value")
But, If I try to use it with a number, then it doesn't work, the problem seems to be with the criteria.... Because Access don't show me any msgbox with errors....
times = DCount("[IdCandidate]", "Booktoscore", "[IdCandidate] = Forms!Teachers!IdCandidate.Value")
Hi all, I have a table that has a long date format for example 05/05/05 02:40:34 AM how can I add an 8 hours to the date and time. Please help if you can because I"m going nuts!!! thanks. I want it to look like 05/05/05 10:40:34 AM
I have on MS Access database.which was working fine untill now but suddenly it started this strange behaviour. When i open it it opens without any error but stays in the frozen state for like 5 mins means i cant do any thing or i cant click anywhere.
and after 5 mins it starts working fine.Does anyone have any clue abt this strange behaviour.