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: *

  • Users: csegal
  • Order by date
  1. csegal

    Name Change

    Hello People, It has been a while since I've needed any help and I am back again to the place I trust the most with access help. I have created a new database using the Access 2000 Wizzard. I have selected the "Asset Tracking" and or the "Resource Scheduling" databases. I would like to customize...
  2. csegal

    Days, Hours, Minutes Countdown

    How can I creat a simple text box on a form that displays a simple text box that displays a countdown in Days / Hours / Minutes / Seconds from a set date say: now to sept 17, 2005. Charles hshi@gate.net
  3. csegal

    COUNTDOWN CLOCK

    How can I create a simple Countdown clock that will display (Days), (Hours), (Minutes) between now and say September 18, 2005? Thanks, Charles hshi@gate.net
  4. csegal

    Date Countdown

    Hello, I want to creat a very very simple date countdown form Where it is displayed: The number of days from today until September 17 such as the difference between today (4/29/05) & 9/17/05 is 139 4/30/05 & 9/17/05 = 138 etc... Please help hshi@gate.net
  5. csegal

    Date Header Issue

    Hello, I have a report where I want to place a date header on each page ie... First Page: January where this page will list all of the activity for January Page two: February and so on. I am currently using =([Date]) This is giving me the actual date of the first record such as if the first...
  6. csegal

    FILE NOT FOUND

    The error message simply says: "File not found" No error number just a small Microsoft Access error pop up that says: File not found and an OK button to clear the message.
  7. csegal

    FILE NOT FOUND

    Hi everyone! On my access 97 form I have a button that points to a database called SERIAL. I am in one database called ETR with a main form with this button for SERIAL. Something happened where the SERIAL database was wipped out!!! I had contacted our companies M.I.S. dept. They did a recovery...
  8. csegal

    Run-Time error '2109':

    Help... On my form i have a button that does several things... 1). Saves the record 2). Prints the current record 3). Advances to the next new (blank) form (record) 4). Places the cursor at the field named ETR as the starting point for the next new record. Often times but not every time I get...
  9. csegal

    HELP WITH NUMBERS

    I GOT IT!!!!! Private Sub Form_Current() If NewRecord() Then Me.Asset = DMax("[Asset]", "SERIAL NUMBER LOG") + 1 End Sub THIS WORKS JUST GREAT!!!
  10. csegal

    HELP WITH NUMBERS

    I TRIED THE FOLLOWING CODE WITH NO RESULTS ALSO If IsNull(Asset) Then Me.Asset = DMax("[Asset]", "SERIAL NUMBER LOG") + 1 End If
  11. csegal

    HELP WITH NUMBERS

    Well it sort of works except when any other field is clicked, the asset number increases by 1??? The code was entered in the Form "On Current" [Event Procedure]code area as follows... Me.Asset = DMax("[Asset]", "SERIAL NUMBER LOG") + 1 This is getting very...
  12. csegal

    STILL HAVING NUMBERING PROBLEMS!

    I'LL GIVE THIS A TRY, BUT AM UN SURE WHERE EXACTLY TO PUT THIS CODE... IN THE FORM: "ON_CURRENT" CODE EVENT PROCEDURE???
  13. csegal

    STILL HAVING NUMBERING PROBLEMS!

    Hi People! I have a simple form where I have to enter the date, a part number, a description and an "Asset #" The "Asset#" field be the next number in sequence ie... 7607, 7608, 7609 etc for each new record should have the next number in sequence. There are currently 3400...
  14. csegal

    More help with numbers please!

    Thanks "HNA" I had inserted this code under the on form_Current: Me.Asset# = DMax("[Asset#]", "Table Name") + 1 And i substituted the "Table Name" with the name of the table where the data is from "SERIAL NUMBER LOG" But i get a COMPILE ERROR...
  15. csegal

    HELP WITH NUMBERS

    Hello HNA I had inserted this code under the on form_Current: Me.Asset# = DMax("[Asset#]", "Table Name") + 1 And i substituted the "Table Name" with the name of the table where the data is from "SERIAL NUMBER LOG" But i get a COMPILE ERROR "Method or...
  16. csegal

    HELP WITH NUMBERS

    Hi People! I have a simple form where I have to enter the date, a part number, a description and an "Asset #" This is a two part question. 1). When the form is opened up, I want to open to an new record and have the date field be automatic with the current date. 2). The...
  17. csegal

    ERROR MESSAGE

    I may have forgot to mention... Everything seems to work ok for about 5 to 10 records,,,then I get the error When I manually forward to the next record and press the print button sometimes I get the error and sometimes I don't so I am not too sure of the regularity of the error.
  18. csegal

    ERROR MESSAGE

    OOOps,,,I am using Access 97... Not my choice, It a network thing using windows 98
  19. csegal

    ERROR MESSAGE

    Help!!! I have a form where when I press a button to print tjhe form, several things take place. 1) Data is saved 2) A new form is to open up 3) The new form cursor should start at a particular place The problem is that everything works sometimes! Sometimes I get an ERROR MESSAGE: YOU CAN'T GO...
  20. csegal

    RUNNING CLOCK

    How do I place a running clock into a form using access97?

Part and Inventory Search

Back
Top