Search results

What makes up a robust Error Handler? To those experienced: what would make up a robust Error Handler, or a method for robust error handling? Example, MS Access wizards generate: On Error GoTo Err_Event (VB Code here) Exit_Event: Exit Sub Err_Event: MsgBox Err.Description Resume...

How to Open a Webpage automatically without using WebBrowser Control in Access? I want to open a webpage in the original browser automatically. The problem i have is the automation- if i didn't need it, i would just create a command button or such to manually open the webpage in Internet...

I have a situation where Users have multiple e-mail accounts and different ones are to be used for different auto-emails. The object model for Outlook does not have the "From" as available for modification. Can i modify this field; and if so, how? Thank you! Llyal

I get #Name? when assigning Public variable to Control Source of unbound Textfield of Report I am new to Access reports My code: Report Open() Public PubstrTest PubstrTest = "TEST" End Sub In Control Source of unbound Textfield i put PubstrTest. When i open Report i get #Name? in Textfield...

New at making reports, having problems. I get the "#Error" in Preview and Print when i do simple formatting to report fields. Example, I have a report field associated with a date/time field in a table (with a typical date 3/06/2000); I get the "#Error" when i put this code in the report...

How to Get Rid of Quotes When Writing to TXT File I am making a routine in Access that will automatically generate a custom HTML page. I find that writing strings to the TXT file generate quotes (as if i am creating a delimited file). How do i manipulate things so that only what i send to the...

I found how to test for a specific database object (which is a good idea since i have a DB with hundreds of objects!); basically, you try to access the object and then trap the error generated when the object does not exist, then act open the error. My sample code is as follows for a temp table...

Go to Microsoft Main site and do keyword search for TREEVIEW; there are a handful examples in their knowledgebase (good enough to get started) Llyal

How to determine if a database object exists before creating, deleting, or modifying What VBA code is used to check to see if a database object (table, etc) exists or not before creating, deleting, or modifying object with VBA code? In this situation i am dealing with Access97. Thank you! Llyal

Is the VB code qritten in Access compiled? is it P-Code? Curious. Llyal

Change form recordset remotely from another form problem I want to change the recordset on a form remotely from another form and would like to do this in DAO. How do i do it? I am not familiar with what is involved with DAO in Access- the following code does not work. I get an 'item not found...

Problem: I cannot modify a forms's Recordset and Bookmark properties remotely from another form. Overview: I have a main form used to enter and display data. User wants search to be done many different ways, preventing me from putting the search on the main form because there is not enough...