Search results

Thanks for all of the responses! I will try some of the suggestions tomorrow. I'll let you know what I find out.

Thanks David, I'll try some of the ideas mentioned.

Yes, I have tried holding down the shift key, but I still get prompted for a password. If you remember how to disconnect the mdw, it would be greatly appreciated!

Kevlray, Thanks for the response. The problem is that I cannot even open the mdw. It prompts me for a password. My user name is already populated, but I have no idea what it wants for a password.

Ok, I think I may have messed up. We have an older mdb at work that has a mdw as login/security. Well, the guy that setup the database is long gone and we are trying to get in to setup different individuals as admins. Well, I found something on our forums that will let me join the group, but...

I am not sure if this will help, but I borrowed your code (I hope this is ok) to email and save my reports to pdf, but of course I was having the same issues (error 2501 and would not save). I had my file path as such: myFilePath = "C:\Users\arr\Documents\Allegation Reports\" When I...

Did you read post number 10? It is the same issue that you are having; typing "I" leads to an error. Read the whole thread. Go to page 2 of the thread

Go into design view for your form, then click on the data tab of the properties sheet. Under the data tab, go to data entry and click the "yes" to allow data entry. When you open the form, then it will start as a blank form.

You might find this thread of interest (starting at around post #10): http://www.access-programmers.co.uk/forums/showthread.php?t=240269

That is a great idea! Thanks sethgecko1977!

Paul, I was just curious, is the undo suppose to remove the data that was entered? The reason I ask is because it will give focus to the data in the textbox, but does not remove it. UPDATE! Ok, I see what happens. I had already entered data into the textbox a couple of times and when...

Boy, I have a lot to learn! Thanks again for the much needed help!

Access 2010 With the help of pbaldy, my code is now validating for duplicate entries. My problem is now with the rest of the code: Private Sub RankOrder_BeforeUpdate(Cancel As Integer) Dim lngRankDup As Long lngRankDup = Nz(DLookup("[RankOrder]", "tblTestEvents", "[RankOrder]=" &...

Darn! and I have spent an hour trying to figure out why that code was not working, grrrrrrr! Thanks a ton pbaldy!!!

Hello all, Access 2010 I am trying to check for when a user trys to enter a duplicate number. The control that I am checking is in a subform on the main form: Main: frmCandidateInfo Sub: frmTestInfo Control on the subform is: RankOrder I am trying to check the control entry against...

I guess I posted to early, sorry for the thread. I just changed the following and now the subforms shows the controls and are still locked. Case acSubform 'Recursive call to handle all subforms. bSkip = False For lngI = LBound(avarExceptionList) To UBound(avarExceptionList) If...

Ok, I just realized that the disable code I am using is causing the issue (Allen Brownes code). I am using his code because it allows me to keep my combo box active so that I can search through the records. Does anyone know of a work around? Case acSubform 'Recursive call to...

Hello all, I am using Access 2010. I know this has been asked before, but I could not find a solution to my problem. Whenever I come to a record that does not have any data in my subforms, then (as you can expect) my subform controls disappear. My subforms have "Allow Additions" set to...

That link seems very promising. Thanks jdraw!

Yes, I am trying to generate a dynamic report, so the users can pick what information to include in the report. I am trying to adapt another members code (from the code bank) , Lister, to fit my needs. Here is his code: Private Sub cmdOpenReport_Click() 'Lister 07 Aug 2008, Waipawa New...