Search results

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?

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

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

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

I'm playing around with the idea of reading values we enter into a web page form and inserting them into my little Access program to save us from typing data that's already entered. I cannot link to the tables the web form uses directly because our IS dept. will not allow it. I do think that...

Hello again, as I learn more I have more and more questions. I'm sure this is an easy syntax problem, but I cannot find an example that shows how to code what I'm trying to do. My old form had the values 'crew1', 'crew2', 'crew3', ect. that populated the combo boxes cboCrew1, cboCrew2, ect...

I'm still new to VBA, so it wan't until a week or so ago that I implemented error catching in my code. As a general rule, I understand that programmers should attempt to first prevent and then catch errors. I would like your opinion on whether an 'on error goto' statement should be a part of...

I've been stomping around in the forums for an hour now and I have to ask for some help because I really don't know what it is I am looking for. I am interested to know if there is a way to write VBA code that reopens my menu form if all other forms have been closed. The database window is...

How may rows can a DB handle before it becomes inefficient? Some of the software I work with record Latitude and Longitude for aircraft every 30 seconds. I was wondering one day if this table should eventually be split into multiple tables or if having literally millions of rows is no problem...

I'm trying to run an SQL statement to Sum the values of a table column. No problem. It would be useful for me to take that total and be able to set it equal to a variable within my VB code that's running, I just don't know how to do that, I'm very new to VB programming. I cannot find help...