Search results

Why are you not setting? Me!Sales_org.Selected(0) = True/False

Re: Where statement causing "This expression typed incorrectly or too complex" error I would suggest you get rid of all fields except bare minimum (after making a copy of the query) and see if the Where works. If not, then post this simplified query.

Is the record source for the form a table or query? If query, open the query and see if the dates are all correct at this point. Is the control source for the invisible field simply the field name from the table/query? What happens if you use the original field in your string calculation...

As a start, you could make your invisible fields visible to try to narrow down when the change is happening (on the original field, or on the later calculation)

have you tried vlu = "= VLOOKUP(" & ActiveCell.Address & ",windows(" & adst & "), Escalations!E2:F200,7,FALSE)"

is your report based on a query (or have a query for the Record Source? That would be a good place to replace '0' with '-'

you are taking the number of seconds, minus the number of days (e.g. 2321-1). Not very useful. Use Ranman's formula or at least get rid of -DateDiff("d",[Startshift_Date],[Time_Out])) from your formula

what if statement did you use and where did you put it?

what is the relationship between the two tables? Can you copy the entire SQL?

Another option which does the same thing would be for you to set a breakpoint after the sql= statement and look at the statement in debug. not better, just different

you need to loop through the selected items For Each varFile In .SelectedItems Me.EmailList.AddItem varFile Next

Where are your primary key fields? Why does CrewMapping not have field(s) for employee name (re: #3)? Here's a basic query that may help you see how to do it. SELECT [EmpName] FROM [CrewMapping] LEFT JOIN [DataTracker] ON [CrewMapping].[EmpNum] = [DataTracker].[EmpNum] WHERE...

Where is the Original Qty which contains the total number to be done? I'm confused about what the two tables are for. Correct me if I'm wrong. tblFitterOrder contains the name of a fitter and the products he is to install. What is OrderNo? tblInstallStages contains the quantity that has been...

Do you already have the table structure? That is the first step. If so can you provide table and field names?

Now can you provide the field names for each table?

Can you provide the table names and field names. I'm hoping you have two tables, one for the employee and one for the roster info)

>>James has I think misunderstood the question. Wouldn't be the first time....Won't be the last :)

They allow you to use a database designed in Access without owning Access. You won't be able to change or add any forms/reports/queries, but will be able to input data. Just like the PowerPoint viewer listed, you can see a presentation created in PowerPoint, but can't modify it.

When clicking the table button on the ribbon, are the After Insert and After Update buttons shaded showing that there is already a macro there? After clicking the After Insert button, are you sure your macro is not just closed? There're boxes to the left which will close/open a branch of code.

Brian, I usually go from smallest up, or largest down in my tests like this so that if an additional test ever needs to be made it will be easier to modify the if's. I'm not following what you meant by, "I would test in the order I stated as then non integer values are catered for" I don't see a...