473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Change Field Name on a ComboBox

I have a reports that I need to reword:

Billable Hours by Employee
Billable Hours by Project
Employee Address Book
Employee Phone List
Non-Billable Hours by Employee

I have a combo box that shows these reports and a button that opens up the reports I selected.

I want to change the wording a little bit to show in the combobox

Hours Worked by Employee
Hours Worked by Project
Employee Address Book
Employee Phone List
OT Hours Worked by Employee

I have changed my reports to reflect the name change, but I just don't know how to update my combobox. Is there any way to keep the orignal report information in the combobox, but display the name differently in the combobox?

I can always email you a copy of my database if you'd like to play around with it.

Thanks!
Mar 13 '14 #1

✓ answered by NeoPa

Select the report in your database (not the shortcut but the report itself). Rename it.

There are many ways to rename an object. I'm surprised you would need to ask about that. One is to use the F2 key. Another is found from a list after right-clicking on the object. There's another option from the menu or ribbon that I'm not familiar with as the other methods are so much easier.

6 2174
zmbd
5,501 Expert Mod 4TB
Please do not attach nor send your database unless one of the experts/moderators/admins ask for it.

What we need to see is the base information behind your combobox control.
Open the form in design view
Right click the combobox in question.
Select Show Properties in the popup
Select the data tab
What we need is the information in the following property fields:
Control Source:
Row Source:
Row Source Type:
Bound Column:

We may need more detail about Row Source depending on your answers.
Mar 13 '14 #2
Thank you for responding ZMBD!

I have to warn you, I'm not very knowledgable in ACCESS. This is what I show in the database that I'm using.

Control Source: Is Blank
Row Source:
Expand|Select|Wrap|Line Numbers
  1. SELECT MSysObjects.Name
  2. FROM MSysObjects
  3. WHERE (((MSysObjects.Name) Not Like "*Subreport*")
  4.   AND ((MSysObjects.Type)=-32764))
  5. ORDER BY MSysObjects.Name;
Row Source Type: Table/Query
Bound Column: 1

Thanks again for your help!
Mar 13 '14 #3
NeoPa
32,556 Expert Mod 16PB
If the reports are already renamed then your existing code (.RowSource) should now produce a list to match that.
Mar 14 '14 #4
Thank you for your help NeoPa and your patience. I think I renamed the shortcut to my report but haven't actually renamed the reports. Is it possible for me to rename an existing report? If so, how would I go about doing it? Thanks again!!!
Mar 14 '14 #5
NeoPa
32,556 Expert Mod 16PB
Select the report in your database (not the shortcut but the report itself). Rename it.

There are many ways to rename an object. I'm surprised you would need to ask about that. One is to use the F2 key. Another is found from a list after right-clicking on the object. There's another option from the menu or ribbon that I'm not familiar with as the other methods are so much easier.
Mar 14 '14 #6
NeoPA, THANK YOU, THANK YOU, THANK YOU, THANK YOU!!!! Thanks to your help, I was able to get it figured out. You're a life saver! And great and prompt responses! I really appreciate your help and patience with me!!! Thanks again!!!
Mar 14 '14 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Stuart Palmer | last post by:
Hi everyone, I have a form with '/' in some of the field names, when I pass through to the next page the field name comes back as though it's been htmlencoded, so getting the value out of the...
4
by: Wim Roffal | last post by:
Is it possible to use javascript to change the name of a field in a form? Thanks, Wim
2
by: Ray | last post by:
I tried to change the field name in a query using "New Name: ". It did not work at all and just display the caption of the Field Name. Is it possible to change the field name or use a new caption...
5
by: David | last post by:
Hi I seem to be getting nowhere with this. I am opening a form which will be used to input Notes into different fields in a table. My problem is changing the unbound field name to the field name...
11
by: Eych | last post by:
I get a VB error when I try to update a table whose field I change with the following statement: dcUpdate.Dataset.Tables(0).Rows(0)("User Name") = Me.textbox1.Text if I change the field name...
5
by: HS1 | last post by:
Hello I have a datagrid to show data for a database table using "seclect * from tablename" The datagrid works OK. However, I want to change the name of the fields in the database to other...
12
klarae99
by: klarae99 | last post by:
Hi everyone, I am new to Access 2003 (though my time on scripts has helped alot) and am creating an inventory database. In my original table design I had a field tblTrans.Date which I was advised to...
1
by: bassi.carlo | last post by:
I have an application with many combobox in different forms used for choose a particular length (for example items are "ft" - feet, "in" - inch, "m" - meters, and so on). I don't want to put in...
7
JustJim
by: JustJim | last post by:
Hi If all you can do with ALTER TABLE....ALTER COLUMN is change the datatype/size then how do I change the name of a field? I have several database files spread all over the state and some of...
8
by: Jeffrey Tan | last post by:
So i have a few forms that are named similarly: Maintenence-users Maintenence-files Maintenence-printers i have a combo box that shows these forms and a button that opens up the form i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.