I am attempting to use a combobox to fill several other unbound textboxes on a form. The syntax I am using is simple,
(SAMPLE)
Private Sub Combo48_AfterUpdate()
Me.SSN1 = Me.Combo48.Column(0)
Me.Rank1 = Me.Combo48.Column(7)
End Sub
This command is based off a query I set up combining 2 main tables. The problem is it only seems to be working for column (0) and (1), anything above that and I just keep coming up blank. Is there a better way to do this or does anyone know what may be limiting the above command from displaying any column above (1)?
I've created a shared database to track customer requests. Every once in a while, I get a record that is populated with what looks like Asian font. I'm unable to delete these records if this occurs. Does anyone know why this happens and what I can do to fix this?
I have simple invoice database, tyhe old one I made works fine, trying to make a newone always simple but now Access is not helping me for some reason,,,, Can you look at this? I create an invoice form using wizzard i join invoices and invoices details to it and from there I create my Invoive form that has the invoice info and the details.... I change some stuff for looks and easyness... Mostly change text boxes to combo boxes... I did this in office 2003 and had the same results than in office 2002, Why dont know... Once I create the invoice from and change the text boxes combos and ofcourse set everything else, once I pick a product from the detail form I get the product but I dont get its price. Now on my other older database made excatly the same way it works!!!! WHY IIIIIIII DONT KNOW!!! please help me:(
I have attached both db so you can look at them!!!
I've got a database, which has been working fine for the last 6 months, it's nt spectacularly large, or complex (abotu 10mb, 15 tables, (5 of which are lookups), about 20 forms, 40 reports, and 30 or so queries).
I've tried to add a new query today, again nothing special:
all comes from one table: column 1 - group by column 2 - max column 3 - if = "No" column 4 is an expression: iif (a=1,col_a,iif(a=2,col_b,iif(a=3,col_c, .... ))) and so on for 8 col_*'s
The query creates happily enough, and is viewable. When I try to save it, access shuts down completely with no warnings.
creating the query apart from the last column, saving it then works, but on adding the final column the database shuts down every time.
1. After my relationship table is built, is it possible to have some tables automatics fill in according to what another field in the table is inputed? EX: I have a Ordertable(orderID,itemID,Itemdesc), and a Inventory table(ItemID,Itemdesc), When you select an Itemid to put in the order form, the order Description from Inventory would appear in the Itemdesc of the order form.
Is this possible? If so how?
2. In tables, is it possible to make a cell = to something? So like if I wanted to add a subtotal and a final total after tax, I could use = * .08 or something?
Can I fill all cells in a column that dont contain any data with the same value?
I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".
I am trying to self teach myself and I am sure I am going about his wrong.
I have a form with a fillable text box called ProcessCode, a drop down box called CostContainerSize, and a fillable text box called disposal cost. Their are dozens of possible process codes and container sizes of 55,30,15,5,P,Y etc... I want the disposal cost box to auto fill based on Process code and disposal cost. I wrote the following in the control source IIf([ProcessCode]="LF" and [CostContainerSize]="55","$65.00") THis works to auto fill, but obviously only for that particular set of parameters. I have tried adding "or " comments to include other sizes for that particular process code with limited success. I have tried IIf([ProcessCode]="LF" and [CostContainerSize]="55"or"30","$65.00"or"$50.00") among other variations.
I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant figure it out. Anyone?? Im not very good with code but if thats what it takes thats what it takes.
Hello everybody! Im new in Access as well as in this Forum! Glad to be here :) Im currently developping a small application in Access 2003 and here is my problem: I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber" Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox. Note: SupplierName values are from other table: Suppliers
I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:
API# Current Operator --------------------------------- 1 | 1 | 2 | Bob 3 | Joe 1 | Mike 3 | 2 |
I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.
Need some help with a table, or possible more to do with a form design..
I'm looking to autofill in a field depending on data that's in the previous field.
E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list.
It's probably a simple query or something I need to do..
Can anyone please help:confused: . I am setting up a database for events for local companies, I have an events table (event title, date, time etc) and a company table (name, address, postcode, tel, etc) They have a one to many relationship, with the events table being 1 and the company table being many.
I have a main form with the event details and I want to add a subform for companys, but would like this form to autofill the companies address and contact details when I enter the company name. Is there a way you can do this? :)
I have a combo box for rooms: single, twin, double, suite, grand suite
This is found from a lookup table
In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box when the type of room is selected?
I need some help with getting my form(form 2) to autofill from another form(form 1).
Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.
Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.
p.s why is it access books tell you everything except what you want to know.
I have 2 forms with 1 combo box in each form. I would like to be able to choose, for ex. a date in 1st combo box and be able to have that displayed in the 2nd form in the 2nd combo box.
Hi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused) Anyway I have a form which is based on a table that holds all the info for orders placed by customers. It holds info on all the orders plus some info about the customer
Example of Orders Table
Order ID Customer No Suburb State Item Number Qty Ordered Description Length Weight Order Type Day Received Last Dispatch Day Actual Dispatch Date Comments Date Due at Customer
On this form I would like a combo box which is linked to a Customer table which has all the details regarding the customers. When I pick the customer I would like all the other fields relating to the customer on this form (Customer No, State, Suburb) to be auto populated to save entering data individually.
Example of my Customer Table
CustomerID Customer Name Customer No (not unique) State Suburb Customer Factory Rail Terminal code Destination Rail code Destination Road code Cust Code
I manage a self-made database of property deeds for my business. Since it often happens that there are multiple owners and multiple buyers of these properties, and that many of the owners and buyers are the same people from time to time, I think I can manage this database more efficiently by using subforms that autofill when I start to type a person's name. I hope this is possible.
My main table and form are based on the deed description. Each deed will have unique buyers and sellers and each buyer and seller can be on many deeds. Thus far I have created tables and queries for sellers and buyers. The seller subform is set up and can accept entries in the form view. When I scroll from record to record, the names seem to show up where they belong, so I'm happy with that. The problem is that when a name comes up a second (or more often) time, I end up typing the entire name in again. This sort of defeats the purpose of having related tables. How can I get it to recognize that the name is already there and perform an autofill for me? What am I missing?
I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box.
I have a table with the following fields: PK - autonumber Frequency - text TimeD - text TimeN - text
The frequency entry describes the frequency at which paramaters are to be measured, and Time1/Time2 are the times that are set by each frequency for Day and Night resp.
I know this has been discussed ad nauseam, but I have spent almost a week searching this forum as well as a couple of others, and just keep coming up short.
I have uploaded a zipped db that will better illustrate where I'm at with this project. Please have a look.