Filling Database With 2000 Numbers
Feb 9, 2007
Hello
I have one question
I have simple table in Access 2003 with three fields
One is (field name), type - autonumber
one is (field name), type - number
one is (field name), type - text
my problem is that i need in number field nubers between1 and 2000 and in text fields same numbers between 1 and 2000 with letter G at the end.
that will look like
Autonumber 1 ... 574 ... 2000
Number 1 ... 574 ... 2000
Text 1G ... 574G ... 2000G
Problem is that I dont know how to write a code for that i think that there would be a macro.
So can someone help me please!
View Replies
ADVERTISEMENT
Nov 22, 2013
I am working with an inherited database. When this database was created, a large amount of data was imported. Over the course of time, I have added additional fields for tracking information. One such field is "Date Started."
Unfortunately, there are almost 500 records without this information and that is skewing some report results.
I would like to do is insert the date of 9/9/1999 into all records that have no data in this field. (This date is well before the creation of the database and would serve to indicate old records, whether or not they are still active.) Copy and pasting isn't working, and I can't do a find and replace, since there's nothing to find.
View 1 Replies
View Related
Feb 18, 2006
Can anyone direct me to someone that does work with Office 2000 Developer
to complete a database runtime version. I paid Microsoft for help that was expensive and all i got was suggestions to but more software. I own Office 2000 Developer 2000 version 1.5. Its a small job so I dont know where to start looking for someone to hire.
Thanks
View 11 Replies
View Related
Dec 6, 2006
My database is written in Access 97 (I know get out of the stone age) but we have a mix of office 97 and office 2003 users. Anyway I'm afraid that one of the few people that have access 2000 or higher will open my database and convert it. I found (through here) code to check the version but it is attached to a form opening which is way to late. Is there a way to have access check the version as soon as you click to open the database and if it isn't 97 close the database?
View 4 Replies
View Related
Mar 31, 2008
I built a ms database and I'm just wondeirng about the compatability of using 2007, what kind of issues can i expect to run into and does this sound like there will be a major overhaul needed in the programing, or should it be pretty straight forward.
View 1 Replies
View Related
Jul 29, 2005
I've been having serious problems with my ASP scripts. Ok, for
the last week or so I’ve been working with you people and my
ISP to resolve this damn problem. Just last Monday, they told
me that it had been fixed. And it was true! I tried it and
everything once again worked fine. I made a dozen tests, and
everything worked fine. But when I tried it again two days
later, it's suddenly back to crashing again, the exact same
damn problem I was having before! I’m so frustrated I could
kill. I don’t think I did anything. Yes, my ASP code still works.
Yes, the HTML code still works. It’s when the code attempts
to open a *.mdb database it crashes.
Call up my demo script (then click "Reservation.") : http://christiansencustomsoftware.com/guestbk/dindex.htm
which will demonstrate the problem.
A newsgroup I work with writes: “This sometimes happens when you try to use the new MS Jet provider on a Access 97 database, upgrade your Access database to 2000, should work just fine.”
Ok, so how can I upgrade my Access database to 2000?
View 1 Replies
View Related
Dec 28, 2005
I have written my very first database in Access 2003 but it tells me that it has been saved in Access 2000 Format.
My questions are:
1. Why has it done this?
2. Can I change it 2002 or 2003 format?
View 3 Replies
View Related
May 16, 2007
I've been having some problems with sharing an MS Access 2000 database across a network.
The database is setup to open in shared mode and has been tried both with and without record locking, with the same issue occurring.
The main users are:
User 1 (Administrator) - MS Access 2000 Full Version (WinXP Professional)
User 2 - Access 2000 Runtime + Access 97 (Win XP Professional)
User 3 - Access 2000 Runtime + Access 97 (Win XP Professional)
The problem is occurring when User 3 opens the database. For some reason it opens in exclusive mode and locks out Users 1 & 2. This issue only happens with User 3, and does not happen with User 2 who has the same software setup.
The database was previously an Access 97 database (no problems) and has been converted to Access 2000, this share issue has been happening ever since the conversion.
Any ideas as to how this shared issue could be resolved? :confused:
BTW - I am familiar with FE/BE setups. This database is accessed by all from a network drive and not setup as FE/BE. This was never an issue, as shared access worked fine when the database was in Access 97 - the problem has only been since converting to Access 2000. I do not have access to the PC of User 2, and User 2 does not have any PC knowledge to install a FE, which means I would need to create an install package (which I'd rather not do). Are there any ways to resolve the shared access issue without changing to FE/BE?
View 2 Replies
View Related
Aug 20, 2007
I design the db in 2003
include form,report,and query
any problem??
View 1 Replies
View Related
Oct 22, 2004
Hello Everyone!
I've installed the windows XP. Also, I have an ODBC connection to ACCESS 2000 database.
My scripts are already reads data from ACCESS databse. But it is failed to create new table in database.
What may this problem be solved?
View 1 Replies
View Related
Oct 24, 2005
Hi
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
chris@ctbjs.co.uk
many thanks
Chris
View 1 Replies
View Related
Jun 2, 2006
I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected
2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
Any help most appreciated.
Dalien51
View 1 Replies
View Related
Mar 27, 2006
If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
Please help...Thank you so much....
View 3 Replies
View Related
Aug 20, 2007
Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
Thank you in advance for any help,
Dom
View 10 Replies
View Related
May 19, 2012
I've got a database, that I'm trying to update for my sister in law.I've got 2 tables, Items and Customers.As I've been working with the id's they have used so far, these aren't currently automated.
for customers, they use their number in the auctions, to place bids etc, so I can't change them.But once I hand over the database, I want to automate the generate of Customer ID numbers from that point on, but not override the history.With the items, what I have done, as an item can be relisted up to 3 times, I created a LogID auto number which is also my key number.
Before I hand it over, I need to do a big update there with them, to pull in the latest customer and item information.But after that, I'd like the new items added, to be given a new automated number, but the logid still needs to be generated automatically as well, as the login allows no duplicates, whereas the itemID does allow duplicates.
Its the item ID that is used to generate an invoice and show how many times its been listed to pick up correct number of fee charges.Customers can be both buyers and sellers, and I had to allocate 2 different fields, and the buyerID just replicates the sellerId number. So the Seller number is the main number on the table, I didn't want 2 tables of buyers and sellers separately, its one table.
View 1 Replies
View Related
Nov 15, 2006
Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?
Thank you in advance.
View 3 Replies
View Related
Oct 31, 2012
I imported an Office 2010 excel file into Access 2010. All the headers match.
All the data transfered, but the phone numbers.
In Design View, the phone numbers are listed as numbers, not text.
Then I tried to copy the two columns from Excel and past into the two columns in the database. No go. It did create a new table called Paste Errors.
How do I move that into the Table that I first created?
I need to know how to get the phone numbers in their because I need to import several other excel files into this table.
View 5 Replies
View Related
Feb 14, 2012
I have a database for donation collection. So Receipt No's are already printered. I need to add these numbers in my database table with one click. Is it possible? There too much receipt I don't want to add every receipt my self.
View 1 Replies
View Related
Dec 4, 2012
I am creating a training database and i have a courses table. And I need to somehow record all of the different employees that attended a course?
What i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees together in one field? what field would the attendees be? currently is numeric which doesn't seem to work.
View 2 Replies
View Related
May 29, 2015
I have a database for quotations. The database automatically generates a new quotation number every time a new quote is started. This works great, and I am very happy. My next task is to allow the employee to pull up a quote that has already been generated and edit it. I would like for the new quotation process to be followed step by step, but with all of the information already filled in.
This will allow for any edits that need to be made, and keep from having to re-enter a lot of data. I want one thing to change, which is the QuotationNumber. It is currently formatted by "yyyymmdd-01" for the first quote generated on that day. I want the edited quote to have a QuotationNumber formatted by "yyyymmdd-01a". For every edit that letter change going through the alphabet in order. How would this new QuotationNumber code differ from that of the Other?
QuotationNumberCode.PNG
View 10 Replies
View Related
Jul 7, 2014
I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.
Example:
current format - 1,2,3,4,7,8,9,10
desired format - 1-4, 7-10
View 2 Replies
View Related
Apr 15, 2007
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
View 1 Replies
View Related
Dec 7, 2005
i am trying to use access 2000 database onto to access 2003. When i try to click design mode to change something it gives me this message:
You dont have permissions to modify.
If i run it on access 2000 it runs fine.
Someone please help.
View 5 Replies
View Related
Sep 27, 2006
Hi,
A few years ago I’ve made an access database on access 2000. The problem is that now I’ve installed the office 2003, and I can’t make the database work properly.
At first says that are missing those files: “tshoot.ocx”, “msioff9.ocx” and “msowc.dll”; so, I’ve copy them from another computer using office 2000 and now only complains about “msioff9.ocx” saying that my database contains a reference incomplete to it.
Is there no other way to convert my database do work properly with access 2003? What can I do?
Regards
View 2 Replies
View Related
Aug 12, 2014
I'm having multiple problems with my database like things such as -
i'm currently working on the Query 2 - On the Phone database (ignore Query 1) and i want to search for multiple plot numbers preferably in one parameter prompt with a comma to seperate numbers. (this could be a multitude of numbers so i would like to be able to input as many as needed). Also when i do search on this query since the Criteria is a 'Between' Value i would expect everything between the 2 numbers input to show up - but a lot of numbers out of the range show up too - why is this? (The Numbers are like "69 to 136" and they will show up - but 1-69 and 136-170 would too
I would also like to implement the search results from Query 2 into the Form i currently have made but it just opens up a access table when the search is made?
i cannot link my database as it is too big for the server - But here are the Criteria for Query 2:
Plot No - (criteria = Between [Enter First Plot No:] And [Enter Last Plot No:])
Site - (criteria = Like "*" & [Enter Site:] & "*")
Product - (criteria = Like "*" & [Enter Product:] & "*"
The Query is the one im most concerned about , i can live without a form.
View 14 Replies
View Related
Feb 20, 2008
Hi,
I am doing some computer work for a company that has an Access 2000 application. This app is split up between a program database that contains the forms, reports, etc. and a data database. Both the program database and the data database are located on a Windows 2003 teminal server. There are usually two or three remote users logged into the terminal server, but this number is about to increase to 6 or 7. I am concerned that these user's will all be running the same copy of the program database. I have read that this can lead to performance problems.
I was wondering if anyone hear thought either of the following would be an improvement:
1. Put a separate copy of the program database in each user's profile on the terminal server.
2. Rather than keeping the program database on the terminal server, put a copy of it on each of the remote client pc's. Then set up a VPN connection to the server and use this to link to the data database.
If anyone could tell me if either of these options would lead to improved performance, I would really appreciate it.
Thanks in advance,
Paul
View 2 Replies
View Related
