I decide I want to make a quick Database to merely keep track of a few job details. My use only mainly. Well the new guy decides that to get in the good graces of the production manager we're going to track all this other stuff with it and make the data easy to enter so anyone can do it. Well apparently HE bit off more then WE can chew. And now it's a matter of US working on this by HIM looking over my shoulder as I muddle my way through this. So now I turn to experts for help....
The Problem:
What I've got is a form that allows me to enter a variety of info on the projects we're doing. Nothing special. What I now need to be able to do is enter time employees spent on this job so we can better track how much each department spent on it. The problem is to enter the time ATM we have to rummage through every person's time sheet on a particular job and add all the times and enter it. This is sort of a grueling task at best and leaves ample room for error. What I'd like is another form specifically for entering the time. Chose the Job # from a drop down menu. Then chose which piece of the job from the drop down menu. From there I'd like to merely be able to select which department, (Also via drop down menu I suppose). And then merely have a box in which you enter a dept time and it ADDs it to the time already in the table for that dept. That way it should be easy to go through one employees time sheet, enter all there times and then go to the next one and have it added to a total dept time value in the table. Probably not overly complex. Merely beyond my limitations in Access.
So as an example.
All the data is entered on the project itself aside from time.
So I want to be able to look at Mike's time sheet and say ok he worked for 2 hours on job # 4434 Unit 3. Pick #4434 from a drop down menu. Have the second menu sort to know that there's only Units 1,2,3, & 4 on Job #4434. (Got this accomplished.) Be able to pick a production department, let's say graphics. Enter 2 hours. And then when I get to Eric's time sheet I want to enter his time on that Job# and Unit# and have it added to that 2 hours giving a total department time. Got that? Any help or insight anyone?
I want to connect an Excel table with an Access table so when I make changes to excel table these changes to appear in the access table and use the access table for my web site. The excel table looks like:
Room Type01/05/06-06/06/06 07/06/06-15/07/06 21/09/06-30/09/0601/10/06-31/10/06 * Standard Single 26 34 * Standard Double 44 59 * Standard Triple 60 80
When I try to connect this table with access I am getting an error reffering to the second line of the excel table where there are not numbers but dates. The access connected table looks like:
Room Type01/05/06-06/06/06 07/06/06-15/07/06 #Number! #Number! * Standard Single 26 34 * Standard Double 44 59 * Standard Triple 60 80
Been using the access database created by a previous employee for a year without any issues. All of the sudden, the data I am entering in the table is not showing up in the query or report.
I have two tables: "Tbl_CM_Project_Details" and "Tbl_CM_Inventory"
that have the data that I am trying to connect with a third table: Tbl_CM_Proj_CMI_Connector.
Tbl_CM_Project_Details connecting field is PK_Project_Num to Tbl_CM_Proj_CMI_Connector field Connecting_Project_Num Tbl_CM_Inventory connecting field is CMI_ID to Tbl_CM_Proj_CMI_Connector field Connecting_CMI_ID
On the form I have a SQL Query where I enter the PK_Project_Num and the CMI_ID Auto enters. What I need is for this information to automatically fill the connecting table so that the information is connected.
I have a query all set up and now I have to add one field from another table in it. I am looking for a date which has the criteria Now() - Last Movement Date. Last Movement Date is the column I am taking from the other table which I just added which is the ZLX02 table. When I run the query, everything but the Last Movement Date shows up. What can I do to get the Last Movement Date to show? Check out the attached pics.
I have a form that shows information on a person (think first name and last name) at the top and contains tab controls that hold subforms each containing a different set of info about that particular person. Ex: for person 1 the main form will display the persons first and last name as well as show the subject tabs. as you click on each tab you should see the information that pertains to that person. I would like to step through each ppeson one at a time using the horizontal record arrows (eventually I will change this process to using forward and back buttons) on the main form with the persons names changing as well as the information in the subforms changing to match the person on the main form. I can step through each separately (main form and each subform) but I cant get the subforms to change information when the main form changes persons. Seems simple enough but I cant get the subform to change when the main form changes. They are not connected. This is for an Access class that I am taking and we use Access 2013.
I want to create a form that has several parts(5), that will direct to 5 different tables(they will all be connected). I want to keep it as one form because if I'm successful it will be easier for people to transition from a paper to electronic form(if the format is similar). I don't want any subforms, I just want to be able to direct the information to different tables.
I have a form based on tblContact with a subform based on table tblCategories, and another subform based on tblCompany. I have a one-to-many relationship between tblCategories and tblCompany, with the pk in tblCategory linking with a fk in tblCompany. All of the fields in tblCategories/ sbfrm Categories are yes/no fields, not sure if that plays into my problem at all.
When a user checks one or more of the check boxes in the categories subform, closes the form and re-opens it, none of the check boxes are checked for that person. I know this has something to do with the relationships and how the categories are linked to the contact... but I can't get it straight in my mind as to how that should be set up.
Is it possible to connect a Document to the Access Database. To have a button beside the field in the form allowing you to browze and connect the document. If not does anyone have a way around this. Any help would be well appreciated.
Hi We have a database implemented in MS-SQL server 2000 on a local machine. I want to use some of tables in my access (or excel) program. Can I link to the table?
I'm having a problem in Access where I'm trying to connect 2 tables together. On one table is all the information of the person, the other table is a list from 1-50. That list is a drawing of all the peoples ID number for a drawing. When I type in their ID next to what order they got picked in is there any way where All of their information comes with that ID number they have? I really need help on this.
Hi there, I'm currently writing an accounting system and i got stuck with this section of trying to produce the account name in a query.
i have four tables
tblPurchase PurchaseID -Number
tblAccounts AccountID - Number AccountName - Text, usually has names like asset, cost of sales, expense, telephone, electricity, etc...
tblItems ItemID, Number AssetNum (tblAccounts.AccountName foreign key1), Number ExpenseNum(tblAccounts.AccountName foreign key2), Number IncomeNum(tblAccounts.AccountName foreign key3), Number
tblPurchaseLines PurchaseNum (foreign key for tblPurchase.PurchaseID), Number ItemNum (foreign key for tblItems.ItemID), Number
My question is how can i generate the query with the following fields:
PurchaseID ItemID AccountName of AssetNum AccountName of ExpenseNum AccountName of IncomeNum
I am aware that the query would produce three PurchaseID's for every ItemID it would encounter for every PurchaseLine.
So, here's my problem: I'm doing a database on my DVDs, and I wanted to add as much info as I can about them. But I have some problems with "actors", as you know one actor can be in several movies and one movie has several actors.
I want to put the actors in their own table and movies in their own. I know how to link them together, but I don't know how to link them together so that actors could be in more than one movie and movie could have more than one actor.
Hope that even someone understands my question since my english ain't so good..
I'm somewhat new to working with ASP and very new to databases, MS Access, and SQL.
What works is opening my .mdb file, which connects through an ODBC DSN to get dynamic data. Nothing fancy.
What I'm trying to do is create a web interface via ASP to access certain data and fields in the db.
Here are the super-noob questions...Do I need a version of MS Access and the .mdb file on my webserver (where the .asp file is)? I don't have the ODBC DSN set up on the webserver (which is linux). Does that need to be done before anything will work?
Let me know if code snips would be of any assistance. Thanks much, in advance!
I work in an office where we do testing with clients . I want to create a database that can create a unique report for each client on the testing results.I envision a database with at least three tables. The first table would be client demographic information with a unique ID field (CID). The second table would be the Appointment information (date, referral source, etc.). The third table will have the test results (although I'm wondering if I should have a table for each test).
Sometimes, we see clients more than once, and so need the ability to have more than one appointment record for each client. For each appointment, we would record test results.I have created a one-to-many relationship between the Client Demographics and the Appointment tables. When I created the form for the Client Demographics, I inserted a subform for the Appointment. That works great. The CID automatically transfers to the Appointment record and instantly connects the two.How do I connect the Test Results table so that the CID automatically transfers to the Test Results record as well as the Appointment Date field from the Appointment Table.
Before we moved webhosting company we could have external access to our MySql database which was great as our MS Access system would periodically pull data from our MySql site (namely customer enquiries which were entered via a form on our website) and dump them in our MS Access live quotes table all automatically.
With our current host (which seems to be the norm from my web-searches) they only allow local access to the MySql system.
My question is, how can I oversome this hurdle without having to move hosting company. I really don't want to move again as it's a real pain.
I'm using flash mx and MDM zinc which i assume connects using the JET rather than ADO database engine.
For the life of me cannot get a simple update to work due to the dates involved, lost count how many hours have gone by trying!!!
Within access I can easily switch quotes and hash symbols and all SQL THREE SQL queries work without problems on my database i.e.
UPDATE UserOverallResults SET Results = 20 WHERE UserName ='Robbie' AND Quizdate= '19/2/2008 12:15'
UPDATE UserOverallResults SET Results = 20 WHERE UserName ='Robbie' AND Quizdate= "19/2/2008 12:15"
UPDATE UserOverallResults SET Results = 20 WHERE UserName ='Robbie' AND Quizdate= #19/2/2008 12:15#
Within the database the fields are defined as :- Results (Integer) Username (Text) and QuizDate (Date/Time) within MS ACCESS DB schema.
in Flash MX TextDate param is a STRING and All parmaters are populated appropriately (see this later in error message).
Example of existing date data stored in database in format "19/02/2008 16:48:11" as a DATE/TIME field.
My code within in flash is :-
mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = " + UserScore + " WHERE UserName = '"+ UserName +"' AND QuizDate = '" +textDate + "' "); I've tried with and without Hashes still no joy ..
mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = " + UserScore + " WHERE UserName = '"+ UserName +"' AND QuizDate = Format( '"+ textDate +"', "#yyyy\-mm\-dd hh:nn:ss#")"); The error message I get from the code above is ..
SQL Query has failed for the following reason: Data type mismatch in criteria expression SQL statement: UPDATE UserResultsOverall SET Results = 30 WHERE UserName = 'd' AND QuizDate = Format('19/2/2008 19:4:35' ,"#yyyy-mm-dd hhnss#")
My text string removes the leading zeros not sure if that would cause an issue or not (its doesnt in MS ACCESS running query) ...
Anyone have any ideas??? Losing my mind here !!
PS I had problems using '&' instead of '+' to concatenate fields.
is there a possibility to connect two different databases??? I mean is, I have a table called PERSON. under PERSON, there are fields called PERSON NAME, BIRTHDAY and ADDRESS. another table is called SEMINARS, under it are DATES FROM, DATES TO and TITLE.
I want to combine one of the records in PERSON to the 5 records in the SEMINARS. is there a possibility to do that???
to include in the information, there are 10 records in the PERSON and there are 75 records in the SEMINARS. and I want to add more records in SEMINARS in any of the records in PERSON in the near future.
how do you connect fields from one table to another? what im trying to do is to connect two fields from product! product id and order details! product id. the one in the order details table should equal whatever i input in the product table.
A school table is there in old and new data base, if i give school key as 001 (which is the column of school table) i need to compare old database school table "001 key" and new database school table "001 key" and if it is not matched it should be displayed. Please give me detailed dicription with example.
I have a little problem: And hope somebody can give me an answer.
I have two tables, one form and on the form I have two textboxes. One of the textboxes should be connected to ONE table and field, and the other textbox to the OTHER table and field.
I tryed to conect through the expression builder but had not much luck! See code below.
This code comes up in the ControlSource property section and textbox also: =[tbl_CompanyContact]![CompanyPhoneNumber] =[tbl_PrivateContact]![PrivatePhoneNumber]
Where do I set in properties the connection to different tables i.e. tbl_CompanyContact / tbl_PrivateContact and where the connection to the field CompanyPhoneNumber / PrivatePhoneNumber.
I want to know if it possible to use MS Excel instead of web application (ASP, HTML,...) that is connected to MS Access and will update MS Access as user update information on MS Excel?
If it possible how I should get started b/c I kind of have a template for Excel. I just need to learn connecting excel to MS Access and maintain them.
I was wondering if someone could try and connect my database to the web. I would like to view the names of the CDs in her collection over the Internet.
I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients.
Our db is Access front end with SQL backend.
My initial thought for the remote office is: High Speed Internet Either CAT5 to each desk or Wireless Access Point 5 thin clients.
Using RDP they should have no problem accessing our network unless they can't all use the same public IP address for our main office.
The other thought is Setting up a Point-to-point VPN. My biggest problem is I havn't worked with thin clients until I started working here. I don't know what I would need at the remote end in order to connect the thin clients through the VPN. They don't want any servers or desktops if we can help it.
Does any one have any suggestion or thoughts on this?
I've just set up my Access on a new PC and now when I try to connect to my MySQL database through odbc, Access crashes without any error messages, just the standard microsoft error reporting message.