Search results

cheers for your input :) i've allways adhered to the addage that trying to do something and discovering its not possible is better than being told you cant and giving up :)

03 Version :) while it will grow to be a largish database it would never usually be used by more than one user at a time but so much more usefull to have a dropdown filter rather than a cold search form with various spellings/mistakes of names/surnames in the database

here is a sample one

i think im halfway there with a "Like" Criterea Combobox label is NameLookup with Row Source is a query where TableName.CustomerName has the Criterea Like ("[NameLookup]*") but i cant seem to get this to refresh ideas ?

not quite the problem ...yes it does go to closest matching but if you then select the dropdown it still contains ALL the data still ie a table with 3 records Daniel David Peter if i type Dan it will jump to Daniel but if i select the dropdown it will still show all 3 i want it to requery on...

just wondering if its possible to requery a Combo box with text allready partially entered (ie a Name Combobox from table with hundreds of names the drop down list changing with every text character entered) way i figure should be possible with a requery on update for field with a criterea of...

I have a Report that is generated from a querie with the usual criteria Between [StartDate]and[EndDate] which works fine but when i choose to print preview it asks for the Criteria again i figured a way around it with a button macro to blind print but as you prob have experienced Report view...

ok if i were to take this simple sample data base as a example and wanted to add say a further parent field called Hospitals so it would be ; Hospitals ---PersonID-------FRM_Metodologies ............................-------FRM_Sistems then wanted to to a report of Metodologies and Sistems by...

ok figured it out had 2 master/child links in my mainform/subform instead of the single which was causing my problem now to fix my reports and combo box lookups which worked under old system :/

it seems to behave like this regardless of restarting the form or going next for the first record but after that choosing any but value of first record works fine just if choose first one will it autofill

im afraid its a 07 Db and i cant change it to a 03 because of certain used features but here it is in 07 To see Behaviour go to New Form select a JobNo put something in the Decription dropdown then go the the next form NOT NEW FORM then in Job No choose the same one as before and watch it...

yah its a strange one i cant seem to see any thing in the filter i changed my navigation from next form to close form--reload form--go to new record and that seems to work fine but be nice to know where the bleed comes from

i rebuilt the subform using the wizard and that seemed to fix it now .... saved my old one but apart from an extra link in the child/master cant see any difference another interesting problem i saw was when i ran it on another computer a laptop with smaller screen the final total down bottom...

Crazy one this have a Report with a subreport the report view is missing data and total from the subreport but if i print its fine even the totals have changed . any ideas ?

have a form where the initial field is a combo-box if i complete the form then start another if in first combo box i choose the same selection it loads the previous values in other fields instead of continuing with a fresh one any ideas ?

as a general question do you usualy base Forms off Queries or Tables or mix of Both ? i can see advantages to Both

yah i just deleted it and restarted and sems fine now :/ must have been something underneath

in the Report Footer

yeah i was a little confused made a few major changes got my head around Queries so basing forms and Reports on queries now so all the math is done properly and figured out how to pull subform totals out to main form and so for reports as well got a crazy one atm tho my reports totals are...

Work Performed = Description ok the Form Layout Data should look like so ; . Header.... .. Job No..34524.. ... ......Work Performed.......Quantity.......Price.......Total ------------------------------------------------ ......Grading.......................2..............$10........$20...