Search results

  1. A

    Import Firebird tables

    http://www.connectionstrings.com/firebird/ http://www.firebirdfaq.org/faq200/ http://www.firebirdsql.org/en/odbc-driver/
  2. A

    Adding Windows username in a new record?

    Are you calling the Query in the button event? DoCmd.RunQuery "QueryName"
  3. A

    Sharing one form with users who do not have access to the back end storage tables

    If they don't have access to the shared area how are you expecting them to enter data into the db?
  4. A

    Count the number of items selected in listbox

    Me.ListboxName.ItemsSelected.Count
  5. A

    Cannot get desired data on a form

    You could either create a Query that orders the records the way you wish and base the Form on that. Or add some code: Private Sub Form_Load() DoCmd.RunCommand acCmdRecordsGoToLast End Sub
  6. A

    Cannot get desired data on a form

    Copy last Record http://www.599cd.com/tips/access/130921-copy-last-record/?key=AkexForum
  7. A

    Win 7 Open db

    Have you tried adding it to the startup folder in All Programs?
  8. A

    Not empty list wiev at Formload

    If you open the Form in Design View and select the listbox, bring up the Property Sheet. Is there an Items/List Property that contains values? -- Are you setting the Data Source to a Table/Query or is it a Static list. Is this being populated manually by the user or in code after the form has...
  9. A

    Multi-column List box

    The "Amount" Field, what Data type is it? Number, Single, Double, ...?
  10. A

    Forms layout/size acting erratic...help!

    Do you have Access set as Overlapping Windows of Tabbed Documents, I presume OW. When you have sized the form are you saving, this should save the Size and Position of the Form so if you close and re-open it will show in the same place. Are there any events running on the Form, macros or VBA...
  11. A

    Strange behaviour of combobox

    Is there a number in the ListRows Property? Does the combo show a scroll bar? Suggestions: Try changing the default value for Default Max Records in the Advanced tab of the Options window. Options->Edit/Find Check for a Limit. Try a Compact and Repair. Try creating a new combobox in case...
  12. A

    Dlookup issue

    Is [REFERENCE_NUMBER] the Primary Key or a unique number in the Table?
  13. A

    Average data in a field and print it out in another

    You just need the Field and the Query name: Set the textbox to be =DLOOKUP ("Field", "Query") =DLOOKUP ("AvgOfTOTAL", "TOTALQRY") A few DLOOKUP examples: http://www.599cd.com/tips/access/dlookup-function/?key=AlexForum =DLOOKUP (Field, Domain, Criteria) =DLOOKUP ("LastName", "CustomerT"...
  14. A

    Update and Navigation

    Are you storing who creates each Record? How are you achieving this? If you store who created the record using ENVIRON("USERNAME") then you can create a Query that returns just records with the Criteria of the given logged in User.
  15. A

    add date from calendar

    There's been an update with an added Calendar Control made with a Form: http://www.599cd.com/templates/access/calendar-control/?key=AlexForum
  16. A

    Average data in a field and print it out in another

    You can either set the source of the Form to be the Query that has the values in or use a DLOOKUP to display it on the Form.
  17. A

    Criteria doesnt work in chart report

    Access has issues with parameters and Crosstab Queries. Try declaring the Parameter by choosing Parameters on the Query menu.
  18. A

    Average data in a field and print it out in another

    Have you tried adding the AVG as a calculated field in a Query with the other data you require. If you update a Field that the AVG uses it will update. Aggregate Queries http://www.599cd.com/tips/access/aggregate-query/?key=AlexForum
  19. A

    add date from calendar

    Have a read through of the following Calendar Picker Blog Post. You could use an Active X Calendar Picker Control. It doesn't work in later versions of Access which is why the below was suggested and Access added the inbuilt functionality. If you want an indepth tutorial on Calendars check out...
  20. A

    add date from calendar

    You can also use Application.RunCommand (acCmdShowDatePicker)
Back
Top Bottom