Search results

Here are some examples of how to set the background color of a command button: http://www.peterssoftware.com/clrbtn.htm Hope this helps, Peter De Baets Peter's Software - MS Access Tools http://www.peterssoftware.com

Sometimes if I see a question that is very wordy or too vague, then I just skip it. I don't know if this was the problem with your posts (I only saw one of your posts, and it didn't seem wordy), but maybe you could try to be brief and as specific as possible. Hope this helps, Peter De Baets...

Do you mean "DAO reference(s)"? You can loop through the references collection to see which libraries are referenced... ex.: For Each ref In Application.References If ref.Name = "dao" Then References.Remove ref Exit For End If Next Hope this helps, Peter De Baets...

When you set Cancel = True from the BeforeUpdate event proc, that will cancel the update. So, I think you don't need the me.undo in there. Also, you may want to check the field for the empty string (""). I.e.: if isnull(mycontrol) or mycontrol = "" then ... Hope this helps, Peter De Baets...

Some examples of how to manipulate form, and Access window size and position are here: Window Manipulation Examples http://www.peterssoftware.com/winmanip.htm Hope this helps, Peter De Baets Peter's Software - MS Access tools http://www.peterssoftware.com

Some colored button examples are here: http://www.peterssoftware.com/clrbtn.htm Hope this helps, Peter De Baets Peter's Software - MS Access shareware and freeware http://www.peterssoftware.com

What kind of validation do you want to do? If you just want to validate that it's numeric, and has a certain number of characters, use the BeforeUpdate event proc. Hope this helps, Peter De Baets Peter's Software - MS Access Tools http://www.peterssoftware.com

To prompt the user for a folder to import from/export to: http://www.mvps.org/access/api/api0002.htm Regards, Peter De Baets Peter's Software - MS Access tools http://www.peterssoftware.com

Put a DoCmd.Maximize in the form OnOpen (or OnActivate) event proc. Hope this helps, Peter De Baets Peter's Software - MS Access tools for developers http://www.peterssoftware.com

Yes, I'll fix that in the next version, but the solution for now is to un-check the "confirm action queries" option. Regards, Peter De Baets http://www.peterssoftware.com

Here's another option: I've just created a free database that may help you out. It's called Compact A List, and with it you can backup, repair, and compact a list of Access database files. Here's the link: http://www.peterssoftware.com/cal.htm Regards, Peter De Baets Peter's Software - MS...

I've just created a free database that may help you out. It's called Compact A List, and with it you can backup, repair (Access 97 only), and compact a list of Access database files. Here's the link: http://www.peterssoftware.com/cal.htm Regards, Peter De Baets Peter's Software - MS Access...

Why not just bind your table to your form? Then you don't need all the coding behind the scenes. To do this, just create a new form, and follow the wizard. Or put a table name in your form recordsource, and drag and drop field names from the field list box. Hope this helps, Peter De Baets...

You can use the Left and Top properties to determine the position of a control. Ex. (from a command button on your form): msgbox "My control is at " & MyControl.top & ", " & MyControl.Left Hope this helps, Peter De Baets Peter's Software - MS Access shareware and freeware...

Yes, "#" is a reserved character. It is used to denote date fields, as in #3/23/01#. It's best to not use it in variable names. Hope this helps, Peter De Baets Peter's Software - MS Access shareware and freeware http://www.peterssoftware.com

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended). A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended). A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...

Well, I don't know if it's exactly what you're looking for, but I have an example of a maximized pop-up form, and it has no control buttons at all. It's part of my Window Manipulation Examples database here: http://www.peterssoftware.com/winmanip.htm The example is "Size pop-up form to exactly...

Try setting form property AutoResize = yes. That will size the window to fit the form. I think your width setting is too small. 2 pixels is not very much. Hope this helps, Peter De Baets Peter's Software - MS Access tools http://www.peterssoftware.com

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself (because of the complexity, this is not recommended). A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...