Search results

Take a look at this MS Knowledge Base article on maintaining a print log for reports (article no. 154894) http://support.microsoft.com/default.aspx?scid=kb;en-us;154894 HTH

I don't think I can help you unless I see what you're talking about. Can you post your db?

Here's an idea: Create a table to hold information re: the date/time a report is printed. Each time the report is printed, use code to programatically add a record to this table. Then have the report only print those records posted after the last date/time entered in the table mentioned...

Be sure you are referring to the subform correctly - check out this MS Knowledge Base article http://support.microsoft.com/default.aspx?scid=kb;en-us;209099 HTH Elana

Here's the answer to your question - MS Knowledge Base Article 271607 HTH E

Hi - I solved the problem with this code placed in the On Format event: If Me.Left > (3.5 * 1440) Then Me.txtSalesperson.Visible = False Else Me.txtSalesperson.Visible = True End If Can't remember where I found that code - believe it was on the MS Knowledge Base tho. HTH E

I think this MS Knowledge Base article will give you some help here: http://support.microsoft.com/default.aspx?scid=kb;en-us;208866 HTH Elana

:o Sorry, I spaced out that you were attempting to use multiple criteria here. I don't know off the top of my head how to solve the problem you are experiencing. Hope someone else can help -

it should be placing brackets around it. Try placing brackets: =[forms]![frmTowns]![Text1] E

Have you placed an equal sign = in front of the criteria?: =forms!frmTowns!Text1

Looks good to me - if it's working, that means you did it right! E

Here is the db:

Okay, here is the code that I placed on the OnOpen event of the main form. Plus, I disassociated the subform label so it will always display. Plus, I added a text box behind the subform to display the text you want when there are no records. Dim dbs As Database Dim rst As Recordset Set dbs...

If you can post your database, I can take a look at it and perhaps give you another idea how to solve the problem.

Let's experiment and see if I can help you without actually looking at your app: Let's try to work with just one of the subforms right now, and if you get this to work, you can adapt it to the other 2 subforms. On one of your subforms, insert a textbox whose control source says ="This service...

You need to filter the form to open to a specific record. Behind the click event of a button on your dialogbox form, place code like this: Dim strWhere As String strWhere = "[RecordIDNameOnFormyouareopening]=" & "forms!yourdialogboxformname!RecordIDThatmatchestheRecordonthe otherform"...

You can change the behavior entering a field by going to the Tools/Options/Keyboard tab and selecting which behavior you want. But, this will affect all fields. I don't know how to isolate just one field, though. Maybe someone else can point you in the right direction.

Use VBA code behind your form to perform this check, something like: Select Case formfield1 Case 2 perform some action and don't look at the other field Case Else select case formfield2 case (whatever value you want to check for) perform some action...

Check out "Format Property - Date/Time data type" in Access help. For example - to show the hour of the current time, place this in the control source of your field =Format(Time(),"hh") You can play with adding and subtracting from there. HTH

I'm working off the assumption that for every project, there will be more than one invoice - true?