I tried to chosee Lookup Wizard as data type in my table so I can have drop-down options from another table. However, I received an error message, "ActiveX component can't create object". What does this mean, please help :confused:
View RepliesHello,
I wonder if anybody can help me.
I have a table called ITEM, within ITEM I have three fields ITEM NUMBER (Key Field), Item, Cost,
I have another table called INVOICE ITEMS, Within INVOICE ITEMS I have six Fields, INVOICE NUMBER, ITEM NUMBER, ITEM, UNIT COST, Amount, Total Amount.
I want to use Lookup wizard to complete the fields ITEM NUMBER, ITEM, UNIT COST from the ITEM table.
Is this possible?
Regards
Nathan
I have three fields that I would like to have access the same table using the Lookup Wizard. I am unable to get the query to work.
Example:
The Fruit table has 5 records, let's say: orange, apple, banana, kiwi, strawberry.
The first field -- Fruit1 -- would use the Data Type Lookup Wizard referencing the Fruit table.
The second field -- Fruit2 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The third field -- Fruit3 -- would also use the Data Type Lookup Wizard referencing the Fruit table.
The bottom line: a person will have a choice of 3 fruits.
Again, the problem is that I cannot get the query to work where I choose =banana for the criteria for all three fields. Banana might be person one's first choice, but it might be person two's second choice, etc. I'm looking for all the bananas no matter which choice it is.
Your assistance is appreciated.
I will try and explain this as simply as possible.
I have a lookup table that is purely dates so the field is Clinic_Date, the format is date/time, and the input mask is set to short date.
I have a table called appointments. I have a field called appt_date which I am trying to make a look-up field by using the wizard to look up from the clinic_date table. However I an getting the error message "You have entered an expression that has an invalid reference to the property l." (thought it doesn't look like the letter "l" but more like a long vertical line).
What on earth could be going on?
hey,
i have applied a lookup wizard to some fields, just to see what happened, and now i want to undo it... how do i do this pls?
thanks
I'm using the lookup wizard for to allow a user to pick a value from a text field. However, when I use the lookup wizard the field type for the field that displays the selected value is number instead of text. When the selected value is displayed in List Box, instead of the text it displays the ID number for the record the text is picked from - For example, if I choose the name "Alex" from the lookup, the number 1 is displayed, if I choose "Bob" it is 2 and if I don't select a value, it shows 0.
Any idea what exactly is going on?
How does one use the lookup wizard for dates?
It says: The lookup wizard doesn't apply to fields of this data type.
I want a combo box for dates.
Heres something I dont understand about the lookup wizard:
Ive done a lookup wizard on one of my fields, so that now the user gets a drop down list of options to choose from:
0;1;2;3;4;5;6;7;8;"NTSC";"PAL"
Ive also set "Limit to list" to yes, so that these are the only options the user can enter.
However, it will still let me change and play around with the data type settings under the general tab. I dont understand why it lets me do this. I can set the lookup to the above list, and then specify a date type of type "date", and it will allow me to do it.
Why is this the case? Which datatype should I set it to, if I have a list of values like the one above?
I've been doing a lot of research and reading on databases and normalization and things of that sort because I need to create database from scratch. I've been maintaining a db that someone else made, but it turns out I will have to recreat the whole thing because it's not useful anymore and the users need a more user friendly db. I have a couple of days some are:
tblTO
------
TONumber
Contract
Product Directorate <- combo box 20 items
Document Type <- combo box 15 items
TOManager <- combo box 10 items
tblTOItem
----------
Product <- combo box 13 items
JobNo
BasicDate
ChangeDate
ChangeLevel
TotalBillablePgs
TotalTextPgs
TotalArtPgs
Standard <- combo box 22 items
TemplateVersion <- combo box 20 items
SourceFormat <- combo box 15 items
SourceLocation <- combo box 10 items
The ones I have the arrows for will be a combo box on my form.
My question is should I make each of these field a table of its own?
For instance make the Product field a table and list all the 13 products there?
Or keep the Product field in the tblTOItems and in design view of tblTOItems use the Lookup Wizard and type in my values there to make a lookup column.
I have seen it done both ways, and I was just wondering which way is more efficient.
As one is typing in a field with a lookup wizard - dropdown list - is there anyway to see the list without clicking on the down arrow? Perhaps there is a choice somewhere in the program where dropdown menus for the lookup wizard can be made visible?
View 3 Replies View RelatedI know this is odd but I need to somehow create a way of making a dropdown list with more than 50 characters. One has 250. There are 3 options to choose from and only one needed to be selected.
I am happy to just type a 1, 2 or 3 in the box IF it can be referenced somehow to one of the 3 longer statements that I need to use but how to do this.
I am having a problem when trying to use the Form Wizard.
I select a table or query, but it shows no fields! Here is a screenshot:
http://img.photobucket.com/albums/v85/retroap/access.jpg
I am running Office 2003 with the latest updates on XP Professional SP2, again with the latest updates. The install was fresh only about a week ago, and I had only used this install of Access for a few hours before it started doing it!
I have tried creating a totally new database, or using an existing database, and the same happens. This led me to believe it was my Office install. I tried doing a repair through add/remove programs, which successfully repaired Office apparently, yet the problem persists. I even totally removed Office, rebooted, and reinstalled, and tried without updates!
Can anyone suggest what I could try next?
I'm trying to create a field with the lookup wizard, however it's a bit more complicated. I need the field to have multiple choices(3) and when a specific option is selected I need some additional choices to appear. For example: Question - have you ever used a specific product. Options: a-yes, b -no, c-other. If option b is selected then thats it, but if option a is selected I need a few other options to appear: was the brand Option1 or Option2? Also did you use it before(option1) or after(option2) smth.
View 2 Replies View RelatedI've designed a database at work to collate information about locations around the world that are contaminated by conflict and military activities. I'm struggling with the use of the lookup wizard to populate some fields in one table from another table.The database is ultimately meant to be used to identify contaminated sites in various countries and also to be a source of data for an online interactive map. As such, it needs to hold a fair amount of information. I figured that it would be normal that some fields and tables would be connected to one another. So, for example:
Country table is looked up by the conflict table to provide the names of countries participating in a conflict. To do so I used the lookup wizard. Similarly, the Site information table is looked up by the Site contamination event table to provide the names of contaminated sites. The Site contamination event table. Then the Site assessment table looks up the Site contamination event table to provide the name of contaminated sites. The relationship between these three table is intended so that at any given site multiple instances of contamination and their subsequent assessment can be recorded. This is where I started noticing problems. When I tried to input some fields into the Site assessment table, specifically the 'Site name', it would only display the primary and foreign keys in the drop down menu but not the 'Site name'.
- Have I messed up by relying on the lookup wizard in my table design? This seems to be the consensus in this and most forums (I checked another thread in the 'Tables' forum here). That said, I've seen some people making a distinction between using 'Lookup tables' and 'Lookup fields within a table', but given my relative newbyness I'm struggling to see the difference!
- If the answer is yes then what approach should I take to achieve the same aim (having multiple tables that feed information to one another). Initial research seems to suggest putting lookup/combo boxes in my forms. I'm dabbling with that at the minute but so far the results haven't been as desired.
I've attached a zip file with a screenshot of my relationships diagram to give an extra idea. Note that the relationship between the 'Site assessment' table and 'Site contamination event' table isn't showing up as I removed while trying to troubleshoot, but it is supposed to be one-to-many from 'Site contamination event' to 'Site assessment'.
I've managed to use the lookup wizard to show me two fields in the drop down list, first name and last name, but when i select a record I can only see the first name in the cell, not both.
Is there a way to display them both together?
I am trying to create a lookup wizard to record the number of people who attend a regular event. I have a table recording the names, surnames and DOB of registered members and a number of other tables for regular events we hold. Previously people have been manually adding the names of attendees and of course there have been inconsistencies in the data. I want them to look up the names from the table of registered members. I have been using the lookup wizard, but it is only displaying the first name in a string. I need it to display id, first name, surname and DOB in a table. I also want to be able to type in the first letter and then pick from the list.
View 5 Replies View RelatedI seem to be having a problem with access 2007
When I use the filter by form, filter by selection, and toggle filter buttons located on the ribbon, they work normally on my form, in the usual way.
However when I use the button wizard to add the various available filter buttons to my form, it adds the buttons with the correct graphics on - but in form view clicking on the buttons does not actually do anything.
I've tried running compact and repair but still the same.
I have created a table which has a lookup box linked to another table with a bound column reference. The lookup works in the table.
On the form I have linked the original table to a query table which does a calculation based on the result of the lookup and another field.
Everything was working until I tried to put it in a report and deleted something by mistake. Now the drop down and calculations are visible on the form but I can't add a record or change the values in the drop down. The actual field appears blank. I have had to replace a lot of the relationships so I think the problem's something to do with that, but I can't seem to find it.
Does anyone have any idea what I can start looking at?
Sorry to be so vague, but I have tried to attach the database in a previous query and it is too big.
This is really frustrating 'cos I finally managed to get it working, then broke it, so any help would be gratefully appreciated.
Have simple continuous form to create a pick list. One combo field looks up products from a list of about 5000 items.
Even though the combo homes in as letters are typed there is still a lot of typing needed to identify the target product. This is because many products have the same 10 to 15 characters to start, then have different endings.
It would be great if in adding a new item the combo remembered what was typed in the previous entry, as the picklist is built alphabetically.
Any ideas
I have my main form which is connected to my main table - Query 1
I have a lookup table (actually a view from SQL Server) which holds my user name - the username used to login to the database- just one value.
In my main form I have a 'Logged By' field. I want this field to default to my login name when I process a record.
I thought it would be as easy as connecting the lookup table to my main form and then in default value typing My_login.user_name.
Apparently not. It just has the #Name? in there.
Anyone have an opinion on this ?
I can use the =environ("username") in the default value which works to good effect but different users use each others PC and I would like the field to be defaulted to thier database login and not thier windows on.
Please help ! It seems so small and its driving me ceeerazy !
I'm wrestling with the issues; in other threads, it became apparent that because I could not know ahead of time what I will need to know about a given entity, I will use a table to enumerate attributes that is applicable for a given entity.
However, the stumper is that what if an attribute should conform to a set list of values? Since they are dynamic, I would have problem predicting what I will need to be able to lookup, and am even don't know whether I will need a one-many lookup or many-many lookup.
I thought that generic lookup table with a table listing "classes" of lookup would allow me to have one big generic lookup table while using "classes" to act like virtual tables so I can then set the query to appropriate "class" to return just right set of values.
But as I thought about it, I ran into some issues which is pulling me toward the crazy idea that I should have freestanding tables, and use a field in tblAttribute to give me the table's name so I'd know which free-standing table it points to, and have the necessary key to lookup the values within that table.
Even though my gut instincts tell me that I shouldn't be going against the conventions of database design (who the frick goes around creating free-standing lookups?!?), I'm simply not sure how I can use a generic lookup table to hold all information.
For example, suppose I was given a list of values that has its own categories. Since the former design allows only for two level (lookup and lookupclass), where am I to insert that extra level?
Furthermore, I found myself needing a set of virtual keys to reference a certain "class" of lookups for report purposes. That means I need an extra field in my lookup table than I originally anticipates. What if I find myself needing one more field that just won't fit the generic lookup table?
So does anyone have suggestions on how we would create a placeholder for a lookup table that will be made just in time?
I have three large source tables imported into my database. I have created queries to retrieve relevant values from fields in each source table which feeds into my form. Each field on my form that is connected to the relevant query is a lookup field. For example, one field called "Supplier_Name" another called "Supplier_Code" and a third called "Route_Number".
Needless to say each of my lookup fields are very long. I am trying to filter my search based upon the selection from the previous Lookup field. How I can filter a lookup field's value based upon the previous lookup field selection? Each Supplier has a code and assign route(s) and I have already established these relationships.
how to do a particular thing in Access 2010 (I don't even know if it is possible).
I have a table named PRODUCTS:
ID_PRODUCT (primary key, autonumber long integer)
ALLOWED_OPTIONS (multi value text lookup field: "Option 1";"Option 2";...;"Option 9")
So I can store, for each different product, none, one, or more options to let the customers choose from.
I have a table named ORDERS:
ID_ORDER (primary key, autonumber long integer)
FK_CUSTOMER (foreign key, linked to the primary key of a CUSTOMERS table; represents the customer that places the order.)
FK_PRODUCT (foreign key, linked to PRODUCTS.ID_PRODUCT; represents the product that the customer has choosen)
CHOOSEN_OPTION (lookup text field; the customer must choose ONE option among those allowed for the product he has ordered)
The problem is that I would like the CHOOSEN_OPTION field to show as a combobox, listing the values stored into PRODUCTS.ALLOWED_OPTIONS, so that when a customer buys a product, he can choose only among the options allowed by that particular product.How can I manage a multi value field to populate a combobox, in which every item stays on its line? If I use, as a query to populate the combobox:
select [PRODUCTS].[ALLOWED_OPTIONS]
from PRODUCTS
where [PRODUCTS].[ID_PRODUCT]=[FK_PRODUCT]
I obtain an empty combobox.If I refer to the last field as [ORDERS].[FK_PRODUCT], Access asks me to type a value for "[ORDERS].[FK_PRODUCT]", treating it as an unknown parameter.I think that the problem is that when the combobox expands, the record is not committed yet, so FK_PRODUCT is unknown (NULL?). But this happens even if I commit the record typing something in FK_PRODUCT and then I re-enter the record and I expand the CHOOSEN_OPTION combobox, that is still empy although FK_PRODUCT exists, now.Is there a particular syntax to refer to a field in a record not committed yet (something like "THIS." or "ME.")?
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
guys, can someone help, i copied this sql from the wizard window, i'm trying to put the sql in a vba code here is what i did, the select is not working it has syntax, can someone help?
Dim mySQL As String
Dim db As Database
Dim rs As Recordset
Dim x As Long
Set db = CurrentDb
mySQL = "SELECT change_order_tbl.serial_num, Max(change_order_requestor_tbl.change_order_effect ive_date) AS MaxOfchange_order_effective_date" _
FROM change_order_requestor_tbl INNER JOIN change_order_tbl ON change_order_requestor_tbl.change_order_id=change_ order_tbl.change_order_id
GROUP BY change_order_tbl.serial_num
HAVING (((change_order_tbl.serial_num)="abc"));"
Set rs = db.OpenRecordset(mySQL)
rs.MoveFirst
x = rs!countoffield