Sometimes the simplest of questions can be the hardest to find the answer to. I have spent the last 2 hours searching for the answer to this one. I'm sure it's on this site somewhere but the search is running way to slow for me to be of any use.
What exactly does the numeric color codes in VBA represent? I have downloaded a score of color pickers. utilities and none use these numbers in the way Access does. Ideally, I'd like to find a utility that will allow me to specify a particular color and then give me the corresponding code for that color.
Does anyone out there have any ideas on how I can get a full list of the error codes and their descriptions for microsoft access?
I've set up a simple table with two fields, one for the error code and the other for the description. I've written a short bit of code (see below) to build the table for me, but it only generates 88 codes with the highest being 746.
Now I know that there are error codes up in the 3000 area because I'm trapping a few of them.
What I'm looking for is a list of the error code so I may write an extended list in my error trapping routines.
Code as follows:
Private Sub Form_Load() Dim My_RecordSet As DAO.Recordset, My_DataBase As DAO.Database Dim My_Error As Long Dim My_Description As String
Hello, I was wondering, is there a way to comment out some of your SQL codes in Access querries, like you do in Oracle or SQL Server or VB? I need to know how to write comments in my SQL codes when usingh access
I run an after-school youth program for high school students. My issue is an accurate way to track attendance of students. We have MS ACCESS 2010 on our computers at work.
On any given day we may see between 30 to 50 students, so this is a small operation - - and the reason I'm adverse to buying fancy "custom" software and hardware "systems". Because students come and go and vary over time, we may see 100 kids in a given week, but in the past 2 years of operation, we have had well over 250 students come through our program, with some returning at various times.
What I would like is to be able to
1) Make a simple ID card with student photos and a unique ID # that can be ...
2) Scanned by a simple barcode system.
2b) Actually two barcode swipes ... one swipe at the front door / main entrance, and a 2nd swipe by a hand held bar code in the various four classrooms to be sure the student is not only in the building, but also went to the correct class.
3) That the input of that information dumps into our ACCESS database so we can track student attendance, and ...
3b) provide reports out to school counselors / principals of the numerous highs schools that our students come from, to let them know which of their kids are actively attending our program.
My questions are ...
A. Can this be done with ACCESS?
B. Would it be better to do this with EXCEL?
C. If ACCESS can handle it, which types of bar code devices would be the best choice for us to purchase? (We would need a total of five barcode scanners. One at the front desk, and one in each of our four classrooms.)
The system would need to be expandable seeing that this could easily be doubled in terms of classrooms and students within the next year or so. We are currently just 2 years old.
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.
I have access query opening in excel. After it opens i would like everywher where where is says "no", to make next 2 cells BLUE.
The code below is doing it, but it's taking few minutes. is there any way to speed it up ?
'shading non-matching items With objActiveWkb.Worksheets("Reconciliation Sheet").Range("b5:ak500") Set c = .Find("No", , , xlWhole, , , True) If Not c Is Nothing Then sAddress = c.Address Do c.Offset(, -2).Resize(, 3).Interior.Pattern = xlSolid c.Offset(, -2).Resize(, 3).Interior.ColorIndex = 33 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> sAddress End If End With
I can use Conditional Formatting on the text to color code the record data in a report.But, I want the text to be the same color.What I'm trying to do is add a Box control from the Design Tools and color code the box depending on the value of a field in the table. The box will appear next to the record.
The field is called ReminderTypeID and there can be only two values for this field - 1 or 2.If the value is 1 I want the box's BackColor to be red. Otherwise what ever color I assign it to in design view.I've tried the following in the On Current.
Code:
If Me!ReminderTypeID = 1 Then Me.bxCode.BackColor = RGB(186, 20, 25) End If
I get no error messages but in all records bxCode has the same color which isn't the one I'm trying to set.
I'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?
Is it possible to have a field (Color) on a form be set to a combo box. A drop-down box appears with Green, Red, Blue, Yellow, Other. When other is selected a dialog box prompt appears asking the user to enter the color. The response is then what appears in the Color field.
I'm trying to export my queries into an Excel product color coded to one simple field. for example if a aircraft in maintenance will only be available for four months from oct-Jan in the Pacific i want it colored blue. I want it keying off the region EX: (Pacific) So far It shoots out the product with one color, and I have to manually change the colors in Excel.
I have created a series of pie charts in reports based on queries. The data that is being charted are agree, strongly agree, neither agree nor disagree, disagree, and strongly disagree. I want the colors for these to be consistent in all the pie charts but they are coming out different colors on each chart: i.e., agree may be blue on one pie chart but yellow on another pie chart. How can I change the colors either in the pie charts or legends so that they are consistent on all the pie charts?
I have a lovely report that includes a small color photograph. I'm sending the report to print on my HP Color LaserJet, but it is printing in black and white.
I can't find anything in the Properties that specifies whether this prints in color or black & white.
I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.
Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).
I have a table that contains a Zip Code field. Some of the Zip Codes are missing the leading 0. Zip Codes are a 5 digit field and these codes only have four. how do I get Access to recognize the number of characters and then add the leading 0 to only the ones that have 4 numbers?
Has anyone had any dealings with a way to calculate distance between 2 zipcodes? Of course all the zips wouls be in the current DB.... Then need to query those within a certian distance of another zipcode. I have a feeling this will need to be linked to an external source or app........ BUT... Anybody have any experience with anything similiar?
I would like to print a bar code on my invoices and then have my delivery drivers run the invoice under a bar code reader when they return from delivering. I know how to print the bar code I am nit sure how to go about interfacing a bar code reader in access 2000. Any thoughts?
Hi i have designed a database where the users use a combo box to find a particular code they want..for example dog_brown or dog_grey, on the report which i have produced this code for the type of dog shows up to. I have another table which has a column with the code and also the description...eg dog_brown...brown dog. My users have asked me if on the report which i have produced can the description be shown instead of the code. I dont know if this can be done...any help would be grateful. Thanx
I was wondering where I might get a list of code I can use to change text in my program. If there is no list what would I use to get dark green. Right now I am using the following:
I have been wanting to ask this question for long. Is it alright to put too many codes in the various events of the forms and controls? Will it affect the efficient functioning of Access? Will those codes result in any absurd behaviour? For example, I have DMax function in the BeforeInsert of form followed by three If....End If codes. I have not faced any problem so far. However, I just want to hear the opinion of the experts.
I have three tables, Main Table, Table A and Table B. All three tables have a field called "Cutoff Time". The Main Table will look up the info from Tables A and B. Table A has a field called "Service". In the main table, there is also a field called "Service", which is same as the field in Table A. The condition is this: The main table should use the "Service" field to match the "Service" field in Table A to get the "Cutoff Time" from Table A. If there is no such match, then the "Cutoff Time" will be taken from Table B using another field called "Station". I was wondering, how can I perform such an operation? Do I need to write SQL statements?
I would like the textbox named "text7" to show the word "keswick" when the text inside the "txtUsername" is KH and show the word "Lawrence" when the text inside the "txtUsername" is LH. What sort of codes should I write? should it be SQL or Expression Builder or Code Builder? Thank you=)
I am working on a membership database that only has members from Canada and the United States. In the zipcode field, is it better to have two seaparate fields or is there an input mask that can handle both US and Canadian zip codes.
