Search results

No. Departments and contacts are INDEPENDENT. Its the Join table that matches them together. You can have departments with no people assigned and people not assigned to a department. It is only when you add a record to the join table, matching a PeopleID to a DeptID that you create a relation...

none, Again, what you use is a JOIN table. its the JOIN table that manages the relation.

Are you putting the Terms and conditions in a Group or report footer?

Space(40-Len([string])) & [String] will pad with leading spaces, reverse the order to add trailing spaces. You can also handle this in the export specifications. When you export to a fixed width file you can specify how many characters each field will take up, Sop you can set the field for 40...

Looking at your criteria document (which is the same thing you sent me privately) this looks like a homework assignment. If so, then suggesting that you would pay me to do this for you, is very wrong. Most of us will not do homework assignments. What we will do is critique your work and make...

That's what we are here for.

I think the thing you are missing is how to use the Detail band. The detail band of a report will increase as needed to for the amount of records in the report. lets say you have a standard US letter size which is 11" high. You have a 1" top and bottom margins which leave 9". you have a .5"...

You are going about this wrong. The balance remaining shouldn't be stored. it should be calculated: =DSum("[charges]","table","[PatientID] = " & Me.Patient & " AND [FeeDate] > #" & DateSerial("Year(Date()),1,1 & "#")-500 This will give you a negative figure until the total charges for the year...

just ask your questions here. If you need to attach a copy of your database Zip it and Attach

I would create this piecemeal instead of trying to get the whole string at once. You can then use a fixed width format in your export. for example: Field1: "2UPRR" Field2: Format (Date(),"YYMM") & "00" Field3: Format(Int([BillingCost]),"0000000") &...

I don't see a problem with it as long as the customer is totally aware that's what it is. However, unless I'm actually working under the client's supervision I would give a flat fee. If I was a customer hiring a remote freelancer, I wouldn't know what they were doing during the hours they...

Then you need to use the table or query that the form is bound to. Applying any filters from the form.

Again, what you are describing is governed by a join table. I gather you have 2 tables one for contacts and one for employees. Instead you should have one People table with a flag to indicate they are a contact or an employee. if you can't do that then you expand the join to: DeptID PersonID...

Are you saying a Dept can have a single contact and a contact can have a single dept, but not necessarily the same dept that they are assigned to as a contact? That doesn't make a lot of sense. But i would still use a join table to express that.

Again a form does not have records. The table or query bound to the form has the records. As to not trying to build on the fly reports see my answer int he other thread.

Approach it to them this way: I'm trying to make this easier on you by giving you a set of reports that lists the info you want. All you need is select the type of report and print it. I can give you as many report layouts as you want. You just need to list what you want. If you don't want to...

I've taken a look at your database and there are a number if things I don't follow. I gather that you have different prices for each customer for each product. Do you really what to do that? Wouldn't it be easier to have a base price and then have a discount or increment percentage apply to...

Hi Ken, I recommended that earlier ;) I would say that's one of the areas where Access is weakest, the ability to create reports on the fly. Its definitely something I wouldn't attempt.

Use the TransferText method. See Access Help for how to use it.

You are entitled to your opinion, I'm entitled to mine. I've had many friends AND clients approach me over the years to do things I felt I was not competent to do. In such cases I would explain to the person that I felt I wasn't competent and offered to find them someone who was. Sometimes I...