Search results

Hello: Have you established your relationship link between your two tables. This needs to done to keep your Primary key and Foreign key assignments synchronized. Regards Mark

Hello: You can hide the tables. Just preface the name with Usys

Hello You need to use the SetWarnings statement to do this: Regards Mark You can use this action to prevent modal warnings and message boxes from stopping the macro. However, error messages are always displayed. Also, Microsoft Access displays any dialog boxes that require input other than...

Yes Date()-60 will give a date that is 60 days from now Regards Mark

Yes. Put your report in design mode and change the particular text box control's border property. Regards

Hello I've noticed that many folks seek the syntax for common date and time transaction. I have compiled a database of the most common requests. This may ease the burdon somewhat. Your comments would be appreciated. Regards and good coding. Mark

Hello: Please post what you have so far, so we may help you further. Regards

Hello: Procedure: Drop a single label on your form. Then, Copy the label Then click on your text box that has no label Then select paste from the menu The label now should be attached Regards Mark

Hello: You need use a variable to represent the form. Dim x as Form Then you can refer to that in your code such as: msgbox x.Name Regards Mark

Hello: You would reference a Label caption in the following fashion: LabelName.Caption = You would use the Controls Collection to seek out just the labels. An Example of this is in the Access Help. Regards Mark

Amen Moniker and ditto. This forum should not be utilized as an avenue for home-work assignments PERIOD! Regards Mark

Hello: I agree with KernelK, this looks like a home-work assignment. Regards Mark

Hello: Take a look at Candace Tripp's site below. She has an excellent example of how to do this. http://www.candace-tripp.com/pages/access_downloads.aspx Regards Mark

Hello: Your welcome and good luck with this. Mark

Hello: Enclosed is an example. Enter a date later than today and notice the message. Regards Mark

Here you go..... http://support.microsoft.com/kb/304463/en-us Regards Mark

Hello: Make sure in your table design that the Format Section is set to "Short Time" Regards Mark

Hello: In your table design place, 00/00/0000 for the Input Mask, and dd/mm/yyyy for the Format section. Then try to enter your data Regards Mark

Hello: As far as I know, you can hide the database window within Access but not the Access window itself. Regards Mark

Hello: If the form is too large it should have scroll bars on the bottom and side of the form to allow you to see the entire form. However, design-wise, should construct your form so that it fits all within the Access window. If you have a lot of controls you can save a lot of form real estate...