Search results

  1. D

    Summing Totals

    Thats it , I'm at the end of my tether now. I've attached a demo of my problem if some-one can help me out. The 4 fields on the form to the left work ok, Summing each column correctly. The 3 fields to the right is where I am struggling. I need to do the following:- Add New & R-R if UnitId =...
  2. D

    Vehicle Database

    A long shot. Does any one have a complete list of vehicles supplied in the uk to import into my db [Manufacture] [Model] [Variant] [Year] As their are thousands of options, I thought I would try and see if some one has already got one instead of starting to populate my own table. In Hope Dave
  3. D

    Query Criteria

    I want to enter a condition in the criteria of a query. The condition is approx as follows:- =>#01/04 (of the current year) and =<#31/05 (of the current year) There is a reason for this, I want the query to be constant so I don,t have to re-design the query each year. Can some-one help with...
  4. D

    Populate Listbox With File Names

    I need to populate a list box with the contents of a directory. The path is as follows. L:\Home\???.jpg I understand the callback function will do this. I have had no experience using this function before, can some-one help with this. Dave
  5. D

    Wztreevw

    Would any one happen to have a version of this for A2000 or even a A97 mdb not mde so I can convert it my self. I would appreciate a copy if possible Dave@mmvehiclerepairs.co.uk Dave
  6. D

    Common Dialog

    Is it possible, or is their a common dialog with a preview facility. I'm designing a section of my db with an imaging module. Dave
  7. D

    Special queries

    I'm trying to achieve something I'm not quite sure can be done. I am working on part of my db which is a form with three fields. [Ref1]-number [Ref2]-number [OlePic]-OleObject. As you know, pictures bloat a db out of proportion, so here's what I've done to work around this. Created a form...
  8. D

    Imaging Code

    The following code is causing a problem in my db. On Error GoTo Errtrap DoCmd.GoToRecord acDataForm, "frmImage", acNewRec Forms!frmImage!EstimateNo = Forms!frmdetails!EstimateNo Forms!frmImage!Supp = Forms!frmdetails!Supp Me.cmdlgpicture.InitDir = "L:\home" Me.cmdlgpicture.Filter = " Image...
  9. D

    start Menu

    Is it possible to prevent Microsoft Access from showing in the Windows Start Bar. ie When opening a form, the start bar shows; Microsoft Access - [Whatever Form] dave
Top Bottom