Search results for query: *

lachesis You should be able to enter 1 in the 'Default Value' Tom

Hunnicutt I believe you are saying you want to save the DLookUp field. Normally you don't need to, as it is already saved somwhere, otherwise your DLookUp wouldn't find it. If you really need to save it, use a macro in the 'AfterUpdate' of your combo box. Use a 'Set Value' function. Keep in...

hermanlaksko My master and child fields are linked by the InventoryID fields. SBendBuckeye My form is for doing inventory at a parts store. With the form and subform I have now, the user enters the 'Date' and 'EmployeeNo' on the MainForm, then an autonumber is asigned to the 'StockTakeID'...

In the 'after update' property of your subform field, you could fire a macro using the 'Set Value' function. In the 'Item' line enter where you want the value to go. [Forms]![FormName]![SubFormName].[Form]![SubFormFieldName] In the 'Expression' enter what value to use...

Hi I have a Form, 'StockTake' It has 3 fields, 'Date' , 'Employee' and 'StockTakeID' (when a stock take is done it is to tell us when and by whom) Imbeded on the Form is a Sub Form, 'StockTakeSub' The Sub Form is set to 'Data Sheet' It has several Rows to show the stock data. ('StockNo'...

Hi I want the computor to answer an incoming connection after four rings. Right now it answers after two. How do I change this setting?

Mairtin You have came across one of Access's few pitfalls. I am going to guess that your PC screen setting is 800 by 600 and your lap top is 1024 by 768 pixels. There are some programs out there that claim to change your form sizes to fit what ever size screen setting. eg; Shrinker Stretcher...

Hi I have users enter all uppercase text, which overfills the text boxes. I want the force the textbox to display lowercase text with the first letter of each word uppercase. Thanks Tom

Thanks a bunch guys! The active x progress bar was giving me odd errors. It would work and then it would stop. In order to change the time interval I had to delete the progress bar and add another one, then enter the new time. For my application the rectangle idea of oharab's worked just...

Madjock Thanks for the reply. I am running access 2k and would greatly appreciate any help. Also I made a typo. The splash stays open for two seconds, not minutes. I just want the progress meter to look as though it is opening something. Tom

I have a splash form that opens for two minutes when my database opens. I want a progress bar on the form to be zero when the forms opens and fill to be full when the splash form closes. I have put an active x progress bar on the form but I have no idea how to make it work...

I have an idea that would make my lists easier to read. If line 1 had a white background and line 2 had a yellow background and line 3 had a white background again line 4 yellow again, and so on...

Hi If certain text boxes are left blank on my form, I want a msg box to alert the user. If the user clicks vbRetry, on the msg box, they will be taken back to the empty text box. (I have this part working.) What I can't get to work is this part; If the user clicks vbCancel, on the msg box...