Rating Thread / Thread Starter	Last Post	Replies	Views
Automatically associate value from one table to another table Hello All Can anybody please help me out with this small and ofcourse a crucial problem for me. I have two tables in the database system. Table1... anita	11-18-2004 06:42 PM Darryl Kerkeslager	1	117
Identifying if Office 2003 is installed I am trying to write a routine to look at the registry and identify if Office 2003 is installed, then, if it is to take certain actions. I have used... dixie	11-18-2004 06:39 PM dixie	1	99
How to do ALTER TABLE after a DML sentece in the same transaction. Hi all, Does anybody know how could I manage to do a sentence like this... ALTER TABLE Table1 DROP COLUMN Col1 after doing a DML sentence like and... NKN	11-18-2004 05:55 PM Trevor Best	1	83
long binary data I have people in the field submiting excell spreadsheets through a website which is tied into a SQL server which I am linking to in my database in an... Randy	11-18-2004 05:14 PM Trevor Best	1	86
School Lunchroom Admission I want to set up Access to use a barcode scan for admission to the lunchroom at the school I work at. We already have the scanners and computers. I... Me@Home.com	11-18-2004 05:11 PM Trevor Best	1	87
"kicking" users from a database Another Q, Because we sometimes need to repair the shared database I would like to find out if there is a way to "kick" all users from a database.... seansan	11-18-2004 04:41 PM Trevor Best	4	81
renaming field names in a query table I have a table created by a query. I would like to create a query which would create the exact same table but rename some of the field names. How... Michel Rousseau	11-18-2004 04:25 PM Michel Rousseau	0	66
to make a special column I have a two column table containing numbers. I would like to make a third column called fieldname "special". In this column I would like to put... Michel Rousseau	11-18-2004 04:25 PM Michel Rousseau	4	76
Data Transposition I'd prefer not to type 100 field names for a union query, so I was wondering what code methods are available to do something like the following: A ... Doug Leonard	11-18-2004 04:25 PM Doug Leonard	0	89
converting to a standard Hi, I wonder if anyone has some ideas on the best way to create this type of query. I have a table of four columns. The first column field... Tim Donaldson	11-18-2004 04:25 PM Tim Donaldson	7	86
Control sequence of objects in main window OK this is really bugging me. At one time, Access always listed objects in the main window in alpha/collating sequence. Now it seems it displays... Bob Alston	11-18-2004 03:52 PM Trevor Best	6	61
Opinions on db structure I'm creating an Access 2003 field-based survey tool. The field users (50 of them) submit survey results each week to a master db at the HQ. Primary... DFS	11-18-2004 03:02 PM DFS	0	87
Run a report based on a 1 month range How do I set up a report that runs after the user selects a month, (from a combo or list box on a form) so that the only data in the report is data... Andrew	11-18-2004 02:18 PM Bas Cost Budde	1	77
canadian postal code lookup Hello there, I am creating a contact database and I would like my user to enter postal code (Canadian) and the city/province will be... Ronnie	11-18-2004 11:28 AM Paul	1	71
Combo box filter I am having a problem working with one combo box that is filtering another combo box. My table is tblResearch. There are two field in this table;... D Perron	11-18-2004 10:58 AM D Perron	0	72
After inserting a record a different record is displayed I am using a SQL Server 7 databaes with an Access 2000 front-end. I have a form where after the user inserts a record the screen refreshes to... Chris Dixon	11-18-2004 08:41 AM Steve Jorgensen	3	70
Getting location of OLE object via VBA Hello All, I have an OLE Object type field in an Access database. The objects in this field are files which are linked rather than embedded. My... Zelda87	11-18-2004 08:05 AM Tom van Stiphout	1	65
Snapshot Report From Access To Outlook I was wondering if it would be possible to snapshot an access report to Outlook, and have fields come in the To: and Cc: fields, and also the subject... Jonathan Pinto	11-18-2004 07:56 AM Chris Dixon	1	80
Re: How do you model a family? Assuming frmPeople shows data from tblPeople, and has frmsubRelationships, with another PeopleID and RelationshipTypeID. Person1 has the... Penguin	11-18-2004 07:54 AM Darryl Kerkeslager	7	101
ordering records I have a really silly problem and hopefully someone will be have a very quick answer for me. I have a text field in a table and i'm storing... Stu Mac	11-18-2004 07:28 AM Darryl Kerkeslager	5	93
Uppercase problem I'm working with access 97. How do I setup a uppercase and validation rule at the same time. I did setup the CapALL function but it is not working. ... Kufre Anaka	11-18-2004 05:48 AM Wayne Morgan	1	100
Lookup tables - alternatives Hi, In my database I am converting grades into scores (A=7, B=6, B/C = 6.5) I'm told this is quite slow, and sure enough, a report doing a fair bit... John M	11-18-2004 05:38 AM Wayne Morgan	2	82
complex expression builder Hi, I want to use the expression builder in a query to define a field. I know how to do it for simple fields, like the one below : orderdate:... Laertes	11-18-2004 05:23 AM Wayne Morgan	1	86
pasting multiple lines in MS Access I am interested in creating a database of my mp3 files. What I am looking to do is paste a series of lines of text into a series of table cells... John Doe	11-18-2004 05:14 AM John Doe	4	64
Autokeys Macro not Working Hi all, I have an Autokeys Macro that's all in a sudden not working in access 2000 when pressing the key combinations. Open up the database in... Jim Caddy	11-18-2004 05:04 AM Jim Caddy	0	88
How do I create a query to link unrelated items between dates. I have designed a database but need help to find the code to link data by date/time as follows Times data entered at different parts of the process... Robin	11-18-2004 03:40 AM Robin	0	94
Saving design changes For a client who wants answers, but doesn't want to bother to learn Access, I've built a cut-down query generator, where they can select fields... MacDermott	11-18-2004 01:45 AM Bas Cost Budde	7	86
A question about Northwind traders Database Hi All, Have been using access for some time on a limited basis.I was playing around with the Northwind database and I have a question for you all. I... Allen	11-17-2004 11:05 PM Allen Browne	1	88
Opening multiple instances of a form in A2K: Gotchas? ( 1 2 ) I know I can open many instances of a given form, but I've never done it. Now I'm analyzing an application where that seems like just the ticket: ... (Pete Cresswell)	11-17-2004 10:40 PM Allen Browne	12	126
Carriage Return Issue I have a VBA function that returns a string including "vbcr" (VB Carriage Return) to seperate a list into multiple rows, eg Item1 & vbcr & Item2... Andrew Chanter	11-17-2004 10:27 PM Andrew Chanter	2	80
A note about Component-Based Development I'm posting a link here because I'm hoping it will be as enlightening to other Access developers as it has been to... Steve Jorgensen	11-17-2004 10:13 PM Steve Jorgensen	0	70
Access 97 runtime Hello, I'm searching a runtime to read access databases on computers which doesn't have access installed. I found this runtime for access 2000, but... B&C	11-17-2004 08:19 PM Albert D. Kallal	1	87
Access 2000 files with Access 2003 Hello, I have an Access 2000 database that I copied to a new computer with Access 2003. Access 2003 says the file is in Access 2000 file format. I... Mike Gramelspacher	11-17-2004 07:21 PM Allen Browne	3	87
What does normalise mean? What does normalisation mean in relation to an Access database? I have posted a question on a couple of groups and people have suggested this. How do... Tony Williams	11-17-2004 06:27 PM Mike MacSween	7	111
selecting from a table with multiple records Can you please help? I have an appointment table and employees have multiple records in this table simple because their contracts change. The table... Anderson	11-17-2004 05:27 PM David Seeto via AccessMonster.com	1	77
sub-form: 3246 Operation not supported in transactions Hi! I use Windows XP and Access 2002 (XP) SP2 (not SP3) My company has not upgraded to SP3. My problem: -I have a form "F_BOMs" -in this form, i... Nico	11-17-2004 02:55 PM Nico	1	128
Application Title is not saved I have a .mdb that I did not write. I open the app and change the Application Title in the Startup dialog box. The bar at the top changes to what I... Paul	11-17-2004 02:40 PM Rick Brandt	1	87
Format x column of Combo Box/ List Box as a phone number – (xxx) xxx-xxxx Having trouble in Access XP. I want to display the customers name, city and phone number in a Combo Box but the but the formatting is lost –... Dman	11-17-2004 02:18 PM Dman	2	57
need help with query I have a table of "memos". each record in that table has a primary key "memo ID" that is autonumber. I have another table that is "memo receipts"... Bob Weisenburger	11-17-2004 01:45 PM Bob Weisenburger	5	81
Latency in DB-update using Jet I'm currently using Jet for an Visual Basic Access application. The application is supposed to delete a row in a table, and afterwards update... Tormod Engebu	11-17-2004 12:23 PM James Fortune	7	79
School Year Months as 1 to 10 TblSchoolYear SchoolYearID SchoolYear SchoolYearStartDate SchoolYearEnddate A typical record looks like: 1 2004 - 2005 9/4/04 Julie	11-17-2004 12:12 PM James Fortune	5	87
Geneology tracking Does anybody have code for real geneology tracking through many generations? And maybe an associated family tree report? Tim Tim Graichen	11-17-2004 12:04 PM Tim Graichen	4	99
ACC97 on a Network environment Rosco, Thanks for your prompt answer. Users have those kind of rights, after talking to some colleagues it seems that using some features,... amazo	11-17-2004 10:47 AM paii, Ron	7	86
Dynamic Hyperlinks in a Form I have a form field that dispays a dynamic hyperlink that changes for each record dispayed. I need help setting up the form to execute the hyperlink... Jeffrey James	11-17-2004 10:30 AM Jeffrey James	0	104
Return value from a field of a query in VBA access Hello! I'm using Access and I'm trying to write VBA code to get the value of a specific field from a query. I want to use this value to set a... Samuel	11-17-2004 09:48 AM Edward	2	88
3001 Arguments are of the wrong type I have a wrapper function for executing a SQL Server Stored Procedure that returns no records: Public Function modRunStoredProc(vstrSPName As... Edward	11-17-2004 09:32 AM Edward	0	77
Importing a CSV file; imports all but one field Hi there, I'm running access 2002 SP-2. I'm trying to import a CSV file where everything except the last (end, and most recently added) field will... Fraza	11-17-2004 09:23 AM Janross	2	84
How do I Create an Index of a Report in Access I have a Report that creates a Catalogue of Products we sell under various Headings eg: Books, Recordings, Health Food, Diet Foods, etc There are... Ross Hamilton	11-17-2004 09:23 AM Thug Passion	7	89
Code for query to "Export to Excel" as pivot Is there a way to code the button that's available in the query window--microsoft excel icon that exports to excel. I know transferspreadsheet will... John	11-17-2004 09:06 AM user_5701	3	86
How can I use today's date as a variable? Hello all - apologies for putting such a banal request for help on a forum as distinguished as this, but I'm in trouble and didn't know where else to... Jimi Ffondu	11-17-2004 06:18 AM Bas Cost Budde	1	84

Page 530 of 820

530

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