Search results

  1. D

    Dynamic sizing text fields in reports

    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
  2. D

    Forms - combo box

    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...
  3. D

    Inserting data from forms w/ Junction Tables

    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?
  4. D

    Displaying info from combo boxes in sub-forms

    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.
  5. D

    Forms - combo box

    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.
  6. D

    Need to Add and Delete records in subform

    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...
  7. D

    Numeric Feild Overflow

    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...
  8. D

    Text Field size and enter key behaviour

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

    SQL query

    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
  10. D

    SQL query

    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))
  11. D

    Application Crashing.....????

    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...
  12. D

    Numeric Feild Overflow

    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?
  13. D

    Interrogate the new entry in a field

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

    Double Tab

    how about DoCmd.GoToRecord acDataForm, , acNext then?
  15. D

    Interrogate the new entry in a field

    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?
  16. D

    Double Tab

    Try me!nxtFieldName.SetFocus
  17. D

    Retrieving Module Line Number

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

    Retrieving Module Line Number

    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...
  19. D

    Toggle Button

    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
  20. D

    Toggle Button

    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
Back
Top Bottom