About 2 years ago, I created a database (my first real one actually) which is extensively used. I havent had to maintain it too much in this time but I was looking at the live table data and noticed that the users are placing inappropriate entries in fields designed for other data such as listing the Company name where the last name of the person should appear and also they are using the first name field for the entire name of the person (lastname, firstname). Knowing this is an issue, I contacted the user who didnt seem to care as thats how they chose to use the database. Since Im the person who created it and Im ultimately responsible for it, I would like to prohibit these types of entries in the future. Does anyone know of a way to force integrity in an example such as what I outlined above? I thought about trying to prohibit the use of a comma in the form field, but then I suspect they would probably choose something else or nothing at all and we would be at the same point with no resolution. Im not trying to be a jerk, but the point of the DB is being tossed away because the users choose to be stupid. Any help would be greatly appreciated.
What I am trying to do is stop the ability to duplicating records over a series of fields (FirstName, MInitial, LastName, Company)rather than just one specific field.
The problem with this is it wont allow me to enter more than one person with the same first, middle, or last name or company.
I tried "DCount" Code in a form with no luck, that code reads as followed:
Code: Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("*", "tblEmployees", "[firstname]=" & Chr(34) & Me!firstname & Chr(34) & _ " And [MInitial]=" & Chr(34) & Me!MInitial & Chr(34) & _ " And [LastName]=" & Chr(34) & Me!LastName & "#") > 0 Then Msgbox "Person already exists." Cancel = True End If End Sub
Note: this code was initially used on a different database I was working on that accounted for an individuals First Name, Last Name, and Date of Birth which worked great. I am just trying to apply that similar concept to this new database with first name, middle initial, last name, and company; which will be a foreign key.
How can I perform an action when ever the db closes… Basically I have a table, users, and when the db starts a logon form is used. Once the logon is successful it records into the user table that a user is logged in. I want to at the close of the db rewrite the record to show that the user is not logged in.
So say user A logs in successfully so then the users table would show Key | Name | password | logged date | currently logged on(these are the column headers) Somekey | user a | ***** | somedate | yes
I want to rewrite the yes to a no when the db closes and the user is currently not logged on. For the rewrite I can use a simple SQL statement to update the users table, the question is where would I place this code, the on close property for the switchboard is not enough, is there an on close property for the entire db.
I have a report, which shows all unsold items for a particular auction date, and I have created a form using this report.
I'd like my sister in law, to be able to go through and easily select which items to relist, and which to return.
I've tried using a subform, but I've either not done it correctly, or its not quite the right tool for the job. I've tried listbox control but can't get it to work properly either.
Once she has gone through the list ticking one or the other, I'd like to be able to automate with a button "Relist" and a button "ReturnItem".
I'd like Items to be returned - to automitcally close item off so it no longer incurrs a weekly listing fee and change status to "ReturnToSeller" and the relist ones, to create a new entry line into the main item table, with replicated information, except it clears out the "lot number", as they enter that manually when the generate a new list for the next auction, my ID numbers remain current and unchanged but the tableID is automated to a new one which is my key number.
then on my invoice, I get for instance, 3 rows for one Item, which could have 3 different lot and ID numbers, and get a listing fee of £1.20 for each week you see.
How can I automate the actions to relist and Return to Seller?
Hi. I have a table used for years. I added new fields bringing number to 160. When I go to insert another row, I get message saying 'Row inserted in the grid exceeds limit of 255 rows for table or 1,000 rows (actions) for a macro.'
BUT as the number of records had not increased and I am under the 255 limit why the error message?
I tried in vain to copy and compact/repair the database, but still no luck.
Suppose I need a database with customers, able to store: what different events, were performed on what date.
So let's say possible actions are: a customer called, emailed or visited.
(note, it might be possible that a customer both called, emailed and visited on the same day)
Should I start with four different tables for: customers, called, emailed, visited? Or would the three actions just go into one table?
Another aspect that I don't understand at all yet is how to proceed with the dates.
Should I create another table with a long list of possible dates for the coming x-years?
I would like it to work:
I am thinking about creating a form with buttons behind the terms 'called', 'emailed' and 'visited'. When one of those buttons is pressed, I want an entry for that action, day and customer entered in the database.
So that later on I could e.g. look up on what day how many customers called, etc. etc.
How can I edit a query in SQL view to run multiple lines of SQL?
For example I can use the GUI to create a query, then in SQL view enter the following:
DELETE FROM Employees_copy;
which clears the Employees_copy table. Perfect. But what if I want to do this for mulitple tables in the same query eg for a second table Employees_copy_2 as well? I've tried
DELETE FROM Employees_copy DELETE FROM Employees_copy_2;
which gives a syntax error, as does
DELETE FROM Employees_copy, DELETE FROM Employees_copy_2;
how I can automatically change the Client settings either with a macro or code. Specifically for the three confirm actions (Record Changes, Document deletions and Action queries). I have a database that is distributed to end users in different offices around the world. The old way lazy way, was to go to each computer and set these settings to "off" manually, but this isn't possible. I want to be able to run delete queries and action queries in the back end without the end users knowing its happening and having to select yes all the time.
Test findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all three forms.
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's. But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.
How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:
If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:
1.3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?
I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?
I am trying to create a database that MULTIPLE users can log on and view the data.
Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details.
I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them.
Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once.
Can MS Access do this?
if it cant, would a vb front end located on each computer help?
What the user front-ends required in order to run/view my DAPs that put on the web? Do they really need to have Access installed (any versions is OK?) .... or anything else?
What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can 1) Kick a user off 2) Send them a message 3) Send a user a message and then kick them off
i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time. Any help will be highly appreciated.
This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.
Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?
I am pretty much self taught so nothing too technical if possible!!
Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.
I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.