Replies

Thanks Wendell…

Font color was the first thing I checked… I even tried making everything bold to see if that would make it print darker… No such luck… I noticed this problem a while ago… I’ve just been working around it… I figured if anyone would know why this was happening, the gang at Woody’s would know…

I’ll let you know if I figure it out… Have a great day!

Hi Janie…

Well, I’m not sure I understand your conditions correctly… but this is how I’d set it up…
First, I would deal with getting the records I want (i.e. the records with ID_status 1 or 2)

• open a new query in design view…
• add the table with the records I want…
• select the fields for the report…
• in the Criteria section for the ID_status, I’d enter 1 or 2
  [/list]Then I’d use the DateDiff() function to find the time span between the dates…
  If you look in Access Help you’ll see that you can specify that you want the amount of days, weeks, weekdays, months, etc…
  One example could be something like… DaysElapsed: DateDiff(“d”, [indcident_date], [reported_date])
  This would return a number respresenting the amount of days between the two dates…

  Once you get the correct results for the date difference field(s), you can add criteria specifying “> 5” or something like that…

  Sounds like you will need some nested IIF’s to choose the right fields to use, but I’d need a little clarification in order to help with that…
  Hope this gets you started at least….

Hey Paul…

Try this… Me!subfrmName.Form.AllowEdits = True
(Just change “subfrmName” to the name of your Subform… )

HTH

Hi Kindra…

Try creating a calculated field in the query and sorting on that…
For example… fldNumeric: CLng([fldText])
This will Convert the Text Values to Long Integer… (There are numerous conversion functions… CDbl (convert to double), CStr(convert to string), etc… )
If you then set the sorting to ascending on fldNumeric field, your resulting records will be sorted correctly…
You can also hide the calculated field so that there is no confusion between the two…

HTH

All you need to do is format the results…

Try this: Difference: Format(CStr([field1]-[field2]),”Fixed”)

HTH
P.S. There are no dumb questions silly!

Hi Paul,

That looked good to me, so I tried it on my machine here… Worked fine??… Go figure…
What error message are you getting? Are you sure the field name isn’t mispelled or something like that?

Thanks Steve… I do know about logical operators and arrays… I just didn’t know the * and + worked as AND and OR in Excel… COOL STUFF!
I was actually trying to use AND in the formula and it wouldn’t work, so I went on to trying nested IFs… This is useful knowledge!
Thanks again!

Thanks a million Steve! Option 1 worked perfectly on the first try…

Ummm… at the risk of completely embarrassing myself with a dumb question…. (Just kidding… This is how I learn… I MUST know why… )
what’s with the asterisks between the conditions?

* = multiplication operator OR wildcard operator to me… Does it mean AND in this case?

I would like to try and help, but I’m not quite sure I understand correctly… I have all kinds of questions based on what you’ve said so far…

Are you looking for help with the query to get the data for the report?
Are the goals set by program? (ie… the same for every employee that will be working on that program)
Does the production field in the Employee table get summed to find the percentage of goal achieved?
Is there any way you could show us some sample data to see what exactly you are looking for?

Sorry… You misunderstood me… I didn’t mean to check your On Click events…
You had said that the error read: “The LinkMasterFields property setting has produced this error: ‘Ambiguous names detected: Clients_Click’.

First, I think you should check the form module for two procedures called “Client_Click” first.
Second, you should check the subform control to see what shows in the Link Master Fields property…

Hope that makes more sense…

Try replacing the double quotes around the field names with square brackets…
NET_VALUE with quotes around it makes it a string… Therefore Access can’t multiply that string value by .077…

Try: [SHIP_CHARGE] Between 0.073*[NET_VALUE] And 0.077*[NET_VALUE]

HTH

Add an If statement, inside the For-Next loop that tests if it’s a system table or not…

If Left(tdf.Name, 4) “MSys” Then
DoCmd.DeleteObject acTable, tdf.Name
End If

HTH

Can you give a bit more detail than that?

I know that the “Ambiguous Names” error arises when you’ve accidentally create and try to use two procedures with the same name…
For example, if there are two sub procedures in the form module that are named “Client_Click” and the On Click event property is set to [Event Procedure], click that Client button and the error will come up…

What that has to do with your subforms linked fields I have no idea? …Have you actually checked that property (Link Master Fields) in the subforms to see what’s there?

HTH

I am having the same problem with VBA help in Excel, Word and Outlook 2000… My employer upgraded everything to 2000 other than Access…. The Help is fine for Access 97, but nothing else… Our desktop support was useless at fixing this for me (as usual… )…

Wish I could help… but I’ll be watching for an answer…
I hope someone knows the solution!

Oh… OOPS! …
Sorry Charlotte!