p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  View Archive 

Thread subjectAuthorRepliesDate
Crosstab queries"joh bell" <johnwardbell@a...> 31 Aug
DEVLOPER Access & SQLGerald Lee <gl17@s...>631 Aug
Transferspreadsheet and SQL Servereman1205@a...131 Aug
Left Pad ? Len?"mike" <MIKEZCG@Y...>230 Aug
Licens key in applications"Claus Chr. Nielsen" <ClausC.Nielsen@f...>130 Aug
R: RE: access 2002 project and sql server 2000...again"Vladimiro Cerni" <vladimiro.cerni@t...> 30 Aug
Print to file not paper (VBA syntax)?"Silas Wild" <SILAS@d...>130 Aug
Parameter Values Too Large ??"Lonnie@P... 29 Aug
Sending a report as RTF creates an XLS extensionzielink@b... 29 Aug
Access interpreting SQL Server 200 bit field"Dave Anderson" <superdave1325@h...> 29 Aug
Run Time 3211 error..Im suicidal......"Tim Maher" <tim.maher@s...>629 Aug
Conditional Formatting in Report"Daragh Mulvany (Ext. 816)" <Daragh.Mulvany@f...>429 Aug
User Level security problem"AMIT JAIN" <amitjain76@h...>129 Aug
Automation Error - 2"Vivin Deshpande" <vdeshpande@m...>229 Aug
problem with cursor"Howard Stone" <ququmber@h...>129 Aug
One photo for each personacaxias@i...829 Aug
How to unreplicate a database or recover from a .bak file?<odempsey@b...>229 Aug
Variant Array IsEmpty returns False, Ubound throws an error"Phillip Johnson" <phillip.johnson@e...>229 Aug
Runtime 3211 cant lock table.......HELP"Tim Maher" <tim.maher@s...>229 Aug
Calculate the last day of the monthrobeetpotts1@h...229 Aug
DB loacked by Admin"Kenny Alligood" <kennyalligood@h...>329 Aug
Charts in Access"Pam McMillin" <pmcmillin@m...>128 Aug
Is there anyway to test whether an SQL query used as a rowsource for a combo box returns zero rows?howardb@k...328 Aug
access 2002 project and sql server 2000...again"Vladimiro Cerni" <vladimiro.cerni@t...>228 Aug
Database Access"Vivin Deshpande" <Vdeshpande@m...>128 Aug
Auto-magically Resize Reports?Beth Moffitt <BethMoffitt@i...>828 Aug
Format of "Checkbox" (simplest question)LoonieVisa@h...428 Aug
Running Access reports in vb via docmd with shared level securityfc87pc@o... 28 Aug
VBA for Access"Vivin Deshpande" <vdeshpande@m...>628 Aug
Calculated fields in queries"Andrew Payne" <andrewpayne.plastics@b...>228 Aug
Excel Automation question"Kenny Alligood" <kennyalligood@h...> 27 Aug
Start Up Properties"Kevin Crider" <criderkevin@a...>127 Aug
Only display duplicates"James" <j.boorman@u...>1827 Aug
Convert Text field to Integer in a make table query"Tim Maher" <tim.maher@s...>127 Aug
List users currently using the databaseRobeetpotts1@h...827 Aug
Perform calculations in excel from access"Tim Maher" <tim.maher@s...> 27 Aug
User input to determine WHERE statement"James" <j.boorman@u...>127 Aug
Users Save at the Same Time"enZo :-\)" <enzaux@g...>827 Aug
Run a report multiple times (newbie question)"Silas Wild" <SILAS@d...>126 Aug
getting number of records updated"Rahul Alavalapati" <arahul2@u...> 26 Aug
Automation Error"Vivin Deshpande" <vdeshpande@m...>326 Aug
Network access"Kaufman, Michael" <Michael.Kaufman@a...> 26 Aug
Access Dbase on a server machine"enZo :-\)" <enzaux@g...>226 Aug
Access 2000 Runtime"Steve Hindle" <Hindle@c...>126 Aug
Circular Query Problemsmahajan@l...426 Aug
How to Print Barcode"Johnny" <djj99@c...>226 Aug
Disabling a mouse wheel"Morris Tomlinson" <faucault@h...>325 Aug
screen resolution"Howard Stone" <ququmber@h...>225 Aug
beanbo69"Kevin Crider" <criderkevin@a...>423 Aug
lookup combo box won't function in add or edit mode"Daren Porter" <porterdt@h...>123 Aug
VBA Comments"Daragh Mulvany (Ext. 816)" <Daragh.Mulvany@f...>1523 Aug
What is better"Nikola" <Nikola@B...>623 Aug
Counting different itemsrobeetpotts1@h...323 Aug
Query on the fly"Andrew Payne" <andrewpayne.plastics@b...>123 Aug
Unbound Controls - Populating with data"David William Blythe" <dblythe@w...> 23 Aug
RE: Removing All Items from a Combo Box"Tom Milbourne" <tom@b...> 22 Aug
Network UserId with Access Rintime in Windows 2000PStreeter@C... 22 Aug
SQL Statement Changing Data on Form's RecordSource"Gregory Serrano" <SerranoG@m...>122 Aug
Query Questiongmead@d...122 Aug
Error Run time 3061 for Multiple Search Request"Rick N" <loonievisa@h...>122 Aug
Query Problem"Rahul Alavalapati" <arahul2@u...>422 Aug
Query Resetting to Primary Key"Rick N" <loonievisa@h...>122 Aug
exclusive access to the database"peter pennells" <ppenn@b...>422 Aug
Function to connect to a dbase using ADO"enZo :-\)" <enzaux@g...> 22 Aug
C Unix connecting to Access"Saad Masood" <saadahmed42@h...>222 Aug
multiple subforms"Howard Stone" <ququmber@h...>222 Aug
Macro Button to add new info"Rick N" <loonievisa@h...>221 Aug
Print out on Report (Infor page, Blank Page, Info page...)"Rick N" <loonievisa@h...>521 Aug
How do I use reports InputParamter"Tad" <tegrovesjr@r...> 21 Aug
On-Line List of Access XP Error Codes"Gregory Serrano" <SerranoG@m...> 21 Aug
Open template as new doc"Andy Whittaker" <andy.whittaker@g...> 21 Aug
format a number"carlier jacques" <jacques.carlier@c...>621 Aug
Relationships"George Oro" <george@c...>1321 Aug
Workgroup information file missing (0x80040E4D)"Thea Burger" <theab@l...> 21 Aug
Access over network"peter pennells" <ppenn@b...>321 Aug
Controlling on when to save data in a record"enZo :-\)" <enzaux@g...>1521 Aug
Still Confused!"George Oro" <george@c...>221 Aug
FORMAT OF REPORTLoonieVIsa@h...421 Aug
Database Internet Syncronization / Replication<odempsey@b...> 20 Aug
Run-time error '2115'"Nancy Mendonca" <qtnm@s...>220 Aug
Missing Stored Procedures after relocating"Alan Hawkins" <alanhawkins@c...>120 Aug
Counting Query Results"enZo :-\)" <enzaux@g...>220 Aug
combobox"Nikola" <Nikola@B...>320 Aug
Run-time Error 3075"Marcelo R. Lopez, Jr." <mis@p...>320 Aug
Report WidthPam McMillin <pmcmillin@m...>119 Aug
Creation of USER/LOGIN Box & RECORD COUNTER"Rick N" <loonievisa@h...>419 Aug
Access 97 to 2000 conversion prob. (DAO Library Reference)"Doug" <cookda1@y...>519 Aug
Client requirements"Kaufman, Michael" <Michael.Kaufman@a...>519 Aug
update Access table using data from Excel"Rahul Alavalapati" <arahul2@u...>419 Aug
References - Non Missing - Cannot Make MDE - Compiles All Modules"Phillip Johnson" <phillip.johnson@e...>119 Aug
Autonumber jumped 1000 ++ post backwards ??"thore" <thore@n...>519 Aug
Invalid HTTP address<odempsey@b...>719 Aug
Importing Access Data to WordCarol Pinger <carol@c...>318 Aug
an MDB data base"Ahmed Khamis" <Ahmed.Khamis@v...>318 Aug
Calculate Time"George Oro" <george@c...>618 Aug
Combo Boxes"Charles Sanders" <cvs715@h...>216 Aug
SQL Statement"Andrew Cooper" <aecooper@i...>216 Aug
clear text box on form"Howard Stone" <ququmber@h...>116 Aug
need an example for modulus 10"thore" <thore@n...>316 Aug
Re: reassign or disable "ctrl" + "p" keystrokes"Guy Harwood" <guy@h...>116 Aug
Library database procedures executing procedures in the calling databaseJohn Fejsa <John.Fejsa@h...>216 Aug
Tranfer access Report form to Excel"clarita" <clarita@p...>516 Aug
Printing Report"Maha Arupputhan Pappan" <mahap@p...>216 Aug
Calling Subform Procedures from a Main Form"Jamie Starkey" <jastarkey@i...>616 Aug
If..Then..Else/Select Case....Help?!?!?"Morris Tomlinson" <faucault@h...>315 Aug
Error passing User-defined Type to Sub"Marcelo R. Lopez, Jr." <mis@p...>115 Aug
Combining if statements to avoid Null values"James" <j.boorman@u...>715 Aug
Report printing"Andrew Payne" <andrewpayne.plastics@b...>215 Aug
How to get expiry date from issue datemohd_shah_abd_rahman@h...115 Aug
Password expiryrobeetpotts1@h...115 Aug
What's wrong now"Andrew Payne" <andrewpayne.plastics@b...>315 Aug
Reset Autonumber"Maha Arupputhan Pappan" <mahap@p...>1015 Aug
TYPE MISMATCH ERROR"frank robinson" <robinsf@d...>214 Aug
Built-in Toolbars"Tad" <tegrovesjr@r...>214 Aug
Updating ADO Connection via VBA"Greg McGuffey" <teiwaz@p...>814 Aug
System Messages"Kaufman, Michael" <Michael.Kaufman@a...>1114 Aug
Packaging Access and deploying the runtime version"paul mc namara" <paulmcn01@y...>214 Aug
Compilation Errors"KennethMungwira" <KennethMungwira@y...>114 Aug
Access Securitypaul.ansell@t...214 Aug
Using a pull down to select from a list of queries"James" <j.boorman@u...>214 Aug
DAY"George Oro" <george@c...>514 Aug
Forcing a subform updatemjackson11@h...614 Aug
record bg color"Howard Stone" <ququmber@h...>213 Aug
Word document opens Access"Stephen Birnie" <beelzebubs_offspring@h...> 13 Aug
formula in excel from access"Steve Sutton" <steve.sutton@s...>313 Aug
Error Message: Syntax error converting varchar to int"Alan Hawkins" <alanhawkins@c...>513 Aug
How can I change the startup form outside Access?"Cesar Guerra" <cesar@e...>112 Aug
Stupidly simple problem that has been stupidly hard to solve"DiBernardo, Michael" <Michael.DiBernardo@m...>212 Aug
vlookup equivalent in Access"Jeff Graves" <jeff@i...>312 Aug
Add Time"George Oro" <george@c...>112 Aug
UseTransaction Property"George Oro" <george@c...> 12 Aug
Opening a selected report in a Project"Alan Hawkins" <alanhawkins@c...>312 Aug
Degree Symbol"Phillip Johnson" <phillip.johnson@e...>412 Aug
Need Suggestions on how to format my Primary key"enZo :-\)" <enzaux@g...>2612 Aug
hyperlink from tablehazawak@y... 11 Aug
Access DB, QueryString, single quotes & javascript"Craig Miller" <canonelan2@y...> 11 Aug
Re: type mismatch: August 10, 2002"Wade Weal" <wadeweal@h...> 11 Aug
type mismatch"Howard Stone" <ququmber@h...>710 Aug
Converting to a Date type from a Numbersimonds@s...109 Aug
is it possible to edit a database in wordpad?<odempsey@b...>2609 Aug
Excel question"Scott Eisenreich" <seisenreich@h...>609 Aug
getting wrong sumRohit.A.Bhalerao@C...1009 Aug
Exporting recordset to Excel"Tim Maher" <tim.maher@s...>309 Aug
Split database"T.J. Haggai" <thaggai@g...>409 Aug
RUNTIME ERROR 3265Omar Chaudry <OChaudry@b...>209 Aug
Sybase Connections with Access 97"Mike" <mike.day@o...>109 Aug
SQLstate 08001 : DriverManager.getConnection fails : using MS-Access ODBC"Basant" <bsahu@m...> 09 Aug
Active Textbox Name"Steven White" <Steve.White@m...>409 Aug
cleartin access's list of past files"Russell E. Martin" <remartin@d...> 08 Aug
Printing the 'Current Record' in an Access report"Morris Tomlinson" <faucault@h...>608 Aug
Form will not open, modules cannot be updated"Garett Raines" <gtraines@y...>108 Aug
problem running an application"stijn goris" <mepisto@h...> 08 Aug
String Length"Andrew Payne" <andrewpayne.plastics@b...>908 Aug
Can't filter in access Runtime"paul mc namara" <paulmcn01@y...>208 Aug
VB vs. ACCESS"George Oro" <george@c...>708 Aug
VBA setting field size"Tim Maher" <tim.maher@s...>108 Aug
Error 3800"Mart Anand" <yuli_89@y...> 08 Aug
running an application"stijn goris" <mepisto@h...>308 Aug
Switchboard problem"Nikola" <Nikola@B...>208 Aug
Importing Named Excel Worksheet (Access97)John Fejsa <John.Fejsa@h...>108 Aug
Problems exporting Access reports to rtf formatJohn Fejsa <John.Fejsa@h...>708 Aug
Changing the Window Caption"enZo :-\)" <enzaux@g...>408 Aug
Unrecognised Database Format"Talon Wolle" <ta_iwo@y...>108 Aug
Query Joins"Ajay Jain" <ajain@i...>307 Aug
Access Front End for SQL"Mike Marcus" <mmarcus@n...>207 Aug
Access 97 MDE compiler"DiBernardo, Michael" <Michael.DiBernardo@m...>407 Aug
Path() function?"Kaufman, Michael" <Michael.Kaufman@a...>207 Aug
Cannot update. Database or object is read-only"peter.bender" <peter.bender@n...> 07 Aug
Teach yourself Access97 in 14 days - Sample Datadanirubin@m...507 Aug
Is there a VBA programmer tough enough for this?????"Tim Maher" <tim.maher@s...>307 Aug
The search key was not found in any record. (Error 3709)<odempsey@b...>207 Aug
Duplicate Order"Nikola" <Nikola@B...>107 Aug
NEED HELP!"George Oro" <george@c...>707 Aug
Importing Named Excel WorksheetJohn Fejsa <John.Fejsa@h...> 07 Aug
Please Help me"Johnny" <djj99@c...>1507 Aug
linking split db"Howard Stone" <ququmber@h...>107 Aug
Updating fields to a table without having access"Erik Schlegel" <eschlege@p...>206 Aug
Access forms with SQL - editing data problem"Alan Hawkins" <alanhawkins@c...>206 Aug
Creating forms through codeOmar Chaudry <OChaudry@b...>206 Aug
Beginner: Tabel selection!"Karin Almqvist" <karin.almqvist@s...>506 Aug
using Variables to save Queries"Tim Maher" <tim.maher@s...>106 Aug
Re:Sample Applications"Joseph O. Makong'ong'o" <jom@s...>506 Aug
When to use Standard Modules and Class Modules"enZo :-\)" <enzaux@g...>506 Aug
reestablish link in split db"Howard Stone" <ququmber@h...>106 Aug
Database Level Security"Sean Penton" <SeanCP93@Y...>105 Aug
Splitting and synchronising a subform"Morris Tomlinson" <faucault@h...>205 Aug
Setting a New Recordset"Garett Raines" <gtraines@y...>605 Aug
SQL Query"Ajay Jain" <ajain@i...>205 Aug
AW: Save SQL Query"Stefan Bechtloff" <stefan@b...>205 Aug
Unwanted Formatting when Field Gets the Focus"Gregory Serrano" <SerranoG@m...>105 Aug
AW: Re: VBA - working with System Date"Stefan Bechtloff" <stefan@b...> 05 Aug
AW: Changing an adp connection"Stefan Bechtloff" <stefan@b...>105 Aug
VBA - working with System Date"Tim Maher" <tim.maher@s...>905 Aug
Re: New user with conditional querry problem"James" <j.boorman@u...> 05 Aug
Changing an adp connection"Alan Edwards" <alan.edwards@n...>305 Aug
Text align in list box???"Wesley Kendrick" <wez.k@n...> 05 Aug
listbox vs combobox"andre" <andpatag@t...> 05 Aug
Beginner: compair no. in a table"Karin Almqvist" <karin.almqvist@s...>305 Aug
query listbox with access"andre" <andpatag@t...>405 Aug
IF statement in query?mail@s...305 Aug
runtime error 70 "Permission denied""Michal Chyska" <michal.chyska@c...> 05 Aug
RE: Synchronized only the structure changes"Ian Ashton" <ian@c...> 05 Aug
Save SQL Query"George Oro" <george@c...>305 Aug
AW: RE: AW: Can't Carry out this action error"Stefan Bechtloff" <stefan@b...>205 Aug
Queries designingtopwebdesigns@h...504 Aug
AW: Can't Carry out this action error"Stefan Bechtloff" <stefan@b...>104 Aug
Can't Carry out this action errorluckychap@b... 04 Aug
parameter query"Vlad VRA09 Rakic" <vrakic@q...>504 Aug
Find a space"Kenny Alligood" <kennyalligood@h...>403 Aug
AutoNumber Fields - How to maintain a consistant series of numbers"Mark kelly" <mkelly21@y...>403 Aug
SQL and Access"Nikola" <Nikola@B...>1003 Aug
Stored Procedures"George Oro" <george@c...>403 Aug
FW: Over flow Upsizing to SQL"George Oro" <george@c...>903 Aug
Basing an Access 97 form on results from a stored procedure"lhedquist" <lhedquist@i...> 02 Aug
Forms will no longer maximize"Tad" <tegrovesjr@r...> 02 Aug
Re: Search all tables for a field"Amy Wyatt" <amyw@c...>102 Aug
Beginner: Insert values from Combo Box and Text Box into the same tabel?"Karin Almqvist" <karin.almqvist@s...>502 Aug
Avoid getting null Values in queries?????"Tim Maher" <tim.maher@s...>602 Aug
recordsetclone equivalent in ADO for .adp"Jim Tredinnick" <jet@a...>202 Aug
Can ASP run an Access macro"Curtis J. Pogue" <poguec@c...>201 Aug
Re: 500,000 + RECORDS"Beth" <BethMoffitt@i...>201 Aug
Re: date format"Amy Wyatt" <amyw@c...>1201 Aug
Re: Searching Records Too Slow"Amy Wyatt" <amyw@c...>301 Aug
Monthview Help file"Daragh Mulvany (Ext. 816)" <Daragh.Mulvany@f...> 01 Aug
Re: open form - Gregory,Wesley"Nikola" <Nikola@B...>201 Aug
Re: Un-editable Combo Box? How?"Wesley Kendrick" <wez.k@n...>301 Aug
R: Re:NETIQUETTEBohus Peter <peter.bohus@l...>101 Aug
Re: Change subreport depending on amount of data"Steve Sutton" <steve.sutton@s...>201 Aug
open form"Nikola" <Nikola@B...>401 Aug
Preferred Number of Fields per Record"enZo :-\)" <enzaux@g...>101 Aug
Re: R: Re: R: Re: R: Re: R: Re: R: Re: hidding Tables"Steven White" <Steve.White@m...> 01 Aug