Recent content by DW

Hope this helps, I've attached as a txt file, it might be out of date but should get you started. I'm interested in what you're working on, May I ask ??

Have you tried a DLookup Private Sub Form_Load() DoCmd.OpenForm ("Products") DoCmd.Minimize Me![HelpFigure2] = DLookup("HelpFigure1","tblSomething","HelpFigure1=" & me![HelpFigure2] End Sub You'll have to check the syntax, but get that right and it should do the trick. Dave

Perhaps you can strip some idea's from my code below. It works for me. Regards DW Private Sub Command0_Click() Dim strWhere As String Dim strSQL As String strWhere = "EstimateNo = Forms!frmDetails!EstimateNo And Supp = Forms!frmDetails!Supp" If IsNull(DLookup("EstimateNo", "tblDates"...

Firstly I would check the references on each pc and make sure they all are registered the same. I would check to see which version of MDAC you're running. I recently had a similar problem running MDAC 2.1 vs 2.5, causing certain forms to not load. Hope this gets you started Dave

Not quite what I was after. On the main form you see 3 unbound texts. Paint Body Fit The paint text is straight forward as paint is always the total of Paint. The other two texts are the problem. Body needs to show the total of New+Rep if unitid=B Fit needs to show the total of New+R-R if...

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

As far as I know, no you can't. What you can do is to make the button transparrent and overlay it with a label. Go to the format menu and bring the button to the front. You can do anything you want with the label then. Dave

Check references in any module. If one says MISSING, uncheck it. That should sort your problem. Dave

I think whats happening is when the first line of code is fired. it closes the form of your choice and the rest of the code doesn't fire. Try re-entering your code the other way around. Open the form of choice, then close the other form after. Have a look at the attachment. you shouldn't...

You could pick one of your fields as a focus point and do the following in the forms current event:- If Me.YourField = "" then Me.YourButtonControl.Enabled = False There are may ways to do this If IsNull (yourFieldName) then me.YourButtonControl.Enabled = False Dave

This is by far the better way to store images. Holding one pic as an OLE or standard background pic is ok but, if you're going to save numerous pics, the database will increase in size enourmously. With the sample, it stores only the file name and path, so not bloating the db. Have fun Dave

I use this in my forms. Private Sub Form_Load() DoCmd.Close acForm, "frmsidemenu", acSaveYes DoCmd.Close acForm, "frmpolicydetailsmenu", acSaveYes End Sub It works for me. Perhaps if you attach a demo, we can help you. Only two of your forms are needed Dave

I had this problem ages ago and couldn't find out why. It suddenly went away one day for whatever reason, I'll never know. This happened (I think)when two users edited the same record at the same time, so some-where I had a record locked. Do a search on each users machine to see if their is...

Here's a sample for you to play with. Dave

Well done if you've sorted it, but see attachment, it should do what you want. One thought though. Your fields contains data like:- Tin,Plastic Wood,Metal I would really look to change this for fear of causing problems later on. I feel one item for each field is better. Tin Plastic Wood...