Search results

is it possible to have the source of a text box set up as an SQL expression? What i want to do is when the records from a particular table are displayed on a form, it goes out and grabs a field from another table which is related to it. so the sql would be something like SELECT [Phone Number]...

Yeah really though, you'd think SOMEONE at MS would have thought of that. ok thanks i'll look into that.

Is there anyway to rename a table and then have al the queries/reports/forms automatically change to reflect the renaming?

hmm i tried to strip it down and ist s till too big, 182 kb zipped ( i compacted + repaired) there must be some other way?

hmm i tried everything you said including making a query based on the original, it still prompts this doesnt make much sense to me at all, especially since specifying every other field works properly so i guess im just out of luck here then?

nope there is nothing listed there this thing is pure evil

no it doesnt prompt by itself, only when i try to specify a paritcular tendor no my form lets me specify any of the data then the report is opened using the where clause thing but anything i specify filters through fine, except tendor no which it prompts for a parameter value \

SQL SELECT Contracts.[Tender No], Contracts.[Contract No], Contracts.[Project No], Contracts.[Contractor Name], Contracts.[Beginning Date], Contracts.[End Date], Contracts.[Security Deposit], Contracts.[WCB Valid Date], Contracts.[Insurance Valid Date], Contracts.[NSCSA Valid Date]...

code sorry, here it is: DoCmd.OpenReport stDocName, acViewPreview, , Mid(stlinkcriteria, 5) (stlinkcriteria starts with " AND " so thats why i used mid)

I have a simple form which opens a report based on a query. It keeps asking me for 'Tendor No' even though it is IN the query and i am just specifing it in my docmd.openreport call. I tried redoing the form, the report. and the query, but no matter what it prompts me for the value. I have no...

I am trying to use either cancel = true or docmd.cancelevent to stop the printing of a report when there is no data however, it comes up with the error: 2501 The OpenReport action was canceled. Is there anyway around this inane error? i tried docmd.setwarnings = false but it still came up

i have a form which brings up a report using docmd.openreport and the where clause i have a field in my report (which is based on a query) called [Tendor No], when i click the button on my form it uses a clause of [Tendor No] = "something" but it keeps prompting me for tendor no it is driving...

sounds good. i want it to update all the values to the same one... anyway to do this using a form instead of those ugly prompt boxes?

is it possible to make an update query where the "update to" parameter could be specified by the user? that is, i want to update the field to a non-static string

Thanks fizzio that works except for the following inane error: 'The OpenReport action was caceled.' Anyway around this? I dont see why access would error on this considering its what the code tells it to do. thanks

I am using docmd.cancelevent in the on no data event in my report but for some (stupid) reason access is telling me 'The OpenReport action was cancelled.' Is there anyway around this ridiculous error message?

i dont, thats the point i want it to either skip the code so it doesnt error, or just not run at all

I have a report which when used on an empty data set gives me this error: 'You entered an expression that has no value.' It is trying to evaluate: If Me.Wdate < Date Or Me.Idate < Date Or Me.Ndate < Date Then So i assume access is stupid enough to error because there is no data instead of...

Well the point of adding the 'wdate <> null' was so that it wouldnt attempt to evaluate the 'wdate < date' if wdate was null, so what i wanted to know was does access evaulate a logical AND statement properly or does it evaluate both sides regardless if the first is false anyway

The expression being evaluated is if (wdate <> NULL AND wdate < date) then ... end if now the error i am getting is "You entered an expression that has no value (2427) So what i am wondering is is it evaluating the left hand side of the AND expression even though it is seeing that wdate is...