Is there any way to change the colors of different lines in a label/textbox?
For example, the default text color is black. I want to have the first line of the label text black, the second red, then set it back to black for the last one.
Reason i'm trying to do this is I have a calendar form, with boxes (labels) for each day of the month. Each day will have a few items on it, and I want to be able to control the colors...
matt753
Last Activity: Aug 18 '10, 09:03 PM
Joined: May 6 '10
Location:
-
Is there a way to set a specific color for each line in a label
-
Which form event fires after any field is updated?
I'm trying to find which event fires after any of the textboxes are updated on my form. I have an average field, and any time a user changes any one of the 20 textboxes I want it to update.
Or, is there a better way to do this?
I have tried Form_AfterUpdat e, Form_DataChange but no luck -
Backend file size jumped from 50mb to 200mb
What would cause the file size of my backend to jump from 50mb to 200mb (seemingly) overnight? It has always been right around 50mb, growing slowly as more and more data is being entered into it.
I am using Microsoft Jet Engine for the backend with Access 2003. -
Oh ok this makes sense now, and I guess i shouldnt be too worried anyway, that decimal would have to be multiplied by a very large currency amount to even make a $0.01 difference.
Thanks for the help and explanation -
Thats understandableLeave a comment:
-
Sorry I got a bit confused with some of the posts back and forth here we each thought we were talking about different things.
The Dlookup returns the "0.05" or "0.12" from the 'Rates' table, and puts it into a double variable. The variable 'CTaxRate' is then put into a textbox.Code:CTaxRate = DLookup("[RateValue]", "[Rates]", "[Rate] = '" & CRegion & "'")Leave a comment:
-
Yea kind of went off topic of the Dlookup but I suspect the overall slow speed must be the problem. A lot of other Dlookups run quite a bit faster in other places in the database.
I tried putting a couple posts up in this site before (about the slow network speed) but never really got any responses.Leave a comment:
-
For some reason it runs faster with the backend on another users computer rather than the server. Should it not be exactly the same?
I thought it should almost be as fast as running it off the local machine with a gigabit network and SSD.Leave a comment:
-
The CTaxRate is a double variable, then it goes into a textbox.
The 0.0500000007450 581 is an example of what shows up up 0.05 was entered. it will be a number very very close to the two decimal version just with a lot of unnecessary numbers added on.
I think it might be storing it in the table this way for some reason. Even though it is set to 2 decimal places in the table design.Leave a comment:
-
Thanks that worked perfectly!Leave a comment:
-
Heres the code:
The returned value is going into a textbox. It is a double in the backend table, specified in the table design to only have two decimal places. When I inputted the value I only typed "0.12".Code:CTaxRate = DLookup("[RateValue]", "[Rates]", "[Rate] = '" & CRegion & "'")Leave a comment:
-
Seems to still run a bit faster if I move the backend onto the local machine. The whole database runs a bit faster, a lot less lag between switching records, etc.
Not sure why it slows down so much when running it off the server. We have a small Acer server running Windows Home Server with a 64GB SSD inside (only thing on the SSD is the backend). Have a new 24 port Cisco Gigabit switch, with everyone running gigabit to their computers....Leave a comment:
-
oh ok, so if i accidentally change the source for that record, the data is gone?Leave a comment:
-
It is looking up a 'Double' with 2 decimal places from the backend. It goes either into a textbox or a double variable.
I'm not sure if it has anything to do with it, but for some reason in the form, if the looked up value is "0.12", it will show "0.119385766345 " instead. Even if I put Round(DlookupSt atement,2)...Leave a comment:
-
If I put a debug dot in and step through it, once the yellow highlight is on the line of code, then I press F8 and it pauses for a few seconds then assigns the lookup value to the textbox....Leave a comment:
-
How do I make a .cmd file? Just notepad that 'net use' text then save it as the extension .cmd?
I know how to do it from the command line I just need to make a one-click file for other users to do this.
ThanksLeave a comment:
-
Changed them to indexed but still the same speedLeave a comment:
-
Dlookup running very slowly
Some of my Dlookups run very fast, where some take up to 3 or 4 seconds to return a value. The table the slow one is coming from is only 10 records and 3 columns.
What are the causes for Dlookup to run slow? -
Dlookup returning unnecessary decimal places
I'm using the Dlookup function to return the value from a table. The value is "0.05", in the table the fields format is number and decimal places set to 2.
When I run the dlookup, it returns "0.050000000745 0581". Where does it get this number from and why does it add on extra decimal places?
Even if I put Round(Dlookup(" ","",""),2) it still displays all those decimal... -
Save an embedded worksheet from a bound object
I have a bound object on a form that is "embedded" to an OLE field on the table.
If I have it linked, when I double click a field on the spreadsheet it opens excel, I can type text in a field, then save and close. When I refresh the form it will show up there, and it saves to the original file.
If I have it embedded, I can double click and edit the field right inside access, but when I save it it doesn't save...
No activity results to display
Leave a comment: