Rating Thread / Thread Starter	Last Post	Replies	Views
Re: Why no 'LIKE' created by BuildCriteria? "Nicole" <nicolecxspamx (AT) namg (DOT) com> wrote Thanks so much for your response Nicole. You've saved me from a big headache and of course made... Paul	08-07-2003 03:16 AM Paul	0	81
Use multi select list box to select cities in query OK I'm a little new at this, so help on with this problem is greatly appreciated. I want to use a multi select list box on a form to choose one or... Steve-o	08-07-2003 12:46 AM Steve-o	0	61
VBScript equivalent to AllowEdits property Hi there, I've just started working in VBScript and I want to be able to lock a record down after action by the user. What is the vbscript... snapper	08-06-2003 11:49 PM Awa Tankan	1	66
Access 2002/2000 compatibility Hello to everybody in the NG. I have a question: I have written an application in Access 2002; given that all the PCs of my customer have Access... Zawy	08-06-2003 11:45 PM Kelly Groves	2	69
Open subform to specific record My database has TblCustomers - CustomerID, Name, etc and TblOrders - OrderID, CustomerID, OrderDate, etc. I have a form/subform based on TblCustomers... Sally	08-06-2003 10:01 PM Allen Browne	1	76
Re: FindRecord finds record in table but not in form-AHA! PS: The form is based on a query called Full Editing. BUT when I run the query by itself, the records I am looking for are missing! (i.e. sebastian).... Ken	08-06-2003 09:07 PM Ken	0	58
need help pls how can i enable the tool bar and menu bar? i disabled all menu bar and tool bar and secured with password. now i can't edit the form. jinoy	08-06-2003 07:51 PM Michael	1	57
Open color picker with color already selected http://www.mvps.org/access/api/api0060.htm shows how to call a color chooser. I'd like to open it with a color loaded. E.g. When the user clicks on... Mark B	08-06-2003 07:18 PM Mark B	0	57
How do I center a color chooser? http://www.mvps.org/access/api/api0060.htm shows how to call a color chooser. How do I center it? Regards Mark Mark B	08-06-2003 07:14 PM Mark B	2	62
Parsing address Info for database I'm new to access and extremely new to programming and I have a huge listing of schools in a word doc to parse and put into an access table. What is... Lisa	08-06-2003 06:08 PM Art	1	55
Re: List of Records / Double click to a Form I do this all the time. Take a look at the following screen shots: http://www.attcanada.net/~kallal.msn/Search/index.html In the above I used a... Albert D. Kallal	08-06-2003 06:05 PM R2	1	66
Changing path of linked text files I've inherited a database that has about 20 or 30 linked text files used to import various monthly stuff into a few other tables. I want to have a... Colin Campbell	08-06-2003 05:50 PM Douglas J. Steele	1	74
Importing more than one Excel file Hello all, Csn anybody out there help me as I need to import several Excel FILES into one Access database and I don't know how to differentiate... Accessman	08-06-2003 04:14 PM PC Datasheet	1	60
Re: Case sensitive query into an MS Access database. Is that possible? On Wed, 06 Aug 2003 13:04:49 GMT, kjell.arne.johansen (AT) kongsberg-simrad (DOT) com (Kjell Arne Johansen) wrote: AFAIK, Access can't do this. MSDE... Tom van Stiphout	08-06-2003 04:09 PM Michael $michka$ Kaplan [MS]	1	64
OT - Fascinating article on small-business tech support Slashdot recently linked to this set of hefty articles on one man's experiences and advice on his freelance technical support work. I found it very... Pete	08-06-2003 03:32 PM Pete	0	64
Form Object Causes Access to Lock Up After spending all morning revising my database and re-doing forms, I realized that just 1 of my forms is causing Access to freeze up and not close... Michel	08-06-2003 02:55 PM Michel	0	68
Access Subform New Record Displays in List but cannot Select Help!!! Any Access 2000 Master out there?? This is a tough one... I have a Main form with a Tab Control which contains a Subform Control. The Main form is... codemonkey	08-06-2003 02:54 PM codemonkey	0	54
DBForums (OT - mostly) "Albert D. Kallal" <kallal (AT) msn (DOT) com> wrote in news:aucYa.642313$3C2.15605345 (AT) news3 (DOT) calgary.shaw.ca: Does the yahoo mail system... Lyle Fairfield	08-06-2003 02:48 PM Lyle Fairfield	1	70
Need Help To Summarize Survey Results I have an Excel worksheet that tabulates survey results for about 100 questions. There are over 100 responses for each question. The responses vary.... Melanie	08-06-2003 01:54 PM paul	3	58
Simple Address Labels I have my addresses stored in seperate fields for First Name Lastname Address 1 Address 2 Address 3 Post Code Not all of the fields have data in... Andrew Corbett	08-06-2003 01:13 PM Andrew Corbett	5	78
Re: Increment ID value. I don't know about you code, but I use this: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.RecordID) Then Me.RecordID = DMax("",... r0adh0g	08-06-2003 12:47 PM r0adh0g	0	56
Turn off Wildcards Hi there. I need to search for wilcard characters within an acess table. How do I do it? If I search for *, it will of course bring up evrything. ... Graeme Howard	08-06-2003 12:36 PM Graeme Howard	5	77
Automatic scrollbar in a textbox Hi I'm trying to emulate text boxes in some apps that auto add/remove a scrollbar when necessary in a text box. Here's my code in the OnChange... Jon Lewis	08-06-2003 12:29 PM Jon Lewis	0	60
Multiple Running Sums in Sql I am looking to return a running sum for more than one unique id. For instance I have the following table: Id Order Value a 1 10 a 2 ... Christopher Gedemer	08-06-2003 11:53 AM Christopher Gedemer	0	58
Can't print only one page of multipage report, why? I have Microsoft Access 2000 and I know when I had 97 I could print one page of a multipage report. HELP (which never is much) says to "click print... MartyHarp	08-06-2003 11:35 AM TR	1	62
Is there a way to change a name of column in a linked table? Hello I have a MS Access 97 application, which works on 2 different sets of background tables. The same form can be based either on one table, or on... Galina	08-06-2003 10:56 AM Rick Brandt	1	58
Re: FindRecord finds record in table but not in form Is the cursor in the field you want to search before you invoke the search dialog? If not you will need to make sure that the search options are set... Bruce M. Thompson	08-06-2003 10:33 AM Bruce M. Thompson	0	75
A2K2: Getting past "...Object Variable or With Block Not Set..." error Rich- Thanks for your reply. I'll do as you suggested and look for missing End If and Next statements. However, unless I find those... Josh Nikle	08-06-2003 10:13 AM Rich Protzel	2	75
Access and live data problems Hi all, I've been looking for a fix for this and have had no joy. When I try to display an Access 2000 database using ASP/IIS with Dreamweaver, I... Jim PKP	08-06-2003 09:53 AM Rick Collard	1	78
Re: adhCalendar (Access 2000) I have modified the adhCal to return the existing date if there was one in the field, or return null if cancelled. See code below -- Leah Public... Leah	08-06-2003 09:41 AM Leah	0	83
populating fields from a listbox selection I have a listbox problem which i cannot figure out. I suspect that it is actually easily if one knows forms. I've used Access a lot but only for...	08-06-2003 09:02 AM Geir Baardsen	1	66
Open statement in VB .net The open statement was pretty simple in VB6: open "test" for input as #1 in VB .net I get an error saying: 'open' is not declared. File I/O... John Yaralian	08-06-2003 08:43 AM Tom van Stiphout	1	83
Corrupt database Hi I am using Access 2002 on a XP machine My database give me the follwing error. Unrecognized database. I have tried the following. 1.0 Try to... Alfred	08-06-2003 07:24 AM Alfred	0	68
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 04:22 AM TC	1	81
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 04:15 AM TC	1	66
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 03:58 AM Vladislav Moltchanov	0	65
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 03:46 AM KeARe	0	78
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 02:24 AM Peter Russell	3	103
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 01:20 AM Koen	6	70
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-05-2003 11:46 PM Tom van Stiphout	1	73
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-05-2003 11:42 PM Michael	2	74
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 10:44 PM K.D. Kalyn	0	124
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 10:28 PM Ashley	0	68
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 09:20 PM John MacIntyre	1	90
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 09:11 PM John MacIntyre	1	76
?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 08:58 PM John MacIntyre	2	60
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 08:55 PM Art	1	64
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 08:50 PM Albert D. Kallal	3	71
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 08:39 PM Allen Browne	4	57
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 07:18 PM Ken	0	59

Page 789 of 820

789

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