Anyway To Avoid Scrolling Across Screen For Subforms?

Mar 25, 2006

Hi guys

i really hope this is possbile...

i want to have one form, that relates to about 70% of the data in one table. however, the remaining controls will be coming from 3 other tables. i cannot for the life of me figure out how to create a form that will display these controls for all 4 tables on a single page.

every attempt i make with the wizard makes me the form with 3 subforms that the user has to scroll across the page to use. i need to have all my controls pretty much lined up on the page without moving horizontally across the screen to enter data

ive tried creating a form by dragging the fields into it in design view from the primary table, but i cant see how to include (or drag) fields from my other tables into this form

does anyone know of a solution to this problem?

thanks

View Replies

Expand List Box 'on Enter()' To Avoid Scrolling

Oct 28, 2004

Is there a code for event procedure OnEnter() that allows me to expand my list box so that i can see a list that's larger than the size of it. I was hoping to multiple select from the list and do it at a glance because my list is very long.

View 1 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).

Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.

Thanks, everyone has been a great help in creating my first Access program.

View 3 Replies View Related

How To Link Subforms To Other Subforms On An Unbound Form

Feb 4, 2006

I forum could someone tell me:

I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.

When I try to link them it says you cannot link items on an unbound form.

regards in advance
Peter:eek:

View 1 Replies View Related

"Do Not Show This Screen Again" : Splash Screen

Aug 1, 2006

Hello all,

I have this splash screen, which welcomes all the users. It has an OK command button that exits the screen, and a checkbox that says "Do not show this screen again". I still do not have the code behind the checkbox. Thus I was wondering if there is a way where I could entirelly close or "get rid" of the splash screen until the user loggs in again. Because right now there is no code behind it, so everybody that checks it and click OK, leaves the screen. But they can still open it, if they select the "splash form".

View 11 Replies View Related

Scrolling

Dec 10, 2004

Does anyone know why with some combo boxes, when I grab the scroll bar and haul it to the bottom of the records, after I let go of the mouse button, the scroll jumps back up to around the middle of the combo box? Then, I have to keep pulling it to the bottom several times before it finally gets to the last record.
Thanks

View 1 Replies View Related

Should I Avoid Memo Fields

Jul 18, 2005

I've read on this forum that memo fields can be a spot of bother. I only saw this after I put several memo data types in my tables. I wasn't going to do that much with them; it was intended as a electronic scratch pad of sorts for the user. Where does the trouble arise from with them? Should I just leave them or should I change them to text fields with 255 chars and hope that's good enough?

scratch

View 1 Replies View Related

How To Avoid Duplicate Data

Apr 28, 2006

I have inherited a 5 table database which is associated with membership details and all tables are linked via the membership number which appears in every table..eg
Main Register
membernumber, surname, forename, age etc etc etc
Home address
membernumber, address1, address2, address3, postcode
Business address
membernumber, company name, address1, address2,etc etc etc
Subscription
membernumber, grade, subscription, bank account, etc etc
Training
membernumber, college, results, etc etc

I am informed that it is bad practice to have duplicate data in multiple tables (ie. membernumber field) as updating the data item would be difficult (eg. if the members number needed to be changed for any reason). If this is the case how would I restructure the tables but maintain the link through the membernumber?

I am fairly new to Access....as you can no doubt tell.

View 4 Replies View Related

Requery? Need To Avoid Duplication!

Dec 14, 2006

is there a way that I can compare the ID number from a combo box selection and a table... in order to avoid duplicating that same entry?

ie
If me.cbo1.column(0) = [table name].[field] then
me.cbo1.column(0) and me.cbo1.column(1), etc... = vbWhite

End if

What I am ultimatly trying to accomplish is a way to get rid of one selection in a combo box after it has been selected once and used for another record. is the .requery a better method... if it is, can someone please elaborate on how to use that a little more.

View 2 Replies View Related

A Different Scrolling Issue

May 18, 2006

This is not an other post about disabling the mouse wheel in access application but an other issue that is starting to really bug me...
Some of my forms have a continuous subform, I can normally use the scroll wheel to go up and down the different record in the subform BUT i have noticed that if there is just a small amount of record in the subform (let's say three for example) when I scroll down the different records, they disapear in the detail header frame of the subform and only the last record is visible which I guess I don't mind to much. What annoys me is that if I scroll back up nothing happens the 2 records stay hidden behind the frame and the only way to put it back to normal is to use the scrolling bar on the right of the subform!???
I was wondering if anybody had a similar problem and if there is any solution to it?

View 4 Replies View Related

Mouse Scrolling

Feb 15, 2007

In Access (2003) I was able to (by default?) scroll through records with the mouse scroll wheel. That no longer works. How can I have the form scroll backwords and forwards with the mouse wheel?

I've been reading threads and it sounds like MS "fixed" a feature that I was relying on heavily to move through records. I can't find a way to enable it again......

View 2 Replies View Related

Mouse Scrolling

Jan 17, 2008

Hi,

how can i stop wheel mouse scrolling on certain forms? it is ok on some forms but others where specific data is viewed can be scrolled to a blank space.

Many Thanks,

Nigel

View 4 Replies View Related

Scrolling Down A Form

Jan 12, 2006

I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did not find.)

Thanks

Jamesmor

View 2 Replies View Related

Scrolling Problem

Oct 3, 2006

Hello,

This is kind of ridiculous, but I'd like to get to the bottom of it.

I have a form with a tab control on it, which holds all my controls on several pages. The tab control takes up almost the entire form; there's only a small area of the underlying form visible around it.
For some strange reason, every time I open the form or switch from design mode to form mode, the form scrolls down a bit, on its own, so that my tabs are hidden and I have to manually scroll back up to see them.
Apart from being very annoying, this may also hide the fact from some unsuspecting future user, that there are any tabs at all.

Can somebody explain this, and, hopefully, suggest a solution?

Thank you.

View 6 Replies View Related

How To Avoid From Overlapping Between Times Per Date

Jun 16, 2007

Hi

I need to know how to avoid from overlapping between times per date when the user is isernt a new data.

I thought to use dllookup function but it finds one result but if there is more than one result.

Date Ent Ext

1/1/2007 8:00 17:00
1/1/2007 9:00 16:00
1/1/2007 10:00 15:00

In this case there is overlapping and I need a code that avoiding this situation.

Thanks

View 1 Replies View Related

Avoid Auto Save Record

Mar 6, 2006

How can I avoid the auto save record in Accesses? I want save the record under definite conditions.

View 1 Replies View Related

Avoid Repetitive Values In Several Fields

Nov 21, 2006

I have a table similar to this

table
-----
ID
field1
field2
field3

'ID' is the primary key but I want MS-Access to have an eye on field1-3 to avoid entering the same information into field1-3.

How can I do this?

(Using field1-field3 as primary keys is not desirable)

Please help.

Thanks in advance.

xxyy

View 4 Replies View Related

How To Avoid Duplicates In Append Query

Jun 13, 2005

Hi all,
I have an append query that I run daily and want to append only records with
different OrderID.
------------------------------------------------------------------------
INSERT INTO tblConfirmSchedule ( OrderID, JobCode, JobDate, Status, [Home#],
[Work #], Ext, [Other#], Ext2 )
SELECT Orders.OrderID, [Schedule Info].JobCode, JobSchedule.JobDate,
JobSchedule.Status, CustNew.[Home#], CustNew.[Work #], CustNew.Ext,
CustNew.[Other#], CustNew.Ext2
FROM (CustNew INNER JOIN Orders ON CustNew.CustomerID=Orders.CustomerID)
INNER JOIN ([Schedule Info] INNER JOIN JobSchedule ON [Schedule
Info].JobCode=JobSchedule.Scheduled) ON Orders.OrderID=[Schedule Info].OrderID
WHERE (((JobSchedule.JobDate)>Now()+3) And
((JobSchedule.Status)="Scheduled"));
--------------------------------------------------------------------------

Any ideas?
Thanks in advance,
Emilio

View 1 Replies View Related

Simple Query -- How To Avoid Duplicates?

Nov 28, 2005

View 4 Replies View Related

I Want To Avoid Using DSUM In This Form. Dont Know How!

Aug 15, 2005

I have a form based on a lengthy SQL query.

I have several controls in this form whose control Source has the following formula:

=Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0)

When I navigate from one record to another record in this form, the values in the controls take a looooong time to populate (most of the time they come up as blank and when I move my mouse over that control - the value gets populated....this is slow !!!).

I believe this is happenning because I am using DSUM function all over the form.

What is the fastest way to display this control WITHOUT using DSUM?

Many thanks!

View 4 Replies View Related

Record Locking - Help Me Avoid Further Corruption!

Dec 13, 2005

Ok, here's the deal. I'm tired of fixing our gigantic table because of corrupt records in my firm's database. I find that the problem ordinarily comes up when someone opens the same record in two different forms (whether on the same computer or on a different machine) and both attempt to make changes. Is there a way (preferably simple) to just LOCK a record in a particular table to keep this from happening? I assume there has to be, but I've just never taken the time to find out. I'm not sure if this locking is done on the form level or somewhere in a table option or something.

View 1 Replies View Related

Reports :: Avoid Blank Spaces

Mar 21, 2014

I have the follwing three quantities: category, month and value.so I would like a report to place each value in the corresponding row (category) and column (month).using a cross tab query this is quite easy, and I also managed with a simple query, by placing 12 textboxes in the report and using the iif instruction (iif month-jan,value,null and so on for each month).

now the problem arises when i have two values for the same category but in different months. In this case, the report will place the last value in the line below the previous, leaving a blank space.I'll upload an example asap, in the meantime i try to explain it here below:

.......jan..feb..mar..
cat1 10
cat2 30

View 1 Replies View Related

Avoid Multiple Entry For Foreign Key?

Sep 8, 2014

I have a master to child table relation which is one to many. Each one is represented by a different form.

The problem is, the user enters the primary key "JobID" on the master form, then he needs to enter a few records on the child list with the same "JobID" which is the foreign key in that case. I don't want the user to enter the "JobID" every time he enters a new record in the child form.

Is there a way I can copy the primary key to the foreign key each time the user enters a new record in the child form?

View 2 Replies View Related

How To Avoid Auto-generated Messages Pop Up

Oct 14, 2011

I have the following code (below) that I use to allow the user to select a particular value to determine which records to delete. However, I was wondering if there was a way to avoid having the Microsoft Access auto-generated messages pop up.

For this particular case, after the user selects the value and hits the command button, then a msg box comes up verifying if the user wants to delete the records with selected value. Clicking 'Yes' will then generate the Access message that asks the user again if they want to delete the records and that these actions can not be undone. Clicking Yes here will delete the records.

However, clicking 'No' or x'ing off this Access generated message will then cause a Run-time error 2501. I want to handle this error if it all possible.

Code:
Private Sub CmdRemove_Click()
Dim strQuery As String
DoCmd.Beep
If vbYes = MsgBox("Are you sure you want to delete? Clicking 'Yes' will completely remove all prospects with the selected Class from the database", vbYesNo + vbQuestion, "Delete prospects?") Then
strQuery = "DELETE * FROM [Prospects] " & "WHERE Prospects.Class = '" & Forms("Classpopup").cmbRemove & "';"
DoCmd.RunSQL strQuery
End If
End Sub

View 3 Replies View Related

Scrolling In Form View?

Mar 15, 2006

Hey, just a quick question that I hope someone out there maybe able to help with :-) In form view I don't want the mousewheel to scroll through my records when I use it, Can someone tell me what is the easiest way of turning this option off? I tried editing the [event procedure] in the form properties but it bought up a page in VB which I have no idea how to use. Sorry if that is confusing, basically i only want mousewheel to scroll down the form page that I'm on and NOT iterate through all my records. Any help would be much apprecitated :-) Thanks

View 1 Replies View Related

Scrolling To Keep Current Record At Top

Jun 27, 2006

This doesn't appear to be covered off in any "Scroll" type threads.

I have a continous form with several 100 records.

What I want to happen is when a record is selected it will automatically scroll to the top of the display (this is because my user is computer illiterate and gets confused where they were up to easily).

I can achieve this in Visual Basic but its not pretty.

If the user is scrolling down I can do this in the "On Current" Event by remembering where the previous "Current Record" was and using Command "GotoRecord" to go to the Last Record (so the screen instantly scrolls all the way to the bottom) and the using Command "GotoRecord" Last Record Number + 1 (so the screen scrolls back bringing the desired record to the top).

This works but looks messy as screen flashes a lot.

Similarly if the user is scrolling up (just use go to First Record first instead).

The best way would be if there was a Visual Basic equivalent to what you get when you Right Click on the Vertical Scroll bar where the option "Scroll Down" or "Scroll Up" is available. It would be simple if I could call that!

Any suggestions (apart from getting another user?). Any ideas would be appreciated.

View 2 Replies View Related