Search results for query: *

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

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

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

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

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

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

Hello, I am getting a frequent error message: (There is no field named 'Tag Number' in the current record) I have a form in access 97 a particular button on the form a).prints the current record b).saves the record c).goes to the next new record (blank form) d). Cursor starting point is the...

I would like to add an audio sound file to play when a particular button on a form is pressed. Is there some code to add to the button that already has code to open a particular form? If so... Where do i place the "sound code" ? Please be descriptive as I am not very programmer savy. I...

I would like to play a wav file when a button is pressed. is this possible using access 97? csegal csegal@arrowair.com

HOW DO I MAKE A JOKE BUTTON?... I WOULD LIKE TO MAKE THE BUTTON MOVE WHEN THE MOUSE POINTER IS PLACED OVER THE BUTTON MAKING IT IMPOSSIBLE TO CLICK THE BUTTON. i HAVE SEEN SEVERAL JOKES OF THIS FORMAT BUT I AM NOT SURE IF IT CAN BE DONE IN ACCESS 97. ALSO, IF IT IS POSSIBLE TO DO THIS,,,CAN I...

Is it possible to create a button on one form to have the information from certain fields to automatically be placed in another form? ie... PART NUMBER on one form to be placed in the part number field of another form. SERIAL NUMBER on one form to be placed in the serial number field in another...

I am using Access 97, Is it possible to highlight a field as I toggle through the form. For instance, the current field background color is WHITE. When I select a field I would like it to be light BLUE or YELLOW etc... then when toggled to the next field the previous fiels goes back to WHITE and...

I have a main access form that has buttons to various forms in (access).This main form is called "Starting Point" I also have an excell form that I would like to make a button link from my main access form. When I create a button using the wizard, I can get as far as linking to excell...

How do i create a button on an access form to open a specific form in excel? I have used the tool wizzard to create the button but i can only open excel in a new workbook. My specific form is: "C:\My Documents\JW3 NON-ROUTINE FORM.XLS" Help!!! Thanks