Pulling data from 2 columns
I am planning to develop a database to monitor th stove production.
I have production table contains 2 fields, called From No. and To No. Since there are a number of pieces of product produced on daily based. eg. I have 100 pieces, every piece needs a unique serial number. If I enter the first serial number into From No. field and last serial number into To No. field.
My question is that: is it possible for access to pull out those serial numbers in a range from those fields and pace them in either query?
Does anyone have a clue
Validation on identical text question
I am working on a database where there are three fields named "Meeting Reason 1," "Meeting Reason 2," and "Meeting Reason 3."
The information in three fields is identical, that is to say, that I created a drop-down list with that information. The users want the ability to list 3 Meeting Reasons, and I don'tthink that Access has the capability to eliminate the options that match when the user selects the first reason, and then the second reason.
Example: Choices for the field are: "Planning," "Production," and "Party."
If I select "Planning" for the first field, I can't force Field 2 to have a drop-down with that choice gone. Field 2 will still have the same four choices.
Therefore, I decided that I would create a Validation Rule. My hope would be that the user could select any option for the first field, but if they selected the same option for the secondfield or the same option for Field 3 that matched 1 or 2, they would get an error (or Validation Rule) message when they tried to save/exit the record.
Example: User selects "Planning" for Field 1, and "Planning" for Field 3. That should invoke an error and an error message.
Duplicate field(s) and move to new record
I am buidling a 10 day planner. I'll try to explain as simple as possible.I have a Planning table (with field'sm PlanName, StartDate and Issues) This Planning table would tie to an Issues table (id, IssueName, IssueDescription, Status).
Here's where I get lost. When I create a new Plan (or another record in the Planning table), I want it to copy any Issues that do not have a Status of Complete to the new Planning record.This way I can keep issues active but still go back and see what was on previous Plans.
Unique data to a report?
I have this query.
SELECT [Print Production Input Table].[Project Name], [Print Production Input Table].[Print File Name], [Print Production Input Table].[Machine Envelope Count] AS [Envelope Count]
FROM [Print Production Input Table]
WHERE [Print Production Input Table].[Print Date] Between Forms![Print Production Input: Envelope Count Report Form]![StartDate] And Forms![Print Production Input: Envelope Count Report Form]![EndDate];
NOW, say in the report that this query is a part of, I want a Project to only be listed once with a calculation of the envelopes from the various Print File Names that are a part of the particular Project Name. Right now, it prints out the Project Name over and over with each Print File Name. I want to condense that
AVG BETWEEN DAYS
Within my qry I would like to calculate the average daily production for the month. The data I'm working with is: production volume,) and ID number. I'm working with tons of data that have production for each day of the year dating back 5 or more yrs. However I'd like to narrow my daily data to only 6-months prior summed up to monthly data and averaged.
Create multiple records/fields simultaneously
I am extremely handicapped in Access 2010. I am currently trying to create a database for a small company I am interning in. One of the things I would like todo is to update or create multiple fields in different tables simultaneously.
To explain, I have two tables, Production Activity in CY 2012 and Production Activity in $ 2012. Both tables have a field "Date of Activity." In addition to some other fields, ProductionActivity in CY has a field "Actual Production in CY" and Production Activity in $ has a field "Actual Production in $".
Now I had initially created two forms, each dedicated to one table, however my supervisor wants to use only one form to update both fields.
SQL Database connection error
I'm not sure if this is the correct spot for this thread so here goes.
I created an access project using link tables to a SQL development database. I finished the project on the development side and need to connect to production database. I created the SQL user objects on production database, validated that the user can connect directly to database via SQL Enterprise manager. Created ODBC connection on my laptop and tested connection. Modified Global module for the SQL connection for the VB code to point to production database. Open the access project that now points to production database, typed in login credentials to receive user cannot login to database.
What else do I need to modify to point the access project to production database?
Totals from Subreports
I am trying to create an oil/gas report focusing on monthly adjustments. Here is the table structure of my database:
Each "Well" has many monthly "Production Entry"
Each "Production Entry" can have many "Adjustments"
I am trying to create a report that will resemble the following, but I am unable to get my totals to work:
Production Date, Production Amount
Adjustment Date, Adjusted Amount (negative value to zero entry)
Adjustment Date, Adjusted Amount (positive value for new entry)
[Total of Adjusted Amounts]
[Total of Adjusted Amounts +/- Production Amount]
Access IFF Statments not working
this statement to generate N/A if both fields from the tables are Null. Here is the Criteria I wrote:
IIf(IsNull([CPC_Old].[Project released for planning Actual]) & IsNull([CPC_New].[Project released for planning Actual]),"","N/A") & IIf([CPC_Old].[Projectreleased for planning Actual]=[CPC_New].[Project released for planning Actual],"No","Yes")
The output I'm getting is Yes if they both fields match, No is they are different.this is working.but it appears that if both fields are null then it defaults to Yes.
I'm creating an issue tracking database. This will track issues I'm having on multiple production lines. One of my fields in the issue table is what production line the issue is occurring on. Some issues can occur on multiple lines though. I set field in the table as a list box that will allow multiple values, on my form is there a way I can have the production line selection appear as radio buttons or check boxes? and still have them linked to the table
How do I get an updated table structure into the production back end?
I have a split database. I updated the main table by adding two new fields/columns. These fields/columns were placed at the end of the field definitions. This update caused updates to be made to most forms, queries, and reports. So far this has been done only in the development copy of the database.
How do I get the development-area updated table structure into the production back end without messing up the production data?
Showing Graph of Prior Days Downtime
Somewhat new to Access so please bare with me.
I am trying to show a Graph on my main form of all of my production lines with the total hours of downtime from the day before. However I have two issues . . .
# 1 I do not know how to add the amount of total downtime per each production line in my table. I have four production lines with all downtime calls being entered into the same table. I have a downtime start and a downtime stop column in my table. And multiple entries could be entered into the table numerous times a day. How do I add the total hours of downtime in my table, per production line, for my graph?
# 2 How do I then generate a graph on my main form? And how will it only know to show the prior days downtime
is a sub query required here?
I have my query set up with calculated fields like so:
PARAMETERS [First Date] DateTime, [Second Date] DateTime, [Shift] Text ( 255 ); SELECT Main.[Mth/day], Main.Shift, [Run Hrs]*[Actual Lbs/hr] AS [Gross Production - LBS], [Scrap Lbs 1]+[Scrap Lbs 2]+[Scrap Lbs 3] AS [Scrap Produced - LBS], FROM Main WHERE (((Main.[Mth/day]) Between [First Date] And [Second Date] And [Shift]=[Main].[Shift]));
what I'm trying to do now is calculate the net production by subtracting the two calculated fields [Gross Production - LBS] - [Scrap Produced - LBS] AS [Net Production] and I need to Sum the date range I input because the final data must display a full month or a quarterly summary. not sure where to go from here.
Access Databases with new Office 2010
I have a question to make. I have a production server that is a file server, holds shares and some databases in access 2003 format. (mdb or mde) files. We added a new WS2008 server and want to move the shares and databases in it. We are going to install Office 2010 professional in it. Are we supposed to have any problems? Users in the company will still use office 2003 suites in their pcs. Do all the users need to update to office 2010? We are planning it, and we will do it some day eventually but I want to ask if users with office 2003 can open the network database on the server with office
I need to make a database that records our employee hours and production results on a daily basis. At the end of any given time period, I need to be able to pull up employee hours and production data for a variable period of time.
I've created tables and made a form to where a user can add new employees to the database. I need to make another form that uses the employees entered into form 1 (add new employee) and lists them in form 2 (enter employee hours) with a text field behind each employee name for inputing their hours.
Criteria for date and time
The production DB table has field called DT_AND_TIME_SCHEDULED and the data is stored as:
5/9/2007 1:30:00 PM
I cant change the format of the table field because it is our production DB.
So if Im looking to find any records that are scheduled anytime on 11/15/2011 what would I put in the criteria for the DT_AND_TIME_SCHEDULED field in my query?
Order Planboard Mdb
I uploaded part of my database where I scheduling orders in frmmain
These orders I can plan on a machine during a certain date and time
if I have done that on my frmplanboard I can visualise this order on a planning grid. So far so good. Now I trye to Add some information
about my order when I click on the grid /color. Problem its not displaying the right Order just the last input order
Maybe someone can help me with this thing. I am struggling with it for a
long time now. My Production planner database is ready, and its looking
great only this is missing.
So steps frmmain Input order Customer references adding on order,
those referenses I try to visualise by clicking in my frmplanboard
Any ideas, sorry did not had time to change up all the language in English in frmmain.
Query or VBA
converting a production code into a date. The production code consitis of 4 numbers. Not sure if I can use a query or need to use VBA.
Eg, 0029 = 29/01/2010
The first number represents the year then followed by 3 numbers that represent the day number
Return 13th month of data.
Entity | First Production Date | Oil
1 | 1/1/2011 | 500
1 | 2/1/2011 | 450
1 | 3/1/2011 | 575
1 | 2/1/2012 | 400
1 | 3/1/2012 | 500
I would like to return the Oil data for the 13th month from the date of first production. So in the example case above, I would need a query that would return the Oil data for 3/1/2012.There are thousands of entities and the First Production Date is never the same.
Unusually Large .accde File
I created a database for a department in our company to track the projects they work on (15+ users). In order to protect the data and design, I split the database and also created an .accde file for production that the staff use from a shared location.
Today, I noticed that the production .accde file was unusually large at 128MB. My back-up .accde file is 3.3MB, so I tried using that to overwrite the production db, which worked; however, the file size increases back to the 128MB once someone opens it again. The back-end (_be.accdb) file is about 5.6MB and my database pre-split was only 31.3MB.
The database has been in use since the beginning of 1st quarter and I've never seen this before. Any ideas why this might be happening