Search results

  1. V

    Using Sendkeys for a game

    I have a backgammon game (not a Microsoft product) which I am trying to send 'ALT F' to. I use the code below: SendKeys "%{TAB}", True ' ALT TAB to switch windows:) vkWait ' pause a short while:) SendKeys "%F", True ' ALT F:confused...
  2. V

    Hiding Menu Bar on Form Loading/Opening

    In form design, properties set Menu Bar=1 – this will stop the menu appearing…….is this what you meant….
  3. V

    Nth select

    Or Private Sub cmdWhatEver() Dim rst As Recordset Dim dbs As Database Dim intCounter As Integer Set dbs = CurrentDb dbs.Execute "UPDATE tbltablename SET chosen=False" Set rst = dbs.OpenRecordset("tbltablename", dbOpenDynaset) intCounter = 1 rst.MoveFirst While Not rst.EOF If intCounter = 5...
  4. V

    Difficulty Using Form with Checkboxes as Query Interface

    Could you show us the commands behind to cmdRunSoftwareQuery button? (One method I’ve used in the pass is that when the above button is clicked, a single temporary table is created containing all info [with no filering] i.e. all users with all apps. The query or report is then run against this...
  5. V

    Query/primary key

    Yes - it could be that the value already exists or that it cant be changed cos it is part of a relationship. Can put show the sql?
  6. V

    Reports and Date Ranges

    The approach will work – I would check the following: 1. make sure the dates in the base table have data types of date 2. start and end date in the form have are formatted as date 3. open the form, minimise it, open the report and run the query Its asking for parameter value cos sometime is...
  7. V

    Can a subform display the same as a mainform?

    On the on load event of the “another form” put: Private Sub Form_Load() Me.Filter = Forms!”main continuous form”.Filter If Forms!”main continuous form”.FilterOn = True Then Me.FilterOn = True End If End Sub Hope this gives you want you want.
  8. V

    Query/primary key

    Eh? Yes an update query will do this – more details required.
  9. V

    Updating Data Using Queries with table open

    Look at the refresh and requery command. Is this standalone over network, update query from a form ? Could you post the query. Thanks.
Top Bottom