General :: How To Make Records Automatically Scroll From One Record To Another
Jun 27, 2012Is there a way to make records automatically scroll from one record to another?
View Replies
ADVERTISEMENT
How Do I Automatically Make A Set Of Records Based A(some) Main Table
Nov 28, 2007Hello people,
I have for some time now been fooling around with a database to keep track of several clinical trials
Basicallly I have made 4 tables..2 which defines the project ( Project and visist), 1 that populates the projects ( patients) and 1 that bind the patients visits to specific dates ( appointment)
The trouble is that im Lazy :D and therfore dont want to enter the appointment data for all patients one at a time each time we get a new guniea pig since all thats diffferent is the dates he/she has to show up.
Im hoping for some way to fill up my appointment table based on patientID and projectID alone.
SO this is my 4 tables... ( some unimportant fields left out)
Project
ProjectID (PK)
ProjectName
ProjectDescription
Patients
ProjectID(FK)
PatientID(PK)
PatientName
patientScrnr
Visits
ProjectID (FK)
VisitID(FK)
VisitName
VisitPrice
DaysToNextVisit ( integer)
Appointments
VisitID(FK)
PatientID(FK)
AppointmentDate
AppointmentID ( PK)
The idea is to create a project and then add a set amount of visits to the project ( days when they have to come and get a blood sample taken)
All patients involved in the project is likewise added in the Patients table and joined to a project.
Since the patients all have to come to a fixed amount of visits ( determined by the project) I was thinking I could make a form where I pick a patient from a combobox
(select projectID,PatientID,PatientName) and then automatically generate a record for each visit in my Visit table where Visits.ProjectID = cboPickPatient.ProjectID
and show them in a subform so I can enter the date they have to come. I hope that makes sense. ( preferably I would like to add the date also by just entering the first Visit date and the using the DaysToNextVisit to make the other visit dates or each patient, but thats a whole other problem :o )
My instinct tells me I have to do some sort of loop code but I havent figured out the details.
Can any of you guys lead me in the right direction before I loose all my hair in frustation??
This seems to me to be a pretty simple problem-making a recordset based on a projectID and the visits involved in that project but im just out of ideas:confused:
Kind Regards,
Brian Bj
Modules & VBA :: Text Box Automatically Scroll Down To Last Line
May 24, 2015I have a textbox on continues form which contains multiple lines and I d like to set it up so it ll be scrolled down completely when it displays the form. I ve already found a few so called solutions but nothing worked for me.
View 5 Replies View RelatedGeneral :: Move A Record To Another Table Automatically
Sep 18, 2012Using access 2003, i would like to add a button to a form so that when clicked all the data in that record is moved (cut and paste) to another identical table, like archive.
View 5 Replies View RelatedGeneral :: How To Create A Database That Updates Records Automatically
Jul 1, 2015I want to create a database that keeps track of contributions of members of an association. Every member can voluntarily give a standing order to contribute a fixed amount every month. A member can as well decide to review his/her contribute.
how I can come up with a database that can automatically add the contribution of a member monthly without manual input since the stated contribution is known. So that I can run a report for individual member and the report can capture the every monthly contribution that has been added automatically and shows when ever a member changes his/her contribution amount.
General :: Fill In Date Automatically When New Record Is Created
Dec 18, 2012I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.
View 2 Replies View RelatedGeneral :: Automatically Show A New Blank Text Box For New Record
May 5, 2013I would like to input data into textbox and it will automatically open up a new blank textbox for another data.
View 3 Replies View RelatedGeneral :: Records Using A Select Query That Is Sending To A Make Table
Feb 25, 2015I have records using a select query that I am sending to a make table. I would like to have those records excluded from being used again for 180 days, at which point they can be used again. Essentially, I have an ID and an email address which gets stored in the Make Table. I would need to ensure that if we send an email out in Week 1, we do not send an email again for another 180 days if there is activity from that same ID. On day 181, the ID/email address can then be resent.
View 6 Replies View RelatedGeneral :: Text Box On Form - How To Make Textbox Date Default To Previous Record
Nov 13, 2013I'm having trouble with a Form and getting a text box entry box (Date entry) default to the date entered on the last record, which is linked to a table.
The only way I can get it to work is to type the date into the Text Box's Default property, for example, #11/13/13".
How to get the correct syntax or code into the Default property of the Text Box to make this work? I only want the entry to change versus the previous record/entry if the User changes / enters a new date.
Record Scroll Loc
Apr 19, 2007When I am filling data in a form, I will use my scroll button on my mouse to go to the next field. Instead, it takes me to the next record. How can I prevent from going to the next record? Thanks!
View 1 Replies View RelatedForms :: How To Make A Popup Go Away Automatically
Jan 20, 2015I had used a form to come up as a popup, and on that popup, the person can chose a report to go to (button). Is there a way that once they chose the button they want, to make the popup to go away automatically?
View 11 Replies View RelatedGo To Next Record By Scroll Wheel
Oct 30, 2011in a form i type my information and want go to next rocord, there have a few way for this task like create a button or .... but i want use scroll wheel for go to next rocord, is it possible? if yes how do it?
View 3 Replies View RelatedHow To Make Associated Label Not Automatically Show With The Field
Aug 21, 2013I'd sure like to drag fields from the field list onto a report without a label automatically showing with it. I have so many fields to deal with the time just to click it gone adds up.
View 2 Replies View RelatedForms :: How To Scroll Down Mouse With Record
Mar 15, 2014i have a continuous form used for selling item , i want when the user selling item the scroll mouse working with the current record look the attachment to see how to fix the problem .
View 2 Replies View RelatedModules & VBA :: Scroll Listbox To The Top - No Selected Records
Apr 23, 2014I'm using the following code to clear selected records from a listbox after a button is pressed:
Code:
For i = 0 To lstProducts.ListCount - 1
lstProducts.Selected(i) = False
Next
The code works great except that it leaves the listbox scrolled all the way to the bottom. What is the best way to scroll back up to the top of the listbox without selecting another record?
Forms :: Cannot Scroll Back To See Previous Records
May 2, 2013I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries.
View 9 Replies View RelatedForms :: Subform Scroll Bar Scroll To Bottom?
Apr 25, 2013I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?
Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub
General :: Access Form - Scroll Box Does Not Bring The Selected Value Up
Sep 18, 2013I have added a scroll list to my access form and although I can see the item I need to pick in the drop down list when I manually start typing it, the scroll box doesn't bring the value up and states that the value I have selected is not in the list (when it clearly is !!)
View 10 Replies View RelatedGeneral :: Scroll Wheel Doesn't Work In Only One Table
Jan 11, 2013happen- scroll wheel stops working in one table- the rest you can scroll in as usual? I know there can be issues with scrolling when you're missing some driver for your mouse, but this happened all of a sudden to just this one table, so I can't imagine that it's the mouse missing any drivers. I did compact/repair, restarted, and also tried repair of office installation. That table still won't allow scrolling unless you move the scroll bar manually first.
View 3 Replies View RelatedHow To Stop The Scroll Button On A Mouse From Going To Next Record On A Form
Mar 10, 2006I have a form that opens to a NEW record, all fine and grand. there are a few drop down choices, and modern users are using the scroll button to try to move up and down the list in the drop down boxes, but this action actually tries to move to the next record, causing an error as fields are blank etc (which is fine) but its confusing everyone.
the nav buttons are not shown on the form, so what can we do to stop the form trying to goto another new record?
the form is opened using a macro, where the action is OpenForm (view=form, data mode=Add and window mode=Normal) GoToRecord (record=new).....
General :: Unable To Disable Mouse Scroll Wheel On The Form
Apr 24, 2014I'm trying to disable mouse scroll wheel on the form but no luck here,
View 1 Replies View RelatedForms :: How To Scroll Through Records In Access 2010 With Mouse Wheel
Mar 6, 2015I want to scroll through records in Access 2010 forms with the mouse scroll wheel.
View 10 Replies View RelatedForms :: Make Frame Automatically Adjust To Image Width And Height
Aug 7, 2013Is it possible to make it so that whatever the dimensions of the image i paste the OLE object's frame will also be the same? I'm having a problem, not necessarily a problem more like a preference, I'm inserting pictures of each individual inside a database and whomever last took these pictures didn't make sure there was a standard size So all the images are different sizes and when they're put inside the OLE frame you can see the image inside it but the frame itself also shows its white background because the image isn't the full dimensions of the frame. I was thinking if it's possible to make the frame automatically adjust to the image's width & height.
View 3 Replies View RelatedWay To Make Access Be Able To Store Software Versions And Product Keys Automatically?
Dec 4, 2014Is there a way to make access be able to store software versions and product keys automatically? Programs I am most interested in is like Microsoft Office suites and Adobe Acrobat and Photoshop and whatnot like that. I am not sure if this is even possible but I am trying to get my database fully functional with all the data and efficiency I can for at least 5 people so that I can try to sell access as a better tool than the service they are using now.
View 4 Replies View RelatedForms :: Record Selectors - Quick Scroll Option No Longer Available?
May 13, 2015I have recently updated several forms from Access 2003 to 2010.
On the old version I could 'hold down' the forward or backward pointers to quickly scroll through the individual records. Now I have to click each individual record to move one at a time.
Have I inadvertently changed a setting or is the quick scroll option no longer available?
General :: How To Divide 1 Record In Multiple Records
Nov 12, 2013I have an order table
order nr quantity.
100 110
and a pack table
pack quantity
1 1
1 2
...
1 25
2 1...
I want to make a query that returns this :
order nr pack quantity
100 1 25
100 2 25
100 3 25
100 4 25
100 5 10