Search results

Continuous form displays a set of record. Sometimes, list shrinks to empty based on the user action. So when a user closes the form, "No current record" message is displayed. How to stop this message from appearing?

Hi, I had unchecked all the options in Tools --> Start up dialog. In that screen I could not save Menu Bar to blank, when I come next time it displays (default). I am still getting menu (With file, edit, insert, records, window, help) while opening the application. How to remove this...

Hi I have date and time value together. Want to merge it and store it in the database. Please let me know how to handle this. Thanks in advance.

I want to make my form in such a way that always the current working control should stay on top of the form. Can the form scroll in round. so current control can stay in the top (even if its the last control in the form). Can this be done. Please throw any information that you have related...

Hi, Can I use Frame in Access Form like in Visual C++? So I can have group of related controls within a frame. will be easier for me to enable or disable, just by saying frame1.enable = true / false. If there is no standard control, is there is any custom control / ActiveX control so I can...

I want to display my form to the full windows, I want to avoid horizonal & vertical scroll bars if possible. So Whats is the normal form size to use? Is it Width = 6.5 " Heigt = 4.5 " ??? I want to fix this size standards on all the forms from the beginning to avoid scroll bars (as the users...

Can I specify a column to store only the date value, is there any formatting option, so I can say like col1 datetime format ('mm/dd/yyyy') Can I specify Validation rule and text in SQL Server like in Access. So that way I can keep all the validation texts stored right in DB not in Form...

Hi, I want to display MyForm by Pointing to the New Record. How to create a new record and point to that while opening a form. Is there any straighforward way to specify that while opening a form. MyForm should work in 2 modes, which is "Add" / "Edit". Edit is quite straightforward I specify...

Hi, 1. Can I enable a field based on other input field's enabling status. Right now, I am doing it in the respective after_update event. Is there any other efficient way to do this? 2. Also, can a date field accept the format 10302001, but access gives error for this. But the requirement is...

Hi, I am just wondering how to change the color of a particular days in a month in ActiveX calendar control. Actually I am using ActiveX control for scheduling, and I want the available days in a different color. Any ideas about how to do it? Please throw any information that you have related to...