Search results

  1. G

    Problem Closing Visual Basic Help Window

    Hello everyone, I have office 2003 Professional, and I work in Access's Visual Basic Editor. Sometimes after opening the "Microsoft Visual Basic Help" window by standing on a function in the code and pressing F1, the help window refuses to close - I click the X but it does nothing, and I'm...
  2. G

    Scrolling the current window using ScrollWindow function

    Hey all, I'm using vb 6.3 and access 2003. I have a wide access form which has a horizental scrollbar. I want to scroll the form sideways using VB code. I've searched around and it seems that the scrollwindow API function is a good way to do so. I call it thus: dim i as rect GetClientRect...
  3. G

    Combo Box Populates All Form Records

    Hi everyone, I have a form with a combo box, whose afterupdate code is: Private Sub CustomerName_AfterUpdate() Dim rs As Recordset Dim person As String {This will contain the SQL Statement} person = "select people.department from people where people.name='" & CustomerName.Value & "'" Set...
  4. G

    Deriving data from another query

    Hello everybody, I'm an Access novice, so maybe my questions will be a bit foolish... I have a query that says: SELECT people.name FROM people WHERE people.ID=[TheID]![ID]; And I have a query called TheID which has a field named "ID". But alas! When I run the first query, Access (2003 btw)...
Back
Top Bottom