Attribute Linkage Problems...
Sep 21, 2005
hello...
I need a little help in making a small database, I have made the tables already but the hard part is the relation
LINK: www.sunalpina.com/test.mdb
well the thing is that I need to make a database for tables "Product", "Category", "Admin", well the problem is between the tables "Product", "Category".
I want to make a category example "food" and in that category I want to make a sub-category "italian", "japanese"
and in the category "italian", I place product "pizza"
and in the category "japanese", I place product "noodles"
I don't know how to place the sub-category relationship in the database...
could someone please help....
View Replies
Sep 29, 2005
hi,
i would like the form that is titled "machine#search". to also be able to display all the faults by that machine number.
if you look at the form i just need some code to copy the machine number, into the subform. so if i search for machine 2, all the faults for machine 2 will be displayed in the sub form.
hope someone can make sense of this!
a little rusty when it comes to access!
thanks
View 3 Replies
View Related
Jan 16, 2007
Hi there
I have a MS Access 2003 DB. I need to make some changes in that but it shows me that Database is in Read Only and none of the changes can be saved.
I have tried to changed the Read ONly attr. from right click and properties but that option is allready unchecked.
Please help.
Thanks..
Danny
View 2 Replies
View Related
Oct 7, 2013
I am creating this temporary table on the fly I find I need a default value of zero for the field [GrpCount] . However I can't find the correct code to set this default value? I'm assuming it's an attribute
Code:
Set tbldef = DB.CreateTableDef("tblTempLkp")
With tbldef
.Fields.Append .CreateField("ID", dbLong)
[Code]....
View 4 Replies
View Related
Nov 3, 2005
I have a Front-End Access Data Project file (ADE compiled format for distribution) that I purposely have the Read-Only file attribute set to True.
I've been using it this way for about 7 years starting with Access 97 and the current version is 2000.
I am upgrading the app to 2003 now and everything with the conversion is fine except when I set the Read-Only file attribute to True it all of a sudden when starting it no longer connects to the Back-End (sql server) and displays a "form load cancelled" error before hanging.
If I disable the Read-Only attribute, everything is fine again, but I prefere not to do this because that will require me to rework my auto updater.
I use it this way because it prevents bloating of the file and allows for my auto updater to determine new version by using the file modification date.
Any Idea's?
View 1 Replies
View Related
Feb 18, 2013
I am using Access 2010. I have many tables that are downloaded from SAP into Access.
Within each table structure are the following standard Access attributes: Field Name Data Type Description
When I create a query I add the Field Name from the table nothing earth shattering here. But, in addition or instead of Field Name, I want to use the Description attribute. Mostly because the SAP field names are acromyms in German and are useless to the untrained eye. Please see attachment as an example.
Is there a way either using VBA or some special SQL language in any query I write to show me the Description instead of or in addition to the Field Name?
View 1 Replies
View Related
Jan 16, 2007
Hi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform, viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU
Thanks heaps for your help
View 1 Replies
View Related
Jan 12, 2013
I have a keys table and a keysctivity table. I need keys to not be available if they are currently signed out (return_date is null) or if they have been marked as lost (lost_key = true)
This is my activity table. URL....If for example signin_id 1 was not returned or was lost, key_id 1 should no longer be available. Is this something that can be done?This is the access file I am working on: URL....
create two new tables "lostKeys" "unreturned_keys" and have records moved to their respective tables based on whether they are indicated to be lost or currently not returned.
View 4 Replies
View Related
Oct 17, 2013
I have a combobox on my form called TypeOfBusiness, with fields including Corporation, Education, Industry, Non-Profit. In order to make a second combobox called IndustryClassification appear when Industry is selected from the TypeOfBusiness combobox, I have used the following code:
Code:
Private Sub Form_Current()
If Me.TypeOfBusiness = "Industry" Then
Me.IndustryClassification.Visible = True
Else
Me.IndustryClassification.Visible = False
[Code] .....
It works just fine. However, when a user selects both, say, Industry and Education, the IndustryClassification combobox will not appear. What code I can use to ensure the IndustryClassification box will appear regardless if another box is checked in addition to Industry? I am wondering if it has to do with the Column attribute.
View 14 Replies
View Related
