Search results

rutica, I glad you got it "working", but I think that you will run into problems in the future as (in my opinion) you should not have the same data in Three Tables. Post a question on this site and ask if you should have the same data in 3 separate tables. What happens if you want to add...

I'm not a guru but I think that your table structure is wrong. You have the same data in 3 tables; Criteria Code in table:blEscalationReportsDetail and table: KPI Rating Rationale and table: KPI Rating Criteria In my opinion the data should only be in 1 table.

spetty, Have a look at the attached sample, it may help you find the error. My advise (if you don't mind) is to name your controls as I have and do not use spaces in field names (when you create them in the table). Also name you forms e.g frmTimeCard and for subform I use sfrmTimeCardHours...

rutica, You asked: Answer: Yes. I have looked at the other part of your question and sorry but I am unable to understand what you are trying to do. What is ReportID is it the name of a field in a table? What is CriteriaCode is t the name of a field in a table. Also I don't understand how...

Bob, I read this in the module and assumed that it was ALL your work: Sorry about that. ------------------------------------------------------------- RuralGuy, Sorry I don't have a link to the download, I think I downloaded it a long time ago.

RuralGuy, Downloaded and installed Allen's calendar into my program and it works fine. Thank you for pointing me in the right direction.

RuralGuy, Yes I had looked there and this is what I found for unbound controls (which I am using on the form.) I have entered "Short Date" in the Format property. I will download a copy of his calendar and give it a go.

I have tried to use Bob Larson's, "zsfrmCalendar" but am having the old UK - USA date format problem. I would appreciate it if someone could look at my sample and provide a solution. Thanks in advance. PS Bob thanks for "zsfrmCalendar" anyway.

Mike, What I use a lot is a command button that is transparent, I call it cmdDud and use that as the first item in the tab order and in the after update of combo's etc so that the set focus is to cmdDud" I have created a quick sample for you to have a look at, hope it helps.

CCK, I can't open your attachment as I only have 2003,2000 & 97 NO 2007.

Have a look at the attachment and you will see that; the current subform total appears on the main form the current running total appears on the main form. If you have a look in the form footer of the subform you will see how it works. Then have a look at the 2 text boxes on the main form...

AggieLJ, Always glad to help anyone from Texas.

Glad it worked for you.

Put code like this behind the onClick event of the list box. Changes "Names" to suit. Me.List6.Column(1) , assumes that your SSN's are in the second column of your list box (first column is 0) Me.txtSIN is the text box on your form that you want to populate with the SIN number. Private Sub...

Have a look at my sample posted Here Go down until you see PrintCurrentRecord_Update.zip. It will show you how to email, print etc the current record. Any further questions post back.

Ashfaque The only error I can see in this code is there is no ' before try the following Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) try the following Select Case KeyCode Case vbKeyEscape docmd.close acForm, me.formname End Select End Sub I have tested the code and it...

Put this code in the Detail OnFormat section of the report Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType = acTextBox And IsNull(ctl) Then ctl.Visible = False Else ctl.Visible = True End If Next ctl Set ctl = Nothing I hope this help you.

If you want a simple method to put the "Grand Total" in the "Last Page Footer" then have a look at my sample. 1 >You must have the in the page footer, I have made mine visible = false. 2> Put an unbound text box in the report footer (see report in sample) make it visible=false 3> Put an...

Do a search on "Sending E-Mails from Access" , you should get plenty of hits.