I currently have a list Box populated with some table data which has 9 columns and 255 rows.
I want to enhance the appearance of the list box i.e. 1 row of data will be blue, and next row will be white, and the next row blue again etc etc
How can I do this?
Kind Regards
Richard
I do not have a great knowledge of Visual basic but what I want to do is if a Field = Deceased I want to fill all fields of that record with a gray background Fill and make the font bold.
Any help please, remember I am not very knowledgeable of VB, so please treat me gently
I would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?
View 2 Replies View RelatedHave now graduated to 2003 from 97 and was wondering if there is a way to configure the main Access menu so it doesn't look like cartoons. I hate the default "bubble" look...I don't know any other way to describe it at the moment, other than to say that the menu looks XP-like. I want the normal menu and look. Thanks for any help here.
Edit: I should add that I'm running Access 2003 on a Windows 2000 machine.
Hi,
Yesterday something wrong happened with my computer and got hanged!
I called a hardware person and he corrected the O/s. I am using XP (O/s) and office 2003. The hardware person told me that he has not changed anything in msoffice.
I have already created some applications in access 2003.
I have observed that the application swithboard appearace is changed and buttons on switch boards are looking now like access 2000. Then I checked for database window. The Table, Query, Form, Report etc are looking like access 2000 window.
I have captured present screen and my earlier screen how it was.
Can anyone help me to get original display of my swithboard ?
Thanks in advance..
Satish
Good afternoon,
I need to use a selection from a drop down list to change the criteria in a query as opposed to typing text in a parameter box. This is to allow the user to choose from a list and then click on a command button to move to the next query. There are 20,000 records in the table. The series of queries will take the user to 1 or 2 records in 3 or 4 mouse clicks.
Thanks
I have a list box (1L) in a form (1F) that list member IDs from a table. Then I have a query (1Q) that use (1L) member ID to get data from a table another related table. When I change the 1L and run the query 1Q the results is correct. So I added a new list box (2L) in form 1F that show the results of the query. When I open the form 1F the 2L is populated correctly by the query. Here is my problem. I need to have list 2L update when I change 1L. Here is what I did. I created an On Change event for 1L that has a code Me.2L.Requery, but nothing happens.
View 1 Replies View RelatedI have a drop down list with the following : Week And Weekend :. I want to change the Average field depending what is selected. But having a problem.
I'm using the below code, but does not work
Code:
=IIf([Days select]="Weekend", [Reports]![Weekend Settings]![Average),([Reports]![Week Settings]![Average])
I have a spreadsheet that has been downloaded from a website. On the website people have chosen from a group of 28 checkboxes their answer. I have imported this spreadsheet into access. I now need to be able to run a report that shows only the one they chose instead of listing all 28..
View 1 Replies View RelatedRefer to the image below:
I want to make a form with the following criteria:-
Has one dropdown list. (like in the picture) Has one table. (like in the picture) When I select an item (for example: Syarikat A Sdn. Bhd.), the table below it (yellow circled), will automatically change data according to the corresponding selected list so that user can edit/add/delete the data in the table.
The issue: I already made the dropdown list and table, but how can I make the number 3 condition.
I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.
I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.
My list box will be used to populate a form, is it possible that once the item is dble-clicked, it reverts to a different color to let the user know it has already been selected once or can the row be locked once it has been selected?
View 2 Replies View RelatedHow to change font in database objects list view windows? (not datasheet, table/query windows)
View 1 Replies View RelatedI am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
View 2 Replies View RelatedI am using MS Access 2007.
I have created a multi-valued field "Product Category" that lookups data items from a linked table. So, the Data Type for the multi-valued field "Product Category" is Number.
Now I want to change the Data Type of "Product Category" from Number to Text, and make a value list that I can type values in and can provide the same data items as the linked table.
How to change item source for the multi-valued field from a linked table to a list that I can type in values? Is there a feature provided by MS Access 2007 can enable such a conversion?
I am using MS Access 2007.
I have created a multi-valued field "Product Category" that lookups data items from a linked table. So, the Data Type for the multi-valued field "Product Category" is Number.
Now I want to change the Data Type of "Product Category" from Number to Text, and make a value list that I can type values in and can provide the same data items as the linked table.
How to change item source for the multi-valued field from a linked table to a list that I can type in values?
Is there a feature provided by MS Access 2007 can enable such a conversion?
The following code works to change the column header name for a listbox in form view when the data source is a local table, but not when the data comes from a sharepoint list.
Code:
sqlstatement = "SELECT ID, PONum as [PO Number], ActDate as [Date], VendorName as [Vendor Name], Service, BuildingNumber as [Building Number], ReservationDescription as [Description], POAmount as [Amount], QuoteType as [Type of Quote], Comments" & _
" FROM ActivityLog" & _
" WHERE (Activity = 'AcceptReservation') AND (PSCName = '" & Me.PSCCombo4.Column(0) & "')" & _
" ORDER BY ActDate;"
'MsgBox sqlstatement
Me.EditPOListBox.RowSource = sqlstatement
sqlstatement = ""
Also it appears that there is no such thing as a caption property for a sharepoint list column.
Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
Here's a query that the bottom listview in the attached form i.e. a listview representing a table of calls(many) to fims (1 top listview)
Code:
SELECT calls.id, calls.firm_id, calls.called, calls.said, calls.spoke_to, calls.next
FROM calls
WHERE (((calls.firm_id)=[firms].[id]))
ORDER BY calls.called DESC , calls.next DESC;
When I run the thing...I get a dialog asking me for firm id.
I want to change this so when I move up and down the firms LV (top)... the bottom LV updates taking firm id from the top LV with focus.
Access 2003.
Hi,
I wonder if this is possible! I want to change some of those default error messages that access pops up to my own messages.
Any help will be very much appreciated.
B
Hello. My database has around 6000 products, and as time has gone by, the database has got bigger and bigger, more and more text - its now a rather large 16MB. Now, everytime i make a small change to it and upload to the server, it takes me about 8 min uploadeing it. Not that bad, but if i have to change 3-4 times a day? Also, it wipes out the website during the upload, which is not that great. Is there someway to compact the access database somehow? Thanks.
View 5 Replies View RelatedI wondered if someone could advise?
We have recently changed our SQL Server and I am now trying to point an access database to this new server using ODBC connections.
I have updated my ODBC settings and altered the name to the new object. It stills seems as though the database is pointing to the old tables though as receiving an error message:
"The microsoft jet database engine could not find object....."
Does anyone have any suggestions?
Thanks
Hello,
I have a query.
When we open microsoft office, background gray screen appears. How can I change this screen and put my own screen?
Thanking you in advance...
Regards,
Satish Aralkar
Hello,
I am developing one softwater in ms access for small scale engineering industry. I have created switchboad wich comes at the center of the ms access gray screen. I wanted to change this gray screen of ms access and replace with my own. How to do this? can I change this screen?
Early reply on this is appreciated.
Thanks in advance...
Satish Aralkar
http://i.domaindlx.com/wheelofgod/Tripledemo.asp
I need to change the Query somehow. I had earlier made a table consisting of book # , Chapter # , and verse #. I had seen a triple listbox online and asked the designer to make the necessary changes to make it work. So he created 3 Queries, a book Query, a chapter Query, and a verse Query.
But later I decided to remove realizing that some columns were unnecessary, it messed up the chapter Query and verse Query. Can someone guide me how to recreate the Queries?
I'll post a sample for you to check. I reduced the data to make it postable, but it affected the "chapter" Query and the "verse" Query.
What I need to to is delete the "chap" column and the "vers" replacing them with the existing "chapter" column and the "verse" column. I would appreciate if someone can work with me on this one.
I have created a MS Access barchart by running a query. X axix has user name and y axis has counts. I would like to change every bar's color based on the x axis user name value .Is there a way to do that using vba code in MS Access barcharts.
View 7 Replies View Related