Search results

I just cant seem to get my update query to correctly update my field. I have a field called Case_No in a table called REVIEW. The case_no field is currently in this format 00-000. Where the first two digits are the current calander year and the last 3 are just a number that starts at 001 and...

I have a DB that is currently being used by a few users and they would like to add a request date field to some of the tables. Here is the probelm. The tables hold info on Drivers license's and SSN's and things like that and the Primary Key is the DL# or the SSN#. The user would like to keep...

I have attached a Zip File that holds 3 tables and my form which will appear on Startup. I have a field in the form that is where a user enters in a SSN. Here is the problem that I am having. When a user enters a SSN that is already in the Database my message appears alerting the user that the...

I have a form where the user enters a SSN and when the user tries to exit the field code makes sure that the SSN does not exist in the database. If it does the user is not allowed to exit the field untill the user enters in a valid SSN. However when a user enters in a invalid SSN a message that...

I have a form where a user enters in a SSN. What I am trying to accompolish is that when the user tabs out of this field or tries to click anywhere else on the form that the table is checked to see if that SSN already exists. If the SSN already exists I do not want the user to be able to leave...

I have a form that the user enters in Case information on. That form is based on table. I also have a table that holds information on who created this individual case. This table just holds the Case Number and the Username. When the user saves the case I need the table that holds the...

I have created application in Access 2000 and I am wondering what is the best way to go about installing it on users machines. For the test application I have completed the MDB. Then I split the front end from the back end, then I saved the front end as a mde file. (All of this is saved on the...

Can I make a textbox on a report = the result of a query? I have tried numerous ways and I cant seem to figure it out. I am not very good with the expression builder either. I tried that but it did not work. Thanks

I have a table that lets me know what users are loged into my database. In that table whenever a user logs in, the YES/NO field for that user changes from a No to a Yes. I need that field to return to a NO, whenever that user exits the DB. I have a button that I have told all users to use to...

I have a field on a Form that is a Date Field. I have an input mask on the field so the user must enter in the date in the correct format. MM/DD/YYYY However, I have tried to trap the MS ACCESS generated error that appears if a user enters in invalid data such as 12/3#/####. Where the #'s are...

In Access 2000 what is the maximum # of records that it can hold? Is there a maximum?

I have 2 unbound text boxes where a user enters in a new password and verifys the new password. I put the password input mask on these two text boxes. Now when I change the password it makes the password all ******* it does not change it to the real characters that the user types. Any ideas? so...

I have several forms where a user can edit whatever record he or she requested from the previos form. The problem is when the user tabs all the way through the form. When the user does this it automatically brings up the next record. The user did not request this record and therefore could...

I have two fields where a user inputs data. These two fields make up the primary key. When the user enters in the data, a button is suppose to check whether or not that exact record is in the table. What is the best or easiest code to write to check and make sure that those two fields which are...

I have a project that I have been working on and I imported some forms into it and now when I try to debug the Code it gives me an error message "Error Accessing File. Network Connection may have been lost." Nothing in this file is on any network its a small 3 table database that has about 12...

This is very strange. I have a query which is shown below. SELECT Mid$([DCN/Serial_No],1,3) AS DCN, [Subject], [Action_Complete] FROM newtaskerform WHERE (((Mid$([DCN/Serial_No],1,3))="SMC")); When I run this query, I get the anticipated information back, then about 3 seconds later I get an...

I am creating a form where the user enters in Case informaiton and the first field which is the Primary key needs to automatically populated with the next case number. Case numbers go like this. 02-001, 02-002, 02-003, 02-004, and so on. The only problem is that the first two digits depend on...

I have a form that the users enters in case information including the case nuber which is the primary key. When the user enters in the case number and then tabs to the next field, It automatically saves the record. Meaning it tabs to the next field and then clears out the Id Field. Saving the...

What is the best SQL statement to Delete duplicates in a table?

What is the easiest way to kick users out of your database? Some of my users just leave the database open on there desktop when they go to lunch or go do anything other than work, and I would like to be able to kick them out when I need to make changes. Any help would be appreciated.