Need Help Simplifying

Apr 1, 2008

All:

What I'm trying to do:
I want to be able to use a switchboard button (or a button on a form) to open a unique form. OK, true, that's easy. Here is where I am having trouble. I want that one click to set the title of the form and the criteria for the query of a subform. Basically I want one form/subform/query to service multiple employees.

What I currently have:
I have a main form and two subforms, and multiple queries for each employee. They all do the same thing, display the same basic information but it all depends on the employee. If I make a simple change it takes hours to change all the forms for all the employees.

What I've done to find an answer:
I bought a Learn Access in 24hrs type book which got me to where I am now. I then purchased an Access VBA book and am currently about 1/3 of the way through that but still have no idea where to go.
I've searched through example databases to find one that does something similar but haven't found one.
I've done web and forum searches. I think my lack of success there is possibly due to not searching for the right things.
I've been experimenting on my own since November of 07.
I don't have a skilled friend I can ask.

There is probably a simple solution I just don't know where to find it.

Any help?

SeaRox

View Replies


ADVERTISEMENT

Simplifying Function Problem

Jan 11, 2006

Hi, how do i simplify this function? I tried substituting the value 1 so it becomes like this but i get the "Expected: end of statement" error. Can anyone help? Thanks

Function StdRow1Enabled(Value As String)

Forms!F_ReceivingStandardParts!subform1.Form!txtBa lQty1b.Enabled = Value

End Function

Function StdRow1Enabled(Num As Integer, Value As String)

Forms!F_ReceivingStandardParts!subform1.Form!txtBa lQty(Num)b.Enabled = Value

End Function

View 8 Replies View Related

Simplifying Expressions By Assigning Parts To Variables Error

May 30, 2012

I have a report with many unbound fields with expressions (over 200). I've began getting this error message. This may seem like a dumb question but what does it mean when it speaks of simplifying the expression by assigning parts to variables. I put a few examples of some of the expressions below.

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

=Count(IIf([District]=1,0))
=Count(IIf([District]=1,IIf([FSL]=4,0)))
=[D1Final4]+[D1Waiver4]+[D1PreMist4]
=[D1TotalCom4]/[D1TotalReq4]

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved