Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 52 of 820

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
DBForms convert Access db and forms from Access to PHP + Mysql Anyone using the product called DBForms to convert an access db and forms into a web based solution? It converts to PHP and Mysql. Here is their... Bob Alston	06-09-2009 09:41 PM Bob Alston	8	18
Access 2002 and 2003 MDE install problems I have a client with Access2002 installed on their Windows XP pc. They are now installing our Access 2003 application on to the computer... PW	06-09-2009 09:22 PM PW	4	29
changing the chart plot area (width and height) using VB Hi I am facing a problem changing the chart dimensions (width and height) to include all the data to be plotted. when i have a lot of records... MacGuy	06-08-2009 11:02 PM CDMAPoster@FortuneJames.com	1	31
Re: Multiple Sub-Queries making for a slow query On May 29, 4:04*pm, Rich P <rpng... (AT) aol (DOT) com> wrote: Hi Rich, It's the same query that I built for the Year To Date sales figures in a... franc sutherland	06-08-2009 02:12 PM franc sutherland	1	23
filter in rapport Hoi, Ik heb een probleem met een filter in een rapport. In een tabel met clientgegevens staat voor iedere client een startdatum en een einddatum... susan	06-08-2009 05:01 AM susan	0	35
Re: Help Needed With Numbering Problem Thanks for the replies all. I've employed a workable solution based on some of the suggestions above. Wayne	06-07-2009 03:35 AM Wayne	0	49
Passing variable from OpenForm to FindRecord method, and back Wayne Gillespie <bestfit (AT) NObestfitSPAMsoftwarePLEASE (DOT) com.au> wrote in news:goif259spvhkg99uofr9fhkdk5gnssjb0s (AT) 4ax (DOT) com: I... Steve	06-05-2009 09:09 PM David W. Fenton	6	52
Re: Trouble with subform glad you got it working, Jack, and sorry for what must have been confusing to read, in my last post - i should have said "have you tried... tina	06-05-2009 08:11 PM tina	0	23
No Data in a form Just a quick one guys, I have a form (1) which links through a standard button to another form (2). If there is no data in form (2), is it possible... John	06-04-2009 12:21 PM John	0	90
String to PDF I have a class module that adds some custom html functionality to MS's CDO email library. I now need the ability to backup an email to pdf before... robert.waters	06-03-2009 07:20 AM mark	2	90
Re: Filteration by the date field Naushad wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'd do it this way: Private Sub cboDocDate_AfterUpdate() Me.Filter = "DocDate = #" &... MGFoster	06-03-2009 07:05 AM Salad	2	69
converted accdb crashes on form I've converted a 2003 mdb to a 2007 accdb. When a certain subform opens another form, Access crashes with no error messages. If I put a stop before... elgin	06-01-2009 04:14 PM elgin	0	53
Can I link an Access2003 table to a Sharepoint List? (or display thedata some other way?) Hi, I've just "exported" a table as a list from Access2003 to Sharepoint. And, I've discovered that it is a static list, not a proper link to the... jonceramic	05-30-2009 12:44 PM Albert D. Kallal	2	111
Re: IIF Immediate If Statement for formating woes you're welcome. but take a second look at ConditionalFormatting. there is an Enable/Disable option available in A2000 and A2003; i don't know... John von Colditz	05-30-2009 08:26 AM tina	4	89
How to detect the drive letter Wayne thanks it works perfect. "Wayne Gillespie" <bestfit (AT) NObestfitSPAMsoftwarePLEASE (DOT) com.au> wrote in message... Simon	05-30-2009 03:14 AM Simon	1	136
How to copy a complete folder Dear reader, What is the syntax in VBA to copy a folder with his content (files)? Thanks for any help. Simon Simon	05-30-2009 03:09 AM Simon	0	67
access 2003 data entry form - copy to clipboard problem I'm working on a database and have a form that is for data entry only - the user cannot view any records except for the ones they have entered during... Benjamin	05-30-2009 12:05 AM Benjamin	0	60
converted accdb crashes on form I've converted a 2003 mdb to a 2007 accdb. When a certain subform opens another form, Access crashes with no error messages. If I put a stop before... elgin	05-29-2009 12:49 PM Elgin	1	34
Find Month End Date On a form a date is entered as 04/30/09 If I use DateAdd and add a month, it shows 05/30/09 instead of 05/31/09 It works okay going from 05/31 to... Karl	05-28-2009 11:47 AM Karl	3	64
Report - First page landscape others portrait?? That I thought. I already have such a solution. Thx Tom van Stiphout wrote: Gox	05-28-2009 08:50 AM Gox	1	37
Re: Integrating desktop search to my Access application Paul H wrote: Shell()? Salad	05-26-2009 10:48 AM Salad	0	82
Re: A2K: series of yes/no fields - how to select entirely blank rows? Martin wrote: Select * From TableName Where Jan = True Or Feb = True... You'll problably want to add Distict, as in Select Distinct * so Tim rolls... Salad	05-26-2009 08:18 AM paii, Ron	1	70
Re: How To Find Specific Keywords tungsten (AT) safe-mail (DOT) net wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 With the regular expression parser you can indicate more... MGFoster	05-25-2009 11:27 PM MGFoster	0	43
asking vb code to check if a field is blank Hi All, Just a quick question. How do I ask VB code to check if a field is blank? I want to add an if to some code so that if some fields on the... DeZZar	05-24-2009 06:50 PM DeZZar	2	85
Logical Problem with a Relationship while Trying to Normalize Too BACKGROUND: I'm building a USPresidents database from scratch. Grover Cleveland was president twice (non-consecutively). So, to avoid a duplicate... Richard Hollenbeck	05-24-2009 02:14 PM Richard Hollenbeck	0	28
How to access Form Description How to access (and change) Form (or other access objects) Description (the one u see when u right click object on object browser window) well that... evan.lack@gmail.com	05-24-2009 01:00 PM evan.lack@gmail.com	0	50
I need help with my project, please help The scenario: You have been asked to set up a simple database that will allow you to create queries and reports about clients and their... lionnick@gmail.com	05-24-2009 12:37 PM evan.lack@gmail.com	8	79
Parsing Data HI, I have one field I have to split into 2 fields. PrevCarrierAcct 123456 pass 2222 287fdkgab-92 pin 12345 absd2249 6429ab pass 111 Smythe32@aol.com	05-24-2009 10:01 AM Allen Browne	4	67
Selecting Max "row" given effective date and seq number Help! Can anyone tell me why this query doesn't return just the maximum "row" for each employee ID? Example: 101 4/5/2009 1 John Jones 12.34 101... Dave Moore	05-22-2009 09:34 PM Frank	5	55
Outlook Reference Problem Re: Access 2003 / Outlook 2007 I have Access 2003/Outlook 2007 on my development PC. My customers have Access 2003/Outlook 2003 on their PC. When... RLN	05-22-2009 03:13 PM Tony Toews [MVP]	2	40
VB Code for a Memo Field wanted Hi All I Have Memo Field (txtDescription) that which has the following data (or similar) on 10,000 records Some of the records have a * before... bobdydd	05-22-2009 10:00 AM Salad	4	96
Access not shutting down when application closed I have an Access application that no longer shuts down properly. The msaccess.exe process remains running in the background. Obviously there is some... Br@dley	05-22-2009 06:42 AM Terry Kreft	3	40
The usefulness of stdole2.tlb? Folks Some time ago there was some discussion as to the usefulness of the above VBA referece. Which wasn't much. One particular person said they... Tony Toews [MVP]	05-21-2009 08:02 PM Sky	2	98
SQL query in VBA This SQL works in the QBE window. I am trying to run this SQL in side of a VBA module in the form. strSQL = "SELECT DISTINCTROW " &... RLN	05-21-2009 05:43 PM Bob Quintal	7	137
How To Get The Red Out I have several forms where a user can search the entire database for specific keywords by typing the same into an unbound text box (FindBox). I am... tungsten@safe-mail.net	05-21-2009 04:52 PM Salad	2	38
The AI Show Tonight Before I look at any of the threads and posts I just want to say that this was an awesome show. The artist selection was great and the... Salad	05-21-2009 03:38 PM Tony Toews [MVP]	3	67
counting unique values Hi I can create a unique list using the SELECT distinct, Sum(item). How do you select all the values that are duplicates??? Thanks clive Clive Swan	05-21-2009 09:54 AM Frank	2	64
Multiple Field Index problem Hi, I created a Multiple Field Index containing the fields: First Name, Middle Initial, Last Name to prevent duplicate names to be added (prevent... zufie	05-21-2009 09:41 AM zufie	4	68
Dir Function - causing Invalid procedure call or argument I have the following code that is hanging with the above error when it is looping through my code with the following line: strFolder = Dir Get next... Carl	05-21-2009 05:17 AM Carl	0	66
Drag and Drop Just curious, does Access have any Drag/Drop capabilites? I suppose that needs to be asked for v2007. I know it doesn't in the older versions, but... Salad	05-21-2009 03:53 AM Salad	4	89
Strange Form & Report Import Problem - Access 2007 I have automated software that imports new forms, reports, etc. (home grown) on database startup. The source database is in Access 2003 format.... John von Colditz	05-21-2009 02:12 AM MGFoster	1	60
Using Terminal Services for Access optimization ( 1 2 ) As you all know, accessing a BE over the network can be an order of magnitude slower that having it on the same machine as the FE. If the FE of the... mark	05-20-2009 04:28 PM Tony Toews [MVP]	14	105
Access 2007 button style I can't figure out why one of my access databases has nice modern looking "curved" buttons and another one of my apps has the old windows 95 style... Paul H	05-20-2009 12:42 PM Paul H	3	113
using a string as a varible name In code I have to append a number to a string to make a variable name. how do you use this as a variable name? something like newstr = string... sparks	05-20-2009 10:04 AM Rich P	2	52
Automating an Access App launch Re: Access 2003 I have an Access app that runs a boatload of processing using two command buttons. "Button A" connects to Oracle, and brings in data... RLN	05-20-2009 09:57 AM RLN	8	62
Duplicates Highly Unlikely In a split db, I have a Mainform which recordsource is a table . The primary key (No Duplicates) in Tbl_Incident is the field . The other indexed... Earl Anderson	05-18-2009 11:20 PM Earl Anderson	0	65
Setting up a new custom dictionary I use MS Access 2002 and Win XP. I run a database that creates databases for 30 different users. For all the databases I would like to have a custom... damezumari	05-18-2009 11:03 AM Jan	2	68
trying to show all records in form view with domenuitem DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3 The above did not work in Access 97. Why? On a filtered form, what three numbers (X, Y and Z)... MLH	05-18-2009 10:47 AM Allen Browne	9	99
combo box / limit to items not already selected I have a combo box based on a table. For example say this contains the following 'items' A,B,C,D,E,F I want to record which of these items a... GW	05-18-2009 09:20 AM Roger	2	71
1 field 2 forms I have a datasheet view with data init, I also have a form with the same data in it. I would like to be able to click on the id in the datasheet... Elaine	05-18-2009 08:28 AM Tom van Stiphout	1	63

Page 52 of 820

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