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?

Thanks all of you ! I followed your suggestions, it works!

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 Pat, I think this is an old posting, however I ran into the same situation recently. Did you give Driver = Sybase in the connect string? Actually When I designed the access database I relinked to the databse thru ODBC. I am doing just this to refresh the link during the application...

Thanks Jack!

Thanks Jack, Actually I have date and time in separate fields, I want to merge and store it in the database.

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.

Thanks Ghudson, I want all the controls to work in round scroll, the user never have to scroll all the way down to see the current control. Atleast I want the control to be in the viewable area of the screen. I tried GotoControl but it does not work.. Thanks

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

Thanks Hi Soloprogrammer, Thanks for the information. After I resolved the SQL Server bit nulll problem, I am okay now ! Thanks a bunch !

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

Thanks a lot AutoEng!

Thanks Brad ! I am using docmd.maximize in the form open. Basically my form is little over the normal size and the user does not prefer scroll bar. I want to fix the form size (width and height) for the normal screen resolution. So then I can avoid the overlapping, chop off etc. Thanks

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

Great, it works. DoCmd.OpenForm "MyForm", , , , acFormAdd The problem was we were not inputing one of the required field, so the record was not created due to that. Thanks a lot for your help !

I tried, but its not generating a new record. Thanks !

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, Where I can find Character map, so I can copy and paste the superscript 1 , 2 , etc. Is it under windows directory or under programs menu ? Thanks in Advance

I am in the same boat now. Did any of you find a way to change the text box background color in the continuous forms. I could change the fore color with this logic. I want to change the background color explicitly depending on the text box content. Please throw any information regarding this...