Rating Thread / Thread Starter	Last Post	Replies	Views
Re: Set Recordsetclone Not Working Try: Dim RecClone As DAO.Recordset Details: http://users.bigpond.net.au/abrowne1/ser-38.html -- Allen Browne - Microsoft MVP. Perth, Western... Allen Browne	08-06-2003 05:22 AM TC	1	75
Correct orthography error Hello, I'm looking for some code which allows the user to see some suggestions extracted from a reference table, when the orthography of the input... Zitoun	08-06-2003 05:15 AM TC	1	65
How to exit Access 2000 in autoexec macro I am moving one application developed in acc97 to 2000. There are several mdb or mde files which contain autoexec macros and which must perform... Vladislav Moltchanov	08-06-2003 04:58 AM Vladislav Moltchanov	0	63
transferdatabase data returned by stored procedure Hello all, I have some problem i can't handle. I work on adp project connected to sql server 2000. When i try to run... KeARe	08-06-2003 04:46 AM KeARe	0	76
How do I decript and encrypted field in SQL Hello All... I am running queres that are linked to tables in FOXPRO, running on SCO-UNIX. I have a date stamp field that is encrypted by FOXPRO.... jcampbell	08-06-2003 03:24 AM Peter Russell	3	101
Re: Please help, must be simple Chuck Grimsby <c.grimsby (AT) worldnet (DOT) att.net.invalid> wrote in news:mae0jvciob6jajkto4itque9ah1q3vpqs3 (AT) 4ax (DOT) com: Thanks Chuck! It... Larry Linson	08-06-2003 02:20 AM Koen	6	69
How to trap moving from one record to another A2000/2002. Stupid question, I hope. I have a form in which I have a combobox, cboPayType and a textbox, txtCC. If the cboPayType.Value = "Cash",... Pieter Linden	08-06-2003 12:46 AM Tom van Stiphout	1	71
Re: How to display only specific fields from a linked table You select fields in Queries, not in datasheet view of Tables. If this is a "developed application", it is wise not to give the users direct access... Larry Linson	08-06-2003 12:42 AM Michael	2	73
Access failing on DoCmd.OutPutTo acOutputServerView Hi, I'm working with an Ms-Access 2000 project (ADP) with a SQL server back-end. I am attempting to create an Excel backup file of report... K.D. Kalyn	08-05-2003 11:44 PM K.D. Kalyn	0	118
Can't find macro error I have an Access ADP with the ADP file is saved on common / shared drive & Directory which all workstations can read and write to. The application is... Ashley	08-05-2003 11:28 PM Ashley	0	66
query problem ( using inner joins) Hello everyone, Here is my case: I have two tables Master Table: ID MemberID info 1 1 This guy is cool 2 4 ... Jimmy Tran	08-05-2003 10:20 PM John MacIntyre	1	88
remove blanks/spaces I have a column in an Access Table that contains text data. I'm writing a query and want to remove all spaces in the column. Trim will remove... tt	08-05-2003 10:11 PM John MacIntyre	1	69
?Round( 1.5) = round( 2.5) - TRUE??? Thanks Allen, That's the kind of specific detail I was looking for. Regards, John MacIntyre VC++ / VB / ASP / Database... John MacIntyre	08-05-2003 09:58 PM John MacIntyre	2	57
help with VBA code Using Access2000, i need help coding the SEQ field (see sample below) TIA, Bob trans_id beg_date end_date seq 149 ... BFord	08-05-2003 09:55 PM Art	1	61
Functions not working I have a database that worked fine until the hard drive went tits up. I have a new hard drive and have installed office 2000 (in Windows XP). All... PT108271	08-05-2003 09:50 PM Albert D. Kallal	3	64
Re: Not prompted for saving changes when closing dirty form "P" <plavallee (AT) rcn (DOT) com> wrote The acSavePrompt is referring to saving design changes to the form, not to data changes which are saved by... Rick Brandt	08-05-2003 09:39 PM Allen Browne	4	55
On print event problem (Access 2K) Am trying to format a report such that a value does not show if the total of the values in a field in the detail section is less than 1. The totals... Ken	08-05-2003 08:18 PM Ken	0	58
DB front/back-end tool for small Mac/PC side project? I'm wanting to make a project tracking system to track an Access project I'm working on, and allow the clients real-time access to it, but the... Steve Jorgensen	08-05-2003 07:33 PM Steve Jorgensen	3	75
How to Refresh A Sub Form I have a subform (B) on a form(A). From A I call another form (C) that I add a new record to table X which is what is being shown in B. How, from C,... Tony Johnson	08-05-2003 07:29 PM Rick Collard	1	68
easiest way to make query? Is there an easy way to make a query that adds up invoices for customers? I have a table that has a customers # and an balance... such as 1234 ... scott	08-05-2003 07:01 PM scott	0	58
Run-time Error '424' A button on a form has the ONClick Event with this code Private Sub Toggle12_Click() DocCmd.OpenQuery "TEST" End Sub Clicking the button & I get... paul	08-05-2003 06:42 PM Fletcher Arnold	3	91
Newbie help hello everyone! I started studying Access two months ago and there's already something I'm struggling with: what is the difference (if there's one)... Zoe	08-05-2003 06:41 PM Bullschmidt	1	81
Looping through a Array of Controls labeled A1....A7 down to L1....L7 Heya, Thanks for the help the other day it was most useful. Wonder if any one would be able to help with this one. I have an array of controls... Hardeep Rakhra	08-05-2003 06:34 PM Fletcher Arnold	3	66
macros to modules in access 97 when macros are converted to modules how is the module then used and can the macro be deleted clwoods	08-05-2003 06:12 PM clwoods	0	80
Find instance of IE running from Access form. Hello, Is it possible to find an instance of IE (that's been launched outside of Access) from an access form?? What I've read leads me to believe... FrankBooth	08-05-2003 05:40 PM FrankBooth	0	54
compact problems Everett Sumner wrote: Can't say I know anything about linking tables - the only solution seems to be to shorten the connect string, which might mean... Everett Sumner	08-05-2003 05:38 PM Everett Sumner	3	71
What is the maximum number of rows I can get in Access I have a need to get data going back to the 1800's, and need more than 100,000 rows. How many will Access hold, and what can I use that will go over... Bill	08-05-2003 05:25 PM Rick Brandt	1	64
Custom toolbars Reposition Forms Hi everyone, I have been fighing with positoning of forms. I like to have them positioned top left and a certain size. So on the OnLoad event I use... Gary Hanley	08-05-2003 05:22 PM Albert D. Kallal	1	53
Previous record for formatting I would like to be able to refer to the previous entry on a continuous form so that I can conditionally format the new entry if needed. E.g. Date ... Ray	08-05-2003 04:53 PM Rich Protzel	1	52
Re: Totals query plus manual input Chuck Goldstein <chuckmg (AT) comcast (DOT) net> wrote in news:3F2FCC6C.9E078AC (AT) comcast (DOT) net: just total them. Bob Bob Quintal	08-05-2003 04:43 PM Chuck Goldstein	5	70
Link tables by custom autonumbers I have a maintenace table with a custom autonumber field. I have approximately 1000 records in the table. I now want to add another table, for parts,... Rhodrey	08-05-2003 04:42 PM Rick Brandt	5	65
Attach a control to another control Hi, I want to add a button next to a text box that will copy the text box text to the clipboard. I want to this generically so that I can do this... FrankBooth	08-05-2003 04:11 PM FrankBooth	0	59
visual studio anding folder to MS Outlook I have an Access 2000 application that requires the user's computer to have a folder called "Mailing" in the folder "Contacts" which is in the folder... rdshultz	08-05-2003 04:06 PM rdshultz	0	64
laufende summe durch sql abfrage in access Hallo Access – sql Profis Ein wahrscheinlich nur kleines Problem Quelle : Tabelle: Handel ID_Nr Datum Haendler Gewicht Gebuehr ... Ernst Rutz	08-05-2003 03:57 PM Ernst Rutz	0	129
Flag user editing/entering data? I am trying to figure a way to flag which use is entering/editing data into a multi user database. The OS is XP, and each user logs on with their... Shyguy	08-05-2003 03:56 PM MGFoster	1	69
Re: Enabling/Disabling Command Buttons Based on If Statements Hi Mary Ann, You need to check the position of the current record in the forms recordset. ie if you are at the first record, then disable the... Mark Day	08-05-2003 03:44 PM rkc	3	77
Can Exit Access, System Locks up My application now almost works, except that now it will not close. I am getting the ubiquitous hour glass, and in Windows Task Manager, it tells me... Michel	08-05-2003 03:36 PM Michel	0	71
Use Error handler for form_error() code Hi, I use a generic error handler for all procedure. I would like to use it when an error occur in the form. Currently, when an error occur in the... P	08-05-2003 03:28 PM P	2	72
Re: help: design issues Make a junction table that will contain 3 columns: projID, namesID and jobDate. Populate the table with combinations of assigned IDs. Relate the... Pavel Romashkin	08-05-2003 03:02 PM Pavel Romashkin	0	74
Populating one dropdown depending on value selected in another Hi I am banging my head against the wall over this one. I have an unbound combobox on a form from which I want to be able to see the various years... Colin Ward	08-05-2003 02:56 PM Fredg	1	83
VBA SQL syntax help needed John, You have extra &'s you don't need, you have to place a space between the "" ( " ") to get a space, and incorrect placement of quote... John	08-05-2003 02:43 PM Fredg	4	138
copy to clipboard hangs I am having the most difficult time copying any record in my table to the clipboard. The first time I was able to copy without a hitch. Now,... Klaus Buchberger	08-05-2003 02:41 PM Klaus Buchberger	0	81
Many Toggle Buttons ( 1 2 ) Sel, I looked through Forms, APIs and Modules and did not find anything referencing my issue. Can you be more specific as to where to... Rachel	08-05-2003 02:11 PM XMVP	15	148
Access Saving New Record Requery Refresh Issue "TC" <a@b.c.d> wrote I have a main form which has a tab control in which contain the other Subforms/Subreports controls exist. Yes, the 'list' is... codemonkey	08-05-2003 01:54 PM codemonkey	3	78
combo boxes I have 5 "combo" boxes in a single column in my database form. In each combo box is a drop down list of 10 server names(server names are the same in... jim agans	08-05-2003 01:54 PM jim agans	0	82
Autonumber Is there a way for Access 2000 to start an autonumber at anything other than zero? Any help is appreciated. Thanks. Joe Joseph Frazer	08-05-2003 12:09 PM Joseph Frazer	2	117
Re: Help Api Calls ... Copy Paste Clipboard gdbtg <member34937 (AT) dbforums (DOT) com> wrote Have a look at this page on the Microsoft Knowledge Base... Jon	08-05-2003 11:10 AM gdbtg	1	89
Re: Get record value from last record Yep. Read about Send Keys in the help files. I use the following to automatically enter a Set number in the Set field when that field gets the... Greg Homyer	08-05-2003 11:01 AM Lasse Farner	1	70
Table design advice Hello, I'm trying to figure out the best table design for a book database I'm building, and there are a few things I'm not sure about. You can see... Jan Stenqvist	08-05-2003 10:29 AM Jan Stenqvist	0	67
Copy Records Frm One password protected MS Access DB To ANother using sql I need to copy records from one password protected MS Access DB say DB1.mdb to another password protected DB say DB2.mdb The Insert Command with the... ankursinha	08-05-2003 10:00 AM ankursinha	0	55

Page 786 of 816

786

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