Search results

  1. B

    Filter on a Date AND a combo box

    American format Ok...I did some research and I found out that when I use the american date format (mm/dd/yyyy) it works. How do I get it to work with the following format (dd-mm-yyyy)??? I would be very greatfull.... Thanks in advance guys...
  2. B

    Filter on a Date AND a combo box

    Hello everybody, I have a problem. I want to apply a filter on my form.When I filter on the combobox it works fine. But when I filter on the date the form jumps into the error handler. Below is the code that I use for my filter: Sub ApplyFilter() Dim sFilter As String sFilter = ""...
  3. B

    Access 2007 stand alone deployment

    Thanks Thank you very much for your information!!!
  4. B

    Access 2007 stand alone deployment

    Hello everybody, Some time ago I saw a presentation of access 2007. It got me very enthousiastic. But before I start working with it I want to know if it is possible to deploy Stand alone applications I am gonna build in Access 2007? And how??? Thanks for your help guys.
  5. B

    ACCESS and MySQL

    Hello everybody, Who can help me. I want to access a MySQL database with ms access. I cant seem to get it. Please help me. Thanks in advance, John
  6. B

    Delete text from a .txt file

    Hello guys. Help me please. I want to delete text from a .txt file from ACCESS. Thanks in advance.
  7. B

    TOP Statement

    Hello Guys, I have a question. I have a query that looks like this: Category Customer_ID 1 123444 1 233732 1 87667 1 3343 1 99876 2 123 2 775446 2 332334 2...
  8. B

    Error: Could not find Tempfield*0

    Hello my ACCESS friends. I am trying to design a huge Table. When I want to save the table I get the message: Could not find 'Tempfield*0' PLEASE HELP ME.. Thanks very much in advance...
  9. B

    Highlight Current record

    Hello guys. I have a question. I have a form with data in formview. When I select a record I want it to highlight with a specific color. How can I do the. Thank you very much in advance.
  10. B

    Pivot Table

    Hello Rickster... How can I change this?????? I mean...where can I change the grand total to AVG?? Because if I insert grand totals it only shows the SUM... Help help help... and thanks so far
  11. B

    Multiple Selektion

    Thanks for your help RuralGuy... But I couldn't get it to work.... Thanks again...
  12. B

    Pivot Table

    Hi everybody. I have a pivottable query. This works great. I have a column with averages. This works great to. Now here is my problem: At the bottom of my Averages column there is a total (sum) I want an average in stead of a sum. Please help me guys.... Thank you very very much in advance...
  13. B

    Weekdays...

    Hi guys.. Thanks for your solution so far. But I want to do it in a query. Please help. Can I also deduct the holidays???? PLEASE Help me.. And thanks in advance
  14. B

    Multiple Selektion

    Hi Access Gods, Again I come to you with my problems. I have a list box. If i choose something from the listbox a filter is applied. Is it possible to use the filter with multiple selektion??? Thanks in advance guys...
  15. B

    Language Problems

    Thank you very very much Neil... This is gonna do the trick...
  16. B

    Language Problems

    Hi Everybody.. Another big problem from me.. My language is set to english. So when I enter a date it looks like 31-12-05 Other users of my program use german. So there dates look like 31.12.05 I convert my dates to string. So its important the dates look like 31-12-05 HELP ME please
  17. B

    Weekdays...

    Hello everyone.. First of all...I am really thankfull for this Forum. I have a Question I have 2 dates. FromDate and ToDate I want to Calculate the days without the weekdays. Please help.. Thank you very much in advance...
  18. B

    Convert Number to Hour

    Thank you very very much Rickster57
  19. B

    Convert Number to Hour

    Hello Everybody... I have a Question. How do I convert a number (26) to 26:00 Hours. The thing is. I have a database that calculates the hours of overtime. for example. I work from 7:00 to 19:00. Then I get 12:00 hours of total time. The above is no problem. But no I want to deduct the...
  20. B

    Numeric Field Overflow Error

    A new table is generated from the linked textfile... Hope to hear from U guys..
Back
Top Bottom