Rating Thread / Thread Starter	Last Post	Replies	Views
Insert a Dash in a reprot How can I insert a -(dash) in a report if there is no value in the field? Thanks, Greg Greg	10-16-2003 12:32 PM Greg	4	48
& displays As _ Hi, I typed an ampersand sign "&" in the caption of a button (Access 2000) and it displays as an underscore "_". Any Ideas? Thanks in advance for... Nathan Bloom	10-16-2003 12:16 PM Randy Harris	1	62
Re: missed the linked table (Access 2000) with dbase file while i reopen it I have the same trouble with dbase IV and Access 2000 (2002). The links worked for a few months, but for some reasons, now I get the same... csuciu	10-16-2003 12:00 PM csuciu	0	45
bang or dot? How to reference controls in queries? all this dot and bang syntax is confusing. if anyone can bring clarity to this subject I would really appreciate it. Forms!!.Form! -- to reference... deko	10-16-2003 11:18 AM Mike Metzger	3	43
Code adds next email address The email address stays through each loop and keeps adding the next email address. joe (AT) email (DOT) com then the next run would be joe (AT) email... MikeM	10-16-2003 11:15 AM MikeM	0	52
Access/Outlook integration in Office xp/2003 ? Currently using & developing a new application in A97. This app has a lot of Name & Address information in it. A lot of that information will... Iain Miller	10-16-2003 11:03 AM Peter Russell	1	49
One-to-One table / "related record required" - HELP Okay - apologize in advance for the length, but I want to make sure all you knowledgeable and helpful people have all the details you need to... elvin	10-16-2003 11:03 AM elvin	0	43
datetime Hi There, is there any possibility to declare datetime-column with special format in ALTER TABLE-Statement. e.g. I run the following query in... Oliver Neumann	10-16-2003 10:30 AM Fletcher Arnold	3	70
Can't build a link between unbound forms I am using Access 97 and have had a problem joining a main form and a subform. I have a main form and a subform. The data source on the main form is... Deborah V. Gardner	10-16-2003 10:26 AM Deborah V. Gardner	2	55
Lines in a Report I want to draw vertical lines in a report encompassing the header, line item and footer sections. Drawing them with the line tool does not connect... taccea	10-16-2003 10:15 AM taccea	2	89
Parameter Query Problems I am trying to set a perameter for my query but keep getting an error: The Microsoft Jet database engine does not reconize '' as a valid field name... Greg	10-16-2003 09:03 AM Tom van Stiphout	4	58
Change Column definitions? Hi I have a vb app that uses an access database to store information. This app has been distributed to several users. I would like to increase the... Tim Newton	10-16-2003 08:30 AM Tim Newton	2	49
Time differnce in whole hours Hi, I am trying to compare two time fields to get the difference in hours as a whole number. I have tried the... Consigliare	10-16-2003 07:41 AM Rick Brandt	1	45
How to test if records in Table? I'm wondering if there is a better way to see if there are existing records... strRecCount = DCount("Cat_ID", "tblEntity", "=" & !!.Form!.Form!) If... deko	10-16-2003 07:36 AM deko	3	50
Splitter Manager Killing ME I worked two months developing a program to work with county office. Has about 5000 records in it. I was able to load the Access file on CD and... Jack R. Jones	10-16-2003 07:09 AM Jack R. Jones	5	52
OBJECT BLOCK OR WITH BLOCK VARIABLE NOT SET When i attempt to set my 'picture' background for my sub-form i get the error "OBJECT BLOCK OR WITH BLOCK VARIABLE NOT SET". The main form has a... MARK	10-16-2003 05:49 AM Deano	1	49
Parse VB/VBA Code ( 1 2 3 ) I'm pleased you are willing to share your code, and I'm anxious to take a look at it, but this group does not allow binary attachments. If you... Illya Havsiyevych	10-16-2003 03:26 AM TC	22	123
text field only for text - no numbers Hi I would like some help about the following : I have a text field and I don't want it contains any numbers. How can I limit this situation ? So... Paulo Rodrigues	10-16-2003 01:53 AM Mick Hardy	2	48
MSCAL.OCX and multiple versions of Access Hi All, I have Access 97, 2000 & 2002 installed in different directories under Win2K Server on a new PC box I built. The Calendar Control on my... Michael Holberton	10-16-2003 12:55 AM Michael Holberton	0	49
Image database I was wondering if any one of you have some tips on how to display my images when I browse each record in a form. I have the following data... Artco News	10-15-2003 11:41 PM Larry Linson	5	82
orphaned .mdb file I have a problem, I reinstalled my computer (upgraded to XP) and thought I had a save backup of my database, though now I am not able to open... Doc	10-15-2003 11:24 PM Larry Linson	1	54
Images Questions about using/storing/linking to images, in the process of using Access, come up every day. Although they are all based on the... Serious_Practitioner	10-15-2003 11:21 PM Larry Linson	1	115
Conditional display of a Drop-Down selection in a form I would like to display a drop-down list on a form conditional on the value of another field on the same form. I am not sure if this is good form... B Love	10-15-2003 11:12 PM B Love	3	50
Detecting Quit Hello Is there a way in Access code to detect that the Quit command ( Application.Quit ) has been activated ? or if not can a custom procedure be... G.Gerard	10-15-2003 10:37 PM Larry Linson	1	55
Q: Sorting/Grouping query results I have a query that returns data such as: (First row is field name, following are records) strClass, strLastName, lngMonth, lngGrade Biology,... John	10-15-2003 08:52 PM Pieter Linden	1	41
Avery# For Labels Does a label report store the Avery# somewhere? I need to confirm what Avery label a report was designed for. I am near certain which one it is by... Steve	10-15-2003 08:35 PM Sandra Daigle	1	55
decompile in Access 2002? ( 1 2 3 ) After doing a lot of vba work, I've noticed the size of my mdb has grown, even though no data or objects have been added. I've read that the... deko	10-15-2003 08:03 PM Wayne Gillespie	28	148
Restricting the taskbar to one icon per open database instead of a group in XP. In Office XP Pro, how do you restrict the taskbar to one icon for the 'immediate window' (form or report) instead of a group that includes an icon... Kevin Ayers	10-15-2003 07:51 PM Kevin Ayers	2	48
New users & personal ID's... If I create a new user in Access 97 and make that user's name & Personal ID the same as I did in an Access 2.0 database, will that user have the same... MLH	10-15-2003 07:36 PM Albert D. Kallal	1	50
IPersistStream object in Access Is this object available in Access? If so, what do I need to set a reference to? My bigger picture is needing a way to take a .bmp out of a... J Askey	10-15-2003 07:00 PM Stephen Lebans	1	58
error when trying to add record to Access 2000 db Hi All, I'm having a problem trying to add a record to a simple Access 2000 db (db is very similar to an address book but with more info than... Frances	10-15-2003 06:44 PM Frances	0	41
Form/Subform & XP Hi all I have posted this problem before but am having no joy! I have an app written in Access 2000 which is based around a Form/Subform. ... Fionnbarr Kennedy	10-15-2003 06:37 PM Fionnbarr Kennedy	2	62
Relationships Between Lookup Tables and Regular Tables Do I need to create a relationship between fields in a table I created for a lookup(combo box) and the actual table that contains the combo box? Or... Mark Lees	10-15-2003 06:16 PM Fletcher Arnold	1	37
best control/method for item selection on Access form Hi All, * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so... Frances	10-15-2003 05:47 PM Frances	9	87
Is indirect sub/function possible in Access? ( 1 2 ) Is it possible to call a subroutine or function whose name is in a string? dchow	10-15-2003 05:36 PM dchow	10	97
Tapping into 2nd unbound Combo colum Acc97 on a subform I have a series of Combo box's which because of my inability to think ahead! I have had to use a field on the last one which I... Alex	10-15-2003 05:13 PM Douglas J. Steele	1	51
Error on Exit - Occurs on Compacting Database Hello, Following my earlier posting regarding my Error On Exit: --------------------------------------------------------- I get the following error... Rene Crespo	10-15-2003 05:13 PM Deano	1	48
help need urgently hello, everybody, this is Dhiraj here. I need help urgently, as i am getting error on my web page. The error is "Microsoft JET Database Engine... Dhiraj	10-15-2003 04:52 PM Pieter Linden	1	47
FoxPro index problems with Access I have a customer that is using Access to create reports from FoxPro tables. We started noticing problems with the indexes on the FoxPro tables. It... jdola	10-15-2003 04:45 PM Bob Quintal	1	49
Help Desk Call-Centre Log Hey Group, I'm just about to start my task of creating a full-scale Help Desk call centre database and was wondering a few things: - I was going to... Dave \IT\	10-15-2003 04:40 PM Pieter Linden	3	52
Form?? Hello, I created a form with 3 fields. The objective is to input all my CD Albums that I have. The 3 fields are, Artist Name; Album Title; Song... Mike	10-15-2003 04:31 PM Bob Quintal	2	150
Determining OLE dimensions Hi all, is it possible to determine the height and width of an image stored in an OLE field? I need to do this so that I can set the size of the... Richard Williamson	10-15-2003 04:31 PM Stephen Lebans	1	43
What control libraries to use Hello, The following is up to now not very clearly to me. What ocxfiles to use in A2000? For example: The listview. Now I use the one given in... bebelino	10-15-2003 04:26 PM bebelino	8	56
Saving and Updating Records Hello, I have an Access 2000 Project in which the data comes from a SQL Server 2000 database, and multiple users need to be able to see new records... CSDunn	10-15-2003 04:19 PM MGFoster	3	53
Deleting Records with Similar Fields Greetings All I am working on an Access database of contacts. I have plenty of records but plenty of them are almost duplicates. Data in some... Andre Doreid Berro	10-15-2003 03:59 PM Andre Doreid Berro	0	36
Maintaining /updating the backend file "Eric G" <Eric (AT) ether (DOT) net> wrote Ok, I would rather say I link to a copy of the back end. (you don't have to un-link first as separate... Eric G	10-15-2003 03:10 PM wsteinmetz	6	57
Translating Text Document Good morning group. When I translate a text document into access, the data does not align exactly into the fields. It may be spread over... Norm & Debbie	10-15-2003 01:18 PM pjac	1	41
Import a toolbar Is there a way to import a customized toolbar from another Access project? Everything else imports easily, but I couldn't figure out how to import... Randy Harris	10-15-2003 12:10 PM Randy Harris	2	56
Error on Openning Project Hello, I am using MSAccess 2000. I developed an application on my home PC - Windows 98 OS, MSOffice 2000 (including Access 2000). The project... Rene Crespo	10-15-2003 11:57 AM Pavel Romashkin	1	48
Web access to a secure database Can one access an secured MS Access database via the web? User Level Security is in place in this database. Any help is appreciated! Troy Troy Liggins	10-15-2003 10:59 AM Jerry Boone	1	55

Page 742 of 820

742

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