I've set up a form where i choose a country in one drop down box and this choice selects the exchange rate i get in another drop down menu. The exchange rates are controlled by a linked spreadsheet which automatically updates my database with the latest information. However, on my spreadsheet every country which uses the euro is grouped into one name 'euroland'. In my country drop down box though, are the individual names, france, germany etc. I cannot alter the spreadsheet as it is used by many people in the organisation. What i need to do then, it get my database to recognise all the European countries as 'Euroland', while still keeping the discreet names in my drop down menu.
I have a continuous form which selects records to view based on the stock number and the dates, beginning and end, entered by the user. This is based on query that gets data from several related tables. This is what is in the Row Source property of the combo box has in it: SELECT [qrywhobotit].[PROD_CODE] FROM qrywhobotit; don't know if that makes any difference to my problems.
The stock number is selected from an unbound combo box. The dates are selected from 2 unbound text box controls, one for start date & one for end date. I used the after-update event of the combo box and it filters the stock number. I also used the after-update event in the end date text control to filter the dates (from and to).
Question: How do I write the events so it selects the stock number for just the date range entered. I can get the stock number to get the correct records, but the dates are not selected, it shows all records for that stock number not just those matching the date range entered. If I comment out the stock number code, then records selected match the date range entered, I only see the dates I entered but it shows all the stock numbers, not just the one stock number entered. I can get the stock number to work OR the dates but not both at the same time. I think I need some sort of "and" condition, but not sure where/how to put it.
Here is the code I used.
Private Sub cbofindrecwhobotit_AfterUpdate() ' Find the record(s) that matches the control. ' DoCmd.ApplyFilter , "Prod_Code = '" & DblApp(Me.cbofindrecwhobotit.Value) & "'" ' Me.FilterOn = True End Sub
The above commands are commented out, I tried moving it all to the after update event of the end date text box control - didn't work (see following code). It works fine if I uncomment it, but then the dates don't get filtered at all.
Private Sub txtwhobotenddat_AfterUpdate() DoCmd.ApplyFilter , "Prod_Code = '" & DblApp(Me.cbofindrecwhobotit.Value) & "'" If txtwhobotstartdat.Value = "" Then Me.Filter = "FULFILL_DT <= date()" Else Me.Filter = "FULFILL_DT between " & _ "(#" & Me.txtwhobotstartdat.Value & "#) " & _ "AND (#" & Me.txtwhobotenddat.Value & "#)" End If Me.FilterOn = True End Sub
2nd Question: There are lots of records for any one stock number. When I use the combo box to select the stock number, I see the same stock number repeated again and again in the list displayed in the combo box , instead of just one of each. I tried turning both the Unique Values and Unique Records properties to YES on in the properties of the query, but that didn't fix it. How do I fix the combo box to display just a list of unique stock numbers?
I've created a ComboBox and would like one of my selections: "Met" to be converted into a number value: "10" within the related field on the table.I've come up with the expression: =IF([Initial Review Q1]="Met",0,10)
Control Source accepts the expression, however when I go back to Form View and select "Met" access chimes and states: "Control can't be edited it's bound to the expression =if([Initial Review Q1]="met",0,10)".
I need to create a form or a subform that brings up a list of records based on criteria that a user chooses in multiple list boxes. Is this possible? I am pretty new to Access.
I have a continuous subform that shows records from a table [not the table the parent form is based on] - a check box, a text field with text, and a blank text field for notes.
When I click on one particular of the checkboxes I see in form view, I can make the notes field/s visible. Unfortunately, that means right now that the fields for all the records become visible. If at all possible, I would like to set this up so that only one particular text box becomes visible.
Could somebody please tell me if this can be done, and help me do it?
My problem I am having is that in my database you can click around to different customers info on forms and from there you can click on a button to get to another form that lists all of the customers vehicles. From there I have a billing report that I created and I am trying to filter the report to get what I want on there.
I have been searching around and have found codes to filter reports so that right now I have it when I click on Billing Report it filters by the customers form i am on. But now where i am having some issues is that I am also looking to filter by a yes/no field so that anything clicked yes for that customer will be filtered to show on this report.
I'm really new to Access and using Office 2007. Comfortable with SQL but have no idea about VBA. How do I get the form to query multi-selections? For example if you download the attachment here and refer to "Form1", let's say the user multiselects BK and McD's for Vendor, burger for Food, and Coke for Beverage. It should be spitting out 3 records but instead spat out an empty table. I tied my last query "query2" with "Form1" to make them work hand-in-hand which filters the master table "Fast Food". Would I need to tweak the syntax seen in the "Criteria:" cells of "query2" to make them read in multiselections?
So I'm trying to populate a table based on selections I make within a form.
The form is based of a query that pulls a new product category that needs to be added to my first reference table for products.
The form shows all the new unique product codes, and there is a drop down box with product categories whose source is also the first reference table, so a new code would be:
'JBL - TRX - FVB - TRZ' And based on that new info, I would select from the drop down to select the corresponding category and click 'Add Record' button.
I'm building the event for the button and the code is as follows so far :
Private Sub Add_Record_Click() End Sub Private Sub cmbAdd_Record_Click() 'add data to table CurrentDb.Execute "INSERT INTO tblPVMTable(PVMJoinField, SummaryPVMCategory) " & _
[Code] ....
I keep getting errors with the main portion of code.
Using Access 2007. I have a form (Broker), with a combobox (cboClassifier), that I use to select 1 of 4 phrases, display the selected phrase and color the field with a color that I've assigned to each phrase.
Next, I have a report that contains all of the Broker names, addresses, etc. based on a query (qryBroker). I need the vba or whatever that colors the matching records based on the phrase selected by the combobox on the form, when the report is opened.
How to correct the issue below. I created a split form and I have 2 combo boxes that allow multiple selections. The one combo box for LOB (line of business) works perfect and does not create duplicate records in the datasheet view of the split form. The 2nd combo box with multiple selections creates duplicate records in the datasheet depending on how many selections are made.
I have checked this in the underlying table and there are no duplicate records, it is only in the split form datasheet. I have checked settings and configuration between the 2 combo boxes that are reacting differently and they appear to be identical...
I have a combo box in a form. The box is linked to a table called Therapy with 3 fields: TherapyID, Therapy_Type and Therapy_Cost.
The table has been populated with 5 records: 1 Physical Therapy $125 2 Occupational Therapy $125 3 Acupuncture $90 4 Swedish Massage $65 5 Raindrop Treatment $65
I have a field on the form that pops up the cost when one of these is selected in the combo box. This seems to be working but for some reason, and it's blowing my mind, the combo box refuses to let me select Occupational Therapy or Raindrop Treatment.
I have other pick lists of other things working perfectly well, allowing all selections and popping the costs into their little text fields quite happily.
Can anyone give me a hint as to why THIS one isn't working right?
I hope I can form this question so it makes sense. I’ve been trying to figure out a way to do this, if it can be done at all.
Ok, imagine I’m making a database of widgets. In this database I’m creating a table of widget name, cost, weight, and color. This part is pretty simple. Now, my widgets can come in many different colors. To accommodate this, I create a separate table for colors, let’s say red, green, blue, yellow and purple. I create a color item in the first widget table, and use the look up wizard to point it to the color table. This way on my forms I can select the color widget I want and have it all standardized.
This is where my problem comes in. My widgets can be multiple colors. How can I create a field in my widget table, to somehow reference that I can have a red and blue widget? So, when I query all my red widgets, I get the red ones and the ones with red in them?
Now, I could make an item in my widget table for each color and make it a yes/no field. But, my real problem is exponentially bigger than this so that isn’t what I want to do.
I have a table with four columns, each textural - boiler type, insulation type, build type, survey type. Of each coumn there are only a handful of options to select e.g five types of boiiler etc, 6 types of insulation etc. I'm trying to build a query whereby these data are summarised thus: Numbers of each boiler type, numbers of each insulation type etc. I've been messin around with 'counts' and 'sums' but my ultra-novice skills are lame here. Help!
I would like to select multiple records from my combo box not at the same time but each selection to be added to another text field in my form.
PROBLEM: When I select a record that 1st selection is populated in the other text field however when I want to select another choice to be added with the 1st choice the selection overwrites the 1st choice instead of adding to it.
How do I allow the user to select more than one answer in a combo box? It is a drop down menu with several choices. I'd like the user to be able to select more than one if desired and all choices would display when queried. Thank you much. :)
Howdy all, Ive got combo boxes, in a cascading style working well... but what id like to also have is a another dropdown list that shows the last 5 selected options (because often the data will be entered in batches and it should just save time)there is combo1 combo2 and combo3 If Sport is selected in combo1 then it displays combo2 with all the sports in it, so if golf is selected then the golf options come up in combo3 for example tiger, So id like to store Sport > Golf > Tiger Ive already got the value for Tiger being selected, so I can assign that easily enoughWhat id like to be able to do is store the name and its value in a combo box maybe showing the last 5 selections. Im just not sure what the best way to go about this would be, Should I make a table with say 5 rows? or is there a better way to go about it?Any thoughts or advice would be awesome,Cheers Ezy
Hey there! ive nearly completed my databse now, but i have one small niggling problem!
As you can (hopefully) see in error.jpg i have an order form which has a subform in it. Now the Order form itself with the addresses and all works fine, however in the subform if i try to enter a 2nd product things go awry and i get that error message. If there's only 1 product selected everything works fine and all the currency related expressions work fine. Im kinda stumped as to what's wrong. I checked the VB code and that all seems fine (although im not too great when it comes to vb) the subform options all seem right and im thinking the relationships are fine too... its kinda annoying really seeing as i gotta show this to my boss tomorrow and well lets say things would go smoother if it actually worked!!
In that subform im trying to get product information from a table called InputMedia and get it to record my selections in iOrderDetails. Im using a query to tie them together and im guessing that is the problem.
I have a listbox with about 8 different choices. i want to be able to query what is selected in this list box but I need to be able to select more than one choice so that my employees don't have to create multiple forms for the same item. Is there any way to select more than one option? It would help greatly even if I have to add code in VB I will figure out how to do it, thank you.
I have a list of codes that I would like to select among 50,000 codes in MS Access Database:
I can easily find one code but I don't know how to select multiple values:
My Query is:
SELECT [Codes for District].DistrictID, Univ2012.Schoolid FROM Univ2012 INNER JOIN [Codes for District] ON Univ2012.DistrictID = [Codes for District].DistrictID WHERE IN [((Univ2012.Schoolid)= 415030301, 415030303, 415030306, 415030309)] GROUP BY [Codes for District].DistrictID, Univ2012.Schoolid HAVING ((([Codes for District].DistrictID)=15));
When I run this query it gave me Syntax Error in Where clause...
This must be pretty common but I cann't figure it out.
There is a listbox that multiple selections are allowed. This listbox is bounded with a table field. All selections must be stored. I don't mind if each selection is stored as a different record.
I keep thinking this should be pretty simple, but more than 2 hours searching through posts has revealed no answers, probably because the answer is too simple.
OK, I have an append query. I've created a prompt to enter the number of the record the user wishes to append, as it is usually one single record. However, I've recently run into a problem that now there is the possibility of needing to specify more than one record at the same time to be appended.
How do I change the criteria syntax to allow the user to enter two, three, or a dozen (if need be) different record numbers? They are not listed sequentially, so I can't use a "between" statement. I've tried separating the numbers by commas, quotes, and so forth, but can't get it to recognise the records.
I made a listbox in which get's it's source from a field in a table named Soft. The field is named Software1.
This field contains a list off software that could be installed on systems. I allready can select multiple selections from the listbox but what I want to do is the following.
I want to press a button, and after I press the button I want that the selected Software is added to a new listbox which show the Software installed. The software in the second listbox would also be stored inside a Table so that I could print them out in Reports.
To simply explain what I'm trying to do:
SoftwareListbox >> Make multple selections>>Press button>> Adds selected software to InstalledListbox which stores in the softwarelist installed in a Table.
I really hope you guys understand what I'm trying to do. And sorry for my bad english, should have paid better attention during English class ;)
I currently have a form with a drop-down combo box that is used as a tool for selecting an employee's last name. After selecting a name, the text boxes below the combo box are updated to match up with the selected name.
However, I am trying to get the employee images to do the same thing, but it's not working. The employee photos are currently "Bound Object Frame" items. Any suggestions/help would be greatly appreciated.
I have a simple order entry system working with a subform containing combo box where a client selects various products from a table. These are recorded in separate table which allows for subsequent updating of the orders placed.
Now I want to refine this so that the user may make multiple selections as it is a bit laborious making 'n' single selections via a combo based subform.
Only a list box allows multiple selections but I would like some guidance on how to store and be able to recall and update the selected items.
I have an option group on a form, that has 4 possible options. I need to allow the user to select any combination of the 4 options, to be stored in fields in another table.
By default, the option group only allows one to be selected (hence the name "option"? ;) Maybe I should proceed a different way?
I had a bigger question earlier and it was answered but I am still having problems with a small part of it. I am trying to track the details of a meeting. who requested it, for what project, date, duration, who attended. I have everything figured out except accounting for who attended the meetings. attendees also called "analysts" have a manay to many relationship with the meetings. Because they can be a part of many meetings and a meeting can have many analysts. So I created a seperate table called MR-Analyst which was supposed to help me track which meetings each analyst attended. I don't know how the data entery form should look like, right now I have everything on it and linked correctly to track everything excep the analysts. how can I create a list box or something that I can select multiple analysts for each meeting and have that recored linked to the MR-Analyst table? Please Help!!!
