Recent content by reach_dev

  1. R

    General Report/VBA Query

    I have done all I needed to do now... I had two fields in my database > UnitPrice and UnitPriceAmmended. UnitPriceAmmended would be -1 by default (indicating it isnt used). However, if at some point the user opted to override the generated unitprice, then the ammended price would be given this...
  2. R

    General Report/VBA Query

    Hi, I've starting developing some reports, which require some code behind them to achieve what I want. I've had a look around google and read some posts on these forums. Rather than asking specifically for an answer for my problem I was wondering if anyone had any good resources to general...
  3. R

    How to conditionally print subreports

    General Report Coding - oops, new thread. Not reply!
  4. R

    onMouseOver equivalent for VBA

    Just googled and found this; Ive not tested it, and it looks more like VB5/6 than VBA but it might help you out. Private Type POINT_TYPE X As Long Y As Long End Type Private Declare Function GetCursorPos Lib "user32.dll" _ (xyPoint As POINT_TYPE) As Long Private Sub...
  5. R

    onMouseOver equivalent for VBA

    I believe what was meant with the Form's onMouseMove is that it'll be triggered as the cursor travels off the command button onto the form, so you can put the code that would be in onMouseOut into the form's code for onMouseMove.
  6. R

    Strange bug with creating recordset

    Think I just fixed this problem. Im not entirely sure how, I just messed around and something worked. I give it 10mins before the throws its toys out of the pram again.
  7. R

    Strange bug with creating recordset

    Hi, I'm developing an access solution and i've got a really, really annoying bug with one aspect of it. This part of the application displays a list of Pending Orders in a multicolumn listbox, populated by a query. The user selects one of these orders and clicking 'Edit' to Add or Remove items...
  8. R

    Passing a variable to a query

    Cheers mate, thats veery helpful. Just got taken off my access project to work on my predecessors ASP CMS. Its so longwinded! Arg!:eek:
  9. R

    Passing a variable to a query

    Hi, I am developing an access solution, not having used VBA for 7 years. Thrown in at the deep end some might say. My problem is thus; I am going to need to generate reports, based upon user input (OrderID). However, this order ID is not provided by a user, in the form of a text box but is...
See more
Back
Top Bottom