Search results

A97 password form Kevin ive converted the the file to A97 for you. hope it helps. regards ian

Try somethng like the following in the criteria section of the field you want to prompt. like "*" & [Enter data prompt here] & "*" The bit between the [ ] will be displayed in a prompt so if you want it to ask for a name you would have [ Please Enter name] or whatever you want the prompt to...

statsman, I have had my database split into front end with the backend on the local server and its been running for over 5 years now without any real problems. However you do get the odd glitch now and again when one of the remote users had locked the db. If you keep regular backups of the...

daryless, If you dont have a printer installed for the user on that computer not only will you not be able to preview the reports but you cant view them in design view either. If you dont have a printer installed try installing one. However if you do have one installed it may be worth...

validation You can set validation rules in the text box control when the form is in design view. Alternatively you can use vb code to check the length of the string either on the onexit event of the text box or the beforeupdate event for the form. Pesonally I would use the on exit event for...

password form Tru, I have attached a fairly simple password form for you to have a look at. This set up stores the passwords for individual users in its own table. When a user enters their ID and password the code looks for a matching record. If a matching record is found it lets the user in...

msgbox try, msgbox "Are you sure you want to delete " & Me.ExerciseName or msgbox "Are you sure you want to delete " & ExerciseName regards ian

securing a db Please find atached a copy of a sample I have used for some basic security for a db. This uses a popup form with unbound text boxes for the user to enter their ID and a password. VB Code then checks through the personal table to look for matching details. if a match is found...

backend security Basically thats it in a nutshell. It wont stop a determined user from getting but with the bypass key disabled as well it seems to work quite well. Ive been running a split db with this security on the backend for 5 years and not had any probs with it. Additionally you can...

security Dan, Please find attached a basic password entry form. This uses VB to cycle through the table to find the personal details. Its fairly easy to create a logentry table and use VB code to write the details of who logged in and when to it. Not sure if this will be of any help to you...

backend security Digby I dont use workgroups and the like as i dont fully understand them yet. However in the backend i have an admin table conaining user id and paswords for those allowed to enter it. the backend contains 1 form which is the login password form that is basically a copy of the...

help Statsman, Glad to be of help. I agree this forum is a very useful resource and I am always impressed with the knowledge of people here and the help they give. regards ian

Idris, I have used that method on occasions which usually works. However sometimes there is a problem with a specific table that I cant import. I usually refer back to my latest backup and import the data for the table from that one. Unfortunately this does mean some data loss, but as the db...

status field Paul, Good point that I overlooked, even though I do it that way myself. However I think in this case there may be queries running that serach for records where the status is closed, regardless of any of the dates. If not the status field may be redundant and just taking up...

Idris, additionally make sure the databse is not in use by any other users when trying to compact and repair.

try if IsNull(dateclosed)=False then status = "closed" End If

Case To use case select you need to set it up along the lines of Select Case variable name case 1 add your code here case 2 add your code here case 3 add your code here case 4 add your code here etc End Select hope this helps regards Ian

dates I havent used crystal reports so am having a guess at this one. It looks to me that you are aksing for the date the wrong way round. I believe in VB asking for a date older than 7 days from todays date would be <Date() -7. this should return records where the date is more than 7 days...

I have had this message several times with different users on different machines. Generally it has been either down to incorrect permissions being set or a problem with the access installation. The first was resolved by making sure the access permissions were correct for the full route along...

name field Hooby, This means you have bound the text box to a field that the database cant find. the password form should have both the text boxes unbound as you will search through your records with VB code. In the example I have posted you need to substitute the successfull message box...