Search results for query: *

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...

Works like a charm! Thanks Geoff ^^

Hi, I was wonderning if anyone could help me out with a problem I'm having. I've got a database which contains, among other information, the date of registration for clients. These dates are organised in a dd/mm/yyyy format. Is there anyway to extract just the year using a query? I'd like to...

Hi, I was wondering if there is any way to not display a column of a table if the total for that column is zero? For example, if I had the following table: Col1 Col2 Col3 Col4 Row1 1 0 2 3 Row2 2 0 4 2 Row3 1 0 2 1 Total 4 0...

Hi, Let me start with what I'm trying to do. I'm pulling most of my information from a user information table containing, among other things, the users age group, location and sex. I've got my report grouped first by location and then by age group. What I'd like to be able to do is...

What I need it to do is to omit the whole column entirely if its total is zero. That means that the table in the example above should have only 3 columns, not 4, as the second column should be removed.