Recent content by crysma

Thank you, it worked :)

Thanks for your help. I will try this out and let you know how it goes :)

Hi, I'm working on an application with VB interface and an Access backend. I need a way to let userschange and/or delete certain dates of they so desire. While it will change the dates just fine, if I try to delete a date by setting its value to null, it throws an error. Is there another way...

gah! Stupid date picker won't allow me to change the color! >.< I'ts so frustrating.. I've got more important things to do than worry about this all day..

I thought of a solution to this last night. Its not particularly elegant, but I think it will work. Basically, I'm just going to set the foreground value of dtpickerBdate to white, same as the background, when there is no entry in the database. This should make it *look* empty. In its onclick...

thanks so much jpbrassard. I'll try that out, and let you know how it goes either way :)

Thanks jpbrassard . But what if I don't want there to be any value at all? What I'd like is for the field to remain blank if there is no value entered in the database.

Hi, I have a date picker, dtpickerBdate with its checked value set to true. When the date has been entered into the database, it shows the correct birthdate. However, when there is not value in the database, it shows a default date of 2000-01-01. I tried changing the value to null in the...

Hi, I've been working on a reoport where the records will be grouped by the field intAverageExp. For the purpose of this report only, I'd like to get crystal to ignore the values after the decimal point and treat this as a whole number. Thus records with a value of 3.1, 3.2, etc would all be...

Thanks you were right. I just tried it again :) Thanks again Mark and Rick Sheryll

Hi Mark, Thanks for that. Unfortumately, its still not working. It is still throwing the same error :( Sheryll

Hi! I've been working on a program that will help us keep track of our subscribers. Among other things, a user should be able to find a subscribers Zone number by entering their community name. This works for most part, except if the community name has an apostrophe in it(and you wouldnt belive...

hi, Heres a brief overview on what im trying to do: We have a databse with cusotmer information, including their address. we'd like to group the addresses by region, so that all addresses in cities A,B and C go in the South east region, cities D,E,F, go in the southwest, etc. There are about 22...

the age is already calculated. Thanks for your help, i will try that out :)

I've just been given a table containing customer information by region and age. Basically, each row contains the name of the region, and then the number of customers in that region aged 18 years, the number aged 19 years, and so on till 65. However, the client has decided that they don't need...