Search results

My current "Employees" table is exactly like the one on that page referenced earlier. table is titled tblEmployees Field 1=EmployeeID/Autonumber Field 2=Employee Name Field 3=Password I suspect I need to identify what I want individuals to have to which i've been contemplating throughout...

My browser timed out and logged me out but it looks like youve answered before I was able to get back in. Gina, I figured out what you were talking about in reference where to put that line and BAM, exactly what it was missing. I wish I really knew what any of this coding stuff meant and...

I really thank you very much for your help on this and I really apologize for being clueless as I am utilizing all the information i've received on this website, books, and trial and error to self teach myself this program. I've not really gotten into the vba coding as far as understanding...

That makes it do what it was doing origionally. Allows one to cycle a new password over and over and over again without shutting down.

I changed the information where it appears it should be changed; however it then closes after the first invalid attempt! 'If User Enters incorrect password 3 times database will shutdown intLogonAttempts = intLogonAttempts + 1 If intLogonAttempts = 3 Then MsgBox "You do not...

Regarding the first issue, I dont believe its declared anywhere else. I just followed all the steps provided and its the only place I recall seeing it. Thank you for the direction and feedback.

I am working on attempting to create user access into a database i've created. I've found directions for making a form and all necessary steps at http://www.databasedev.co.uk/login.html I've followed the directions all the way through and it works for exactly what I want to a point. There is...

With persistence, i've managed to figure out what the issue was. The mask I set for the table is LL"#"00"-"0009;;_ when creating masks, there is an option that I missed that asks if you want the mask also saved in the table with the data, I indirectly said no. When I slowed down and repeated...

I did some further checking and found another way of doing this but i'm still running into another problem. I put the following string in the input mask of the field for case number: >LL"#"00"-"0009;;_ The problem with this is when I test the reports referencing this information, the # and...

Thank you gentlemen, I'm catching onto the whole access concept relatively quickly, at least until it involves vba coding. I should go find a class on this concept. So the code above in the "Before Update" on the form worked as indicated until it failed and then still allowed me to move...

I just tested it and it works exactly how it should. There is a problem though. I purposly entered data that would fail this rule and after clicking ok, it still let me change to the next cell without further errors. How do i make this not allow data in this particular field unless the code is...

Might someone help me out with something I hope is a simple solution. In my table I have a field where a user puts in a "case number". When typed, the case number should look something similar to this. LL#NN-NNNN L=Letter N=Number Also thinking about it, the last section of numbers may...

I think i've gotten a majority of this completed but have a question regarding the second part of that link you sent. Quoted from your other link "I presume you have set up the combo with Limit to List = Yes Then in it's On Not In List event put the following or similar; Code: MsgBox...

John, First of all I would like to thank you for taking the time to help me out with this. I've tried all sorts of combinations with no success. I took a look at your post linked above and suspect those steps will fix the issue. The problem i'm having now is where do I place those lines of...

I know this has been asked in reference to various problems throughout this forum but I am unable to find a solution as to my issue. I have a form that lists an individuals Fname, LName, DOB. On the top of this form, i have a drop down box that allows me the option to view a specific...

I have a table for employees with a field that has an image attached directly to the database of each employee. I was wondering if it was possible and if so how to do a code in a query to tell me "Yes or No" indicating wheter or not an attachment is associated to a specific indviduals record.

Please forgive me if some of this post doesnt make sense as I am confusing myself. I have a table with person information that has a picture attached directly to the database depicting the person associated. In a separate table, i have cases associated to the persons table that "expire" one...

I think I am very confused as to what if anything I need to do. Your sample is very similar to what i've already got except is not cycling through that one image. In my form, I have a combo box that is filtering the data and showing the profile of a specific person which has a text field with...

Thank you John for attempting to help me out with this. I've opened the sample and find this code in the "on load" portion of the form. Option Compare Database Private Sub Combo11_Change() Me.List13.Requery Me.List13.SetFocus Me.List13.Selected(1) = True Me.Image5.Picture =...

I have a form containing employee information and a spot to show a specific employees image which i am linking via "link" (picture not directly attached to DB). In the form I have a combo box containing a list of employee names and when i choose a specific person, that employees data and image...