Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. crysma

    Setting date to null

    Thank you, it worked :)
  2. crysma

    Setting date to null

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

    Setting date to null

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

    Setting date picker value to null

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

    Setting date picker value to null

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

    Setting date picker value to null

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

    Setting date picker value to null

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

    Setting date picker value to null

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

    How can I get Crystal to ignore decimals?

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

    Syntax error(missing operator)

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

    Syntax error(missing operator)

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

    Syntax error(missing operator)

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

    hi, Heres a brief overview on wh

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

    Merging fields

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

    Merging fields

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

    How do i extract only part of a field

    Works like a charm! Thanks Geoff ^^
  17. crysma

    How do i extract only part of a field

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

    tables with varying numbers of columns

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

    Trouble calculating totals with formula fields

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

    Varying the number of based on totals

    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.

Part and Inventory Search

Back
Top