Search results

I have the field in a table set to hyperlink...but it doesn't default to email...it defaults to a web page. I need to know if there is a way to set the property to default to an email instead.

The field is a data entry field, so how do I handle future data entry?

Does anyone know how to make a field default to an email address rather than a hyperlink to a web page? I don't want the user to have to physically go to the edit hyperlink everytime they enter an email address. Thanks, Tiffini

I don't want to hide the database window...just minimize it upon startup by default. Thanks, Tiffini

I would like the database window (i.e. tables, forms, reports, queries) minimized (not hidden). I have a switchboard that appears upon startup, and I just want the database to be minimized so that the users can still get to it without having to remember to hold down the shift key, but I don't...

Is there a way to have the database window minimized at startup? Thanks, Tiffini

Any help would be greatly appreciated

In the form, there is a combo box that you choose a contact from and it pulls up related info about that contact in the other fields. I want to use the same form for the user to input a New contact, and their info from an Add Record command button. The user is able to edit the contact info in...

Initialy I tried Forms!FormName.Requery at the end of the code, right before End Sub - with no success. I just tried Me.Requery, and still no luck. The other fields in the form still hang on to values from another record. Looks like this: Err_ErrorHandler: ' display error message and...

:confused: I am using the code from FAQ "Adding New Entries to Table From a Combobox (ADO)" in my combo box which works fine. However, the choice from the combobox finds a record for the rest of the form, and when a new record is added...it doesn't requery the entire form. What code do I need...

Actually, the error didn't take me to the debugger. I figured it out...and it seems to be working fine. This time...it was my own error, bad typing! Thanks for all of your help!!!! Tiffini

That definately helped...but now at the end...I get an error #3625 : Item cannot be found in the collection corresponding to the requested name or ordinal. Any suggestions? I've tried some things with now luck! Thanks, Tiffini

Well, I am much, much closer...however now I get an error at the very end. Error #13, Type mismatch... Private Sub Combo32_NotInList(NewData As String, Response As Integer) On Error GoTo Err_ErrorHandler ' provide text constants to reduce text later and allow for faster...

The SQL statement returned an error of missing syntax...so I put the brackets back in...I am getting an error of User-defined type not defined. So...I think it has something to do with 2000....but I can't figure out what to change in the code.?????

Thanks Andy! I wondered if the names of my tables were giving me problems as well?! I do remember the rules from VB, but I wasn't thinking about it when I started creating the database...next time, I'll know better! What about the "Not In List" code in regards to Access 2000? Should...

The Row Source Type is set to Table/Query, and the Row Source has the SQL statement: SELECT [Contact Info].[ID], [Contact Info].[Contact Name], [Contact Info].[Legal Name] FROM [Contact Info] ORDER BY [Contact Info].[Contact Name]; I don't know what I am missing. Maybe I need to add...

:confused: and :mad: OK! So I tried to use a command button to add a new entry to my Form A, but I have a combo box in the form, so I knew that I would have to add some code to be able to enter a new entry into the combo box. I used the code from "[FAQ] Adding New Entries to Table From a...

Thanks Wayne!!!!

Well...I am a newbie first off, so I am sure that there are several "better" ways to design the database. However, that was the only way I could figure out how to View and Edit records on one Form and Add new entries from the another form.

I have a problem with two forms I created and I hope that someone can help me solve it. On Form A there is a command button that opens Form B where data is entered. After Form B is closed, Form A needs to be requeried to show the new values. What code do I need to use, and where do I need to...