Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 19 of 816

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Compile error: User-defined type not defined I have a database which compiles. I removed a number of forms, queries, macros, modules and tables from it. When I try to compile the "boiled-down"... ManningFan	11-03-2010 01:50 PM Tony Toews	2	3
Referring to control on a subform within a subform I have a subform whose SourceObject is set depending on the subform the user wants to see. One of the subforms has a subform within it. I'm trying... emanning	11-03-2010 10:53 AM emanning	2	3
Simple Query - I need to select the value from one column I have been away from this for a long time and seem to have forgotten much of which I learned. This syntax will always only ever return one record... colin spalding	11-03-2010 10:30 AM John Spencer	2	3
OpenCurrentDatabase using UNC for pathname I'm using the following code in Access 2002 to open a report in an external db. Dim objAccess As Access.Application Set objAccess = New... Bob Darlington	11-02-2010 06:32 PM Bob Darlington	7	8
Subform width after anchor stretch across I have a form with a subform. I want to find the width of the subform control after it's opened and stretched across using the 2007 anchoring tool.... christianlott1@yahoo.com	11-01-2010 05:47 PM Marshall Barton	1	2
Copy Files with long file names ( 1 2 3 ) Salad <salad (AT) oilandvinegar (DOT) com> wrote in news:Hqqdnbxa6fd3I1XRnZ2dnUVZ_qudnZ2d (AT) earthlink (DOT) com: With Office files, that already... bala	11-01-2010 05:42 PM Marshall Barton	29	30
context menu will not close Hello All I was on the phone and my little terror started slapping my keyboard....now the right click context menu is on permanently and despite... flymo	11-01-2010 03:16 PM flymo	2	3
Experience using ISAMStats or other utility to understand data readsduring application The link below tells about an undocumented feature of Access, called ISAMStats. It can tell disk read and write data from... Bob Alston	11-01-2010 02:15 PM Bob Alston	0	1
Right Click in runtime ( 1 2 ) I am experimenting with Access 2010 Runtime. Does anyone know how to get the right click menu to work? paii, Ron	11-01-2010 09:59 AM paii, Ron	12	13
Setting a range Bear with me, this is complicated. I have a form called DBUsableObjects that lists pretty well all the tables, queries, forms & reports in the... Phil	10-31-2010 09:53 AM Phil	4	5
SQL Join on same Table Will be grateful for any help I want to show a 3 column table of Manufacturers - ID Manufacturer ParentName When the Manufacturer has a... Ken Ashton	10-31-2010 07:03 AM Ken Ashton	2	3
how to programmatically get list of SQL server drivers installed I would like to programmatically get a list of the SQL server drivers installed. This is needed for re-linking tables. If there is only one, I... KW	10-30-2010 09:29 AM KW	3	4
Option group filter I am trying to filter a subform with an option group I have on the mainform (yes, I know a combobox is better, but this is to help people who have... WhathaveIdone?	10-29-2010 11:07 AM WhathaveIdone?	2	3
math problem converting currencies Hi All, I have a db table containing spot-rates for different currencies. They all lead back to the euro. For example 0,125. 100 EGP -> EURO = 100 *... Co	10-28-2010 01:12 PM John Spencer	1	2
Re: The Auto FE Updatrer will no longer be free ( 1 2 3 ) On Tue, 26 Oct 2010 23:32:18 -0700 (PDT), The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote: Several things have been implemented or will... Wayne	10-27-2010 04:35 PM David-W-Fenton	25	26
populate now() on click I've been trying to get a field (filter_start) on a form to populate the current date & time when that field is clicked on. I went under form design,... Joe Smith	10-27-2010 02:04 PM Joe Smith	7	8
Toggle Button VBA code on Subform I have a Toggle Button on a form and it is to return those agencies that are located within a particular county and that deal with a particular... zufie	10-27-2010 12:58 PM Salad	1	2
Concatenating Cross Tab Queries Is there any way of concatenating the columns in a crosstab query, so you can remove blank entries and add the contents into one column entry, sort... bezz	10-26-2010 07:16 PM Salad	5	6
A2K Error 3011 on TransferSpreadsheet method Hello all, I'm jut trying to import a spreadsheet into a table in Access 2000. The spreadsheet is called cc-ledgcodebalances.xls with no field... buckskin	10-26-2010 10:12 AM buckskin	2	3
Experienced IT Hardware/Software Sales Executive Required Immediately (London) Hi All, We are looking for self motivated, reliable and resourceful individual to join our Company run IT buisness provide a broad range of... Sky Walker	10-26-2010 06:23 AM Sky Walker	0	1
Printing to Custom Size Paper ( 1 2 ) I've already explored this through a different 'Subject' line, and received some helpful replies, but unfortunately I still can't get it to... Bob Darlington	10-25-2010 07:38 PM Bob Darlington	18	19
Sub reports I have a main report with a subreport on it Occasionally the main report has no data whilest the sub report does have data. I want to supress the... Phil	10-25-2010 06:46 PM Phil	4	5
Runtime module ( 1 2 ) Access 2003 + 2010 Hi NG I am developing small apps in Access... I got the Access Runtime module. I use it for distribute my apps... The problem... bsn	10-25-2010 12:18 PM bsn	11	12
Help with query I have 2 tables Table 1 contains all customer information including custVisitID Table 2 contains 2 fields (custVisitID, Coupon) I need to create... steve1040	10-25-2010 11:36 AM Salad	2	3
Select a particular tab/subform in A2010 Navigation control with VBA Hi all, Maybe I'm being dense, but having designed an interface which uses the Access 2010 Navigation Control, I cannot find a way through VBA... andrewmrichards	10-23-2010 11:43 AM andrewmrichards	3	4
Date format for a mail merge I have setup and linked an Access query and a Word document. In Access I have formated using Medium Date format 23-Oct-10 but after importing I get... Duncan	10-23-2010 09:00 AM Duncan	2	3
Calculating an upcoming date I am a novice Access user! I am creating a Access 2003 database and I am stuck currently on one of many issues. I have a Date field and I have a... BamaBlast	10-23-2010 07:50 AM NoodNutt	6	7
Capture all text on a HTML page Is there a way I could have Microsoft Access automatically pick up all text on an HTML page from a hyperlink? Thanks, Laura musicloverlch	10-22-2010 04:24 PM musicloverlch	2	3
Link to table of different name I have a (linked) table called 'Deliveries' linked to a table of that name in the back-end. I now want to create a new link to another table named... Jim Devenish	10-22-2010 07:41 AM Jim Devenish	1	2
Module Collection I want to include a single new line of code in the Activate event in each form in my application (180 forms). Rather than open each manually, I was... Bob Darlington	10-22-2010 12:37 AM Bob Darlington	4	5
Access 2010 for software development ( 1 2 3 4 5 ... Last Page) Sounds like good old days of comp.databases.ms-access is back - which is very pleasing. Thanks Guys PW	10-21-2010 10:03 PM Tony Toews	77	78
sql server permissions on a field ( 1 2 3 ) I'm using sql server 2005 with windows authentication and I have a table tblEmployee now I want to add a field called homeAddress varchar(200), but I... Roger	10-21-2010 09:40 PM Tony Toews	21	22
Specific order to install Access 2003 and 2007 (2010 for that matter) with Windows 7? ( 1 2 3 ) Hi, My wife just got a new Windows 7 laptop. We need Access 2003 on it. She also wants Office 2007 installed in addition to Office 2003. When I... PW	10-21-2010 07:17 PM David-W-Fenton	20	21
Outlook Inbox via ODBC Hi All! I need to connect an Outlook Inbox to Access. I've done it via ODBC and when it is connected that way the "From" field has a proper name in... musicloverlch	10-21-2010 05:55 PM musicloverlch	0	1
Albert Kallal's Outlook-Style Calendar Is anyone familiar with how Albert Kallal created his outlook-style calendar for the web (http://www.youtube.com/watch?v=AU4mH0jPntI)? He stated... Vincent	10-21-2010 02:24 PM Albert D. Kallal	2	3
How to work locally on a Citrix server client terminal Dear reader, Is there some one who knows how you can work in a Citrix server configuration with client terminals (no pc's). To use the client... Simon van Beek	10-21-2010 01:59 AM Tony Toews	2	3
Form_Resize: Getting Undesired White Space At Bottom Of Form Here's a mini-db that contains the form: http://tinyurl.com/24ytz5u Access 2003. File goes "Poof" on 10/27/2010. Problem is that when Form_Resize... (PeteCresswell)	10-20-2010 01:37 PM Clif McIrvin	1	2
Expression in numerical fields Hi Access 2007 I have 2 fixed numerical fields that I used in an expresssion to add together: =txtPostage1_IncVAT + txtBuyerItemCost_IncVAT 9.40 +... bobdydd	10-20-2010 11:48 AM croy	4	5
Opinion: The 8 biggest Business Intelligence developments of 2010 (Part 1) 1. Mobile BI Mobile BI refers to the capability of an organization to deliver relevant and timely data to anyone, whenever they need it,... JTP PR	10-20-2010 07:09 AM JTP PR	0	1
send email using Outlook opens new session each time I send an email Dear All, Office 2010 Access 2010 but still using an mdb-file for the moment. Outlook is running an minimized and should stay active !!! Each time... Filips Benoit	10-20-2010 06:14 AM Filips Benoit	5	6
Change font for report control using VBA and MDE Using A2000. Is there a way to change the font for a report control using VBA and and MDE? One of the controls on the report prints a Micr line and... Karl	10-20-2010 12:01 AM Marshall Barton	2	3
SELECT DISTINCTROW query showing double names ( 1 2 ) Hi All, I have two tables, one with person records (Tabel_Aanvragen) and one with orders (VISA). I want to show all fields from Tabel_Aanvragen and... Co	10-19-2010 05:11 PM Bob Barrows	11	12
Access 2010 creates several copies of the database Dear All, Since we upgrate to office 2010 using access-databases bij Remote Desktop creates copies of the database named as 'database, database1,... Filips Benoit	10-19-2010 03:00 PM Filips Benoit	2	3
set focus to controle on subform Dear All, Access 2010 I (want to) do these actions: 1. Find the item I want to add in a Combobox. 2. Click the cmdbutton that adds a the choosen... Filips Benoit	10-19-2010 02:27 PM Filips Benoit	0	1
Establish When Multiple Fields Are True/False -1/0 Yes/No From A Query I have a table which has multiple flags set for various eventand can be true or false. The table is constructed along the lines of FieldName ... bezz	10-18-2010 06:49 PM Bob Barrows	1	2
Delete Label of TextBoxes in Access 2007 REPORT Hi - I have a report and I want to delete some of the labels of the Fields (textboxes) on the report. I can only seem to be able to delete... sea	10-18-2010 06:39 PM sea	9	10
subqueries Ok – subqueries consistently kick my a**. Any help would be much appreciated. I have a table tblEvents with: EventID – autonumber ID... Tom	10-18-2010 01:36 PM Tom	3	4
Setting Application.Printer.PaperSize ( 1 2 ) I'm trying to set a report (cheques) to print on a printer which is not the default printer using the following code. My intention is to include in... Bob Darlington	10-18-2010 02:54 AM Bob Darlington	19	20
Inserting multiple rows via SQL query ( 1 2 ) Hi, I hope at least one of these newsgroups are still active. :) I'm trying to construct am MS Access (2007) query to insert multiple rows in a... MikeB	10-18-2010 02:22 AM The Frog	11	12
INSERT sql problem ! I have a form and want to append 3 values into another table using the following but can't seem to get the right syntax. Could someone please help... Prakash	10-17-2010 03:35 PM Bob Quintal	6	7

Page 19 of 816

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off