Search results

Yup, there sure is... In the properties window for your textbox, under the format tab, look for the 'Can Grow' property. Change that to yes and your problem should be solved! :p

Sorry, i got that wrong anyway... If you don't know much about code, the easiest way would be to use a macro. Open up your form in design mode, and select properties from the view menu. In the Event tab in the properties window, look for the event 'On Open". When u click in this area u...

If your main form is based on the Orders table and your subform (i assume your using a subform?) is based on your junction table, u just need to set the child/master links in the subforms properties. Which will most likely be OrderNo or something like that?

Are u sure the combo box doesn't have the CustomerID hidden as it's first column? Look at the Column Count and Column Width properties under the format tab of the combo's properties. Sorry if i'm stating the obvious.

U could just add a docmd.GoToRecord acDataForm,,acNewRec on the forms startup event. So when they open the form, it will start at a new record. Then when they choose an item from the combo it will take them to that record.

U can use DoCmd.RunCommand acCmdDeleteRecord in the subform, but the button must be in the subform as well... I put mine in the subforms footer. For a new record, just use : docmd.GoToRecord acDataForm,,acNewRec For distinct values in your combo box, go into your query and select properties...

If your number is 12 digits long and your Field size is set to long integer, i don't see how it would work at all. Long integers will only accept 10 digits (sorta... as long as it's less then 2,147,483,647) When u say "I have tried using every format option.", do u mean u changed the Format...

It seems that the default setting is for values up to 60, and the New line setting is for any value over 60...

Same sort of thing then... in the first line of the date criteria put: BETWEEN [Forms]![listbox2]![Text15] AND [Forms]![listbox2]![Text17] And in the second line put: IS NULL

By sql query u mean in a WHERE statement? for example: SELECT * FROM myTable WHERE ((myTable.myDate BETWEEN [Forms]![listbox2]![Text15] AND [Forms]![listbox2]![Text17]) OR (myTable.myDate IS NULL))

Have u tried using the Jet Compact Utility? Or exporting that table, or importing it into another database? Maybe you could make a query that selects all records except that one and create a new table with that data? When i've had a corrupt record, i've found i've been unable to delete it...

Integer -32,768 to 32,767 Long (long integer) -2,147,483,648 to 2,147,483,647 Have u tried using double instead of long?

ohhhhhhhh :eek: Now that could come in handy! thanks :p

how about DoCmd.GoToRecord acDataForm, , acNext then?

Zoom control? :confused: Maybe it's like u say,it's not saving the record while it still has the focus? I think that's how access works... Try a docmd.RunCommand acCmdSaveRecord before opening the popup?

Try me!nxtFieldName.SetFocus

Well, it is Microsoft u know... :D btw, heres a global error handling example from a cd i have. It covers just about everything.

You can however, view erl in the object browser. You just have to right click -> show hidden members Not that it tells you much :p It isn't? because i'm basically using it exactly how you described in your first post... I know it's a bit of a pain having to add your own line numbers, but i'm...

Best way would probably be to use two combo boxes. Have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31900&highlight=cascade+combo or try doing a search for 'cascading combo boxes'... plenty of them on here :D

You could probably do it that way by having the toggle button/check boxes change the row source of the combo box to match the corresponding tables. But i think you would be better off leaving it all in one table and using your toggle button to filter the combo box by category... Dave