Search results

Write a summary query that will group on Booking and summarize ItemsHired.

What is the purpose of this form you are dealing with? You have data coming to a form from the CustomerMaster and InvoiceHeader tables. Are you trying to update the CustomerMaster or the InvoiceHeader? Which ever table you are trying to update, that would be the only table you should need in...

First, either add .txt to the file name when it is being created or written to disk in the conversion routine, or take .txt out of the code you have shown. Either should do the trick. Your 2nd request for a cleanup routine. It would really help if you could show what the data in your text file...

One of the parts of normalization is making sure we don't have the same type of data repeated in a table. This is not an absolute, but something to always look for. And what I see in your tblCarePlan is Disability, Medication, Requirements, Achievements/Targets as four of your fields, all...

Matt, create a Public Function in the Master form that will accept a parameter of the size you want to make the subform that is on the Master form. Then, in your form that you use to open this Master/subform combo, you can issue this command:Dim ReturnValue as Variant ReturnValue =...

=IIf(Nz(DLookUp("EndDate", "tblEmployeeJobs", "StartDate=#" & DMax("StartDate", "tblEmployeeJobs", "EmployeeID=" & mEmployeeID) & "# AND EmployeeID=" & mEmployeeID)) = 0, "Currently Employed", "Not Employed")Basically, this formula gets the StartDate from the table EmployeeJobs based on it being...

Russ, You still need to initialize record = 1 right after the start of the While Not rs.EOF

This is a very common "GotYa". You need three ANDs and no OR in your criteria. To try to explain. You want to insert Standing = 4 AND Code <> "TR051" AND Code <> "TR052) Before inserting this record, you want all three tests to be TRUE. What you actually had was this: If Standing = 4 AND...

Then where ever I used x, change that to a z. But z will have to be initialized right after the start of the While/Wend loop. Initialize z to be equal to 1. Here is how to change the code near the bottom. rs.MoveNext 'move to next person x = x + 1...

Russ, I really think this should do it. Basically this is what is happening. Open the recordset, then While the recordset is not at EOF, do the code until hitting the WEnd, which is really the bottom of the While loop. This means that we will just keep reading records and creating slides until...

Sorry, but I don't know of any way to do what you are asking about the Access 11.0 object library. I would assume you would have to buy Access 2003 and install it on the computers that need to print this new report.

Try "SelLength" It is available to use to set the len of what is selected within the text box that has the control. Look it up in Access VBA Help. I'd explain how to use it except I have not been able to get it to work the way I have wanted, but you might have more luck. Please let us know...

So, what do you need? The way to do an IIf statement, how to find a date 6 months before now, both put together, or what?

Is the images file still on your C:\ drive? That is what it looks like.

By putting the name of the table you are dealing with, or a query over that table, into the form's RecordSource property, and then assigning the appropriate field names to the ControlSource properties of each field on the form, the form will be Bound to the data fields in the table (or in the...

I would highly recommend you start a new thread. This is a separate problem.

Yes, look into this with Adobe if you don't get any answers here. I've never done it, but know it can be done.

Entry made today = Date() 'This will put in today's date Previous entry date = DateAdd("m", -6, Date()) 'This will subtract 6 months from today's date

Paul, OK, that's why I like the Ridge. It is beautiful, and a VERY good challenge. The last time I play there was the last day the course was open before the last time the LPGA played there. The greens were the fastest I have ever putted on, but also very true. Maybe after you get some more...

You're welcome. I always think it fun when it starts working the way we want. I'm glad I could help.