Search results

Many thanks vbaInet and Steve!

Okay, now I've got the following, but Visual Basic isn't happy with the last line, and I'm sure it's just because I don't know the correct command/syntax to achieve what I'm attempting, but it will likely me most obvious! :-) Private Sub Form_Current() Red = Val("&H" & Mid(Me.rgb, 1, 2))...

Alright, I've attempted to use this code, but it's not happening and I can't see what I'm doing wrong. Any hints? Box18.BackColor = rgb(CInt(Mid(Me.rgb, 2, 2)), CInt(Mid(Me.rgb, 4, 2)), CInt(Mid(Me.rgb, 6, 2)))

Thanks for that Steve. I was intending to try to figure out how to convert the hex numbers manually and feed them in as numbers Access understands. Hadn't realised vbaInet had put in a function to automatically convert them. I'm not sure it's converting them correctly in that case, as if you...

Top banana! :-)

Perhaps one day I will understand your joke. :-) I still don't know where to put the code right enough. Help! :-) The colours are on-screen approximations of paint colours that we use. Not really my doing, so I can't take credit for them. Richard.

I 'thought' it might be something simple like that. The thing is, I've hardly done anything in Access (or indeed similar) so I'm not sure where to actually put that code. I've put some code into an Event/On Click box before, but of course the Back Colour property box doesn't have an option for...

My data has the colours in hex, stored in the table field named 'rgb'. When you look at the form, there's a big yellow square, I was wanting that to be whatever the colour stored in the 'rgb' field was...?!

Okay, that’s a bit out of my depth. Perhaps if I simplify my problem the answer will be simpler (then again perhaps not!). Assuming I don’t need to check for null values, and that we forget about the hex codes for the colours, that I’m giving Access the colour in the form it uses in the Back...

Another idea - it doesn't have to be the colourcode field's back colour that is set to the hex value, it could be a rectangle or whatever, just want to see a block of colour set by the colourcode field's hex data contents... Or if hex is a problem, if I could convert all the hex numbers to...

Thanks for your reply! The table has six fields, thus: ID (autonumber) code (this is a four digit 'RAL' code number for a paint colour) glosslevel (either 'gloss', 'satin', or 'matt') colourname (the name for the colour) stockqty (how much of that paint we have in stock in kgs) colourcode...

Hi, I'm imagining this is probably a very simple thing to do, but I'm at a loss. I'm using Access 2003, and I have a table where one of the fields is called colourcode and contains a hexadecimal number representing a colour like you would set it in HTML. What I want to do is, on my tabular...

Excellent! The February entries are now showing up also! Thank you all for helping!

Thanks for your reply! The format for my Despatch (date) field is set to short date (as is the input mask on the input box), so they're all like 21/01/2010 02/02/2010 etc. I tried the trim thing you suggested, but nothing different happened. I take it that was just to do with if I had a...

Not sure why the filter was working when I typed some dates in, but not for others, so I've deleted all the records in my table and entered new info from scratch. Ran the form again and it was looking good, all the records I entered were showing up when I typed in the relevant date to my entry...

Thanks David, I'm getting somewhere now! I gathered from your reply that instead of .txtDate I should have the name of my field (Text24) so changed it accordingly, and now it is sort of working: Me.Filter = "[Despatch]=#" & Me.Text24 & "#" Me.FilterOn = True When I enter a date into the...

Thanks David. Having a bit of trouble. I've created the form from scratch again, using the new form wizard and making a tabular form from the ManagerData table where my data is. Up in the header section, I've inserted a 'text box' (is this correct?). In the properties for the text box...

Two days and no responses... Did I describe the problem badly? Is it a silly problem? :-) HAILP!!!

Hi, I'm using Access 2003, and have only done a couple of small things with it thus far so not that familiar with it (or similar programs) yet. I have created a simple table with several fields (mostly text), one of which is a date. I've set the Data Type:Format for that field to Short Date...