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???
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
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
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!
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
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??
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.
:) 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.
The attached Access XP file demonstrates my problem. I've included a form to make testing easier.
Each record in the Projects table has one or more linked entries in the Keywordlink table, showing keywords that apply to that record. Each record in Projects has a Yes/No 'Utility' field.
A third table, Keywords, supplies the keywords that the user can apply to records in Projects, using the subform on the main form. The Keywords table also includes a True/False 'Utility' field. I have set this to True for for the first three keywords.
I need a query, a series of queries or some VB code that updates Projects_Utility for all records to True if and only if the record's linked entries in Keywordlink include all of the keywords for which Keywords_Utility is True (a boolean 'and', as opposed to an 'or'). Otherwise, Projects_Utility must be set to False.
In the attached file, with the current settings in the Keyword table, the 'GetSelectedProjects' query should then produce single-row listings for ClientA and ClientF.
I'd appreciate any help you can give me on this. I'm not a programmer, but I can manage a bit of VB code if I have to.
I have a table "Product" and in this table I have two fields "StoragePlaceID1" and "StoragePlaceID2". Both these fields link to the look-up table "StoragePlace"
*Attached Image "Product_StoragePlace" from the Access Relationship Window"*
When I want to add a new Product from my inter face i get the error you can see in the Attached Image "Save_Error".I think the problem is that the Relationship is defined as One-to-Many,there a way to define the relationship as Zero-to-Many.
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??
hi
I have a new table that I added to the back end of my Access 2003 database. I compacted & repaired both the front and back and I can't see the new table in the front end still. Do you know why this is?? I can't find anything on this.
thanks-
I am working on a new system. Have been given Full MS Access but Link Table Manager fails it gives a standard security warning that this new system enforces it says Opening: CProg..FilesMSOfficeOffice11ACWZTOOL.MDE however on selecting OPEN nothing happens. If Cancel is hit then
long critical message saying in short " Can't find wizard , syntax error in delerations in VB. Likewise I cannot link to a spreadsheet without using the manager.
Question is there anything I can do or is it the fact that these are options were not installed and it is an administrators job?
I searched the internet and different forums, but could not find the solution for my problem. In Access 2003 I splitted the database and made a mde file of the frontend. When I copy the front and backend to another computer it cannot find the backend due to the original path is included. To solve this I would like the database to link the backend that is available in the directory of the frontend. No more and no less. Is this possible? I find a lot of questions in this direction, but could not destilate a solution.
View 1 Replies View RelatedAccess 2000
How do I link a table to excel table so if I add or change things it changes in the other.
Bub :rolleyes:
Is it possible to create a table link that is read only. I realize that there a a number of work-arounds, but I'm curious about this functionality specifically.
View 3 Replies View RelatedHiya
Please be gentle I am no expert at this sort off thing.....
Is there a way of clicking on a line in a table and the relavant form opens in a new window. You can then edit the form and the table is updated.
Thanks
Gibby
anyone know how to remove the table link (not delete linked table) at run time?
View 1 Replies View RelatedI have a frontend and backend database put in a network drive where users can access to the frontend version which has tables linked to the backend.
When I set up the link tables from the frontend to the backend, Access points to a local drive letter in my computer. For example, if I map the network drive where the databases are, say to Drive R:, the link table in the frontend will always point to tables in the backend on R:. If other user map the same network drive to drive letter other than R:, the table links between the frontend and the backend will be broken.
I wonder if anyone knows a way to set up table link with a physical path instead of a local drive letter?
Thanks
Mike :rolleyes:
What I need is a table that will hold a primary key field and 16 text fields at 255 characters per field. (NO memo fields) This will total about 4,080 characters but Access 2000 limits the record size to 2,000 characters.
I have two tables with 9 fields in each table in a one to one relationship as follows:
Table1: Primary Key = MyKey = autonumber field.
Table1: 8 fields = text at 255 characters each field.
(i.e. Data1, Data2, Data3, Data4, Data5, Data6, Data7, Data8)
Table2: Primary Key = MyKey = number field.
Table2: 8 fields = text at 255 characters each field
(i.e. Data9, Data10, Data11, Data12, Data13, Data14, Data15, Data16)
The problem is I want all the fields to act as though they are from a single table and to be on a single form. I don’t know how to go about the LinkChildFields and LinkMasterFields without using a SubForm. A SubForm don’t work because it expects the second table to have many records.
Thanks Stan
Hi
I am linking av table from Sybase Adaptive server anywhere 8.05 by using this code:
DoCmd.TransferDatabase acLink, "ODBC", "odbc;DSN=database;UID=dba;PWD=sql;DATABASE=databas e", acTable, "trc.ansatt_dato", "trc_ansatt_dato", False
This works just fine, but I gety this dialogbox where I am asked to select a unique keys or something.... .
Is it possible to write a code to automatic choose OK?
Anyone?
eroness
I am pretty sure the answer to this is no but I need to ask anyway.
Is there a way that your tables can be set up so clicking on a record will take you to the corresponding record on the form (like you can do in Filemaker). I have a client who doesn't want queries or reports set up (!!) just wants to be able to filter and search using the table and then link to the form...
I have developed a Microsoft Database Access 2010 Table and associated Form..I open both the Table and Form and a separate tab appears for each, then I can switch from either the table or form by clicking the tab.In the Table screen I select a record, as an example, record number 1926. How can I link this record with the form so that when I select the form tab, record 1926 is shown?
View 4 Replies View RelatedI am new to using Microsoft Access, and have started a job which it predominantly using access.
I am in-charge of the database, the table contains many fields for instance project code, organization name, project,total budget fee etc.
Project code are unique and represents income stream and work of a consultant.
However i have been ask to link project codes, for when consultants are working on a project together, so when a monthly report is run the work will appear on both consultants reports and not just the ones.
is their a possible remedy for this?
hi,
i'm using access 2000 to create an application. i need to get the information of Staff, but the Staff informationis in Lotus Notes 6.
my problem is how to link table from Lotus notes document?
an for your information exporting from Lotus Notes then access 2000 link table to that exported file is not an option.
anyone help?
regards,
askaccess :confused:
i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?
View 1 Replies View Related