Allow Combo To Read From 2 Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View Replies


ADVERTISEMENT

Allow Combo To Read From Two Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View 3 Replies View Related

Tables Read-Only

Apr 16, 2007

I believe I may have asked this question before but…

I have a FE/BE database. Is there a way to set the tables as “read only”? I’d like the FE to be read only, but allow users to see all the tables, not just forms etc. However, if they open the BE, they would have full control.

Thanks,
SKK

View 6 Replies View Related

Forms :: Table Doesn't Read Combo Box Info Correctly

Nov 24, 2014

I have a form "FrmMaintenance" based on the query "QryMaintenance" that is taken information from the table "TblMaintenance".

In the form, I have to pull the serial number of a machine from a drop down list which works perfectly fine in the form and it also updates other associated records.

When I go to the table, it puts associated number instead of the serial number that I've pulled.

Same thing happening for the pull down list "Engineer".

I've tried to look at the format of the "SerialNo" and changed to text, then to Combo Box but it didn't work, and the same for "Engineer"

View 8 Replies View Related

Forms :: Using Combo Boxes For Search Form In Read Only Mode

Jun 4, 2013

I would like to take advantage of using combo boxes to search records on a form but do not want user to be able to edit or change any of the data. Setting the form to read only of course, disallows use of any controls on the form.

View 2 Replies View Related

Need Data In Tables To Be Read-only

Dec 30, 2004

Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin,
how can i go about doing this/.

thanks!

View 2 Replies View Related

Make Tables Read Only

Jun 17, 2005

can anyone plz tell me how to make a table read only to prevent users from changing the records in the table?

View 2 Replies View Related

Tables :: Read Only Record?

Jul 11, 2013

I have a Workorder table and a Workorder form. I would like to be able to make a Workorder closed when it is finished so that it is read only. I have a finished date field so maybe by entering a date there could be a way to accomplish this?

View 4 Replies View Related

Tables :: Read Value From Field?

Dec 7, 2012

I define one Field in Table with 3 different Values form another Table. But now I dont know how to extract that values.

View 4 Replies View Related

Read Only Access To Appended Tables

Apr 30, 2006

Hello! My Small access aplication has a tables appended from dbf database program. I am coping with an issue to set access to this tables as read only.For me its very vital that source dbf application won't be changed from MS Access.Thanks for help!

View 3 Replies View Related

Linked Tables Across Network Are Read Only

May 22, 2006

I have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only.

How do you link to tables accross the network so you can read and writ e to them?

View 5 Replies View Related

Tables :: Open Table As Read Only

Jun 27, 2013

I want to be able to open a Table as Read Only, so that a user can browse etc., but neither alter nor enter data - I want them to use the Forms for that. How then, using VBA code, do you open a Table as Read Only?

View 14 Replies View Related

Need Help With Updating Number In Tables (read Post For More Info)

Sep 13, 2007

I am new to Access, so bear with me.

I am using Access 2007.

I have 4 tables created, and they are breaking out information for recording files that are being created from a PBX.
The tables are created as thus:

tbl_1
Key:ext_id | extension

tbl_2
Key:loc_id | location

tbl_3
Key:f-type_id | filetype


tbl_4
Key: mass_id | filename | date | loc_id | ext_id | f-type_id


Now I have created the relationships between the tables for the various ID's. My issue is the following:

I will be automating this process, so when the data is imported to the various tables, I need the relevant keys from tbl_1 tbl_2 and tbl_3 to be added to tbl_4 when the new data is brought into the tables.

As to the process of importing the data, I was looking at using PHP to facilitate this. Any ideas, help or direction would be greatly appreciated. I have looked around the net for an idea of how to solve this, but, being so new, I am not exactly sure how to word the question.


Thanks!

View 2 Replies View Related

Tables :: Read A File And Import Its Data Into A Table?

Oct 17, 2014

Was wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data.

For example in the file attached, the first four characters represent a data like 'ticket number' and maybe the third line 6 to 10 charcaters represent 'name of a passenger'.

Now how do i import these data to a table into respective fields in a table.

View 14 Replies View Related

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related

Tables :: Lock Single Record In A Table To Be Read Only On Permanent Basis

Dec 29, 2014

I want to "lock" a record in a table so that it is read only and cannot be accessed/edited/deleted. Is it possible to lock a single record in this way on a permanent basis? It's actually the first record in the table.

View 5 Replies View Related

Cannot Be Read: No Read Permissions

Dec 19, 2007

I have a brand new database in-the-works that is causing me headaches. For some reason, if I create a query and then exit and re-enter the database, I cannot re-open that query. I get an Error 3112 (cannot be read; no read permission on <name>) and to contact the administrator or creater of the database.

I'M the creator and the administrator on this thing - so why can't I get into the darn thing? I haven't added any security features. This has never happened before on any database I've created, so obviously, it's frustrating.

Any ideas?

View 3 Replies View Related

Combo Box Selection Triggering 2nd Combo Box Tables

Oct 26, 2004

I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in combo box (b) something different (pulls data from a different table).

Can anyone help me with this? Thanks!

View 1 Replies View Related

First User Allow To Read And Write / 2nd User Only Allow To Read?

Sep 2, 2014

Will like to check, i have a access database which can be open up by a few users.

How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?

View 4 Replies View Related

1 Combo Box 2 Tables

Mar 31, 2005

Hello everyone, I have the following tables, tblEmployees, tblDependents & tblMedicalInsurance. My tblMedicalInsurance contains the following fields;


MedicalNo
PlanName
Insured
EligibilityDate
CoverageDate
TerminationDate

In my Medical Insurance form the Insured field will be a combo box and I want this combo box to display both the employees and dependents names. Does anybody know if this can be done.


Thank you for your help.

View 1 Replies View Related

Tables :: Look Up Combo Box

Oct 28, 2014

have a combo box that looks up a product number form another field but i also have a combo box in the next field that has product name. It would be much better if once you select a product code that the product name comes up automatically.

View 1 Replies View Related

Combo Boxes And Looking Up Tables

Dec 5, 2004

Hello All,

I am a new Access user, and I am trying to create a database that will store and track print music.

I want to be able to track data by a text box called "Item Number". The item number is obtained automatically when the user inputs data from two different Combo Boxes.

"cmboInstrument" and "cmboMusicType"

Both these combo boxes look up separate tables which have in them two columns each
1. Instrument (Eg. Bass Guitar)
2. Code Number (Eg.0012)

The combo boxes look up the tables fine.

My problem is, that I want the txt box to display the data from both combo boxes (Eg: an eight digit number 01002111). I then also want the text box to generate a Item number starting from 0000.
So all in all the Item Number after selections have been made will display 010110000000 (an ID number example).

The numbers generated need to be displayed in the table under Item Number so that they can be associated with the product, therefore I assume they need to be bound and I am currently using the code

"Private Sub cmboMusicType_AfterUpdate()
Me.txtItemNumber.Value = Me.cmboMusicType.Column(1)
End Sub"

Though this only works for one combo box, if I put it in another combo box - the numbers will not join together.

Please Help!!!!

View 3 Replies View Related

Recall - Combo Box From 3 Tables

Jan 22, 2005

I want to create a combobox from 3 tables. The tables are like this:

Table / Field

TblSource / Source

TblAdverts / AdRef

Tbljobcentre / JobCentre

I now want a combo box listing everything from these fields in the 3 tables. Can this be done through VB or will I have to create a series of queries to append etc (which I think tends to run slower than code)?

I also want everything in the tbladvert table to be prefixed by PR and everything in the TblJobCentre table to be prefixed with JC.

Help on the first one would be great, but even jufirst part would be a big help.

Cheers,
Recall.

View 1 Replies View Related

Tables :: Combo Box Displays ID Only?

Dec 10, 2012

I have been designing a database and finally was making good headway. I have a junction table that references 2 tables (1-m) and the junction table creates an autonumber primary key that many tables will reference. I realized that the junction table could have duplicates. I did not want to use a composite primary key, but found that I could create an index that contained the unique combination of my foreign keys. No more duplicates. I thought things were looking up. I found out that it is a bad idea to use a combo box in dataset view to have look-ups to other tables. If it is a bad idea why have the option? It does make data entry easier. Anyway not my question. The other tables that refer to my junction table no longer show the values of the foreign keys, but displays an id number for my 2 columns.

Using MS Access 2010 32 bit Win XP.

View 5 Replies View Related

Combo Box Values Being Stored In Tables As 1 And 2 Etc..

Feb 12, 2008

Hi,

I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...

View 2 Replies View Related

Urgent Help Please With Combo Box And Populating Tables

Oct 31, 2004

I am trying to create a database which will act as a timesheet and management system.

I have several tables set up. some are:
01-Staff details containing Staff ID, Names, etc
11-Timesheets containing Timesheet ID, Staff ID, Timesheet Period ID
17-Timesheet Periods containing Timesheet Period IDs, Start Date and End Date.
13-Hours containing Hours ID, Timehseet ID, Project ID, Hours
etc.

I want to set up a Combo that lists Names from Table 01-Staff Details, and when the user selects their name, enters the Staff ID on a new row in the tabll 11-Timehseets.

I am able to create the Combo to list the names from 01-Staff Details, but am not able to get the selected name to jump into 11-Timesheets. The field is not available in the Control Source.

Could you please assist? I am not an Access expert, nor have I done any programming, so a step-by-step solution would be greatly appreciated!!

Many thanks in advance

Sunil

p.s. I would then like to ensure that users can't edit data in certain tables (eg. they shouldn't be able to create a new Staff ID/name, etc)

My next task will be to create a sub-form (which I am able to do) where the user can select a project from a combo-box and enter the hours worked on it. I would like the project and hours to be entered on a new row under the table 13-Hours

I look forward to your reply!

Many thanks

View 4 Replies View Related







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