Search results

I have a subform based on a query - Can I change the sort order of the query by multiple fields from the the subform? To make it tougher, the data is locked down in read only mode, so the toolbar sort option is not available Thanks for any tips

Check DataQuery and then LookupQuery in attached db

OK is this data 1/1/09 TV 399.95 1/1/09 TV 185.99 2/5/09 TV 133.99 1/1/09 TV 222.99 all in one field, or several fields? If one, you need to select the first 6 characters out of the data - In a query, select the field with the data, add a new variable (dt) and enter it as dt:=left(fieldname,6).

Create a query with the fields you need, string from the field and Group By to 'remove' duplicates

Best of luck & hope the fingers haven't stiffened up too much

Like "*word*"

I have seen this sort of thing where someone has done a copy & paste out of other software

My 2cents worth: Probably more important than what bit of hardware you use, is how manage what you choose. Keep it simple and don't expect the server to do a million things effeciently - the more things you have running on it, the more likely performance suffers and problems increase

Brilliant - works perfectly. Thanks for your efforts

mmm I guess what i really want is the cursor to jump to that position

try this one

database attached, I am trying to get the Sightings subform to open to a new record Thanks for your attention

Hopefully, pretty straight forward (I'm not clever enough for the advanced stuff yet) Form loads with data from the main table in read only mode, so details can be viewed but not altered. Subforms based on linked tables to the main table, which is where I want to be able to add records

Thanks Bob, but didn't work for me. I have a form with data based on a query, with a tab box with several subforms. It still wants to add a new record to the form data, not the subform

Can anyone point me in the right direction in getting a subform to open to add a new record when the main form is opened? Can do it for the main form, but having grief getting the subform to work Thanks in advance

It will work better if you have your CustomerOrderID as an autonumber, same in details

Common causes are: you are trying to add a duplicate record, or text into a numeric field. Double check the data you are trying to enter

Don't you just hate it when Access does exactly what you tell it?

try this one

I suspect this is beyond my skills. I think it needs some VBA code to cope with this which I am decidedly inept at