Hi, I am having a problem using the combo boxe, I think it is an easy problem but I have been spending the all morning trying to find a solution with no success.
i am designing a form allowing to enter the different costumer information in our system. The costumers information are broke down in 2 tables TblCostumer and TblCostumerOffice where a single costumer can have many offices across the world. The form shows the main costumer with a subform showing the different offices location.
I wanted to use a comboxe on the main form allowing the user to go on the specific costumer page selected, I am just working with 2 fields for now CostumerID and CompanyName. The combo boxe is bound to CostumerID and is not allowing any change, I don't know if it is the right method because I would normally use combo boxe to change a field value not find a specific record. Should i use code in the after update event using the 'gotorecord' or 'findrecord' command?
I have built an example of a form that I am working on. My original design used the default record navigator bars that are setup when you use the wizard to create the form. I would like to remove those bars and use the linked combo boxes that I have placed onto the form instead.
My end all goal is to have those two record navigation bars completely gone from the form and have the combo boxes perform the same function they were used for.
I would like to keep the data entry portion of the form the same because I like the design and I like that I can limit it to data entry only so theres no chance that the users will accidentally modify existing data. However, if you have a different method of entering the data that will still provide me with the protection of "data entry only" that will be welcomed.
Hi everybody, In a continuous form, If I use a comboboxe with a criteria looking up a field in the same record, it seems that the combo boxe only looks up the value of the firsrecord, Iam not sure I understand why? I was wondering if it there was any method to be able to use Cascading combo boxe in a continuous form.
I have a combox field on subform C that shows records from a query.How do I get this combo to only show records that relate to an ID on subform B.I have a subform for storing contracts and these are stored against a company name.On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?
I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?
I have a form on which I have placed a list box which will return data from a query via cmd button.
Is it possible to use the same listbox to see different queries, using different cmd buttons? I will place multiple button each one of which will run a query that will show its data in the list box.
Hello, I have just spent ages doing searches and reading everything I can on locking. But, I have yet to find an answer as to how I can lock a specific field in a specific record.
e.g. Staff enter customer details, then at the end of the day the admin (me) checks it over and presses a big old button that stops them from locking certain fields in the current record only - they must still have access to the unlocked fields of the current record, and it must not lock any other records.
I'm guessing there's some VB code in the form of fieldname.lock = true, but then it locks the field throughout the whole table!
I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.
Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.
I have a continuous form for which the recordsource is a query that retrieves dates from 10 days in the past to 10 days in the present. I want the record with today's date to be at the top of the form. The record with the oldest date is always on top. Is this a scrolling issue? How can I get the record with today's date to appear on top?
I have a form with a subform which has a lookup table (combo box) as a field. I want to be able, when I select a certain item in the lookup to have it automatically open a form. e.g. A field called insurance class - I select motor, I want the motor details form to open. If I select Fire, I want it to open the fire form and so on. I have already created the forms. Please help!
I've attached a sample database. In this database, I'd like to have the combo boxes under the Week Ending label populate the data for the fruit name to the left of each box. For example, if I choose Week Ending 2 in the box next to Banana, I'd like to have the boxes to the right of the combo box auto populate with the data in the table. I already have started some coding, but I'm not getting what I want to see.
Here's the problem: the codes will only display the top row of data in the 9-7 and 9-14 tables, respectively. That is, if I choose week 2 for Banana and week 2 for Orange, the numbers that populate will be the same. Instead of this, what I would like to see happen is that if week 2 is selected for Orange, then have the second row of data, from the 9-7 table, populate into the textboxes on the Products form.
I have a query of "Donations" in a sub form and want to use a combo box to specify all donations having a specific date.is this a job for VBA code? or is there some other way.
I need to print a specific form based on the selection made on a combo box.
I have been able to set it up to open the relevant form when the user selects an option from the combo box, but am unable to find a way to be able to print the specific report based on the selection.
I have a command button which prints a report based on the data in my current form, but would like it to also print the specific form based on the combo box selection.
I have a combo box that I normally type the start of a Surname and it auto drops down from underlying database ID is now show in col count, only 1st two.
Surname Name ID jones/k kelly 33333 smith/m max 12345 smith/m monty 98765 white/t tom 55555
smith/m will short list to the two above, I can mouse click or arrow down to the 2nd one Press enter & its knowa the corresponding ID (= surname.Column(2)) and goes to the correct record.
What I am trying to do, is from another part of my program, eg an incoming email with the corresponding Surname, Name & ID Automatically go to this main booking form, auto enter surname "smith/m" - which is fine, the list shortens but It goes to the first matching on the list, ie max.
Is there a way to get it to go to monty using the ID 98765 which is unique.
Perhaps an odd request but actually nice to book each time through this same main form, I actually also want it to do the same from incoming phone calls, It can get the unique ID ok but can see a way for the combo box to jump to the correct & only row from underlying register.
Bit worried about trying to change the underlying select statement that the combo seems to be based on, perhaps this is the way forward but not sure how to do this & don;t want to risk messing the most important & already functioning well normal entry style.
Does anyone know some code that will take me to the record whose field "A" has value "B"?
It sounds very simple but I can't find anything the does it!
Basically I have a table or enquiry records, some of which are related. I just want to be able to click on a button to take the user straight to the related record. The current design does this using a filter but this is pretty rubbish as it meanhs that in order to search on all records I need to select all records again first.
If DCount("[Po_Num]", "Orders", "[PO_Num] ='" & txtPO & "'") = 0 Then MsgBox "Sorry, No record matched" txtPO.SetFocus
Else
MsgBox "yes" DoCmd.Close acForm, "frmPopUp" DoCmd.OpenForm FormName:=strForm, wherecondition:=strwhere End If
End If
End Sub ------------------------------------------------------------------------
"Orders3" is the subform of Form "GoodOne" . When the user enter the PO Number in txtPo, and press "ok" , it will go to that record. BUT it just show a new blank reocrd instead.
What's wrong with the programme ??? (is it the matter of subform ?)
I have a form which runs specific queries and opens a report using combo boxes, these work perfectly fine if I just try to run them in the form. I have put the form into a navigation form and if I try to run the same query I get parameter queries popping up instead of just running the query and opening the report.
I have a form that displays customer account information. The form is connected to two tables. each customer has their own account number that i use to lookup their information. right now i have to click on the account number field and click find to pull up the record. I have built a popup form that displays the customers names with their respcetive accounts. My question is, How can i use the popup form to select a customer name and have the main form goto that record without using the find button.
I was wondering how I could select a date for a particular field in my main form. What I'm trying to do is this: When I make a particular selection in one of my fields, I need to be able to specify a date that will be displayed on the main form, and also print on the report. I need to be able to select a specific date, and not a default date.
Hope this is clear, trying to keep it simple - which can be pretty complex.
Basically im creating a db that the company i work for will use for invoicing creating orders storing the clients we have and so on. This is my first time using access and ive been working on this project for a few months so my vba knowledge is pretty poor to say the least.
What i need is for the orders form to view the current order i have open in report format. Everything on this order form works and is linked to the invoice report that i created, i even managed to get it to print the current report. I just cant seem to get it to view the specific order im looking at, ive tried loads of things from using my crap vba to queries..
Would greatly appreciate some help on this as my boss needs this db completed asap.
I have the below code behind a form so that a combo box will display a specific list of items based on the data in another combo box on my form.
I have two copies of this same form for two different departments. One of the forms works like a dream. However, when I copy that form, change the name, and update the code as pictured below, the form is asking for a parameter FROM MY ORIGINAL FORM and will not requery the combo box. I can't figure out why...there is no reference to the original form in my VBA as you can see below. I tried deleting the form and re-creating it, I tried deleting the code and re-typing it to no avail.
Private Sub cmboType_AfterUpdate() Me.cmboAction.RowSource = "SELECT tblStatusList.Status FROM tblStatusList WHERE (((tblStatusList.Department)=[forms]![frmInquiryFraud]![cmboType]));" End Sub
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
I need to export a specific record in the table. The menu's export option only export the entire table. Is there a way to define certain record to export?
Note: Dates are in "dd/mm/yyyy" format. Also, not all data is in order in the table. It’s not how I would have designed it but that’s what I need to work with!
I would like to run a query that groups by custID & itemcode and also the most recent date for any price change. I would then like the query to display the relating price for the record it pulls out. (EG for custID 'AAA' and item 21, it would display the price of £5 as that is the value for the most recent price as of 01/06/2005) I then want to link the custID & itemcode to another table that has sales in, to check that we are using the most recent price.
Is there a way I can do this via a query or do I need to put some code together?