Rating Thread / Thread Starter	Last Post	Replies	Views
Populate Listbox With FileNames How can I populate a listbox with a list of the filenames in a certain folder? Can a query retrieve the filenames from a folder? Thanks! Mark Mark	01-14-2004 08:23 AM Roger Carlson	5	42
How to create and reference a Workspace? I need to create and reference a Workspace (kinda new at this...) Here's how it works with the current db: Dim wrk As DAO.Workspace Set wrk =... deko	01-14-2004 08:16 AM Scott McDaniel	1	36
sub report's "report header" on show on first page I couldn't find anything at http://www.mvps.org/access/reports/index.html I have a report with static (name, address, etc) in its report header and... Roger	01-14-2004 07:35 AM Rick Brandt	1	38
Using 'create table .....' to create a table Hi, Can I set the default value for a field using sql in Access? Many thanks, Andy. qUACK	01-14-2004 05:52 AM Allen Browne	1	40
Export Query to CSV File Running Access 2k I run the following in an event code to generate a report in an excel format. What I wish to do is to have to output as a csv file... Clint Stowers	01-14-2004 05:23 AM Clint Stowers	2	42
Using one form to select the current record in another.. Originally I wanted a list box which selects which record is the current one within the same form. Easy enough until Access takes a dump when one... Robin S.	01-14-2004 05:12 AM Wayne Morgan	6	39
Access and Adobe Distiller I have been tasked with changing the filename Adobe Distiller defaults to. My guess is I can't change it. Has anyone been able to use VBA to... xzzy	01-14-2004 05:10 AM Ryan	4	69
Get names and types of modules/forms VB sub, functions and variables Hi! Is it possibile to get names and types of functions, subs and variables included in modules and forms VB code? The reason - I must to create... Leon	01-14-2004 05:01 AM Leon	4	36
can I reference a subform as an object? Dim frm as Form Set frm = Forms!frmMain!frmSub1.Form!frmSub2 Can I do this? I can't seem to get this to work... What is correct syntax? -- or how... deko	01-14-2004 04:18 AM Steve Jorgensen	1	31
Code to Changing a property in the table design view Back again I want to do the following A user decides if they want all orders reports etc to include 10% tax or 0% tax Now i have set the default... David Deacon	01-14-2004 04:01 AM Pink Panther	1	31
Access2K: Extract a string This a a long convoluted string parsing question... I have a string in an Access 2K database table field that I use for noting if a user has checked... Lauren Quantrell	01-14-2004 03:42 AM Tym	3	43
Fixed Width Text File Import Programmtically I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is... Johnny Meredith	01-14-2004 03:09 AM Fletcher Arnold	5	34
Linked table via ODBC We are currently experiencing problems with our Access XP database. We are using access as the front-end and are connecting to Oracle 7.3 via ODBC.... Ian	01-14-2004 02:51 AM Ian	3	44
O.T. - Why would renaming a database file in a CMD window under XP take 85 seconds? I ran the following 3 lines in a CMD window on a machine running XP. The first line took about 85 seconds to run. The next 2 were done by the time my... MLH	01-14-2004 02:29 AM Trevor Best	2	32
SubForm on Tab Control Issue Access XP Access 2002 format. I have a subform on a tab control. The subform has the following code (error trapping removed to make post... Ima Lostsoul	01-14-2004 12:20 AM Ima Lostsoul	2	46
Accounting/Tax Hi I have written a small accounts package My problem is that i have set the GST in qrys as the following AmountDue: 1.1(*(1-)-()) This works... David Deacon	01-13-2004 11:17 PM Roger	4	48
Access 2k to xp Hi I have a access 2000 app which I would like to upgrade to access xp. Is this straightforward or are there any issues that I need to keep in... John	01-13-2004 10:38 PM PC Datasheet	2	49
How to reset AutoNumber sequence? ( 1 2 ) Is there a way to reset the AutoNumber sequence? I have several tables that use the AutoNumber field as the Primary Key, and I'd like to somehow do... deko	01-13-2004 10:34 PM deko	12	89
Sub Report controls for printing Hi, I've got a sub report that has been set to print down then across as the data is sorted in date order. This sub report displays and prints as... Stinky Pete	01-13-2004 09:45 PM Rick Brandt	1	48
How do I make an MS Word background with VBA ? Hello all, I want to create a new word document from VBA (Access). All goes well, except that I also want to establish a background programmatically.... Ronny Sigo	01-13-2004 09:13 PM Mal	1	42
Maintaining and updating an Access database on a remote location I have developped an Access database with a lot of coding. The size of the database without data is about 5 meg. I am ready to copy the database to... ARobi	01-13-2004 09:05 PM ARobi	3	38
Tip for dealing with circular reference issue ( 1 2 ) I just came up with a really tidy little solution to the VB/VBA circular reference issue. It only works with Access 2000 or newer, but that's... Steve Jorgensen	01-13-2004 08:44 PM Tony Toews	11	45
rake-them-all-into-a-string query: is that possible? Dear all, Suppose there is a table whose records contain a textfield TXT, and a query that returns a subset of that table. Is it possible to have... wnstnsmith@yahoo.com	01-13-2004 08:27 PM wnstnsmith@yahoo.com	4	35
Re: ! Form to capture video "picture" In article <71aac38a.0303112049.1f8acf84 (AT) posting (DOT) google.com>, facombs (AT) yahoo (DOT) com says... We have this working at work. I didnt... Praetorian269	01-13-2004 08:15 PM Joe Costa	2	49
Can a control be SUMMED? I know this is a rather fundamental question which has been answered before, but I wasn't able to find the answers. Is it possible to SUM a control... Randy Harris	01-13-2004 07:52 PM Rick Brandt	1	32
What's the best way to export a query dynaset in Access 2.0? I don't want user to see the open query in a datasheet view. I just want the dynaset written to c:\myfile.xls. I was thinking... DoCmd OpenQuery... MLH	01-13-2004 07:48 PM MLH	3	37
2000 mde with xp Hi Will 2k mde run on access xp? Problem is that I need to send an access 2k database to a remote client and I obviously need to turn it into mde... John	01-13-2004 07:48 PM Albert D. Kallal	1	57
Removing Macro Security Warning..arrrggghhh Hi Before anyone blasts me for posting a question that the solution clearly appears in the help file, please read on. I keep getting the Security... -Michelle-	01-13-2004 07:34 PM -Michelle-	0	30
DateDiff, DateSerial, DateAdd, HELP Thank you in advance. I'm trying to pull all inventory items from December of the previous year back to 4 years for my accountant. I know this can... PMBragg	01-13-2004 05:30 PM Douglas J. Steele	2	32
add a colmn to an existing table using ADO I need to add a column to a table using code. The following works, but only for a new table. How should I change this to alter an existing... dave@strategicdelivery.co.nz	01-13-2004 04:13 PM Leon	4	39
MSGraph Display Issue in A97 under WinXP We have an application that outputs several different graphs from data downloaded from our AS400. The application has worked without (this) issue... Anthony Cuttitta Jr.	01-13-2004 04:00 PM Anthony Cuttitta Jr.	2	53
What is Best Method to Limit Number of Records I have created a table and form for allowing the input of a unique customer number (not an ID autonumber number) which a customer would enter once... Dalan	01-13-2004 01:49 PM Trevor Best	2	43
sending email I am trying to send email from Access 2000 using Eudora. The MAPI option is set in Eudora to always be the MAPI server. When I use the Send option... Deborah V. Gardner	01-13-2004 01:27 PM Deborah V. Gardner	2	58
Changing data source for Access 97 I apologize for the basic question, but MS's documentation has been no help at all. I'm working on a database, and need to create a form for... Geoff Matthews	01-13-2004 09:33 AM Geoff Matthews	3	33
access query not returning all records I am running a vb6 application which accesses an SQL server database and an Access database. I have a table in the access db which is... Sinead ORiordan	01-13-2004 09:19 AM Sinead ORiordan	0	36
Register MSFLXGRD.OCX => error 8002801c MSFLXGRD.OCX (version 6) was first registered on Windows XP (Office 2000) with a setup for installing an access MDE. It was unregistered with... CLarkou	01-13-2004 08:59 AM Christina Larkou	2	132
Counting in Query My data looks like: Model: SerialNu. Failure: Problem: Correction: T50 343X4 34 Cooler Repair T55 85B10 34 ... AAMoy	01-13-2004 08:55 AM Leon	2	50
Best way to schedule the print of a report - access '97 with NT scheduled tasks I am trying to duplicate the printing of a shortcut-print of an access report in my NT Scheduled Tasks. I can now print the report manually very... G	01-13-2004 08:38 AM Roger	2	31
Consistantly open database Our working access database applications sometimes will not open. If you log out of the network and right back on again then you will be able to... sherah	01-13-2004 08:34 AM Danny J. Lesandrini	1	42
Hyperlink doesn't work i.c.w. Browse button (API) Hi there, I'm just beginning with programming in Access 2000. I use the API call for browsing to a file. The result is placed in a field defined... Rob	01-13-2004 08:33 AM Danny J. Lesandrini	1	33
Why no user-defined functions as default values? (error 3388) I have a cool function that I want to use as a default value for a column in my table. But I can't because apparently Access doesn't allow user... Ed Havelaar	01-13-2004 06:36 AM Lyle Fairfield	5	43
Recursive join - blind alley? ( 1 2 3 ) Regular viewers may want to turn off now. This will be an orchestral management system. Musicians and other staff being booked/paid for jobs. A job... Mike MacSween	01-13-2004 06:26 AM Mike Sherrill	25	144
Make a MS Word background with VBA Sorry guys, I forgot to enter the subject in the previous message ... just click on it .... Thanks ... Ronny Ronny Sigo	01-13-2004 06:10 AM Ronny Sigo	0	41
Recordset to update queries - help! Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis.... Dom Boyce	01-13-2004 05:47 AM Dom Boyce	9	49
Programmer/Developer needed-Balto. area I need help modifying an existing access 2002 database. I also need to transport data from are current Q&A database email, brian (AT) ahoffmanawning... TY	01-13-2004 05:07 AM Terry Kreft	3	32
AllowBypassKey Function Option Failed Someone recently directed me to http://www.mvps.org/access/general/gen0040.htm for using a Function that includes the fourth place DLL to prevent... Dalan	01-13-2004 05:03 AM Terry Kreft	1	34
Unable to open form !! A particular form - always the same - sometimes becomes corrupt after saving. Error msg = The expression On Open you entered as the event property... Filips Benoit	01-13-2004 04:34 AM Filips Benoit	2	39
Building SQL Statement I'm currently creating an Access 2000 database to keep track of employee vacation hours. I have a form in which the number of hours requested off by... Andrea	01-13-2004 04:25 AM Pink Panther	5	34
Page Setup unstable Dear All, In Access 2000 i have it seems that page setup is not stable. Suddenly the page-setup-values return to defaults for margins and... Filips Benoit	01-13-2004 03:57 AM Fletcher Arnold	1	38
Re: David W. Fenton Awareness FAQ [updated] An Metet <anmetet (AT) liberty (DOT) gmsociety.org> wrote: Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that... Tony Toews	01-13-2004 02:34 AM Unknown	1	42

Page 686 of 820

686

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