Repeating Names In Combo Box
Aug 6, 2007
Hello to all on this site, I am hoping someone here can help me in my journey to learning Access. I have some experience writing simple/moderate code in VBA for Excel, but I am now using Access to create a database to monitor/track progress on projects for an initiative at my work place.
My question revolves around using Combo Boxes. I have one table/form (tblEventSummary/frmEventSummary) where the user will enter data regarding a project they are working on. One field is called txtEventLeader. What I want to do is to create a combobox which will allow the user to either select a name from the dropdown list (of names that have been previously used) or to enter a new one. When entering a future form, I want any new names used to also be displayed in the combobox.
I was kind of successful doing this already using a query (qryEmployees), but if the same name is used in txtEventLeader, I then see that name twice in the combobox and in the associated query. I would appreciate any recommendations for what to do here. Hopefully I was able to ask a clear enough question...
View Replies
ADVERTISEMENT
Jan 17, 2014
How can I repeat column names and row names on multiple pages of the report ?
View 1 Replies
View Related
Dec 4, 2012
I have a form with a combo drop down box to select item from.The problem is once i've picked from a list this result shows up on all forms from #1 to end. I only need value picked to become record, only for that record.
View 1 Replies
View Related
Dec 30, 2005
Hi,
How do you display the names of field for a table in a combo box. I know how to do it in mySQL "DESCRIBE employee_data", is there a SQL command in access to do this?
thanks
Sean
View 6 Replies
View Related
Dec 11, 2004
my search form has a combo box with "make"names. i can add new makes via a other form. so the combo box needs te run via a query so that it can list new makes (so that i can also search them). but, since some makes repeat them selves in the table, sometimes up to 15 times (see atachment 1), the combo box will show 15 times the same make. i just need it to show the make 1 time, all of the makes just 1 time. only way i can do that is to type them my self (see atachment 2). but then new makes that are added later wont be shown in the list.
so: i want that the make is only shown once in the list, and that the list is updated with new makes that are added later. how do i do that?
note: a "make" E.G = Philips, Apple, LG, Microsoft, creative etc (just for the lesser skilled english readers like me )
all help is welcome
View 2 Replies
View Related
Jan 19, 2014
I have a combo box that brings up records for an individual. I have people with the same last names and have their first names showing on the combo box list, but when i choose one of them, it will always go to the name of the person who was entered first, so matter who i pick(that has the same last name).
View 1 Replies
View Related
Jan 22, 2014
I need to give users the ability to change the font of a field in a report. The field shows a barcode.
I thought of using the CommonDlg class to show the Windows font-selecting dialog box, but installed barcode fonts show as a barcode. I need to show the font name.
So I need to populate a combo box with the names of all fonts installed on a computer.
The fonts reside in C:windowsfonts
I have searched Google for a solution but cannot find one.
How do I populate a combo box with the names of all fonts installed on a computer?
View 4 Replies
View Related
May 15, 2013
Currently, I have a form with a combobox that lists all of the names of the tables inside my database. Depending on the table selected in the first combobox, I would like to have another combobox which allows the user to choose from the field names inside that table.
View 3 Replies
View Related
Nov 7, 2006
I have a form with several data fields on it. I also have a button on the form that allows the user to duplicate a record . The reason for this duplication is so that if there will be an additional client record for the same customer, but only one piece of data will need to be changed, it's easier to copy the record and then change the one field.
However, I am getting the following message:
"some of the field names you tried to paste don't match fieldnames on the form"
and then not all data in all fields gets duplicated.
I need to figure this out, but am going nuts with it. If anyone has an idea or two they'd care to toss my way, I would be happy.
Thanks one more time, in advance!!
View 1 Replies
View Related
Apr 24, 2013
I’m developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. There are 16 different “Events” in all.I currently have the following tables set up:
tblClaim
ClaimID
ClaimNumber
fkEmpID
tblEmployee
EmpID
EmpName
[code]....
What I need to do is create a form where management can choose two or more events, and calculate the average number of days between two of any of the events, for an employee, or all employees.I have created a crosstab query to change the values in the EventName field in tblEvents to field names, and the EventDate as values for the related EventNames. I created another query based on this query to do the DateDiff.
I created combo boxes on my form with the Row Source Type set to Field List, for a list of fields in my crosstab query. I’ve tried to use the following DateDiff function to get the days between the two fields selected in my combo boxes:
Code:
DateDiff("d",[Forms]![frmReportBuilder]![cboEvent1],[Forms]![frmReportBuilder]![cboEvent2])
But I get an error about unrecognized field name or expression for my combo boxes. So I added my combo boxes in the query parameter window, with a data type as both text and value, but with both I get an error “This expression is typed incorrectly or is too complex to be evaluated.” I also specified the column headings in the crosstab but I still am getting the “too complex” error.I’m pretty sure it’s trying to do a Datediff on the literal values in the comboboxes and not recognizing that I’m trying to specify field names.Is it possible to assign field names in DateDiff this way?
View 1 Replies
View Related
Dec 25, 2005
hi
my problem is when i export data form table or query to textfile it give me repeating rows my computer is win me
help me
View 2 Replies
View Related
May 12, 2006
As posted here
http://www.access-programmers.co.uk/forums/showthread.php?p=489795#post489795
I thought its better to mention it here as well:
How do I get the query to repeat itself to gernerate extra rows of info.
I have "[Enter Ingredient Code]" in the criteria section on one column, this gives me a popup when starting the report to enter the code. I would like to have this reappear to enter more information. Maybe the action to with another pop up box like
"Would you like to add another ingredient"
"Yes" "No"
Click on yes and the query will rerun and enter the data in, select no and the report is made.
M
View 1 Replies
View Related
Nov 29, 2006
My table has the following fields
ItemNo Name ImageName DateRecd
123 Foo 00123.jog 1/1/06
123 Foo 00FOO.jpg 10/11/06
123 FOO FOO123.jpg 7/5/04
456 bar 00456.jog 6/10/06
456 BAR 00BAR.jpg 7/5/00
456 Bar BAR456.jpg 11/23/06
How would I write / get a query to run and show me, the 2nd item numbers, the 123 but only the most recent date so 10/11/06 and for itemno 456 the item dated 11/23/06
View 5 Replies
View Related
Dec 6, 2006
Here we go again i have another problem.
I am finding it very hard to explain my problem so i have attached a copy of my database:
Have a look at NUMBERPLATE OPTIONS in the booking table. When you click on this field you have to type in the END DATE and the CAR TYPE to generate a list of numberplates that can be selected. This END DATE and this CAR TYPE have already been enetered into the BOOKING TABLE for this particular record. Is there anyway of repeating this data entery?
Iain
View 4 Replies
View Related
May 25, 2007
hello,
I have a form, and I am on record "A". When clicking to add a new record "B" I want all the same information on record "A" to show on the new record "B".
How can I do this without using default?
Thanks
View 8 Replies
View Related
Mar 27, 2014
I am attempting to perform a normalization process in a query where an organization would be operating in several different states and different countries. I have created three tables where: one table is Organization, second table is Country, and the third table is State. I made a table to record: Organization ID, Country ID and State ID. An organization could have 1 or more countries while having no US states. Also the organization could have 1 or more countries while having 1 or more US states.
What I am seeing is in my query is:
Organization | Country | State
Organization | Country | State
Organization | Country |
What I am wanting to see is:
Organization | Country, Country, Country | State, State
In the end, I want to make a mail merge from this query table.
How can I 'normalize' the query?
View 1 Replies
View Related
Dec 2, 2004
I have read lots about importing files but can't find anything on how to handle importing data that repeats itself in blocks from with in a txt file.
Note that I intend to run the import as an event each time the db is opened.
the data is an audit log that looks like this:
Date: 12-01-2004 Time: 11:16:57
Transaction #: 061318 Cashier ID: NB
Computer: COUNTER2
Sale Recorded. Transaction Total: 2.5
Date: 12-01-2004 Time: 11:20:55
Transaction #: 061319 Cashier ID: NB
Computer: COUNTER2
Sale Recorded. Transaction Total: 5
Date: 12-01-2004 Time: 11:59:48
Cashier ID: RC
Computer: COUNTER2
Deleted All Lines From Transaction
Date: 12-01-2004 Time: 12:01:17
Cashier ID: RC
Computer: COUNTER2
Opened Cash Drawer--NoSale
Whats the best way of doing this.
Cheers
View 4 Replies
View Related
Aug 14, 2006
Hi,
On my form, we can enter time off for employees. This is working pretty well, but we have some employees that have flex days every other week or even once a month.
What I would like to make possible on my form, when the user is inputing the data, He makes the initial entry, and then he has an option (checkbox?) that they can select to make this same entry every (week, other week, or 1 month from the date). Have it repeat for a year out maybe, so if the user has every other friday off. It will make an entry for every other friday for the next year.
I've been searching the forum, and I've been reading on the dateadd function. But I'm not sure how to implement it on this form, not sure if there is a way to make it repeat for a year? Also not sure if it's possible (or if that's the best choice) to have checkbox for choices using it?
Any ideas suggestions?
Thanks
Chris.
View 4 Replies
View Related
Mar 16, 2005
I have users who use a form to enter data. One of the fields is "DateRange". The users tend to enter records in groups. The group of 10 records will all have the same "DateRange" As they start a new record is there a way that the "DateRange" field can copy from the prior record?
Any help would be great!
View 8 Replies
View Related
Nov 1, 2006
I am basically setting up a macro that will change the value for a field from "N" to "Y" for all records from a query. The macro works fine except for it does not know when to stop and gives an error message of "You can't assign a value to this object" after it has gone through all of the records and there are none left to change. The macro is set up like this:
OpenForm Action : This form is populated by the query and I set the Where condition to open records that don't already have a value of "Y".
SetValue Action : I use this to set the value of the field to "Y"
Close Action : I use this to close the form and save the changes
RunMacro Action : This is where the problem is. I use this to repeat the macro so it can go through the rest of the records that still have the field set to "N". I need to set the Condition or Repeat Expression so that it checks if all of the records have been changed. It either needs to check that all records have the field = "Y" or check that the macro is on the last record. Basically something that will cause the macro to not open itself again when there are no more records to be changed.
View 2 Replies
View Related
Jan 7, 2014
I have a form that uses VBA codes to write all the info from the controls in the form into different relational tables. I was stopped at the point that I wanted to have repeating controls. Collect multiple instances of the same type of data, such as in the case of writing many people's Name, Age and Specialty in the Employees table. How do I do that? What is the VBA code for this task?
View 1 Replies
View Related
Sep 22, 2014
My query has the fields setup ID, Date, Session, Value.In a report I am trying to create a bar chart that shows session names on the y axis and values along the x axis. I want to show 1 chart per ID.However, when I run chart wizard and create my chart I am getting charts for each ID repeating by the number of sessions (number of records in my query).So for example with 3 sessions im getting:
ID: 1 - Chart
ID: 1 - Chart
ID: 1 - Chart
ID: 2 - Chart
ID: 2 - Chart
ID: 2 - Chart
ID: 3 - Chart
etc.
Where the chart is setup the way I want it, but it repeats for each session.how I can get the report to show 1 chart per ID?I tried grouping by ID but didn't seem to work
View 3 Replies
View Related
Aug 3, 2005
Hi,
Over the past three months I have been trying to develop an application which can repeat appointment entries.
I would like to have the option to repeat an appointment entry for a given number of weeks.
For example if an appointment entry was placed for today (Wednesday), there would be a command to create additional duplicate enties for the same day of the week for a given period of weeks ie say every Wednesday for the next 52 weeks.
Any help on how I could approach this would be very much appreciated.
Thanks
View 1 Replies
View Related
Mar 1, 2006
Hello hello. I'm new here, and new to Access... I've just started taking Microsoft's Office Online training tutorials and I was wonder about planning tables and repetitive data.
I had transferred some stuff from Excel to Access but now I'm looking at redesigning my whole database using relationships, etc.
I'm mostly working with a mailing list, so my fields are:
Mr./Ms.
FirstName
LastName
Title
Company
Address
City
State
Zip
Okay. There is also a second list of contacts that will link to the Company field. But my question is, most of the contacts in this list have the same title (be it President or CEO or whatever...) -- there's only like four variations.
Would I make a separate table with just those four titles, so I don't have to repeatedly type "President" in the title field?
And then if so, what about things like Mr./Ms.? It's only two variations and every record needs one. And what about State? Again, only two states ever. These don't get their own little "related" table, do they? And if not, how do I avoid typing it every time??
Thank you so much for reading this, and thanks in advance for your help.
~Jas/LadyGrey
P.S. I have another major question too, actually. As I said, I'll have two different lists hinging on the Company name. Except I have some companies with multiple contacts... so I don't think I can make the Company the primary key, since it may be repeated for a few records. Help, please! Thanks!
View 2 Replies
View Related
Aug 7, 2015
I need to create a form and report. I created a Form now (i want to Report too.) but i saw, some field records are repeating themself.
I give an example :
ID Group Project Name Maintainers
1 A X-File Top-Secret Saruman
1 B X-File Top-Secret Gandalf
1 C X-File Top-Secret Radagast
On my report or form i want to see only :
ID: "1"
Group: "A" , "B" , "C"
Project: "X-File"
Name: "Top Secret"
Maintainers: "Saruman" , "Gandalf" , "Radagast"
Is that possible to filter records like that ? and How ?
View 3 Replies
View Related
Nov 3, 2014
I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every other field is calculated. A + B = C.
I have something in field A and I am putting the input in field B to get teh results in field C. So that's say that I queried for a certain analyst and I get four records. When I input anything into first record the input is in all the records for field B. This is where I am having a problem. I only want to input into the the corresponding record and not all the records I query.
View 14 Replies
View Related
