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.
Hello friends, Please can anyone tell me how i can make the selections in my combo box (combo is bound to column1 of a table) appear in ascending order, by name (column2). I.e. It's bound by column 1 (with is the Id#), but i want it to appear in ascending by column 2 (Usernames) to make selections easier. Please help :)
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'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 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
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 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!!!
I have a listbox from where i can make selections and generate a report for the selected values , the problem is the selections are limited to 28 selections, if i try to select even one more after that i get an error:
" Run time error '7769' " " The filter operation was cancelled. The filter would be too long."
Now is there anyway to make this limited selection changed to a higher value or unlimited??? so i can select as much choices as i can , even all of them if i want? Does anyone have an idea , i looked throught the properties of the listbox but no help.
I have a form that has names with a subform with information. The contacts are in a list box and the subform (in datasheet view) shows the phone number/email/etc.. of the selected contact person. I am using the form as a quick look up of a persons information. Before changing it to a list box, it was previously a combo box, and everything worked fine. i was able to requery the subform and the cooresponding info for the person would come up. However, its now a list box and i am having problems with the code to make this happen. I have a different button sending the names selected from the list box to a report...and that works fine, but i am obvisouly missing something to make it work with the subfrm requery. Below is the code i got so far. Any help would greatly be appreciated. its driving me nuts!
Private Sub QuickLookup_Click() Dim varItem As Variant Dim strWhere As String strWhere = "[memberID] = " For Each varItem In Me.MemberID.ItemsSelected strWhere = strWhere & Me.MemberID.ItemData(varItem) & " OR [memberID] = " Next varItem strWhere = Left(strWhere, Len(strWhere) - 17) DoCmd.Requery "subfrmqryindividual"
I have a form called frmNotInvoicedSearch and on that form i have an list box called listCompanyClient populated with our client's names.I then have a command button called cmdOK that brings up a search results form called frmNotInvoicedSearchResults.
Currently i can select one of the records and when i click ok it brings up the search results for that selected record.Is there a way that i can hold in the ctrl and select multiple options and the search results report as such?
I found a snippet of code online that I'm trying to use in an asset tagging database I'm developing, but I'm struggling to get it working. To start, I have a multi-column ComboBox that displays information in this format:
When you select an asset to be assigned to an employee, the ComboBox displays only the asset number (e.g., 1001). While that information is pertinent to our I.T. group, when Human Resources goes to collect an asset from an employee, they don't want to be taking cases off of phones or tablets to verify they have the correct asset number. They want to see the person has an iPhone5s and an iPad2 that they have to collect. So, what I'm trying to accomplish in my VBA is to have access read all the asset numbers and provide the descriptions of those items in another field.
The code I have so far is:
Dim ctl As ComboBox Dim varItm As Variant, str As String str = "" Set ctl = Me.Combo217 For Each varItm In ctl.ItemsSelected str = ctl.Column(2, varItm) & "," Next varItm Me.Text207.Value = str
Since this is code is something I found online, I'm not sure why I can't get it to work. I've never worked with the Variant declaration, but I think this may be where the code is breaking because whenever I remove the "For Each...Next", the code correctly assigns the value of column 2 of my very first row to my text box (Text207). Everything I've seen looks as though I don't have to declare varItm because it's function is to represent the rows that are checkmarked for ctl.ItemsSelected.
Basically I have a list box and I want to be able to pick several items from it (No relation except for the name in the Inital Assigned Field) then hit a button and then it opens another form and shows all the records selected. I want to this to see several records at once but also change the value of all the fields to the same value.
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 have a form with fields that gray out or disable depending on selections. If you make selections that result in disabled fields and then save/close it, how do you ensure the fields remain grayed out/disabled when you reopen it?
