Search results

  1. G

    Chart Wizard Error

    Hello, I hope someone else may have encountered this. I am trying to install a chart on a form in Access and am receiving this error: Chart Wizard Automation error Library not registered I am using Office 2016 Professional with Visio 2013 installed on a Windows 10 Enterprise 64-bit OS. Can...
  2. G

    Records under/over 3 days old

    I am working on determining records that are under or over 3 days old. I just can't seem to get the syntax for Access correct. Here is my SQL query for greater than 3 days: SELECT * FROM AFETaskView WHERE Created < DATEADD(day, -3, getdate())I just can't seem to work it out for Access...
  3. G

    Subform Not Showing Data

    Okay I am having one of those moments I guess. I have a Subform that is inside a Subform that its only purpose is to display some calculations but for some reason it is blank. Here is a screenshot of what I am dealing with: See that area under "Pump Calc" that is blank...it should have data...
  4. G

    Access 2013 Cmd Button Issue

    Access 2013 People, Have any of you experience a situation where the command buttons are not displaying properly? Here is a picture of a DB from Access 2010: Notice the words and images are nice and centered in the buttons. The buttons are all the same size. Now look at the same DB in...
  5. G

    Tip Navigation Pane Scroll Bounce -- Access 2007

    I am making this a tip but if someone else has a better solution please comment. System Description: OS: Windows 7 Professional 64bit Office 2007 The issue is when you scroll the navigation pane down (or up) the whole menu list, once you stop the scroll, will jump at least 3 spaces in the...
  6. G

    Opening a Recordset from a query

    Okay here is what I would like to do...I have an unbound form that has a combobox on it. It's recordsource points to a query. What I would like to code is some first, next, previous and last buttons without using "send keys". So in other words when I press "Next" button I would want it to...
  7. G

    Complex Query

    I am trying to write a query from 2 tables. The first table is called Leases, holds the lease information. The second table is called Wells, holds the well information. The lease is the primary key in the first table and is joined in a one-to-many relationship to the lease in the Wells table...
  8. G

    Combobox and Command Button Problem in Access 2007

    Hello, I am wondering if anyone else has this problem? I have a Windows 7 Professional laptop with Microsoft Office 2007 installed. For some reason when I open a database where there is a start up form set, either in the Current Database settings or an AutoExec macro, I can not use the...
  9. G

    Adding "New" to Combobox

    Hi Everyone, I have a question and I am not having any luck finding it out. I want to display the word "New" in a combo box's dropdown list along with the query I have set for it. So if there are no items the word "New" is the only thing listed or if there are items the word "New" is listed...
Top Bottom