Search results

  1. D

    Hide toolbar and status bar on logon screen

    Does anyone know how to hide the toolbar/status bar on the Access logon form? The logon form is the standard Access form that is used with user-level security in a 2003 database. We upgraded our frontend to Access 2010 and now when the user is prompted to logon they see the toolbar and status...
  2. D

    Column filtering on linked table (SQL Server)

    I am having a weird issue that I'm hoping someone has come across. I have a mdb file as a front end and link to my backend which is a SQL Server database. When I open one of the linked tables to review the records, I do not see the same column filtering options that I do when I look at a...
  3. D

    Format double field as 'Long Time'

    The application is very old (18+ yrs) and that is how it was designed. All dates and times are stored separately and it would be a lot of work to change it. I'm hoping that there is an easier way to address this.
  4. D

    Format double field as 'Long Time'

    I have recently upgraded my Access 2003 application to Access 2010. I am running into a problem when formatting a textbox to 'Long Time' that is linked to a Double type field. The error that I get is 'The value you entered isn't valid for this field. You may have entered text in a numeric...
  5. D

    Datasheet filtering

    Thank you spikepl this worked perfectly!
  6. D

    Datasheet filtering

    Thanks for your reply CJ. Unfortunately I tried both of those events. The On Filter doesn't fire at all when filtering by column and the On Apply Filter appears to fire before it actually filters the data. When I check Me.Recordset.RecordCount in the On Apply Filter it gives me the number of...
  7. D

    Datasheet filtering

    Hello, I am using Access 2010. I have a subform(continuous form) that I display as a datasheet and allow filtering. I display the record count by using Me.Recordset.RecordCount in the subform's form_current event. This value updates properly based on the column filtering except when the...
Back
Top Bottom