Search results

I don't believe that girl has a dress?

Can you use a table function - basically a view but accepting a parameter.

Would Offset Fetch do the trick? But you'd still have to evaluate when it was offset by how much.

shadow of the

circle your wagons

Its doesn't have to be the table directly - it can be a form with a subform in datasheet view, with the recordsource set in a way that's not accessing the table directly. I thought the above was what the OP was referring to , as they mentioned a form.

saw her child

Hi Doug , we are Access/Sql Server developers based locally to you. Is there a way we could contact you directly to introduce what we could do , and to find out your more specific requirements? Regards, Tom

I think you may well have hit on the other important thing apart from nutrition- genetics! :-)

I fear we will be disappointed!

an open prancing

As CJ suggests you could have another button say on the main form which then holds the datasheet and subsheet. On the click of the button it could toggle the subsheet to be expanded or not. With Forms("FormName") strExpand = InputBox("Expand subdatasheets? Y/N") Select Case...

Who's going to win - haven't actually watched any being overnight here, but England's struggling down under again!

Neither - a bit of cycling, running, football, and general fitness - but no gym anymore.

travelled with friends

I would have though getting your nutrician right was the most important thing if you are still growing.

Well as with anything I would go with the latest version you can get you hands on to take advantage of new features.

You can get the values for the new records by using something like !NewRecordField = Form_FormName!SourceField but yes you would need to somehow select which fields you wanted if , the whole record wasn't required.

Just as a quick check have you run each line in SSMS just to check them there, you should get a better idea of any errors that way rather than the access message.