Link Combo Box
May 12, 2006
Hi there, I am new to access and this question be a no brainer for you access gurus. What I currently have is a form with one combo box and two radio buttons.
Staff and Status
The staff combo box is a drop down menu of all staff members and is derived from a table called Employees. The two radio buttons represent "Active" and "Inactive".
So if John Smith is selected their current status will be shown on the radio button and the user can change it if they want to.
The problem I am having is linking the radio button to a name in the combo box. Any assistance would be appreciated.
Thanks
View Replies
ADVERTISEMENT
Jun 28, 2006
Hi.. i have a combo1(InvoiceNo) that look up the values in a table, (there are invoices numbers on it) In the Invoices table i have InvoiceNo (that is the key) and other fields like InvoiceCity, SaleDate, etc
I need to store the current date in Invoices.SaleDate = now() in Invoices table that matches with the combo1.
The Form has as RecordSource, Customers Table
Any tip or hint???
View 1 Replies
View Related
Oct 11, 2005
Hi,
I'm trying to link 2 combo boxes, so that the values displayed in the second combo are dependant on what is selected in the first combo.
I've referred to previous posts, in particular http://forums.aspfree.com/t32756/s.html&highlight=linking+combo, but I'm having the same problem...
The Row Source for my first combo reads as:
SELECT tblGroup.Group FROM tblGroup;
The Row Source for my second combo reads as:
SELECT [tblPart].[Group], [tblPart].[PartNo] FROM [tblPart] WHERE ((([tblPart].[Group])=[Forms]![frmQuotations]![qryEquipment subform].Form![cboGroup]));
I also have this code under the first combo's after_update event:
Private Sub cboGroup_AfterUpdate()
cboPartID.Requery
Me.cboPartID.SetFocus
End Sub
However, this brings up the 'Enter Parameter Value' msgbox asking for the cboGroup value.
Can anyone suggest anything I could be doing wrong?
Also, can someone confirm where I would find the subform's name...? Strange question I know, but I did not create this database, and under the subforms properties there isn't a field that specifically says 'Name'. Record source is 'qryEquipment', and caption is 'qryEquipment subform'. The form is also called 'qryEquipment subform' under the Forms tab.
Thanks in advance!
View 1 Replies
View Related
May 15, 2006
Hey all,
I am trying to link a option group to a combo box. The combo box has a list of employee names. The option group has two options Active and Inactive. All I want the user to be able to do is check the current status of an employee (as active or inactive) and to be able to change their status. I am having some troubles linking the two together.
Thanks
View 4 Replies
View Related
Jul 9, 2014
On my data entry Form, I have a Combo Box [Condition] and five tab controls. Each tab has as many as 10 controls on it. The purpose of the Form is to populate a table. My questions are:
1) Do I still need to use a subform on each Tab or leave them as-is? i.e. the 10 controls are on each tab
2) How do I make the value of [Condition] transfer focus to the appropriate tab??
View 14 Replies
View Related
Mar 1, 2005
This is my first attempt with cascading combo boxes (2) and with the help of the forum I've made it work BUT, I feel like an idiot because I'm drawing a complete blank on how to link them back to a "main" data table.
The example I used as a reference was to create them as unbound boxes while using queries to pull for each of the combo boxes. I have 4 tables. One will serve as the main table while 3 others are each feeding one of the combo boxes. I went back and set the main table as the record source and added some of the other fields but those unbound fields have me stumped.
If anyone recognizes an earlier post that clarifies this, please let me know. I've looked through numerous posts but haven't found one yet.
Just like everyone else, any help would be greatly appreciated.
mike
View 1 Replies
View Related
Oct 30, 2013
I've got a bit of a problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. (This is so I can show multiple records for that employee without having their name repeated at each one). I also have the name of contact [ContactName] that sits in the Detail area of the form.Both names come from their own tables that have all their contact numbers and e-mail addresses in columns I have linked the name to text boxes [ContactPhone] & [EmployeePhone] with their relevant phone numbers in within the Detail area of the form.
The ContactPhone that has the ContactName within the Details part of the form works well with no problems by putting =[ContactName].Column(1) in the Control Source
However when I put =[EmployeeName].Column(1) in the relevant Control Source (and / or EmployeeEMail in a second text box), once I have saved the form in Design view and returned to Form view, Access crashes and shuts down!If I remove the wording from the control source Access doesn't crash.
View 2 Replies
View Related
Jan 22, 2005
:) Hi. Basically, I have a form with 3 combos - "from, to and type". What I'm trying to do is when a selection is made in "from", the "type" combo will select one of it's 3 options.
And i spose I'll be doing the same with other options.
View 2 Replies
View Related
Aug 8, 2005
Folks,
i have a small problem wizzing my nut. I copy two tables from mycurrent database to an external database,now i am trying to link these two tables in the external database to the ones in the currentdb. I get a run-time error 3012 telling me that an object 'tblLanguage' is already present.which iam failing to track. Any ideas Please??
Here is my linking code.
Sub LinkMeUp()
Dim tbl As DAO.TableDef
Dim sTableName As String
Dim sThatTblpath As String
Dim dbName As String
dbName = "my_ExternalDatabase"
sThatTblpath = ";Database=" & db_Path & "" & dbName
For Each tbl In CurrentDb.TableDefs
sTableName = tbl.Name
Set tbl = CurrentDb.CreateTableDef(sTableName)
tbl.Connect = sThatTblpath
tbl.SourceTableName = sTableName
CurrentDb.TableDefs.Append tbl
Next tbl
End Sub
View 3 Replies
View Related
Aug 2, 2006
Hello,
The current database I am working on I made it by copying the one I was working on originally. I just realized on the VB window that there is still some relation between them. Because, if I look at the tree on the left of the code window I see it says "GCB (miniGCB)", being GCB the one I copied, and miniGCB the one I am working with.
How can I get rid of the link with GCB?? I want the tree to just say "miniGCB".
Thanks,
View 1 Replies
View Related
Jan 17, 2006
Hello all,
I created a table and linked a pdf file to one of the fields, but when I created a form to display the table contacts, I could not see the attachment or icon or any reference to the linked object. The field in my access table is an OLE object.
Thanks for helping out.
View 7 Replies
View Related
Aug 31, 2005
I have packaged an Access DB (Split) as a run time solution so I can distribute to users without Access.
When I install it on a PC it runs.
If I move the back end to a network, the solution can't find the back end because it has been moved.
Access run time does not include the linked table manager in the toolbar.
Is there code in VBA where I can refresh the link between front and back end.
Ideally I want to write an error handler that will call a sub to prompt the user for the new location of the back end if it has been moved. Then have the user browse to the network location and click on the back end and store that location as a string. Using that string refresh the links.
Any ideas on that?
View 5 Replies
View Related
Nov 3, 2005
Hi all,
I have added about 15 links on a form, linking to word and excel documents. The word documents open fine but all of my excel documents pop up with a messae saying the file cannot be open, yet when i just go to the document on my hard drive they all open fine...does anyone have any ideas please. Thanks
View 6 Replies
View Related
Apr 11, 2006
Hi,
I'm new to this so please go easy!
I have an excel document which automatically refreshes data gathered from an access db.
I need to put a button on the switchboard on the same db to open the excel document, basically to make it easy for others to find.
I have tried hyperlinks but it doesn't want to play. It locks the db and then won't refresh the information.
I know i'm missing something blindingly obvious, can someone help?!
:confused:
Thanks
elsiegee
View 1 Replies
View Related
May 13, 2006
Hi Forum,
I'm building a db to track computer and user problems for work, where I double as a Client Support Administrator (IT Guy).
I have these tables: (simplified list)
tblComputers
tblPeople
tblCompAssignment
tblProblems
I'm at a loss as to how to link the 'Problems' table. This is where I'll record trouble tickets reported by users.
Incoming trouble tickets could relate to the Computer or to the User's Network Login.
I thought I might have a field in the problems table for UserName and also one for ComputerID, but this seems problematic. Anyone got any ideas?
View 12 Replies
View Related
Jun 29, 2006
I am trying to link to a url from a message box with difficulty.
eg the user opens the form and a message box appears asking have the latest datasets been downloaded? If answered yes the form opens, if no links to web address.
has anybody any examples.
Thanks
View 2 Replies
View Related
Apr 12, 2008
I have a database which works as an information system for the upcomming olympics.
In tblAthletes is...
AthleteID (Primary Key)
FirstName
Surname
And Various other fields not needed in this problem
In tblResults is...
Gold
Silver
Bronze
Also other field in this table
What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field.
Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.
View 5 Replies
View Related
Dec 24, 2005
Hi There
i am trying to link some more tables to my access front end from the sql server back end
when i select 'ODBC Databases' from the link pop up box, the pop up box just closes
any ideas why, or work arounds would be appreciated
Happy Christmas
View 4 Replies
View Related
Jun 20, 2006
Does anyone know how to link tables automatically/VBA?
I'm trying to import files from our DB2 database in which one file is created monthly and instead of manually importing / linking the files manually, I'm looking to have access link to the new file automatically.
The file names are structured as so..
ITM01 (Jan)
ITM02 (Feb)
ITM03 (March)
Thanks
View 5 Replies
View Related
Sep 14, 2006
Hello everybody,
I have one dbase with 3 tables wiht 3 forms. One is "custonmers" , "glass" and "lens".
Customers - CusID as primary Keys
Glass - GlasID and CusID primary keys
Lens - LensID and CusID Primary Keys
When I change a specific field (only) I am losing the records on the other tables of the specific customer.
Thanks in advance
xxx ΠΑΟ ΘΡΗΣΚΕΙΑ ΘΥΡΑ 13
View 2 Replies
View Related
Mar 3, 2007
Hi All
I enter data in a form "WIP" that is based on a table named "WIP" in the form I have a command button. When I activate the command button it takes me into another form "Materials" which is based on a table named "Materials".
The data that I enter into "Materials" is not linked to the data ie Customer details which I have entered into "WIP".
My aim is to be able to report the materials used.
I have tried variations of relationships but am obviously missing something.
Thanks in Advance
Geoffk
View 2 Replies
View Related
Jun 5, 2007
Is it possible i create one master table and link few table together??
In the mdb that i attached there have 3 table - tblMaster, tblConfiguration1 and tblConfiguration2.
Using the relationship to link tblMaster's field Configuration to other 2 table Configuration field but there only showing 1 table data.
Is it allow in tblMaster able to show this 2 table together??
View 5 Replies
View Related
Dec 28, 2007
I have a FE database that on initial setup the user will enter the drive letter of the mapped location where the BE resides. The FE will then update all the linked tables to that path. This should work but for some reason the FE locks up (stops responding) when I test this. Any suggestions as to why. It doesn't stop responding until this part of the code:
tdf.Refreshlink
I have looked and it does change the link path, but it locks up.
Dim dbs As DAO.database
Dim dataPath As String
Dim tdf As DAO.TableDef
dataPath = Me.drive & ":IMP1_R2.2_be.mdb"
For Each tdf In dbs.TableDefs
'Not a MSys type table
'If the table has a connect string, it's a linked table.
If Len(tdf.Connect) > 0 Then
If InStr(tdf.name, "MSys") = 0 Then
tdf.Connect = ";DATABASE=" & dataPath
End If
err = 0
On Error Resume Next
tdf.RefreshLink
End If
Next tdf
DoCmd.Echo True, "Done"
View 1 Replies
View Related
Dec 7, 2005
Hi
i would like to link to a query. when i go to file | Get External Data | Link Tables, i don't see my queries. is this possible??? and if so how?
sam
View 1 Replies
View Related
Feb 3, 2005
i have a button that open another form. the form should copy some filed from the form that the button in it.
Example. i have the from-A with field name- ID. in this form there is a button that open form-B.
this form had also the field ID and another fields of information on the specific person (with the same person form the form_A)
i want that the ID will automaticlly updated whrn i open the form so i can add another information. these are teo tables that are linked together and that is the reason that witohut the ID it cant be updated, and i dont want to update it manually.
View 6 Replies
View Related
Apr 14, 2005
i have a cars database
because it is difficult to add 4000 pictures i want to know
if is it possible to add a field that opens an ie page in google images to show results of images for that car?
ex :
model : Ferrari
foto link :http://images.google.com.gr/images?hl=el&lr=&q=Ferrari&btnG=%CE%91%CE%BD%CE%B1%CE%B6%CE%AE%CF%84%CE%B7%CF %83%CE%B7
View 6 Replies
View Related
