Moving Range
Mar 16, 2008
Hi all,
I'm new in this forum and can be considered as beginner in Ms Access. I tried to make a SPC database and currently stuck at calculating the data range for moving range graph.
The question is, how to calculate range between 2 consecutive data and then sum it.
For example:
A, 195
B, 198
C, 196
D, 194
Thus the range between A and B is 3 (198-195), B and C is 2 (198-196), C and D is 2 (396-194). The total range is 7 (3+2+2)
Anyone has the idea?
Thanks.
View Replies
ADVERTISEMENT
Mar 17, 2008
I have a client that wants to enter a range of dates in a query of when they will call that person back. Then they want to be able to type in a range of dates and have a make table query show them all the people that fall in between these two dates....is this even possible???
Ex.
Joe March 3 to March 8
Mary March 4 to March 9
John March 5 to March 10
So if they type into the query March 3 to March 6 all three people should show up because one of the dates specified lies within the parameters they are asking for.....man I am out of ideas
Anyone.....
View 5 Replies
View Related
Mar 21, 2008
I understand with Access 07 we no longer have DAP,s........ Well, I have never moved on of my apps to the web, currently they are on our LAN. Our offices out of town or in different locations access via "remote" hookup. Well, one of the bosses wants to have me develop a new app....but he wants it web based so our other locations and customers can have access to it....... suggestions on which way to go with something like this?
Thanks
View 1 Replies
View Related
Jan 4, 2006
Hi,
I have a delimma and am not sure how to proceed. It falls under the "You want what? When?" category. Basically, I have created an Access program with several (13) related tables and numerous forms. This program mimics an interview we are using for research and has a lot of VBA coding behind it with quite a few skip patterns, value checking, etc. During the testing phase, I was asked to allow the user to be able to go back and check a response to any previous answer at any given point in time. I hear numerous clicks of people running away from this question. This one has me frustrated and not too happy. I am wondering if there is some way I can show a copy of any form and the data contained within it for the present ID? IF it is a copy then the data, I presume would be locked and the user would not be able to change it. Also, I would want to bring the user back to the point where they were prior to going backwards. Feel my pain yet? Of course as I ponder this I can envision that they are going to want to change a value, because maybe a respondent "changed their mind" about a previous question. But, I am sure they would not want to work their way back to where they were, but want to jump back (forward), all the while I need to insure that any skip patterns that may have changed due to a change in data are followed and if a question that was answered before is now skipped then that data needs to be cleaned. I am concerned that as I begin to meander through this issue that I will have "duplicate ID" issues because as I move backward, possibly through several forms and tables and then move forward again the DB will think I am adding two items rather than changing the one. I.e., it will think I have two identical IDs because it already has one from the original pass and as it moves forward and runs through the automated saves that the second pass would represent a duplicate ID, thus crashing the program.
I know this is a multi-pronged question, but I would like to hear some suggestions as to how others with more experience would handle this. I am grateful for your time in reading this and would be even more so for any responses.
Peace!
View 3 Replies
View Related
Mar 6, 2005
I would like a button on my form that will move a record from one table to another. Can anyone tell me how to do this
View 2 Replies
View Related
Jul 21, 2005
Hi guys,
I has a subform in datasheet view. Now when this is loaded I always want to be at the last record in the subform.
I've searched through the forum and am completely unsure of how to do this...
Any hints or tips appreciated :-)
Cheers
View 1 Replies
View Related
Oct 25, 2005
hiya!
i have a database that holds details of calls that have been answered on the phone concerning problems with computers.
details that are recorded are caller name, and date of call etc...
however, i want to know if there is a way that i can move all calls recorded BEFORE the present date to another table ( say a "past calls")..?
is there a button that i can put on my database that will run a function and move all calls recorded before the present date to another seperate table..?
thanks everyone!
johnny
:)
View 1 Replies
View Related
Dec 3, 2005
Greetings,
I have a subform where I can edit data and I have the following code;
Public Sub GotoNewRecord()
If Me.sumtransvolume = me.TotalLitres Then
Me.LabOpNumber.SetFocus
Else
DoCmd.GoToRecord , , acNext
End If
what occurs is that focus moves to a new record not the next record.
I am puzzles by this? Any clues how to fix this and get the control moving to the next record (some subform has 10-15 records)
rbinder
View 3 Replies
View Related
Feb 26, 2006
How do you get the cursor to jump to the next field in a Form?
View 7 Replies
View Related
Jul 5, 2005
I need SQL Statements to use in VBS code for microsoft access that will move the current record being displyed on the form (lets say the table name is called 'old') to another table called 'new'. Also the record that is being moved to the new table needs to be deleted from the 'old table'. All of this needs to be done with the click of the mouse on the 'old' form.
THANKS 2 ANYONE
View 2 Replies
View Related
Jun 27, 2005
Could someone assist me in getting code that allows me to move a record from one table to another when the user clicks a button.
Thanks
View 13 Replies
View Related
Mar 5, 2008
You people are great - lots of help. What I need to know now is --- I input information regarding jobs that we do at my company. I have a customer table, employee table vendor table and invoice table - these are connected thru relationships but the job is eventurally closed. What expression or command do I use to move it to a closed table. I have to keep this information somewhere. Thanks!
View 1 Replies
View Related
Sep 27, 2005
I have had a split data base (version 2000) running on Windows 2000 with no problems. Our office has upgraded the computers to Windows XP Professional Version 2002 and Office Access 2003. I cut the links to the backend and imported the tables back into the 2000 version. I then moved the data base over to the XP machines and everything worked great. I then split the data base and every event results in debug mode. I believe it has something to do with the References but maybe not. If so, what do I need to put in, or take out? Please help. I can provide any information you need.
View 3 Replies
View Related
Jan 31, 2006
I have five text boxes with a separate box for the date that automatically inserts when I enter something in the text box. Is it possible to have it set up to only allow me to enter information in the first box and at a later date when I enter more info in, automatically move everything down to the next box, and so fourth.
Sorry if this is in the wrong section, but I am not sure if this is something simple in the box properties, or if I need code.
thanks
View 4 Replies
View Related
Jun 12, 2006
So I have 2 tables, the first is for "open" orders (where entries get edited changed and deleted), and the Second is for "finished" orders (where once an order is completed it should move from the open orders table to the finshed one where it will no change and will remain for futre reference)
I need help with the transfering part of this problem. I would ideally like to make a form that allows you to pull up the info for the open order then edit it to finally add the finished order to the other table. Im not sure where to start on this one.
View 3 Replies
View Related
Jul 24, 2006
Hi all,
currently on my db it stores data on various projects, and these projects are sorted by a status of on hold, on going, or finished. What im trying do is move only the projects that are finished but still keeping a record of them so we can view them in the future.
i was thinking maybe i could move the finished projects into another db? but not sure how to do, or is there a better way to achieve this?
thank you
View 2 Replies
View Related
Oct 3, 2006
I have a database that I've created for someone else to use. It's split into a front and back end. The user will be placing the front end on her desktop PC and the back end on a network server.
She also will be taking the database home to use from time to time. My problem is that when the database is split, upon opening, it looks for the back end on the network drive, which is unavailable when she's away from the office.
Is there a way to tell the Access to look in a directory relative to the one it's in?
View 1 Replies
View Related
Dec 3, 2006
Howdy,
I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine. Until I tried to open any of the databases. I kept getting the message that they all were read only.
Do I need to bring the database back together before transferring it? I also plan on converting the databases to Access 2003. What precautions should I take in doing this?
Thanks for any and all information you can pass along.
P
View 1 Replies
View Related
Jan 28, 2007
Hi
:) I am creating a program in VB.NET with an access 2003 database. This program will be in 2 physical locations. This is a program that sells tickets. At the end of the day I need to be able to get that days sales data off the remote location and update the main location with that information. This will be sales totals only. The user will plug in a thumb drive to move the data from one machine to the other. Due to the physical layout and other considerations this is the best option. The only action I want the user to have to do is to place the thumb drive in the USB port and hit the “down load” button. Then on the main location the user should be able to just plug in the thumb drive and hit up load. The database needs to be updated with the data from the remote location. What is the best way to do this?
Thanks in advance.
View 1 Replies
View Related
Mar 29, 2007
Hi All,
I have an Excel file with multiple worksheets using VLOOKUPS betweent he sheets and various formulas within the sheets, mainly basic arithmetic and also ROUNDUP.
I am wanting to transfer all this over to Access so that it can be edited by 2 computers at the same time and I need all the formulas to go with it. What's the easiest way to do this? I'm not a very experienced Access user and basically have no idea how to put in formulas in Access.
Any help would be greatly appreciated. I am happy to email to the excel file to anyone who wants to take a look.
Thanks,
Michael
View 7 Replies
View Related
Dec 27, 2007
All -
I am experiencing an issue with the following code. The code works fine, I'm just not sure where to place it on a subform in a Tab Control to ensure that all validation is done before the user can move to another tab.
Any ideas what event I need place this on? I tried the BeforeUpdate and it popped up first error box, but then proceeded onto the next tab that I clicked.
Thanks!
'Enforce required fields on a form
Dim ctl As Control
For Each ctl In Me
If ctl.Tag = "Required" Then
If IsNull(ctl) Or ctl = "" Then
MsgBox "You must complete all required fields to continue", vbCritical, "Required Field"
ctl.SetFocus
Exit Sub
End If
End If
Next
'All fields are validated, now set ctl to essentially being unbound
Set ctl = Nothing
View 2 Replies
View Related
Jan 3, 2005
There is probably an easy answer to this but I can't find an exact answer searching.
I have an Access 2000 database with the back end stored in a separate location. If I want to move the back end data file to a different location on the computer, how do I change the link (file path)?
The only way I can figure out is to delete all of the old links and relink them from their new location.
Isn't there somewhere that you can just change the path name to the entire back end in one easy step?
Thanks for any help.
View 8 Replies
View Related
Oct 11, 2005
I am exporting a table to a text file using a specification. Comma Delimited, no text qualifier. Now, I don't know if this makes a difference but the file is decent size (over 1000 records). The data within each record is exporting fine (about 78 fields) however, I have what is a major problem.
About a third of the way in the exported file are 70 records that have exported 60-70 records too early. Those 70 records are in order themselves but they just somehow jumped the gun(if that makes sense). This is a big problem because this file is going to be uploaded to the mainframe.
Just as an FYI the only VBA I have in my whole database is one pop-up message box. Everything else is run with macros. This one table does not have any primary keys since this is the table the information is oringally imported into and is moved from here. What I want is the information to look like it is in the table.
If anyone has any ideas I would really appreciate it. I'm going nuts and so is my mainframe programmer trying to figure out how we're going to get around this.
Thank you!
View 2 Replies
View Related
Aug 21, 2006
Hi there,
I have a simple database with a form that displays the contents of a table called Products. I want to be able to delete items from Products but these should be move into ProductsArchive table and I will then create a seperate form to view Products that have now been removed but were once currently live if that makes sense?
I would like to write some code that on the form when the user clicks on the delete button it will just move the data relating to that record into the ProductsArchive table.
Can anyone help?
View 3 Replies
View Related
Feb 21, 2007
Hey guys,
I'm trying to move a group of fields to a new table. I want the data to follow it. Is there an easy way to do this?
View 5 Replies
View Related
Nov 28, 2006
Hi again
I have a table that’s full of records, I want to split it into 2 separate tables (identical structure but they have input masks), The input mask is set to LLL0000 all I want to do is send valid records to one table and invalid ones to the other.
I think the best way would be an update query but it doesn’t check the input mask only the validation (and trying to break the string apart using an expression is impractical and lengthy)
Can anyone think of any way of splitting this table – I’m getting rather desperate now and have been trying for over a week with no success
Any help is greatly appreciated
Thanks
Matt
View 3 Replies
View Related
