Setting Function For F Keys In A Form
Sep 4, 2005Where do I go to make the F keys perform a particular function when moving around in a form, like "go the the last page of the form" or move to the top, or to page two etc. Thanks.
View Replies
ADVERTISEMENT
Tables :: Setting Primary Keys To More Than One Field In Table / But They Cannot Have Null Values
Nov 30, 2012Access 2010..One organization that we work with provides us with a block of numbers for each of the two types of contract products we order from them; we do order non-contract stuff from them also.The block of numbers are the same (i.e. 20000 to 30000 this year) for each of the two products. This means that each product can have the number 20000, for example. We call this the Tracking Number. If it is one of these products, we need to select the Contract Number.
For all other one off orders we have with them, we assign our own Tracking Number starting with 00001. This Tracking Number cannot duplicate unless it is one of the aforementioned two products.Both the Tracking Number and Contract Number are in the same table. The user selects the Contract Number from a form (connected to the Contract Number table that has all the details on the contract) and the Contract Number is populated in the same table that has the Tracking Number.Each order must have a Tracking Number (no null)..Not all orders need a Contract Number (null okay).The Tracking Number and Contract Number combination cannot duplicate.I tried setting the primary keys to more than one field in the table, but they cannot have null values.
If not... I have been working on Plan B.... an AfterUpdate on the form (either the form or a field... don't know yet) that looks at a query that only has results if there are duplicate values.
Using Function Keys
Sep 1, 2004How can I use function keys to get it to do a constant thing throughout all my forms etc. e.g. to nominate eg "F3" to save data or "F5" to go back a page etc.
View 2 Replies View RelatedModules & VBA :: Create Disable Alphabetic Keys Function Based On Case Statement
Jul 31, 2015Details:
I have a Profile form that tracks the expiration date for each client's various certifications. These dates are set up in the Short Date format in the table design of Access.
Problem:
When a user accidentally presses an alphabetic key while updating an expiration date, an Access error message is triggered. This is confusing to my users as these messages are written in Access lingo. I would rather that nothing occurs at all. I wrote a case statement to disable each letter of the alphabet and applied it to the On Key Down Event for each expiration date control on my Profile form to solve this problem, but this must be applied to 28 separate controls. I would rather call a function that disables alphabetic keys for each date control in my form when called.
Questions:
How do I transform my Disable Alphabetic Keys Case Statement into a function that I can call for each expiration date control? I know that when writing a function certain variables have to be declared and/or initialized.
Also, will I need to create a function to re-enable alphabetic keys or is this unnecessary because the disable alpha keys function will only be called for specific controls, not the entire form?
What I Have Tried:
I have tried copying and pasting my Disable Alphabetic Keys Case Statement into a module to attempt to create a function, but it needs work.
Below I have included 2 types of code:
(1) The original On Key Down code applied to each date control on my form
(2) The same code written as an attempt at a function
Original Profile Form Code to Disable Alphabetic Keys in the On Key Down event for each date control
Private Sub txtCert1ExpDate_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
'All message box text is for me to test the code, not for the user to see
Case vbKeyA
MsgBox ("you pressed the A key")
[Code] .....
Forms :: Setting Button OnClick Properties To A Function
Feb 3, 2015I am try to open a form from another and set a button's OnClick properties to a function and I keep getting an error message..Run-Time Error 2450Cannot find the referenced form ..And this is the code I am using.
Case 113
DoCmd.OpenForm "frm_View_Defects_On_Screen", acNormal
Forms!frm_View_Defects_On_Screen.RecordSource = "qry_1st_Adv_Report_Combination_111"
Forms!frm_View_Defects_On_Screen.btn_Back_to_repor ts.OnClick = JumpBackToAdvancedReport()
I just don't want to create another form just for one button.
Forms :: Creating Hot-keys On A Form
Sep 5, 2013I have a tab control on a form, and I want to use "Hotkeys' to get from one page to another (or more specifically, to toggle the visibility of the pages).
So, I set up the tab control with the pages I want hidden set with visible=No. Then I enable the Form.KeyPreview, so that the form will get a chance to look at all the key presses.
Lastly I have a Form.KeyDown handler, that looks like this:
Code:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
MsgBox "Key pressed (1): Shift value is " & Format(Shift)
' Detect Hot-keys for the pages in the MultiPage wizard, and make them Visible or not visible
' P/D/X/S/R/H/C
If Shift = acAltMask + acShiftMask Then
[Code] ....
This is early on in the design iteration - more will happen with the pages, but this is an easy way of reviewing various aspects of a project.
So what happens?
I put a breakpoint at the first If statement, and sure enough, it picks up the Ctrl key or the Alt key, whenever they are pressed. (I need to use the mouse to clear the msgbox, naturally!) When I press both of them (Ctrl/Alt) I get the required value of 6, but I never seem to get to the second msgbox. In addition, if I comment out the first message box, I also never seem to get to the second msgbox (ie the point where the combination has been detected.
KeyDown obviously has to fire for each component of a HotKey combination, and the Shift parameter has been shown to be cumulative. The only thing I can think of is that somehow I need to turn off keypress processing somewhere else (Used to be possible to use Cancel to do this, I seem to recall).
Forms :: Any Way To Disable Hot Keys At Login Form
Nov 16, 2013I have a fully functioning frmLogin that appears when the database opens. After correctly logging in, it takes you to the appropriate switchboard. The problem is that I set autokeys to allow F1 to automatically open the switchboard, but I don't want users to hit this to bypass my login screen. The reason for keeping the switchboard open is to force the user to close the database using the switchboard(eventually I want to limit the user to only the forms that I have created in a split database).
My other option that I tried first was writing a module that would detect when all forms are closed, then open the switchboard. But I kept getting Error91 and got frustrated/stopped attempting this method. Using the hotkey gives the user a similar functionality, but less conveniently so(since its not an automated process, etc.).
One Primary Key + Multiple Foreign Keys...help Creating Form With Option
May 4, 2006I need some help creating a simple datebase to store my documents and other knowledge objects. There are two types of
knowledge objects I need to store: Documents and Questions/Answers. For this reason I have created three tables: Index,
Question, and Document.
The problems I am encountering is that the ID field in the Index Table is the Primary and relates to the ID field in the
other two tables. So basically when I am entering information it can either be a question or document. I want to create a
for so that when its a question that I am entering it records the information in the question table and when its a document
I am entering it records the information in the document table.
I'm a beginner at using access and don't know VB or SQL. Any help would be appreciated.
Table Structure
Index Table
ID (Primary Key)
Link
Type
Source
Reference
Question Table
ID (Foreign Key)
Question
Answer
Document Table
ID (Foreign Key)
Title
Summary
Notes
Forms :: Setting Focus To Control On Single Form Side Of Split Form
Jun 24, 2013When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.
Code:
If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If
Any way to set the focus to the single form Side of a split form?
Forms :: Setting Form Properties From Another Form Gives Nothing?
Aug 23, 2013So I have two forms: Af and Bf
In Af, when a button, Abtn, clicked, it'll run
Code:
Me.Visible = False
DoCmd.OpenForm "Bf", , , , acFormEdit
Forms![Bf].Form!Blabel.Caption = Me.Atxtbox
Forms![Bf].Form!Bcombox = Me.Atxtbox
Then Af lost from view and Bf appears in form view, with Blabel and Bcombox show the value of Atxtbox.
BUT if I try something like this in Bf when an event happens
Code:
Me.Bcombox2.RowSource = "SELECT xx FROM tablexx WHERE yy = '" & Nz(Me.Bcombox) & "'"
Nothing will be shown in Bcombox2, because Me.Bcombox return Null. I know this from doing
Code:
MsgBox Me.Bcombox
and the message box will shows nothing. The same thing also happen with the Blabel's caption. In form view, it shows Atxtbox value, but when I accessed its caption's value, it returns Null.
What I wanna do is:
1) Open Af, insert value to Atxtbox
2) clicked Abtn, pass the value of Atxtbox to Bcombox
3) Af is closed, and Bf is opened
Why the null...?
Setting Up A Pop Up Calendar In A Form
Apr 18, 2006I need to include a pop up calendar in a form - could someone please point me in the right direction about how I go about doing this?
Also, I'd like the day to be selected and shown automatically when a date is selected - does anyone have any idea how I could do this please?
Any help would be much appreciated.
Thanks in advance
Setting A Combo Box Value From Another Form
Feb 18, 2005I have a form with a query based bound combo. The same combo can be found on another form which can be launched from the original form. I want to update the combo on the original form with the same value as the combo on the launched form (after update).
In my after update event I have the following code;
[Foms]![form1]![Combo1] = Combo 2
This doesn't seem to work (I don't get an error but Combo1 doesn't update).
Any ideas?
Setting Up Form To Allow Decimals
Mar 23, 2006I need to have a field on my form to accept the user keying in the number in this fashion: 200200.1234 but as I currently have it set it accepts only the 200200 portion of this part number. I am a beginner so I am sure this is an easy question for some of the pros out there.
As a footnote the table design has the bin no. as data type - text and I added an input mask of 000000.0000;0; the field on the form is a combo box. Maybe that will make a clear picture for you.
Thanks in advance for your assistance.
Setting Form Properties...
Jul 6, 2006I have a form that is intended to be used for both data entry and to edit/delete records.
The form properties are set to:
AllowFilters = YES
AllowEdits = YES
AllowAdditions = YES
AllowDeletions = NO
DataEntry = YES
When a user opens the form from a menu they are given the choice for NEW, EDIT or DELETE.
If the user chooses NEW, the properties remain as above
If the user chooses EDIT or DELETE the form should open to a specific record as chosen on an interim form.
I have been using the following code to open the form for EDIT:
stLinkCriteria = "[fldID] = " & Forms!frmsearchresults.fldID
DoCmd.OpenForm "frmJobInfo", acNormal, , stLinkCriteria, , acFormEdit
However, the form continues to open in Data Entry mode.
I have a public variable that is set to NEW, EDIT or DELETE that can be used to trigger code...
Where should the form properties be set to make sure that the form opens correctly?
Any help would be appreciated.
Thanks!
Setting Default Value Within Form
Jul 25, 2006Hi, im new to the forums - this is my first post.
On a form i have a text box which holds the date that a file batch was taken to be processed. Each file holds the date of when the batch it originated from was taken. At the moment for ease of use the 'Default Value' of the text box is set to the batch's date.
I want to set it up so i can change the default value of the cell, so that when a new batch is to be processed the new date becomes the default value.
I am invisaging a button which brings up another form with a text box into which the new date can be put. when the form is saved and closed, the date recieved cell on the master form assumes the new default value.
gawd... methinks that was an awful explanation.
please help!
Setting Form Sizes
Nov 17, 2004Hi,
I am a new member, who has been reading these postings for several weeks, hoping for a few quick answers, but no luck.
I have several issues on form size.
The first is that some of my forms open OK, but they change the form size of the form that opened them. My main form is maximized. When I open a child form, not maximized, the main form, and the open Access windows, such as the DataBase form and any open Tables, Queries, Reports, etc all become non-maximized.
The main form has the dimensions of the last-opened form .mde files, which leads me to believe that there is some Access option that crosses project or database lines. I cannot find it.
If I maximize the main form with the child form open, Access maximizes the child form also. If any form is open in Design View, the Properties window may be on top of everything. As the controls I need are seldom visible in these small windows, I spend much effort resizing windows.
What do I need to do to have a maximized "Switchboard" and smaller child windows/Forms???
Setting Query Value From Form
Nov 11, 2013I am trying to access the same query/report from different forms. For example I have a StudentAttendanceForm where users select a StudentID and then open the report. The query criteria for ID# is [Forms]!
[StudentAttendanceForm]![StudentID].
Can I access this same report from an event on another form. I'm thinking that if I can some how assign the StudentID from the form I want to access the report from, to the criteria on the StudentAttendanceReport Query, this is possible.
I am new to code but I am thinking something like:
SET [StudentAttendanceQuery]![StudentID] TO [StudentEnrollmentForm]![StudentID]
Open StudentAttendance Report
The StudentEnrollmentForm is the other form I want to access the report from
You may need a crystal ball for this one. Let me know what other info you need.
In general I am finding I am copying and tweaking queries to meet specific user needs. For example some want to access a single student and other need "batch" reports.
Setting The Right Shape Of A Form?
Sep 25, 2015When I am working on the Lesson 37 shown here:[URL]
I get to the point
Click the label that was added to the subform and press Delete (to remove the label). You may also need to move the subform and resize the tab sheet.
Now I assume the label to be removed is the original title of the subform or sbfVideos. That is the label that must be removed. It also says "You may also need to move the subform and resize the tab sheet." I will say that you do. My tab sheet is about 2 3/8 inches in width. I want to move it so the width increase to 3.25 as shown in the figure in the tutorial right after it says that you need to resize tab sheet.
When I grab the far right orange line and pull to the right the whole subform moves! That is not what I want.I merely want to increase the width of the form as I said above.Also in this narrow initial file when I switch to form, it cuts off parts, usually the Length. Of course, that is not what I want.
Opening A Form And Setting Values?
Sep 29, 2006Okay. So, i have this frmProduction that has a cbo box on it, and when i select the value 'sold from field' i want it to open up another form (frmSales) that i have already created. Now, not only do i want it to open it but i want to have some information on frmSales filled out with the values the user entered on frmProduction. I already have it opening the frmSales on the AfterUpdate value on the cbo box (if statement) but i don't know what to do about setting the values of frmSales!
Any help would be much appreciated!
Setting A Password Up Before Opening A Form
Feb 7, 2005Hi and Thank in Advance
Is there a way to set up a password when opening a certain form by clicking a button? Thanks
Setting On-screen Form Size
Jul 14, 2005Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.
View 3 Replies View RelatedProblem Setting A Size Of The Form
Nov 23, 2005Hi guys
In my database I have a main form and depending on the options chosen on this form other forms will pop up on the screen.
I want the main form to cover the whole page therefore in the On Open event I have used the Docmd.Maximize function. The problem is that after this point all the other forms will maximize once they are open! How can I stop the pop up forms from maximizing and make them open in a specific size? What code can I use for this?
Thanks
Setting Focus On A Tabbed Form
Oct 12, 2006What is the syntax for defining the tab that has focus when a tabbed form is opened under various situations?
View 2 Replies View RelatedSetting Default Value On A Form From A Query?
Dec 9, 2014I have a combo box field on a Student Details form that displays the Student's class number. For a new record, I am able to set the default value in the control's Default Value property with a literal in quotes (ie., ="2015-1"). But I want to set the default value from a query field. However, when I specify the query field in an expression ((=[Current Class]![Class Number]), "#Name?" appears in the field when initiating a new record on the form.
The control source for is the field in the Students table ([Students.[Class Number]).
The Row Source is a query of the Class table.
How can I set the control's default to the Class Number value in the Current Class query?
Setting Query Search Criteria From A Form
Oct 30, 2006Looking to be pointed in the corect direction,
having trouble using a text box on a form to set the search criteria for a particular field within a query.
Ideally i would like to enter the criteria in a textr box then click a button which sets the criteria and opens the query results in a report,
I have designed the query but cant which works if you go into the design and enter the criteria. the problem lies with getting the text box on teh form to set teh criteria.
If i use the expression builder to set the criteria to the same value of the "text" within the "text box" on said form the following happens,
If i open the query itself it opens a small window and displays the "expression" that i entered in the criteia box, above the data entry. the query does work this way but dont understand why the expression is displayed???
The text box on the form also becomes locked, not allowing data to be entered.
I have tried to link the query direct to the text box.
also tried creating a table which has data entered via form then linking the query criteria to a field in the table.
Could some one point me in the right direction please
many thanks
Cheers
watson
Setting A Combo To The Record Selected In A Form
Feb 8, 2005Hello,
I suspect this is probably rather easy, but I've not been able to figure it out:
I am using a combo to select a record in a form. This works.
The problem is: When I navigate through the records in the form, the combo box does not "update". I need to be able to change the record displayed in the combo box as the record in the form changes.
Any ideas?
Many thanks in advance for assistance.