Search results

Create a macro called "AutoKeys" without the quotes. In Design do the following. Macro Name {F1} Action CancelEvent So forth and So forth, but I agree the previous method works more efficiently. Dave

If the other button is default Enabled =false, you won't make it gain the focus. You must enable that button first and then set the focus. Dave

You first list box will show all the descriptions, seeing as all fields are singular, you can group them soif you have 3 Armaghans, it will only show up once, but the list to the right, will show two, White & Beige. Heres an example attached.

When you press the max or min, you are resetting the Control. Try Putting two buttons on your form. In the properties for each, create an event procedure Button1 On_Click DoCmd.Maximise Button2 On_Click DoCmd.Minimise I use key events with mine If keycode = VbKeyF7 then DoCmdMaximise...

How is your form designed. You perhaps need to look at creating the main form from "Members" with an Autonumber field called [ID] then create a Subform from the table "response". In the Response create a field called [ID] and set the property to numeric long. With the main form in design...

If you have two types of Armaghan you should set your table out as follows. [Item] Armaghan [Colour] Beige [Size] 6x4 [Location] Shelf 3 With your table set out with single text descriptions, your can use three or four list box,s side by side. The first will contain Armaghan or whatever...

I use this in my db and don't have any problems with it. =nz([txtnew])+nz([txtRR])+nz([txtRepair])+nz([txtPaint]) Questions. I presume your texts are numeric. Do they have any default values ? Are they Null, as in blank or do they have a zero in them. Dave

In the datasheet design view, create a button which takes you thru the wizard to open another form. Follow this and the wizard will ask if you want specific data to display on opening the form. Select yes and another box will popup asking which fields to tie the two forms together. Make your...

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

It looks like the report is looking for some-thing that is not on the report. Check the control source of the report to see if the data you want is actually there or not. e.g Lets say the reports control source is a query. This query has 3 fields [1] [2] =Sum[1]+[2] if the field [1] is...

Sorry it didn't work, Ive never used a time-out function. Perhaps one of the more experienced members can help. Regards Dave

I may be wrong but I thought Access records seconds as hundredth's. So if 6000 = sixty seconds, try adding a couple of noughts 600000 Try and see. Dave

My code is throwing an error on the following. Private Sub lstPreviewJpgs_AfterUpdate() Me.[PreviewOLE].Picture = "jpegFolderPath" & Me!lstPreviewJpgs End Sub Run-Time error 438 Oject doesn't support this property or method. ?? Any Idea's Dave

This looks like it could do the trick. I'll let you know if I have any probs. Thanks Dave

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

I use this with my combo's Private Sub EnquiryCode_GotFocus() If IsNull([EnquiryCode]) Then [EnquiryCode].Dropdown End If End Sub EnquiryCode is the name of the combo. What happens is when the cursor lands in the combo, it drops down if their is nothing selected. When the user...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q210590 Don't know if this helps but may head you in the right direction Dave

try this format. dd/mmm/yy hh:mm Dave

Thanks for the links Adrianna. Some very useful stuff there. Dave

I think you have got the wrong end of the stick here. The application is a Microsoft Add In Wizard for A97. MDE or MDA whichever. Judging by your reply, You didn't know microsoft offer this free utility. I asked as many do, for help. Basically thats why this forum exists. Kindest Regards DW