Search results

DJkarl, I tried that and now all I am getting is incorrect password no matter what I type in. Here is what I changed them to. Private Sub TabCtlClientData_Change() Dim strPassword As String DoCmd.Echo False If Me!TabCtlClientData = 1 Then ' 5 being the page number you want to...

How would you code it to hide all the controls on the page? Sorry not really up on all the VB that I should be.

Hey everyone, I have searched and searched but cant find the answer. I have a Form that has 6 tabs on it. I need 1 of the tabs to only be accessable to the managers to update the information. I found some code that seem to be what I needed, but I cant figure out why it is erroring. I will...

Hi stoka, Possibly its not a vertical line but a margin issue, try going into design view and select all "Cntrl A" and move everything to the right to confirm that a field is not to far left and if it is a line you should be able to see it then.

soorags, It looks like you were still pointing the VB code to frmNZ fields when you had the others open. Check this out and see if it fixed everything for you

joet5402, Im not sure exactly what you are trying to do here Is there any way you can put the table, Form and any querys in a sample db with just a couple of records in it so that we can see it in a working form. Thanks

Hi Everyone, I have searched the forum and can't find anything that seems to help. I have a main form with 2 subforms. The problem is when they search for a item if there was a ticket it is populating the subform frm_asset_repair_sub_900 with that info. I have tried setting on open Me.DataEntry...

Thanks Thanks Guys..... that worked great your lifesavers...

Hi all, I have a query that I have an expression in that is returning a text value instead of a number value. The field in my table is a number value but when I use the expression it returns it as text. I have done several searched but can't seem to find anything that matches formatting an...

Thanks RV I was able to make an Expression using your function and it worked. Thanks again your a life saver

Thanks grnzba, I hchanged the joins in everyway that I could LEFT, RIGHT INNER and it made no difference. But when I took the criteria fields out of the show it will return a blank field so that is some progress now all I need is to figure out how to get the blank field to be a 0 if no records...

Hey Everyone, This one is driving me crazy. I have a query that is based on 2 tables. I need the result of the query to be the sum of hours or if no hours then I need a 0. I have searched and tried just about every IIF and NZ function I could find and when I add them I get no results. Which...

Help Please Thanks grnzbra, but but queries 215 through 221 do have joins in them. I have tried it with all 3 joins and still can not get a 0 value to show. What I get is nothing What I need is this, any help would be greatly appreciated. Thanks Everyone

Hi All, I have searched and tried every post that I could find and can't seem to get this to work. What I have is 2 tables "training_tbl_200" and "topic_tbl_200". I have several querys "qry_training_215" thur "221" that make up my main query "qry_training_222" My main query will not show any...

Hello TechChris Unfortunely it sounds like you are asking us to design and build your database. If you follwed the Access Rules for creating the databse tables and structure that is a good place to start. Once you are sure of your structure and direction only you can decide what kind of fields...

Hi All, I hope someone will know if this is possible. I am sending a report from Access via Lotus Notes ( which is working fine ) but my boss would like the report to be a Serial Route Memo. I know there are like 75 threads about Lotus Notes out there but I cant seem to find anything on using a...

I think that will do it I can definitly make that work. You have helped greatly with this and I can not thank you enough. RuralGuy ROCKS!!!!!!!!!!!!!!!!!!!!!!!!

Yes That was it exactly you are a life saver. I have been beating my head against the wall on this form. If you dont mind I have one more thing on this form I have to figure out, if you could help with it to I would forever be thankful. On the "frm_dismount_600 subform" I need help with a form...

Yes it opens inside the main form " frm_tirelog_600 " No problem thanks RuralGuy

Hi, can anyone help with this. Thanks