473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2000 Script

I have an application (MP2) that uses an Access 2000 database. The system has a utility that the user runs at the start of each day to set the beginning work order number. We use the date + a sequential number starting with 1. I am trying to see if it is possible to write a script for Access to do this once a day the just for the first entry of each new day. I hasve looked all over the net, but not much luck at all. Any directions or links to a site that might help would be greatly appreciated! Thanks in advance!
May 28 '08 #1
7 1628
RuralGuy
375 Expert 256MB
Nz(DMax(properly completed),0)+1 will return 1 if that date has no value yet.
May 28 '08 #2
NeoPa
32,556 Expert Mod 16PB
Using RuralGuy's approach you probably don't need to run the script.

However, to run a script automatically, but only once per day, you would need some code in, say, the Open Event procedure of your switchboard (or whichever form is set to open on startup) that checks some sort of flag in a table (probably a date field set in a system management type table). If the flag indicates that the process has run already that day (The field is set to today's date for instance), then skip the routine, otherwise run it. The routine would need to include code to log the fact that it had run (Set the field to today's date).
May 29 '08 #3
Thanks. The problem is that I do not have access to the code. It is a purchased program. The script would have to run when the user logged into the application, somehow? I tried going into the Access 2000 db table where it stores the next work order number, but it appears they have something hardcoded that writes to that table if you tell the application to auto assign the next number. Not sure if this is even possible for me to do. Thanks for the replies, though!
May 29 '08 #4
NeoPa
32,556 Expert Mod 16PB
If you are dealing with a purchased program then that's completely different. You probably shouldn't touch the code anyway, even if you can, as that may (quite sensibly) invalidate any support agreement you may have.

I suggest you contact your supplier and ask them what options they can suggest for your requirements.
May 30 '08 #5
We are contractors for the Air Force. A company my boss used to work for used the same application nad they wrote an access script that ran when the user logged in to do what I am trying to do. We contacted them, but htey have since upgraded to a newer version (7i) and don't have the old scripts they used. Just thought someone here might have an idea of how I might go about doing it. Thanks for the help and responses anyways though! Will post back here if I find out how to do it...
May 30 '08 #6
Also, we have no support agreement for this software......
May 30 '08 #7
NeoPa
32,556 Expert Mod 16PB
I'm a little confused :
What type of "scripts" are you referring to (bearing in mind you have no access to the code)?

PS. Is there any other information that I need to make more sense of the question?
May 30 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

24
by: jason | last post by:
Hi Ray...a while ago you explained an elegant solution to enable me to CREATE and EDIT existing tables and queries inside my online access 2000 database.... could you provide refresher links on...
3
by: Doug Baroter | last post by:
Hi, One of my clients has the following situation. They use Access DB for data update etc. some business functions while they also want to view the Access data quickly and more efficiently in...
20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
2
by: Philippe PERON | last post by:
Hello, An ACCESS application (mde) is installed on a computer looking at an mdb file on the same machine. As far as I know the application is installed thru a Wise Installer script. The...
5
by: lewi | last post by:
I am just starting to use ASP.NET(C#) with VS.NET 2002 Pro on Win2000 Server and spend only little time with MySQL while working with PHP. Now I am only using all this for developement/learning and...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
0
by: NickName | last post by:
What I wanted to do is to have ERwin to reverse engineer an Access db to generate a MS SQL Server 2000 -compatible SQL DDL script. I'll use it to create tables, keys, indexes (and having ERwin to...
7
by: bhavin30 | last post by:
Is there a way to obtain user information (using LOGON_USER server variables) when you have set up the security to Anonymous Access? I have tried setting the security to both Anonymous + Window...
3
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require...
25
by: p byers | last post by:
Good Morning Folks I have a LAN Among the several connections to it are the following four devices: A MAXSTOR network Storage Device A PC running Microsoft Windows 2000 Server 5.0.2195 (SP4) A...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.