How To Bin Continuous Data Set In SQL
Apr 12, 2012
Okay, so I have a large dataset of almost 700,000 records. The field of interest is a continuous variable that ranges form about 3.3 to 5.6, a very high resolution (i.e. high decimal precision). What I would like to do is write a query that will create a column that will take the value in this column, determine which one of forty-six bins (with a bin width of .05) that it belongs in, and simply displays a bin number in the column. So, for each of the 70,000 records, in addition to the original continuous value, it will also have a value in the new field somewhere between one and forty-six describing what bin it falls in.
Due to the high number of records and bins I cannot thing of any manual way of doing this that would not take a very long time.
View Replies
ADVERTISEMENT
Sep 8, 2005
I have a continuous form based on a query.
I''ve added a combo box unbound, and the problem is that any data I enter in any cb are repeated in every record.
Any ideas how to avoid that?
View 2 Replies
View Related
Aug 5, 2013
I have a continuous form that is populated from a query. The header has data entry text box for NCR#. I want to run a update query to have the header update each record found in the query.
I've tried a number of things and the closet thing I've got is the header entry updating every record. Something is wrong with my criteria but I'm not sure what.
View 1 Replies
View Related
Feb 26, 2015
For the report in question all data is taken from one table named "Completions ". The fields I will be using are as follows:
Code:
[Surname]
[Firstname]
[Branch]
[Quarter1_A]
[Quarter1_T]
When the records are added, the Branch is added using a combo box. There can be several rows of data with the same Firstname and Surname but with different Branches.The report layout must look something like this.I have tried using DLookup to select the data based on the data in the Name text box, but this just gets the first result and duplicates it.
View 2 Replies
View Related
Apr 10, 2014
I have to design a table i know its piece of cake.
Here i want user to continous form which wil be once in a month
needed is
EUR USD From To
User will enter the line with values and the period with valid dates.
Since its a continuous form i need user to fill all the details compulsory, as user cannot close the form without it.
View 2 Replies
View Related
Dec 11, 2013
I have a continuous form it has a field (DateStart) and a field (DateStartCarryOver). There is an event on (DateStart) for the (DateStart.Value) to be passed to a new record in (DateStartCarryOver).
My probem is that the new record dosent get saved (i.e. it dosent get an ID so a record isnt created. How can I create that record once the data has bee pased to it?
View 3 Replies
View Related
May 18, 2013
I have a continuous subform that displays lots of questions. This specific form has 10 questions on it. Each question has one answer and the users are required to select one answer for each question. I am trying to do some data validation before the data gets saved to my table to ensure that users have answered all the questions. I found some very useful code online and tweaked it to suit my needs. The validation works perfectly on subforms with only one question, as I have some other tabs that use it.
On the specific form that has the issue, the validation works as expected when no question has been answered, but when a user answers only one question and leaves the remaining nine questions blank, the validation does not work. I guess it is as a result of the continuous form repeating the different questions and ms access thinking that the data entered for one question alone is complete when it actually isn't.
Code:
Private Sub Ctl4_frm_Staff_Exit(Cancel As Integer)
Dim ctrl As Control, EmptyStr$
For Each ctrl In Form_subFrm_staffQuestion.Controls
If InStr(1, ctrl.Tag, "Required") > 0 Then
If IsNull(ctrl.Value) Or ctrl.Value = vbNullString Or Len(ctrl.Value) = 0 Then
[Code] ......
View 1 Replies
View Related
Nov 21, 2006
I have a main form with several continuous subforms. Each subform consists of several listbox controls. I would like to require the user to select an item from the listbox before being allowed to move to the next record in the subform, and upon reaching the last record in that continuous subform, to require an entry there in order to move to the first record in the next cont. subform.
As an added bonus, it would be nice, though not necessary, to automatically jump the focus from one record to the next after data is entered. But my basic goal is to avoid skipping records.
Caveat: I cannot use the "required" option in the field to which the control is bound because that field has a default value previously entered using an append query. (The default value basically means "not yet entered" and is not one of the options in the listbox. I am using this because this field is a foreign key in the table, thus it must have a value in order to have a record with which to populate the subform.)
My apologies if this has been asked and answered elsewhere, but I've searched and, while I found a few related threads, they don't quite answer my question. Here they are for reference:
http://www.access-programmers.co.uk/forums/showthread.php?t=38364
http://www.access-programmers.co.uk/forums/showthread.php?t=69047
http://www.access-programmers.co.uk/forums/showthread.php?t=103176
Thanks for any help! Also, if you are going to recommend VB code, could you be specific about how and where I should use it? I'm not afraid of code, but I'm definitely new to it...
View 7 Replies
View Related
Nov 28, 2013
I'm trying to populate a listbox from a recordset. I will explain what I'm trying to achieve.
I have a (continuous) form with some data from a table. On the form header I have a listbox, showing all (distinct) customers from that form.
The user is able to do some filtering. That all works great. But I want to populate the listbox with ONLY the customers on the form AFTER filtering.
One way I thought might me the solution was using RecordClone. But I'm stuck there. It must be something simple for an expert. I'm not entirely a newbie, at least not to VBA. Is there an easy way to refer the listbox' recordset to the actual recordset on the form?
View 1 Replies
View Related
Aug 9, 2005
What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.
when I put the subform within a subform, access comes up with the following message:
************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.
You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************
which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.
does anyone know of a way around this?
what about Access2003 does it allow this?
help much appreciated.
Steve Ferry
View 8 Replies
View Related
Mar 8, 2012
I have a Traits table that has fields TraitKey and Trait and I'm looking for the subform to show one record for each trait so that I can give the employee a score for each trait.
I'm trying to save that score in an EmployeeTraitScores table that has the fields EmpID, Trait, Score.
If I bind the subform to the traits field, the continuous form shows each one properly but then I don't know how to save to the scores to the EmployeeTraitScores table.
If I bind the subform to the EmployeeTraitScores table then it can save a record but I can only get the Dlookup to show the first trait.
View 3 Replies
View Related
Mar 31, 2005
I have a continuous form which I have placed a unbound text box. For some reason when I place a value in the box it duplicates the value in all the correponding records! Any ideas why!!
View 1 Replies
View Related
Feb 26, 2006
I have just created a new continuous sub form within a main form to display bookings of a particular date. The date field is in the main form, when updated, the data in the sub from updates. Before this, I was using a list box, however I changed to a continuous sub form since I wanted to have conditional formatting.
Now I'd like to have the option to choose a row of data from the sub form and then enable/disable a command button on the main form depending on certain critera...i'd like to know what is the best way to let the user choose a particular row of data...
i have thouhght of a command button or a option button, but it seems that the control wouldn't have a unique identity pertaining to the row..
any ideas appreciated..
many thanks..
View 2 Replies
View Related
Aug 24, 2006
I have a contiuous subform on a main form that i use to enter multiple products for a price check.
I am using Dlookup to pull the description and other details into their respective unbound textboxes on the subform.
The problem im having is that when i enter a partno into the text box on the next line it changes the description and other details on all the lines.Is there a way to stop this or any other way of adding multiple product lines.
Thanks in advance.
View 1 Replies
View Related
Oct 14, 2006
I have a form where I'm entering data relating to each inbound shipment such as date of arrival, vessel name, etc...however i'd like also to enter invoice numbers and values that cover each shipment. one shipment can have more than one invoice. this means that for one shipment i need to enter , for example, 10 invoice numbers and 10 values.
I thought abt having two tables...one table having the shipment data and another table that keeps the list of invoice numbers/values of the shipments (having a foreign key relating to the shipments table).
now...i have an issue on how i'm entering the invoice numbers/values on the form..since the number of invoices might vary with each shipment...i thought abt having a continuous form...i set up one with two unbound fields...invoice number and value...but as soon as i enter data on one row, all the rows become with same value. any feedback on how should i approach this issue?
am not quite sure at what stage would the data in the continuous data be appended to the table..i'd like to have it save to table as soon as a command button in main form is clicked..
appreciate feedback....thanks! :)
View 14 Replies
View Related
Aug 27, 2006
Hi, thanks.
View 1 Replies
View Related
Apr 21, 2006
Hi all,
Is it possible to have a Continuous form that is a pop up.
Any ideas.
Many thanks
View 1 Replies
View Related
Jun 19, 2005
The problem is that I have a recordset Rosters.
Fields are ShftDay, A, B, C
The ShftDay is distinct field.
I have continuous form mapped to this recordser.
This continuous form have 4 text boxes, each is mapped to one of the recordset fields.
The user can edit these fields.
What I want to do is when the user enter the value "Na" in one of A,B or C textbox, I want the backcolor property of this textbox to become pink.
What I face is that for example if I enter the "Na" value in the A textbox, all the cells of the A textbox are converted to pink. What I want is only the cell in the edited record, not all.
Please Help Me.
View 3 Replies
View Related
Aug 18, 2005
I have a subform in continuous mode which has a list of people. I have created an unbound field which has a dlookup into a telephone number table.
What I want to happen is for each person in the list to have their telephone number displayed (not recorded - just displayed) on the form alongside their name. On a single form this works fine, but on a continuous form it displays the same phone number on all the rows (presumably the first person in the lists number).
Can anybody advise how I can get the dlookup working for each record in the continous form.
Thanks in advance,
Adam.
View 14 Replies
View Related
Apr 19, 2007
Thanks for reading another one...
I am building an application for my marketing dept. that will track their mailouts. So far I can handle it; however, they want a thumbnail displayed of each piece of creative. I can do this if they only wanted to see one record at a time, but they want all records w/in a certain date range and the pic that goes with it. I am currently storing the path to the image so not to gorge my db to explosion.
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
where pic is the thumbnail. I have built it with a continuous form so I can display all the records but I am up to change if needed.
I have read other posts and they all deal with single forms and the onCurrent event is not really working for me.
Any and all help is greatly appreciated!
View 10 Replies
View Related
Nov 4, 2007
Hello,
I want to add a command button to my form that enables me to sort all records on the form into a Word document using mailmerge or automation as a "Purchase Order". This Word document will be saved with the name of the Order, then i will try to add another fonction to send this "purchase order" as an attachement with outlook.
The main problem is that I couldn't merge records on the continuous subform including details about the Order: items, quantity,price....
Please note that I'm a beginner on Access and this is my first project.
Thanks again, any help is highly appreciated,
Best Regards.
View 1 Replies
View Related
Feb 8, 2005
Okay. I am trying to build a form where I could get information like this but also editable. It can be either bound or unbound with enough information to update the records. I could do this several other ways but would prefer it just like it is below. Any ideas is greatly appreciated. Sam.
REPORT_NAME_1
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_2
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_3
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
View 1 Replies
View Related
Feb 10, 2005
Hi All - It must be the early hour or something, my brain is dead.
I have a continuous form of Pharmacy items that belong to a specific customer. At the end of each row I have a TickBox.
I have a button that prints a report on the form and when it prints the report I want the TickBoxes to then be ticked automatically. When I put the code
Me.Tickbox = -1
it just ticks the first item and not all the tickboxes.
How can I get it to do the rest? (I have searched but found nothing yet of help)
Col
View 1 Replies
View Related
Feb 16, 2005
I have a continuous form setup that has a check box field (Yes / No) I also have a command buttom to preview data. How can I code the command button for each record so that is the check box = No then the command button is not visible. I had code in the on open but it seem to either make the command button visible for all records on invisible for all.
Jim
View 5 Replies
View Related
Mar 7, 2005
Hi
I have a form and a linked subform which are linked by Purchase Order Number. When items have been delivered on the purchase order, the user should update the continuous subform with the number of items that have been delivered. This works fine.
The problem I have is using an exit button that does not save any of the changes to either the data in the form or the subform. It doesn't matter if there is a prompt to alert the user that there have been changes made.
I have been messing around with DoCmd.RunCommand acCmdUndo in the on click event of my exit button which kind of works when changes has accidentally been made, but is very unsophisticated - any ideas?!
Thanks
Georgina
View 1 Replies
View Related
Mar 22, 2005
I have a continuous form, which is used as a sub form in a main form. How can i put some code on a control which will work only, if the focus is on the last record (the event i would like to use is onKeyDown). I have tried using:
if Me.CurrentRecord = acLast Then ....
but to no avail.
Any suggestions please ?
Thank You
View 6 Replies
View Related
