Rating Thread / Thread Starter	Last Post	Replies	Views
Import Pics from folder... Currently we open a form and manualy place the pic in each new record. I need someway for to give Access a folder and then have it import each pic it... Josh	12-19-2004 03:44 PM pietlinden@hotmail.com	2	50
SQL MAX() on two tables Hello! I try to get data out of my access DB with only sql. I undersstand how I do it in access with two queries but i am trying to access it from... jonaskruger@hotmail.com	12-19-2004 01:17 PM pietlinden@hotmail.com	1	47
Unrecognised database format After splitting a database into a front and backend the database operates ok on a network for the rest of the day, however the following day it... andymerr46	12-19-2004 01:14 PM pietlinden@hotmail.com	1	37
delete column values (but not the column) Hi, A collegue of mine has made an access entry field and keyed in all the data. Now I have to key in the same data in the same database. However, I... Uli	12-19-2004 10:36 AM Rick Brandt	1	44
populate combo with field-caption-names of a table Chuck Grimsby wrote: Not at all, not at all! And for me. I like your Mid(st,2) because that at least looks less cluttered than... Filips Benoit	12-19-2004 10:28 AM Bas Cost Budde	5	47
Solution To ERROR 3051 (Client Cant Connect Due To Open Exclusive) Hi Guys, I have a dbase installed on a network where the clints have linked tables to the database on the server. I found that i had to make some... Aaron	12-19-2004 09:32 AM Aaron	0	50
Function As Rowsource In Listbox??? I have a function named MyFunction in a standard module that creates a semi-colon delimited list. I want to use this list for the value list in... Scott	12-19-2004 06:57 AM Douglas J. Steele	3	40
Making change to tab-defined linked file from access But I can make new records!! Henrik "Chuck Grimsby" <c.grimsby (AT) worldnet (DOT) att.net.invalid> wrote Henrik	12-19-2004 04:14 AM Henrik	1	32
Copy and Paste header into MSWord template I am doing a job where I need to copy a letter header into each of about 100 letters which are mail merge template documents for about 20... dixie	12-18-2004 11:32 PM pietlinden@hotmail.com	1	37
How to track the history of a selected number of fields in a record? Access2003 I have set up two tables **current and **history. The history table contains all the fields which I want to track changes on. The current table... Gomez	12-18-2004 11:11 PM pietlinden@hotmail.com	1	38
Back up split database I'm surprised that when I go to File-->Backup Database within Access only the front end is backed up. Surely I'm missing some setting that I have to... bborden51@NoSpamgmail.com	12-18-2004 09:11 PM Jim M	5	52
Re: AutoNumber Regeneration ( 1 2 3 ) The issue of using AutoNumber keys in joins is problematic for the reasons outlined. You should use hardcoded id's for joins to avoid the... Tony D'Ambra	12-18-2004 07:46 PM Trevor Best	25	113
Table setup I need to setup two tables with default information. First off I need a company table. Quite simple. Name, Address, phone, tax number and so on. ... Paul .V.	12-18-2004 06:39 PM Rick Brandt	4	66
if/then query Hello, I have 3 tables in my mdb file, one contains a list of definitions, one is a list physical items, and one is a list overrides. Normally... JBoeker@gmail.com	12-18-2004 05:03 PM HS Hartkamp	1	55
Syntax For Collection I have a custom collection named CourseDates. In a procedure after I Dim Col As Collection, what is the syntax to set Col = to... Scott	12-18-2004 02:44 PM rkc	5	48
Amherst report card database Hi, I am a new user to Access 2000 and I am looking at developing an High School Report Card Database for the school I work at, using Access 2000.... arcdolphin	12-18-2004 01:42 PM arcdolphin	0	40
How do I...return non BoundColumn value from MultiSelect-Extended listbox using VBA? Hello world: I'm using Access 2003. I have 2 listboxes. One is a single column. The other has two columns. I can use Dev Ashish's code (thanks... Alan Lane	12-18-2004 01:23 PM Alan Lane	2	43
Refresh Form data across a network I have five users using the same forms to enter and retrieve data from an Access database held on a server but the only way each user can see any... Bill	12-18-2004 01:07 PM Rick Brandt	1	33
QUERY I need to run a Query that returns Products wirh a Sale Date Older Than 20 Days and doesn't have a Sale Date of earlier than 20 Days,... DS	12-18-2004 12:49 PM DS	9	52
Treeview Control I am using a treeview control and synchronizing the position in the treeview with a record on a subform (Each leaf node will point to a record in the... sindle@ensco.com	12-18-2004 10:37 AM Project2501a@gmail.com	2	53
How to get a Form pointer to the parent MS Access window? GetActiveWindow() returns a Long... So I'm guessing that's not it. I've got a routine that I can feed a Form pointer to and which looks up... (Pete Cresswell)	12-18-2004 09:02 AM Matthias Klaey	1	42
Class or Function that lists options We are wondering if there is a way to write a function, or perhaps a class, that can do the following. When you start to type a built-in Access... Penguin	12-18-2004 08:52 AM Allen Browne	8	49
NOT FIRST OR LAST In ACCESS 97 : in a txtbox i have (whateverdata) I would like to show on screen (whateverdata), so whithout the 2 * for the first one i used ... Peter D	12-18-2004 08:43 AM Rick Brandt	1	52
Fastest way to browse recordset? When I am programming, I want to view recordsets that I've created on the fly. I open them with something like: set tTable =... David	12-18-2004 05:55 AM Salad	6	33
too many fields defined I keep getting a run-time error that 'too many fields are defined' (it thinks there is more than 255, even when there is not). I looked this problem... Modest Marsupial	12-18-2004 02:45 AM Bas Cost Budde	6	47
Crosstabulate orderdetails I have an order details file with the following layout (simplified): orders_products_id orders_id model name quantity 1 6805 B12 Bananas 1 2 6805 ... John Jessen	12-18-2004 02:14 AM John Jessen	3	40
Access DB "on it's way" to corruption Hello Access gurus, I'm helping out a friend who's a small business owner. The software he uses to run his shop uses an Access backend. We... Matthew	12-17-2004 11:37 PM Tom van Stiphout	1	39
Formatting Fonts How do you Format a Font in a Combo Box? I went to Properties and put a to make them all caps for this report only. Thnaks DS DS	12-17-2004 07:26 PM Tony D'Ambra	6	44
Re: Access 2: Copy Records; Relationships Check out the Tools section to copy relationships from one MDB to another http://www.etechrecovery.com/001-AccessFAQ.asp#Tools Trevor Best wrote: allstreamit@yahoo.com	12-17-2004 06:45 PM allstreamit@yahoo.com	0	45
Re: Automatic copy of table to Access using ODBC Check out the Tools section to copy relationships from one MDB to another http://www.etechrecovery.com/001-AccessFAQ.asp#Tools allstreamit@yahoo.com	12-17-2004 06:45 PM allstreamit@yahoo.com	0	36
RELATIONSHIPS I have a Database where I enter Orders. The tables are as such. Sales Sales Details Discount Types Sales ID Sales ID Discount ID Discount... DS	12-17-2004 06:45 PM allstreamit@yahoo.com	6	87
Form Events MS Access 2000 I can't seem to figure out which of the forms event is called "AFTER" the form is displayed. I am trying to run some code after the form... Steven	12-17-2004 06:34 PM Tony D'Ambra	2	42
Sorting A Collection ( 1 2 ) I have a collection where the items in the collection are dates. I want to iterate over the collection and build a value list string for the... Scott	12-17-2004 06:12 PM Tony Toews	18	81
Access 2003 Form with Calculation I have a form that I created a calculation on using 2003. The calculation works exactly like I want it to but ONLY on the first and last record. The... cdelaney@purdue.edu	12-17-2004 06:02 PM Larry Linson	1	40
Listbox problem This seems like a silly little problem that ought to have a simple solution... but I've searched in vain for one. Among the various controls on a... jimphiggins@yahoo.co.uk	12-17-2004 05:38 PM Darryl Kerkeslager	2	42
Highlight first record in listbox on opening form? Probably really simple but I cant work it out... I have a list box on a form with a few records in. When I open the form the first record is sort of... Simon Rowe	12-17-2004 05:32 PM Stephen Lebans	3	33
scrolling listbox is slow Dear All, Scrolling a listbox having a large numbre of coloms and row is slow. Is there a tric to speed it up? Filip Filips Benoit	12-17-2004 05:32 PM Bas Cost Budde	3	37
Bild in Access-Bericht frei platzieren Ich habe einen Bericht mit vielen Datenzeilen (Detailbereich). Zu manchen Zeilen wird links vom Text ein Bild angedruckt, welches höher als die... Mark	12-17-2004 04:40 PM Bas Cost Budde	1	35
Access developers: Job Title question I work for a company where I've built an Access database system that's used for budget and forecast reporting. Now, this company is at the point... Soundneedle	12-17-2004 04:29 PM Tony Toews	4	32
Access continuous form, different indentation for each record I know Access struggels with having a different look in each record in a continuous form. I am looking to work with a list of data and have some... crcucb	12-17-2004 04:20 PM Colin Colin	2	26
MS Word doc to Access with images put into a file server... Hello, We are trying to design a new website around an Access database that allows employees to enter articles via Word into the database... timullrich@gmail.com	12-17-2004 02:32 PM timullrich@gmail.com	0	41
Controlling Form Size I have a form ‘Main’ and it is maximised, on the form is a command button to open another form over the top I always want it to open in a... Ant	12-17-2004 02:21 PM Jeff Smith	1	44
Using OR in Switch functions I have an option group on a form with three choices "Yes/No/All" I'm using a switch function in a query to filter records on a Yes/No field. There is... wayneh@4taconic.com	12-17-2004 02:10 PM MGFoster	1	45
Get Max Value AND Date it Occurred Hi, I have a lot of sample records done on different dates. It's easy to get the maximum value for any sample parameter for any sample... gostroff@hydroqual.com	12-17-2004 12:28 PM Bas Cost Budde	1	50
Repost - InetTransferLib Http download problem with zip files Reposting this message from last week since I have not had a reply so far. Hopefully someone will have an idea? --- I've been using Dev's fantastic... Owen Jenkins	12-17-2004 12:10 PM Terry Kreft	3	56
Update Query Error!!! I am attempting to run this update query from code and I keep getting a message that says "you are about to update "0" records". The query does not... Michael	12-17-2004 12:01 PM Eric Schittlipz	2	39
Is it possible to filter ontop of the current filter? Hi, Is it possible to filter ontop of the current filter being applied to records? This seems like it should be easy? I have two drop down boxes--... crispywafers@yahoo.com	12-17-2004 10:26 AM crispywafers@yahoo.com	4	48
Reports How do you combine values in a report, for instance: How do you get: 1 Bacardi Gold 1 Bacardi Gold 1 Bacardi Gold To Read: 3 Bacardi Gold DS	12-17-2004 09:50 AM DS	2	84
Read PK from MS Access Metadata Hey, when I open an ado-connection from a dsn that is linked to an MS Access database and I use the openSchema method (adSchemaPrimaryKeys),... thijs.kupers@gmail.com	12-17-2004 09:42 AM thijs.kupers@gmail.com	0	40
JOINing detail tables into the main table I have 2 tables: person (person_id, first_name, last_name) phone(phone_id, person_id, number, type) Each person may have many phone numbers, one... rettigcd@bigfoot.com	12-17-2004 09:32 AM rettigcd@bigfoot.com	2	45

Page 510 of 816

510

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