Rating Thread / Thread Starter	Last Post	Replies	Views
Access 97 bound form edits the previous record, not the one displayed. My Problem: I have created a database here at work that is exhibiting some very strange behaviour. Essentially the database is structured in a... Steve Strik	05-28-2004 02:06 AM Allen Browne	5	41
Export to Word or Excel Is there a way to export an MS Access Report to Word/Excel that looks EXACTLY like it appears in Access? When I export to Excel, only certain data... PerryC	05-28-2004 01:37 AM Albert D. Kallal	2	45
Redundancy ( 1 2 ) I am preparing to write a small utility which will identify redundant objects in an ADP and its SQL db. Suppose my code finds two objects, A and B,... Lyle Fairfield	05-28-2004 01:26 AM XMVP	10	90
looping problem Hi folks. I have a form, frmHistory, whose Default View is set to Continuos Forms. The following is the coding that I inserted in frmHistory's On... Aravind	05-28-2004 12:44 AM Glenn Davy	2	45
Auto Update Month in Calendar I am currently using the Active X Calendar object in a form to select the dates. The problem I am having is when the month changes the calendar... rudy	05-28-2004 12:24 AM rudy	4	41
MSSQL to ACCESS Problems Hi I have a access data base with a event title field and wish to only return say 20 characters, BUT I need it to return to the last space so If the... Keenan	05-28-2004 12:16 AM Larry Linson	1	55
Re: CDMA Newbie Information Re David Fenton Jerry Linson <admin (AT) jerseygirls (DOT) com> wrote: Please ignore the above posting and others which are somewhat bizarre. Note to persons new... Tony Toews	05-28-2004 12:13 AM Larry Linson	3	40
Disable macros? Has anyone ever come up with a way to disable macro creation within MS Access? Not just on a project level, but to prevent macros from being created... Billy R. Moon	05-28-2004 12:11 AM Billy R. Moon	2	48
Programatically Delete A Subroutine Is there a way to programatically delete a subroutine in the class module of a form from another form? Thanks! Mark Mark	05-28-2004 12:04 AM Tom van Stiphout	1	39
Pivot Table from Access to Oracle Dear Oracle Developers, my task is to make up a Oracle View from a Pivot table in MS Access. Given are two tables to join: T_FIRM: FIRM_ABBR ... Michael John	05-27-2004 09:27 PM Ron Tornambe	4	37
AccessXP developer upgrade I am thinking about gettingMicrosoft Office XP Developer (549-00904) for a project I am currently working on. This is an upgrade version. What are... Salad	05-27-2004 09:12 PM Salad	2	34
Backend Database on Web Server ( 1 2 ) I am using the Linked Table Manager in Access to try and connect my front end database (on my desktop) to my backend database (on my web host) I... HB2	05-27-2004 08:36 PM Tony Toews	10	60
Access going slow on new server hardware setup This is about a mysterious slow down only. An application (split data & FE) that has run for 6 years without error with six to ten users. The... Bill Elgie	05-27-2004 08:35 PM Tony Toews	6	42
How to send email via code in an Access Project? ( 1 2 ) Hi, I have an Access project that I use to allow a client to hit an SQL server at my host. This project has several forms that are used to udpate... Tim Smallwood	05-27-2004 08:28 PM Tony Toews	11	72
Constantly corrupting Access 2002 database We have an Access 2002 database of about 35 M with about 7 users. The data lives on the server (Windows 2000 server), while the queries, forms,... heather e blair	05-27-2004 08:22 PM Tony Toews	8	47
Area Codes, this should work, right? Chuck Grimsby <c.grimsby (AT) worldnet (DOT) att.net.invalid> wrote: Interesting idea. Identical to If and IFElse though. Tony -- Tony Toews,... Sean O	05-27-2004 08:16 PM Tony Toews	6	35
TOP Records in SQL Statement I've played with this for several hours trying to make it work with no success. How do I replace "TOP 4" in the following SQL statement with the... Wayne Aprato	05-27-2004 06:22 PM Wayne Aprato	2	35
Shell function in VBA Hi, How can I check whether a program, started with the 'shell' function, has terminated? Can this be done with value, returned from the... Blue in Green	05-27-2004 06:20 PM Douglas J. Steele	1	33
A Better Combo Box?? Hi all, I wrote some code that would enable a combo box to find a specific record, and if unsuccessful, to create a new one. Since the uderlying... AW	05-27-2004 06:19 PM Douglas J. Steele	1	43
Diary of a class module In response to recent questions on when to use class modules in Access VBA, here's a real-world scenario of mine. I had some code that needed to... Steve Jorgensen	05-27-2004 05:17 PM WindAndWaves	4	37
Packaging Wizard error I recieve the following error OffWH Automation Error Library not Registered How do i find what the library is?? Regards DD DD	05-27-2004 04:10 PM Tony Toews	3	69
Possible to use a crosstab query in a report (A97)? ( 1 2 ) Hi, Is that possible if the crosstab query is dynamic? Doesn't seem so as I have to specify the control source for the text boxes and the number of... pw	05-27-2004 03:31 PM pw	10	67
DB table design Q I'm building a db to store product monthly profit and loss data. Is it better to have: (A) each row represents the product and all of its 30 p&l line... John	05-27-2004 02:29 PM Mark	1	46
Securing a Database Greetings. I am looking for some advice on making a database secure. By secure, I mean that I want only certain people to have write access to the... Susan Bricker	05-27-2004 01:28 PM hamking	9	47
Vesrion Control without Developer Edition? Hi All, I'm starting some projects now that could really benefit from source code control, but for various reasons, I don't want to have to be... Steve Jorgensen	05-27-2004 01:23 PM Alan Webb	3	31
cannot open access database from a hyperlink using Internet Explorer I have a Microsoft Access 2000 (9.0.4402 SR-1) database that I am attempting to launch from a hyperlink using Internet Explorer... Bill Thom	05-27-2004 11:53 AM Bill Thom	0	39
Probably a really stupid question regarding indexing I have a database file that I use an autonumber field as the primary key index. Because of some rearrangements in the past, this index does not... noone	05-27-2004 10:19 AM Julia Baresch	9	35
Help! Access automatically saves any changed data on tables how do you stop Access from saving any changed data in your tables and queries? like i just add or change data on the table/query tables,then click... Christopher Koh	05-27-2004 10:09 AM Wayne Morgan	3	34
Ms Access I have designed a Dbase,& I cant get all the Reports or some queries to Print Monthly Summaries in Monthly date order. The date is the first column &... John Pettitt	05-27-2004 10:06 AM PC Datasheet	2	53
Refresh pass-through query ODBC connections? Ugh, I had to change the parameters of an ODBC connection and refreshed my linked tables which isn't so bad. But I noticed the pass-through... jj	05-27-2004 09:46 AM Donald Wisch	1	46
Re: "Replace" supported in 97? Replied yesterday but it's not showing up so sorry if this appears as a re-post ------------------------ Hmm, it's not case sensitive though. The... Terry Kreft	05-27-2004 07:06 AM Terry Kreft	0	38
let and get Can anyone explain me the joy of let and get. Once more, I read the explanation in the help, but did not get much wiser. I seem to learn best from... WindAndWaves	05-27-2004 06:11 AM WindAndWaves	8	62
Calling Forms Hello all, I was wondering if it is possible to call a form from a form, depending on controls from its subform. i.e. I have a client details form... Cillies	05-27-2004 05:44 AM Cillies	0	43
Calling upsizing wizard from VBA I'm looking to call the upsizing wizard from within a VBA function, preferably automating the entire upsizing process. Has anyone achieved this under... Calum Chisholm	05-27-2004 04:17 AM Calum Chisholm	2	42
Urget.. problem in SQL Query Hi, I have created 2 tables tbl1 and tbl2 and added data as follows tbl1: account_desc accountno ... Omavlana	05-27-2004 04:07 AM Bradley	1	30
Uregent... problem in SQL query Hi, I have created 2 tables tbl1 and tbl2 and added data as follows tbl1: account_desc accountno ... K k	05-27-2004 04:06 AM K k	0	33
Shell (sharing window focus on Access and non-Access application like telnet) Is there any possiblity of writing an Access or Visual Basic application that provides a method of sharing the window focus between Access and the... Pete	05-27-2004 04:05 AM Terry Kreft	3	45
Re: Cry For Help! - Filling In Forms Automatically From Tables Make sure that the form is based on the order details table....or a query that joins both and gives you the info you are looking for... The 'magic'... Mal Reeve	05-27-2004 03:16 AM Sabine	1	35
Right outer join help Hi, I need your help to resolve this problem. I have written a right outer join query between 2 indipendent tables as follows. select... K k	05-27-2004 12:16 AM K k	0	31
MS ACCESS - JOIN Query Hi, I need your help to resolve this problem. I have written a right outer join query between 2 indipendent tables as follows. select... Omavlana	05-26-2004 11:59 PM Omavlana	0	38
Code for Start Filter Process Is there a way to Start Filter Process (Filter by Form) using code? Thank you for the help in advance. MFS 43	05-26-2004 11:16 PM Mike 43	2	32
First name and last name I have one client fiield that stores First and last name. I would like to separate the names into a lastname field and firstname field. Can anyone... Edmund Wong	05-26-2004 10:12 PM Mark G. King	3	53
the strangest problem Hi, This happened a while back but never since, until now. When in the sql view of MS Access (2002) and I try to edit the text, quite often... Not Me	05-26-2004 09:36 PM david epsom dot com dot au	3	42
Highlighting Text In Textbox Hello When tabbing in a textbox that contains text, the text string is usually highlighted so that if the user starts typing new text in the... GGerard	05-26-2004 09:31 PM Stewart Allen	1	37
moved from the wrong location From: "WindAndWaves" <access (AT) ngaru (DOT) com> Subject: Re: why use a class module Date: Wednesday, 26 May 2004 6:25 p.m. this is my code that... WindAndWaves	05-26-2004 08:55 PM David W. Fenton	1	34
re: relink problem Access (Jet) caches and pools connections. If Access thinks that the connection has not changed, it will continue to use the old connection. I think... david epsom dot com dot au	05-26-2004 07:34 PM david epsom dot com dot au	0	41
Help wanted, distributing Access 2000 Help wanted Does anyone know of any books out there that addresses the problems of marketing an Access Database program with front/back end... Bob	05-26-2004 06:56 PM Tony Toews	1	37
help! How to make a mdb run in the windows without access? I have absolutely no idea. Any idea will be very much appreciated. Thanks. Paul T. Rong	05-26-2004 05:44 PM Alan Webb	5	34
Computed Query Field QUESTION: In an Access 2000 Query, can a computed field use IF logic? I have two fields that must be logically concatenated. Only one or the other... David McCulloch	05-26-2004 05:37 PM David McCulloch	2	39
TransferText Maintains Old Format Using Access-2k The code below is used to generate a csv file that is used by another application. All works fine till I add an additional field to... Clint Stowers	05-26-2004 05:05 PM Clint Stowers	0	34

Page 501 of 705

501

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