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

...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 event, I'll set the foreground color back to black if it is checked. Like I said, its not very elegant, but it will...

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

...D'Or'' I'd really appreciate any tips or pointers on how to get around this problem. The code snippet follows: strSQL = &quot;SELECT * FROM tblCommunity WHERE Community = '&quot; & txtCommunity.Text & &quot;'&quot; With rsZoneNo .ActiveConnection = cnCon .Source =...

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.