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 =...
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
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...
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
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
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...
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...
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