Search results

  1. P

    question about null value

    Hi SJ, If you don't mind, can you show me how to do that... Thanks in advance Thanks
  2. P

    question about null value

    Hi all, i had a form which is based on a query. I used to list a record which is specifically met the criteria..Is there any way to show a message if the query returned no record..My query works well. I only want to add a message if the result is null. SELECT Institutions.*, Recipients.Rec_ID...
  3. P

    diplaying a word with field

    Hi wayne, Thanks, It worked!!!!! Thanks
  4. P

    diplaying a word with field

    Hi all, This may be stupid question, can I display a word with a field I mean i wish to display a word "program" attached with a field like this [fieldname] program eg: special program easter program christmas program becuase this fieldname changes with different criteria...
  5. P

    Deploying Database in nodes

    Hi all, I had a database which is going to be used by 20 users. Which is the best way to deploy that in user's pc's. 1. By splitting the db to FE/BE and copy the FE to all the user's pc's or 2. or create a shortcut of the db and copy that to all user's pc Thanks in advance Thanks
  6. P

    Compact and Repair in command button

    Hi all, Can I assign compact/Repair code in a command button? SendKeys "%(TDC)", False Will this code do the job? Thanks in advance Thanks
  7. P

    listing records in report by yes/no field

    Thanks Brian, If I am not disturbing you, can I ask one more thing? Can i use this query based on a certain value . I mean in that criteria filel can i use two fields, that is one by this yes/no field and by a specific value??? Thanks
  8. P

    listing records in report by yes/no field

    Hi bryan, Can you please tell me how to do that Thanks in advance thanks
  9. P

    listing records in report by yes/no field

    Hi all, I had a report which is based on a table with one yes/no check field. Is there any way to list the records which is unchecked, I mean not selected. Thanks
  10. P

    DB for client-server use

    Hi Pat, Can I rejoin a splitted be and fe to a single mdb?? thanks
  11. P

    Trimming charecters

    SJ, Thanks for the support Thankachan
  12. P

    Trimming charecters

    SJ, I can't make that work..I am attaching a sample db with this..If possible please add the code to that.. Thanks in advance Thankachan
  13. P

    Trimming charecters

    thanks SJ Thankachan
  14. P

    Trimming charecters

    thanks SJ, Pardon my ignorance, where could I use this code, afterupdate or ???
  15. P

    Trimming charecters

    Hi all, In my form I use browse option to select a file from directory.In the field it will like this c:\database\xxxx.jpg . This c:\database\ will be constant all time . I want only xxxx.jpg in the field. How can I cut off this c:\database while updating the record. Thanks in advance...
  16. P

    Report head missing in second page

    thanks Rich....you saved my time Thanks
  17. P

    Report head missing in second page

    sorry I had posted the thread in wrong area. sorry-
  18. P

    Report head missing in second page

    Hi all, I had a problem in my reports. If the reports had more than one page, in the second page onwards the report heading is missing. That is not a big problem , but I want to know why it is happening or something mistake I had done. Thanks in advance Thanks
  19. P

    deploying db in clients

    Wayne, Thanks for the tip. I am working on it Thanks
  20. P

    deploying db in clients

    Hi all, I had created a db and I want to deploy that to 15 pc's . which is the best way to accomplish that..I want to reduce the traffic to server. Can I use the same shortcut to the db in every pc? Thanks in advance Thanks
Back
Top Bottom