Bound Forms Novice
Jun 4, 2007
In the interest of speed in my current project, I'm working with bound forms, where in the past I have developed mainly using unbound forms. Hence, the word novice in my subject line.
Is there a way to do the following, and is it typically done?
The layout: A typical, record by record data entry main form, with a linked datasheet subform. The underlying query contains person's names and other associated data. The subform is a datasheet with an alphabetical listing of the person's names.
My goals (2 of them):
1. To have the datasheet subform go to the record selected on the main form.
2. To have the main form also go to the record selected in the subform.
The forms' On Current events conflicting with one another, as the subform's Current event fires whenever the main form's does.
View Replies
ADVERTISEMENT
Mar 20, 2006
Hello, I am pretty new to Access. I am able to create simple forms that will interact with tables, reports, etc.. I am trying to go a little farther and customize a form that will automatically be displayed when the user opens the file. I have read that you must have 'modal' properties set to yes. I have done this and when I enter then .mdb file, I still see the default menu.
Do I have to write an expression within the properties? And if so, on which command?
Also, I would like to become more familiar with customizing forms. Is anyone familiar with a web based step-by-step tutorial out there that will walk a person through the process? I am not satisfied with the Help menu.
Thanks for the help.
View 3 Replies
View Related
Feb 7, 2005
Hi folks,
I have a form with a regular save record command button, however I also want to add in an action to open a second form based on information stored within the form.
So users may be directed to Form.alpha or Form.beta depending on their data.
Can any one help?
View 1 Replies
View Related
Jun 22, 2007
Can someone help, please?
I have a simple form to add a new record.
Form is
Single
Bound
DataSource is a simple select query which includes all records in a table.
All I want to do is validate what is typed into the textbox.
I have the following code in the BeforeUpdate Event of txtTest:
Private Sub txtTest_BeforeUpdate(Cancel As Integer)
If Me.txtTest = "Test" Then
Cancel = vbCancel
Me.txtTest.Undo
End If
End Sub
It works fine on an Edit but when I type "Test" into a new record and try to move or save I get the error: The value in the field or record violates the validation rule blah blah BLAH.
Why doesn't vbCancel kill this nonsense?
View 14 Replies
View Related
Sep 16, 2005
Hi All,
I have a main bound form which has tabs.On some tabs i m calling the subforms which are also bound forms.
I am facing a problem in which access automatically saves the data eevn if u dont want to save it.In my subforms i have save button to save the data ..i am also doing some validations there
but if the user is filling some information and then he hits the another tab the data gets stored automatically.
is there any event for the form where i can undo if the user has entered some data..
my subforms are continous forms.
Thanks to all for their help.
View 3 Replies
View Related
Mar 24, 2006
Please help,
I have a form with a subform in it. The main form has a combobox, called vendor. The subform shows all software.
When i select a vendor, i want only the software for that vendor to show in the subform.
What I am trying to do is set up the link child fields and link master fields so that this works. However, i am getting an error saying, 'Can't build a link between unbound forms'.
I have checked to make sure that relationships exist between the vendors and Software tables but the problems persist.
What should i do here???
View 1 Replies
View Related
Sep 27, 2006
Hi all,
My current database (built with a lot of help and sample code form this site..thankyou to all for their advice) tracks the escalations we receive into the business but as we have used it more and more I have started experiencing a massive performance issue.
I basically have a main table that captures the basic details, reference, product, escalation source, escalation reason etc, and these are captured from combo box selections (so only capturing the id numebr of the row in the combo box)
My main problem seems to be a table I have that we have linked, via the unique escalationID, that we cna add notes for each escalation.
So for instance a particular escalations can 1 or 50 notes (or more) depending on the work involved to resolve.
This table now has thousands of entries and is about 10Mb on it;s own.
It seems that when I open my bound forms the query is having to scan not only the main table, but also all of the notes in the journal table.
My question is,
Would I be better to -
1 - Use unbound forms and pull the data via a recordset call or
2 - could I use a query that captures everything for only the open escalations and then have my main form query that query or
3 - have the form load but do not link the journal table and have the form pull the data in seperately ?
Hope that makes sense and appreciate any help on this one.
MattP
View 6 Replies
View Related
May 29, 2015
Is there anyway or code to autofill a bound text/combo box for instance with the person who is working the database i have this code but doesnt work with bound boxes
Me![Agent] = Forms("loginform")![cbousername]
View 1 Replies
View Related
Mar 28, 2013
I have tried creating a combo box in a form and as I have gone through the steps, the option to bind each choice that I created in my drop down box for the form is not an option, so how do I make each choice in my drop down box access the report I need?
View 1 Replies
View Related
Mar 21, 2005
I have multiple users entering data on bound forms. I have three required fields, all in the first 3 fields of the form. My question is, can I program something to where Access will update the record, after the 3rd required field, so that other users are not having to wait to enter there new record?
View 1 Replies
View Related
Mar 21, 2005
I have multiple users entering data on bound forms. I have three required fields, all in the first 3 fields of the form. My question is, can I program something to where Access will update the record, after the 3rd required field, so that other users are not having to wait to enter there new record?
View 14 Replies
View Related
May 3, 2013
I have a Main form with several sub forms on it the tables behind each form are related tables. The user enters data on the main form with the exception of one bound control then moves on to enter data on the sub forms On exiting the record or the main form I want to take data from several of the sub forms and add them together and enter result in the bound form on the main form. Because this bound control is not used to enter data in there are no event triggers to code to get this done.
View 3 Replies
View Related
Jun 2, 2015
My code is not working.
1. The code below should equal the Current Month
2. It does not close the form if no data.
PHP Code:
If DLookup("[CurMonth]", "tblEmpEvaluation") = Format(DateSerial(Year(Date), Month(Date), Day(Date)), "mmmm ")
DoCmd.OpenForm "frmEvalNotice"
End If
PHP Code:
If DLookup("[CurMonth]", "tblEmpEvaluation") <> Format(DateSerial(Year(Date), Month(Date), Day(Date)), "mmmm ") Then 'No Data. NotWorking?
DoCmd.Close acForm, "frmEvalNotice"
End If
View 7 Replies
View Related
Mar 15, 2014
There are 3 column in a combo box, ID is bound column
Part no ID Description
0040 1 class 40-1
0040 2 class 40-2
0040 3 class 40-3
0041 4 class 41-1
0042 5
0042 6
When key in part no 0040, 3 rows under 0040 will be listed out only, filter and match as value entered only. do not show others part no in the combo box selection.
View 1 Replies
View Related
Jan 19, 2013
I have a form for student attendance that is bound to a query and stores a temporary value for ClassesAttended in a StudentEnrollment table as faculty enters the attendance. They then run an append query to write the temporary records to a StudentAttendance table. Because the ClassesAttended field is bound, when the form is opened, it recalls the last number entered for that student in that class as entered by the faculty the last time attendance was updated. I tried leaving the field unbound, but the first value enter into the first record of the form is updated automatically to all subsequent records.
Is there a way to change the properities, use code, etc. to assigne a null or 0 to the ClassesAttended field when the form opens, without the first updated record to propagate through the reaming records?
View 3 Replies
View Related
Jul 19, 2006
My goal is to have two combo boxes the first filters the second. it controls the semester that I am viewing. This works if i don't use continous forms but when i do it requeries every record in the form instead of the current record. I am not an access or vb guy but i have picked a lot up. please help!!!
I have attached a copy of my database.
View 4 Replies
View Related
May 22, 2013
I have a form and subform. The main form shows some customer details, and the continuous sub form shows that customer's charity donations.The code below runs when the form opens, and binds ADO recordsets to the two forms. The binding appears to be successful.
However whatever I do I can't make the subform update correctly to show the relevant customer donations. For example, when I use the **'d lines to update the link child/master fields, I get a "Data Provider Could Not Be Initialized" error.
Code:
Private Sub Form_Load()
Dim cn As New ADODB.Connection
Dim rsCust As New ADODB.Recordset
Dim rsDons As New ADODB.Recordset
[code]...
View 7 Replies
View Related
May 17, 2013
I have written a code to look up by the unique reference number rather than use the wizard to avoid this error happening... The field is restricted to list only so you can't actually edit the number.For ease of use you cannot scroll by record and I need to filter by the ID. Is there an easy fix to this combobox?
Would creating a seperate query work? Is there another lookup code I could use where I don't need to have the combo box bound to the ID field since it's not being edited anyway? I had a go at one and although it would now let me select it wasn't updating the record, tried a few ways but it seems that it needs to be bound to the field.
View 5 Replies
View Related
May 12, 2014
I have a list box bound to a query. If the list box retrieves two records, I am not able to select only one of them. If I click, it gets both records selected ( highlighted ). Is there any way I can select only one record?
View 8 Replies
View Related
Apr 17, 2015
I have a form based on a query. I'd like to add a search box to the top to look up values and then populate the rest of the form. I can't do it with the combo box wizard because the relevant (third) option doesn't show up, I assume that's because the form is based on a query not a table.
Any alternative method of adding a search?
View 4 Replies
View Related
May 26, 2015
I have a bound form that normally is opened via macro. Very straight forward just has the following in the where.
Code:
[userID]=[Forms]![Home]![txtSelectUser]
I'm trying to open the same form via doCmd.
Code:
DoCmd.OpenForm "frmUserInformation", , , "UserID=" & Me.txtProblemID
I've msgbox'd the txtProblemID and the correct ID is being passed. Where I fall into an error is on the frmUserInformation's onLoad event which uses the ID form the frmUserInformation.txtUserID box. The error I get is "Syntax error (missing operator in query expression '[fldUserID]='."
Code:
strEndMonth = DLookup("fldDateExpiration", "qryUserExpirationDate", "[fldUserID]=" & Me.txtUserID)
What I've narrowed it to is the timing between the docmd.openform and the onload of the form. I've tried changing the onload to be on activate - and it just opens empty.
how to get the docmd to open the form correctly before the onload tries to fire?
View 6 Replies
View Related
Sep 24, 2014
I have a number of forms that are bound to recordsets as follows:
Dim rs As New adodb.Recordset
sqlQuery = "Select * from myTable"
rs.Open sqlQuery, sqlCNN, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rs
Set rs = Nothing
In Access 2003, users could open these forms and filter on basically any field by using the right click-> Text Filters functionality.
In Access 2010, this functionality appears to work (users can apply the filter and the Toggle Filter button in the ribbon shows a filter is applied), but all of the records are still visible in the form.
Any work-around that does not involve redesigning the form to be non-recordset bound?
View 4 Replies
View Related
Sep 2, 2013
I'm using Access 2007. I've created a table with two fields. "Novice and Recertification" as in combo box.
I put it on the form. Now the idea is when a user clicks Recertification, it shows up on the report. When the user clicks on Novice, it should be empty on report (Reason why I want to keep novice is so that we have a record of it.)
Now the challenge is I added another column, empty field for Novice and Recertification for Recertification. Thing is if I set the bound column, I select on an empty field on form and it will be empty on report. But I want the user to see Novice on the form and it must not show on the report.
View 3 Replies
View Related
Jul 9, 2014
In my form my combo box displays a list from a query called DORP-HDR that has 3 columns
DORP-ID | CODE | NAME
and displays them like that is the drop down list
The form field that the combo is bound to takes the numeric-id field as its value. In the combo control wizard i nominated that value, and in the properties pane bound column value is 1.
and in the properties pane the row source is:
SELECT [DORP HDR].[DORP-ID], [DORP HDR].[CODE], [DORP HDR].[NAME] FROM [DORP HDR] ORDER BY [NAME];
So far so good. I have created lots of combo boxes before like this.
But this time i want the second field in the list (CODE) ALSO bound to another field in my form . So I want the combo to transfer two values not one. How do i do this?
View 4 Replies
View Related
Mar 20, 2013
So I'm not new to Access but I am to 2010. It has been a bit "challenging". Here's my first question:
1.) I'm trying to search on a field by using a command button. I basically want to click the button and the following message pops up: Enter MRN.
2.) When the MRN is entered, I would like the form to filter on all records that have this MRN.
3.) In old versions of Access, I would create a Macro for this and then call the Macro in the form.
4.) I've tried the FindRecord action in the Macro but it does not work. I actually came across several actions that don't seem to be working properly (getting error messages).
5.) In my head, this should be one of the EASIEST things to do. I've done this before in several different databases. I will admit it has been a few years since I have used Access for this (ie. building forms, macros etc.). I've primarly used it to pull in a data set and then run some queries to get the data I need quickly versus using Excel.
View 5 Replies
View Related
Aug 26, 2014
I have a form AddNewEquipment. This is bound to a table, EquipmentDetails.
EquipmentDetails has a Yes/No field, 'ParentChoice'. So when EquipmentDetails.ParentChoice = Yes, I want to open up a new text box, AddNewEquipment.ParentDescr, into which someone can put some text. This text I want to append as a new row in a different table, ParentList.ParentName. (that table also has an autonumber field)
I only want to do the save when I save the whole form.
Is this something like using an On Lost Focus event from the ParentDescr field which only invokes when the overall form save button is clicked? What would I put in the On Lost Focus event.
View 9 Replies
View Related
