Recent content by csegal

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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