Forms :: Passing Value To Combobox On Load? (Access 2010)

Feb 18, 2015

I have a form design where to enter a new "system" (what we call a new group of members) you have to specify the representative (the member that will represent the system).

If the system is new AND the representative is new, then both need to be entered. Typically this will be done through the "New System" form that has a combo box for you to choose the representative (but the representative won't be there!). If the representative is new as well, then the user clicks "Add New Rep" which is located next to the combo box.

This is where things get tricky, I'd like to use only 1 form to load a new rep. My idea was to use an openarg on the docmd.openform method that specifies what the control should be.

Code:
DoCmd.OpenForm "RepresentativeAddNew_Form", , , , , , "System_ID|" & Me.System_ID

That is the code that is called when the user click "Add new rep" and in the on load event I have this code:

Code:
'Use this version if the ID is text
Dim x As Variant
Dim strControl As String
Dim strID As Long
'If parameters exist, use them

[Code] ....

My goal was to pass the value to the combobox and turn it off, that way they can't change anything about it. This was nice because if the openargs is null (there were none passed) then the combo box would be enabled and the user could select the school that way.

But this doesn't work, for some reason, the combo box has NOTHING done to it (I have the control name correct).

Is this due to the way comboboxes work? Or am I missing something?

I should point out that the on-load event was not my idea, I found that online but makes perfect sense. I was trying something similar but was trying to use global variables because I wasn't aware that OpenArgs was a valid control!

View Replies


ADVERTISEMENT

Forms :: Passing Two Combobox Value To Two Textbox In Form?

May 2, 2015

Private Sub CardName_AfterUpdate()
Me.Purchasing = Me.CardName.Column(2)
Me.Selling = Me.CardName.Column(3)
End Sub

I get value of Column(2) in Purchasing textbox but in Selling textbox not why?

View 14 Replies View Related

Forms :: Passing Multiple Values Based On ComboBox

Jul 10, 2014

I have a form where the user will choose a contact name or names from a multivalue combobox and I want the email address field to update with the corresponding emails separated by "; ".

View 1 Replies View Related

MS Access 2010 - ComboBox On Tabbed Layout Appearing On All Tabs

Jan 9, 2014

I am working on fixing up someone else's Access database. There is one combobox on a form with 4 tabs that is appearing on all 4 tabs, though I only need it on one tab. When this field is deleted it deletes from all 4 tabs.

View 2 Replies View Related

Problems Passing Variable From Combobox

Apr 29, 2007

Hi all!

I have a college project were we have had to code a database for a fictional hospital to hold patient, doctor, consultant and appointment information. I am struggling with one particular problem.

I am trying to pass a variable from a combobox of results to another form to display a certain record.

I am trying to send:

stLinkCriteria = "[NHS_Number]=" & "'" & Me![lstSearch].Value & "'" & " AND [AppointmentID]=" & "'" & AppointmentID & "'"

to the form but it fails, yet if I "hard code" the variable it works:

stLinkCriteria = "[NHS_Number]=" & "'" & Me![lstSearch].Value & "'" & " AND [AppointmentID]=23"

Can anybody shed any light upon this please?

View 2 Replies View Related

Forms :: Multi Select Listbox Access 2003 Code Gives Syntax Error In MS Access 2010

Oct 24, 2013

I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:

My code is:

On Error GoTo Err_Command151_Click

' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String

[Code] .....

The syntax error I get in Access 2010 is:

Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'

View 12 Replies View Related

Forms :: Find Hex Or RGB Value For Blue Color That Access 2010 Uses By Default For Buttons On Forms?

Sep 5, 2014

Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".

By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?

View 14 Replies View Related

General :: How To Use Automation To Run Word 2010 Mail Merge From Access 2010

Nov 26, 2013

I have a MS Access 2010 application when the User opens form CONTACTS Form

◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx

View 10 Replies View Related

General :: Possible To Have Value In Excel 2010 Cell Used To Update Access 2010 Database

Apr 4, 2013

Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?

For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.

View 1 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

Forms :: Access 2010 - No RTF For Textbox

Jun 12, 2014

I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.

I have a textbox where the Control Source is set to this field of the query.

The textbox does not display the data correct and I believe this is because it is in Plain Text mode.

When I try to change it to Rich Text I get an error message.

If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.

View 1 Replies View Related

Forms :: Converting 2010 32 Bit Access Form To 64 Bit

Apr 7, 2014

We recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.

View 1 Replies View Related

Forms :: Access 2010 Subform Filtering

Nov 5, 2014

I have not used access since Office 97 so, I see many changes. A while back I used Access to create some minor tracking databases. Now, with 2010 I'd like to modify the database that I am currently using. I have a main form that tracks daily trips or tasking(s). Within the form are two sub forms that track:

1. People assigned to the trip through a combo box; and
2. Itinerary for this trip.

I have been asked to add a Trip justification(s) through a combo box which will have several selections avail that can be chosen and would apply to each trip. These can be added to by double clicking the justification (figured that one out). What I would like the sub form to do for each new trip that is entered is to display only these values as a single selection rather than 12 times (example) if there are 12 trips that have the reason justification as part of the trip/tasking.

I just can't seem to make this work. The personnel one and itinerary one work just fine (previously existing). I just can't seem to get the new one to work. I have checked that the new table is connected through the relationships. In the exact same manner. The new form has the ID (Key) OPID (to link each trip separately) and justification text field.

View 6 Replies View Related

Forms :: Put Password To Open A Tab In Access 2010

Jul 31, 2013

Is it possible to put password for a tab in Access 2010?

View 14 Replies View Related

Forms :: Navigation Forms In Access 2010

Nov 20, 2014

I have a Main (Home) form that has a sub navigation form (frmNavigationSubform).Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form.

Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3.

NavigationButton 2 Navigation Target Name = 1 (frm #1).

NavigationButton 3 has no Navigation Target Name. This is passed on when user picks Option1 or Option2 form options pop screen.

Now I can pass the name to the Navigation Buttons2 but the subform does not show it. I have to click on the Navigation Buttons2 again for it to show. What I want is when the user makes the choice in the options screen the name is passed and form 2 or 3 should load/show.

View 1 Replies View Related

Forms :: Disable Date Picker In Access 2010

Mar 6, 2014

disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field?

View 2 Replies View Related

Forms :: Multi-select Box On A Form In Access 2010

Jul 25, 2013

I am very new to Access (I started two weeks ago). One problem I am having is I have a multiselect box on a form in Access 2010 and I want to base the value of a text box on the user's selection. However I would like the textbox to just be based on one of the choices and to allow the user to select any other of the choices along side this selection. How would I input this into the code?The line of code I am interested in looks like:

If Me.Reasons_For_Choosing_Physics.Column(2) = "No other ideas" Then..Could I add something like "No other ideas" + "(*)" to allow other selections alongside "No other ideas"?

View 4 Replies View Related

Forms :: Access 2010 / How To Retrieve The New ID During Filling The Form

Sep 23, 2013

Access 2010 frontend, SQL-Server 2008 R2 backend

During filling a form, I generate a code which should include the ID of this record.

But the ID is not available before update of the form.

If I save the record before all fields mandatory are filled, i get an error of course.

How can I manage this and get the ID "earlier"?

View 3 Replies View Related

Forms :: Access 2010 - OpenForm Was Cancelled Error

Aug 5, 2013

I'm working with an old database and I am getting this error. I have have access 2010. I starting to receive this error after I unlinked one of the tables.

Private Sub Command9_Click()
On Error GoTo Err_Command9_Click

Dim stDocName As String
Dim stLinkCriteria As String

[Code] ....

View 3 Replies View Related

Forms :: Carrying Information From One Form To Another In Access 2010

May 19, 2013

I have a unique "CustomerID" that is an auto number (this is how I link tables, forms, etc.), and "CustomerNumber", "CustomerName", "CustomerSubNumber" that could be null and could have duplicate values.

The first form I have is a Contact Info form where users will enter the contact information such as customer numbers, names, addresses, phone numbers, etc. This then links to an order form. My order form has a place to carry over the "CustomerNumber", "CustomerName", "CustomerSubNumber" values from the ContactInfo table. I would like these fields to automatically populate based on the CustomerID unique number as well as only show the information for that customer ID (including listing out any previous orders).

View 2 Replies View Related

Forms :: Access 2010 - Creating A New Record In A Subform?

Apr 12, 2014

I am trying to create a database to manage IT assets, most of the structure is done, I'm now trying to get the details done.

The issue I am currently trying to tackle is to get a control button on one form to create a new record in the sub form that sits in the main form via another pop-up form.

So I have :

>PeripheralsViewForm - that has 4 control buttons (Edit Quantity, Edit Description,Add an Item and Exit)

>> PeripheralsSubForm - (Datasheet) which is referenced to PeripheralsQuery

The Edit Quantity and Edit Description open a separate form which allows the user to update only the quantity or description respectively (I have done it this way rather than allowing edits in the data sheet as I feel that it is too easy to hit a key incorrectly and overwrite data in the datasheet view) Both of these functions work perfectly (to my amazement) - I am using the id field in the subform to link to the pop-up form which then has unbound text input boxes, which I then write back to the subform.

e.g from edit button on click event: DoCmd.OpenForm "perquantform", , , " ID=" & Form.PeripheralsSubForm!ID and then from the pop-up form "perquantform" on the "Exit & Save" button I have :

Forms!peripheralsViewForm.PeripheralsSubForm.Form! Quantity = Me.newquant DoCmd.Close acForm, "perquantform", acSaveYes

This allows the user to select the record in the datasheet form and then click either the change quantity or description button.Also also the other reason I did it this way was because I just couldn't get the subform to requery when I had the two edit popups linked to the table or query.

The problem now is that when I click on the "Add an Item" button, it overwrites whatever record is currently selected !

The code I have is this:

From the "Add an Item" button on click action:
DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec
DoCmd.OpenForm "addperform"

And from the form "addperform" - "Save & Exit" button on click action:

Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerType = Me.pertypedrop
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerMake = Me.permakedrop
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerModel = Me.newmodel
Forms!peripheralsViewForm.PeripheralsSubForm.Form! PerDescription = Me.newdescription
Forms!peripheralsViewForm.PeripheralsSubForm.Form! Quantity = Me.newquantity
DoCmd.OpenForm "PeripheralsViewForm"
DoCmd.Close acForm, "addperform"
--------------------------------------

the line "DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec" is what I have added to try to solve the overwrite issue, but when I run this it comes up with the error :

"runtime error 2498 - An expression you entered is the wrong data type for one of the arguments"

I have put this line in the "addperform" exit action and it comes up with the same sort of error.

Using Access 2010.

View 14 Replies View Related

Forms :: Access 2010 - Hide Menu On Startup?

Feb 4, 2015

Well, I made the move and am using Access 2010 now and I am running into a couple issues.

First off, I want to get rid of this menu on startup:

Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using

DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

...in the OnLoad event, but this only works when running the opening form from the form list. When the form runs at startup the menus do not hide.

Also I would still like to have the file menu available because sometimes the user need to access the print menu to choose an alternate printer.

View 14 Replies View Related

Forms :: Access 2010 Not Filtering Dates Below 13th Day

Mar 2, 2014

Why Access 2010 will filter some dates and not others?? When I try to filter 12/02/2014 it will not work and I have to use 12/feb/2014 but if I use 13/02/2014 it is fine...

View 4 Replies View Related

Access 2010 - Modifying Forms In Split Database

May 11, 2012

I have a access 2010 split database and i need to modify one form on the front end (it is an accde file). However, when i open the Front end, i cannot find the possibility to go into the form design mode.

How do i need to do it? do i need to restart from the unsplit database?

The both the front end and the back end are password protected.

View 1 Replies View Related

Forms :: Creating Cascading Combo Boxes In Access 2010

May 10, 2013

I am trying to create a Cascading Combo Box for my Form in Access 2010. I ahve written the code:

Private Sub Combo11_AfterUpdate()
cboCombo13.RowSource = "Select TblAcc.SubFamily " & _
"FROM me.TblAcc " & _
"WHERE me.TblAcc.Family = '" & cboCombo13.Value & "' " & _
"ORDER BY me.TblAcc.SubFamily;"
End Sub

But keep getting the same "Run time error message 424: Object required"

And when I define the error it says "Identifier under cursor is not recognized" (the yellow arrow comes up and is pointing at the "ORDER BY" line.

I would like Combo Box 13 to give me the SubFamilies of the certain Families choosen from Combo Box 11. (Each Family has different SubFamilies). But if I ignore the error, Combo Box 11 lets me choose a Family and Combo Box 13 gives me options to choose any SubFamily in my DB.

View 14 Replies View Related

Forms :: Access 2010 - Change Theme For A Single Form?

Oct 31, 2013

Is it possible in Access 2010 to change the theme for a single form? I do not want the theme for all my other forms to change, but only for 1 specific one.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved