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

    Control an error

    I'm not much familiar with that kind of code, but thanks anyway, i'll see what i can do. Thanks Aietoe
  2. Aietoe

    Control an error

    Hi! When a user access my database, the first thing that is done is the execution of a macro. In the macro, a table is first opened and the user is asked to enter his userid and password to access the database. Even if the user enter a wrong password, he gets a couple of error messages but...
  3. Aietoe

    Query to compare date with previous record

    Many thanks and a star to PHV for his great help and his patience. Aietoe!
  4. Aietoe

    Query to compare date with previous record

    Hi PHV, Many queries are executed to endup to the final table. If i understand what your looking for, i would have to add-up 2 additionnal fields to make the record unique. The table would then look like this: Name Date Act ActSeq Joe 2004-08-10...
  5. Aietoe

    Query to compare date with previous record

    Created by a query. Aietoe
  6. Aietoe

    Query to compare date with previous record

    Unfortunatly no. Aietoe!
  7. Aietoe

    Query to compare date with previous record

    Hi PHV, Making more tests, i found out that when 2 or more records have the same date, the diff stays the same for all records. EX: Name Date Diff Joe 2004-08-10 0 Joe 2004-08-27 17 Joe...
  8. Aietoe

    Query to compare date with previous record

    Thanks a lot it does exactly what i'm looking for. Aietoe
  9. Aietoe

    Query to compare date with previous record

    Ok PHV, here is approximatly what my input looks like: Name Date Joe 2004-08-10 Joe 2004-08-27 Joe 2004-09-08 Joe 2004-09-08 ............................. sorted by name and date...
  10. Aietoe

    Query to compare date with previous record

    All i want to do is calculate the difference between the date field in the current record and the date field with previous record. I have tried to modify the code from the thread "query to compare data with previous record" but i do not understand it and finaly do not get any result(but many...
  11. Aietoe

    New page number on break

    I CosmoKramer, I copied your exact code from Thread703-18458 as follow: Option Compare Database Option Explicit Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant Dim GrpPage As Integer, GrpPages As Integer Private Sub PageFooter_Format(Cancel As...
  12. Aietoe

    New page number on break

    I, Using Acces97 i'm trying to reset the page number to 1 on a group break. Here is my code: Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) Dim i As Integer ReDim Preserve GrpArrayPage(Me.Page + 1) ReDim Preserve GrpArrayPages(Me.Page + 1) If Me.Pages = 0 Then...
  13. Aietoe

    Access2002 date problem

    Hi! I have just converted an Access97 database to Access2002. The conversion seems to work just fine except that now, some dates do not appear in the reports. The way it works is: - i open a form where i fill in the dates (min and max) i want to use for an extraction - i...
  14. Aietoe

    «Subscript out of range» error....

    Hi Jebry, I have tried to change my proc to : Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) Dim i As Integer ReDim Preserve GrpArrayPage(Me.Page + 1) ReDim Preserve GrpArrayPages(Me.Page + 1) If Me.Pages = 0 Then GrpNameCurrent = Me!Bénef If...
  15. Aietoe

    «Subscript out of range» error....

    I, Using Acces97 i'm trying to reset the page number to 1 on a group break. Here is my code: Option Compare Database Option Explicit Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant Dim GrpPage As Integer, GrpPages As Integer Private Sub...
  16. Aietoe

    Big Big database

    Hi Dhookom and Dvannoy My database contains over 700 queries, 500 forms, 380 reports and over 240 macros. I do utilise back-end mdb for my tables, and i compact my database regularly. The reason for my request is not really to get a better performance but rather to make my maintenance easier...
  17. Aietoe

    Big Big database

    Hi! I have an Access97 database that begin to be very big and that refers to different applications. That database is used by many users at the same time. Is there a way that i could split that database into 2 or 3 smaller databases and access these new databases from a main one thru a...
  18. Aietoe

    Reset variable in footer

    All i needed was a little hint and you gave it to me. I would have search probably for hours by myself and i got my answer in minutes with your help. Thanks a lot! Aietoe
  19. Aietoe

    Reset variable in footer

    Hi, I generate a report with groups(salesman). The name of each salesman appear in the group header... and the last salesman name appears also in the report final page header(footer). How can i reset the salesman's name so it won't appear on the last page of the report? Thanks Aietoe
  20. Aietoe

    Getting the user Identification

    Thanks a lot Rick39. While i was waiting for a solution , i did try that one and it work fine. I am always surprised how fast we get answers and fine solutions from that site...... :o) Thanks again

Part and Inventory Search

Back
Top