Recent content by ColeChaW

Working well going through the tables but when it hits one of the ODBC tables that I'm trying to link to an Access database, it opens a dialog box that asks me to select Data Source to use. I'm stumped.:(

I'm trying to change linked tables from pointing to a SQL server database to pointing to a local copy when offline. I cannot figure out how to change the tabledef.attributes tag. I need to switch it between dbAttachedODBC and dbAttachedTable, I think. :confused: For Each TBDef In...

I'm trying to print 2 copies of a Word document, collated, with the following code: WordApp.ActiveDocument.PrintOut , , , , , , , 2, , , , True And I've tried WordApp.ActiveDocument.PrintOut Copies:=2, Collate:=True I'll get my two copies, but they will not collate. :confused: Any ideas?

Table structure tblMission MissionID (autonumber) ...otherstuff... tblEvent EventID (autonumber) EventName (text) EventDescription (text) tblEventDateTime MissionID (number) EventID (number) DateTime (datetime)

Hello again everyone! My head's swimming right now so the solution to this problem may be right under my nose and I'm just blind to it. I have a table with events, represented by an ID number, and the date/time the events occured. Each event is also attatched to a particular mission number...

Based on your experience, what is the faster, easier way to send e-mail in the background of an Access application, connecting to MS Outlook or using a CDO connection to the exchange server? :confused: I'm not really looking forward to switching to the exchange server and bringing our IT Dept...

Paul, thank you so much. That is exactly what I need. Thanks for the help, I was lost searching for what I needed and not knowing the proper terms for it. =)

I have a table of people connected to a table of phone numbers. Each person can have multiple phone numbers in the phone table, but each number is connected to only one person. This is done by tagging each phone entry with the primary key of the person who owns it. I'm not sure the proper...

I am using the following: Excel.Application.WorksheetFunction.Acos() In order to find the ArcCosine of an equation. For some reason, it will work the first few times and then throw Runtime Error 1004, explaining that it: Unable to get the Acos property of the WorksheetFunction class Not...

Thanks. I'll keep on using the Access forms where I can get away with it. :D

txtYourTextBox = DMax("YourNumber", "YourTable") + 1 This would work best in a 'Save' button command. The DMax will look up the highest value in the "YourNumber" field of "YourTable", then the code adds 1 to this number and sets it in the txtYourTextBox textbox. To lock the textbox, set it's...

Just wondering on the best practice for linking an Access form to the Access tables. There is the default link access creates directly to the tables in the database. To get at information you can also set up a DAO or ADO recordset and save the data to variables. The second method seems...

Click in the 'On Click' field. Click the button to the right with the 3 dots. Select 'Code Builder.' This will open the code builder and you will find something to this effect: Private MaintDate_OnClick() End Sub Put the code between these lines to read: Private MaintDate_OnClick()...

Public ie as InternetExplorer Private Sub cmdButton_Click() Set ie = CreateObject("InternetExplorer.Application") ie.Navigate "http://visualbasic.about.com" End Sub Using ie.Navigate2 in this code will open the website in a new IE window. If you are trying to open the website on one of...

Thank you again. This is what I have settled on using, and for now it seems to work well: strHTML = Me.Browser1.Document.documentElement.innerHTML Of course this only works with a website that is displayed in a browser control on one of my forms, but that is entirely workable. Thanks for the...