Bytes - Microsoft Access / VBA answers - Page 64

Error 2115
clear out a mdb database
maketable query and non-local database
Is there a way to read the status bar?
Poll: How many of you feel inconvenienced by inability to use dbl-click to select a string in A97?
Reset an Undo
Row Source SQL query question.
Updating listbox.
New Adobe Professional 6 user seeks Quick answer!
Synchronizing Two List Boxes problem - Access 2003
Suppress Access Generated Warning
Undocumented rounding algorithm
Failure to open pdf file
Restricting what my user can see, howto?
removing wrap text format when exporting to excel
windomino - migrazione dati in access
problems keeping window maximized
Access and ODBC
Weird form problem
E-mail Attachment
Using Datediff
Access 2002 Wizard Source Code
scanning Multiple pages into Access 2k
WHERE clause constraint with 2 columns
Adox procedures problem
inserting autonumbers in SQL.
Creating relationships in code
Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
Passing variable value from code to query criteria?
Access screen resolution, resizing
Tutorial or Book on Report Creation
auto dial with voip
A97 does not prevent entry of new records from a form bound to a table
Automate import of data from several text files
ECO Database
Is DSN-less connection to UPS WorldShip possible?
Molehill into Mt. Everest
Gathering data from one table and sending it to another
Output to CSV
Import all Files in a Folder
Adding Bulk Records
Two questions relative to security.
hyperlink address on rich textbox control - Any possibilty ?
Access vs. SQL for audit trail of record changes?
barcode active-X
Display records from MS Access Database
record locking but not
Need form button that creates URL link from unique ID record
what is demo.hlp in A97?
a2k - does supporting multiple users imply use of Access security?
o2k - more thoughts on moving to multi-user - comments?
Ok really Wierd
Fill query column with my own values
problem accessing access 97 database through odbc on windows 2003 sp1
Sequentially numbering a field !
Convert DB Access 2002 to Access 2003
ApplyFilter method
Getting more than one result from a function.?
Is there a benefit of setting up relationships in A2003?
Help creating connection function
Derive Ranking Function
Amateur would like code critique
Filter on subform no longer works with linked ODBC table
reference a column but avoid blank rows
A97 runtime objective: put a set of files in alternate dir
Find via code
VBA DoCmd.GoToRecord , , acNewRec in first row
Redundancy of multifield indexes?
Help - Updateable query adds new row with missing criteria fields
Database corrupt by one record
Access 2003, Can run a report but can't print 1 section.
restricting access to records based on user identity
editing MSysRelationships
Updating cells
passing data to modal dialog box in VBA
Rich textbox control .
MS Access Help: Copying database Relationships
Problem with activex control in report
Focus & Navigation Problem !
embedded users manual ?
Import not working- need SQL statement to add table2 into table1
Linking two fields
Group column headings and sum their values
multiple contition field in a query
AutoFill Field
Calculate one year back, Access and Oracle
Remove Access Protection
Stacked Column Charts
Is this a many to many?
Display a form's Context help when the form opens
Exporting to Excel: Multiple tables in 1 spreadsheet - the last of 3 tables won't export.
How to do this??
email via winsock
access subquery not enough storage is available to complete this operation
How can I make the database multiuser?
VBA: Generic reference to ME
Reference problem by running an application on an alien pc
Simple Query to Linked ODBC table gives wrong results
Open Office 2.0 import to dBase from text & spreadsheets
Formatting a SQL Server decimal data type
Update table after leaving a record.
sql for an A97 query that'll return 6 future consecutive dates 20-25 days from now
printing "blank" pages
Copy at specific record...
How to change the table name in a report?
MDIClient height
Duplicating record
SQL to query value from field of current record only
Help with Do...Loop command using dates as parameter
Parameters based on Multi-Select List Box in Access 2000
Memo
Access Databases and the Internet
Separating the database
sendobjects with text fike
How to utilise "Me" in a public function
modify a line in a line graph using code
Counting Columns in a table using code
Altering tables in code
Display two fields by selecting value in one
Begineers question
Is it possible to create a runtime A97 app that runs from a CD only?
Save or Drop Record?
autofill
Property Not Found error when trying to set AllowBypassKey in A97
AutoExec macro, A97?
Why are some of my comboboxes getting populated and other are not?
I have a completely secured database and I want to completely unsecure it
Upsizing A2K to SqlServer, is Access Project necessary?
Combining multiple columns into one row in one field
Capturing Forms
Whats in my queries and marcos!
Combo Box Synchronising
Help needed with combined Dlookup/DatePart Syntax
Querrying Jet and SQL tables
Windows 2003 Server and Oplocks
Need Help with DLookup Function in Access
MBE File Creation problem.
Export to Access - ERROR: User-Defined type not defined
"Select single * " in ACCESS 2000
Reconneecting to BE after network drops out
Export Delimited txt File
Failure to compact/repair: why?
Is the Between ... And operator strictly reserved for use in SQL?
How to "hold" execution
A97 code causes keyboard loss
How to link an image to a record using VBA?
Problems playing sound from A97 on Win98 box?
Colours in Report acFormatHTML
Limit to New records only after synchro
Is This Possible?
The missing hard drive
ANDing and ORing question...
Running Total Query SQL Syntax Error
Won't open with startup, decompiling sorts it out, why?
James Isle Mercanti's barcode39.mdb
Permissions, RWOP queries not the answer
Invalid Bookmark Error
A97 syntax for specifying currently open database in DAO...
How can I be sure I'm reading a MAC address hard-coded on a NIC?
Report with subreport - one-to-many relationship
MS Access 2003 and Word 2003 Mail Merge Problem
Anyone know how to get a list of files in a directory
sql
Alternative application security schema via web verification
Scrambling suggestions sought.
schedule report mailing without leaving access open?
Communicating with Act
Seeking old Access 2.0 code for reading MAC address
I'm pulling MAC address off local machine with code furnished by Radu Lascae
Access 2003 - Error 1706. No valid source for product DAO.
Automate Import from Access to SQL Server through VBA in a ADP....
What's the easiest way to read a MAC address 'n suck it into MS Access?
Query Querstion
tracing relationships
I've created some forms with the wizard that have textured background in detail section
Web-ifying an Access database / Security
Close application and automatically shutdown XP Machine
Web-ifying an Access database / Security
Close application and automatically shutdown XP Machine
Please post a sample A97 runtime launch string example
Pass Running-sum Group Total from Sub Report to Main Report
from mdb to exe???
How to Open a database.db in access
Problem referencing the form that a Dcount and If...Then...Else statement are place in
Make form uneditable based upon Access login group
Yet another Backend Bloat Discussion
Help with Fiscal Date problem Date(), DateDiff(), DatePart()??
database design query
Updating project rankings automatically - Help needed
Testing for time elapsed
link tables
INSERT Query on two dependent joined tables ??
Get rid of "Add or remove buttons" dropdown menu on custom toolbar
Patrick Snowball
How to display (print) the day of the week for a date field
How did I accidently turn "snap" on in access 97?
How to write by VBA in an embedded xls-file?
Data in different tables.
creating a query out of thin air
Linking Outlook 2003 Tasks to Access 2003
Changing the background picture on a form with code
ODBC works in Excel not Access
Requery Combo Box Clears All Combo Boxes
Write conflict error - single user database
Help with a form and checkbox
Suggestions: Best Way to Integrate Excel with Access - Pivot Tables
Adding records to a filtered form
Subquery Fields Null
Access Report Prints Shaded
Returning True, False, and True Or False records
Extracting records from recordsets
Application and Form Design Suggestion
Viewing PDF files from within a form
Extract Data with VBA from table
ASP.NET Application - Migrating from Access 2000 to SQL Server 7
Creating Template in MS Access
Stampa unione Word 2003
Is there any known procedure to move the data from an excell sheet to a well designed DB in Access ?
Help with code
Weighted YTD Avg?
Export Access table to Excel and format wksht using macro
Lookup/ Combo Box issue
Top 10 Issues with mdb front and SQLServer back end
Errors Sharing 2000 DB
Listing of tables
Can I automatically generate a field in a table?
Aggregate function Access
Bulk Converting Access 97 to Access 2000
Dcount in query not working
TIME
Restore Value
EVAL
How to secure an A97 database from being opened w/o the correct system datbase being in place
Error Number 3000: Reserved Error (-3002); there is no message for this error
Was the A97 runtime setup wizard in the ODE tools something MicroSoft begrudgingly offered?
Export Access tables back out to XML
Option Group on a Form
Upsizing Wizard Nightmare
Does anything like a "master error trap" exist in A97?
Move a Record Up/Down in a Continuous Form !
Can you tell the datatype of a control
Query question - SQL syntax and joining multiple tables/queries
ADP frontend - How to update a row added by a trigger
Database window (list of forms) is frozen
Listbox with Multi-Select Output Question
Oracle Linked Tables - Big problem
Add toolbar to MS Access
Extract File Name From Path
Autonumber failure
Hey Horace
WTF?? No save of modules?
Select statement Help
Can't delete fields
A97 runtime installation onto Win98 box creates target mde file with +R file attrib?
Showing currency decimal values in formns
I have a problem w/ calculated field in A97 query...
A97 Workgroup Security puzzle
Repost (corrected explanation): Lengthy Error from Combobox
Show certain records in 1 table - yet able to add new.
Windows Terminal Server Printing Access Reports
Update Using Form and Another Table
switch attached hyperlink from an order to a loan.
How to print report on one side of the page?
how to backup an mdb file thru vba?
Lengthy error message when attempting to select from a combobox list
looking for ms access 2.0
tracking changes among records in ms access
Conditional Tab Order?
Problem querying datetime in SQL Server
Can SHELL handle a windows switch?
Agregate function dates
Something clobbering custom menu
Easy Question: Comparison Operator
Licensing Question
Access on the Web
function to stop certain dates being entered twice in access form
Count, Sum or Ave records in a table with VBA
A97 error "Operation Must Use An Updateable Query" ???
Make a form query that allows the user select the text boxes ?
date/time in access to date in excel
Locking a temp table
Format a reports layout
end if function
MDW
Breakpoint being hit even when THERE ARE NO BREAKPOINTS set
What the hell happened to my database?
File bloating/compression problem in Jet
Counting of records in a union query
Admin Tables to avoid hardcoding data?
privileges and tables for different types of users
Help with Dlookup and Mid
Create modular access frontend
VBA/Lucent
Can't open query in SQL View to correct query ("Join expression not supported")
Spammed by PC Datasheet
skip patterns thru a module....current forms problem
How do I print the definitions of several queries
Automated Data import from an excel form!!
3rd try: COMBOBOX not displaying all rows
Combobox not displaying all the rows that it should be
In the U.S., are EIN's nine digits long like SSN's?
Can't load DLL '48'
How to Lomit a Report
Repost: To Dev Ashish (Concat query)
Junction tables
upsizing A2K to SqlServer
Merge Query
Populating one field in a table with one to many relation
Using the replace function with ADO and an Access db from Visual Basic 6
Multi select list boxes in Access
Sagekey Access 2002 Runtime Object
data weekly- monthly
Access 2003 - How to show ValueList listbox data containing commas?
Searching Child Forms
Field Length for text box in form
Exporting to HTML
Error resolving replication conflicts
Access and HTMLEncode
Exception Report
Failure to exit
Confused about docmd.openform
Cannot open any more tables
how can I disable the mouse Scrolling Wheel?
Most Recent Dated Record, perhaps I am not seeing it correctly.
Incapsulate EXCEL into a ACCESS Form
How to use Access with Web Services?
SQL Server Connection User Security
Record Number with a twist
Strange Print Preview Behaviour
Looking for an easy way to browse the file system
Crosstab report with dynamic column headings
SQL question... batch query...
DateDiff function question
keep track of Consecutive numbered cards
Duplicate check on 2 fields
Data type mismatch
Cannot run any functions from a form
Distinct vs DistinctRow?
Appending to existing table painfully slow on network and 'out ofmemory' error
Full, simple, instructions for connecting my C# app to an Access database?
Dimming the Image in an IMage Control?
SQL Linked Records (Quotes)
Input range
I copy Table from a DB to other one and am recieving an error, why?
To Dev - Concat query
To Dev - Concat query
List Box. Please help
Boot users - i'm sure i;ve seen this somewhere
expression invalud, aggregate functions allowed only on output fields....
add dummy character
How to test the competence of Access Developer job applicants?
HOW CAN I PRINT ACCESS REPORT FROM VB.NET.
Stamping in a Hyperlink populates the Display Text but not the Address
Can't save decimal numbers
Displaying hyperlinks (as hyperlinks) data stored in linked table
Search multiple job sites for you!
Displaying Asterisks for Password typed into InputBox( )
Determining the highest array value without cycling through
VBA function for rounded pdf rectangles
HELP - Everything is Locked
How to prevent Form from closing?
Dates confusions
HELP! Strange behavior in A2K3 Dir function
Insert statement into Access 2000 DB from VB6/ADO
program to rename image paths
Reusing a Form
Creating Word Documents From An Access Query
MS Access security-Read-Only with Create Report option
Problem create view access ADP
Trouble Exporting data
Strange problem: Crash in print preview when opened by switchboard
me.formheader.height compile error
Please suggest right-sized shared database solution
Grouping Problem
Building a query with dates
How to cancel unnecessary pages in report?
PLEASE HELPPP URGENT..
Record milliseconds
MS Access linked to SQL Create View Problem
Controls Flash Out Of Place On Form Resize
Using a report multiple times
Scroll bar on a disabled TextBox
Pivot Table OXP W2K
Numeric Field Overflow
Last checkbox doesnt want to party
APPOINTMENT TRACKING PER CLIENT AND CALCULATIONS - HELP
Picking Random Values From A Table
clipper code to VBA
MSQuery Question
Need help - trying to create a searchable list
Date Criteria in a query
run stored excel VBA procedure from ACCESS
How do you export attachments on Access records?
please help
recordset bookmark problem
Clearing a label used to display info from a combo box based on a linked table
Custom Menus Overwirtten
Transfer table records from one to another
Problem UNIQUE KEY generation !
Copy data from forms via relationships....
data entry in add and verify mode
Compact and repair
Microsoft Graph and Access 2002
Please, any help appreciated
Open Acesss DB Backups
Data entry of a swimmers/athlete's time
Migrating data froexcel to access
msjet40
text limit on a textbox
cannot import delimited text programmatically (macros) with automatic primary key generation
Err 3188: Couldn't Update; currently locked by another session
Login Security Question
Importing text to Access, How to?
Check off Items in Form
determining next record in BeforeUpdate event
Opening a form based on user selection in combo boxes
Need some help in designing a simple customer database
Checking if record exists
Need to use a yes/no box on a form to drive a table update
Table form cross query
how to link a master detail table
Using Code to log activities in a text file
Carriage Return problems when importing from a Word document
Operation must use an updatable query. (Error 3073)
Show another item in table based upon what user selects.
Access DB back-end File bloating
Problem Using "Multi Select" Feature with a List Box on a Form
Designing a small CRM system
Memo Fields
DoCmd.OutputTo vs. Macro Sheet
Database Size
HOW TO
More of a Word problem really.. mailmerge
how to lookup value in a form
Entering records into a table from list box values
Using different versions of access
Reports: Formatting can grow / can shrink fields to the largest box.
Excel VBA query to Access DB not returning all rows
Access Date calculation
Query
Un
Locked out
Import CSV file that is currently zipped
MS Access 2000 Report
"Leftover" tab
SelStart - SelLength
SQL
Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
how to validate quarter-hour increments??
How to create an e-mail as a sum of columns?
How to creat thumbnails of jpg images in MS-Access database
Mail merge date problem with Word 2002 using Access as data source
How to determine if directory exists
Random insertion upon deletion
Delete a space in a string depending on the fields lenght
Parsing Problem
mde
Driver License Scan
locked out
Query Multiple Criteria "All" or 1?
How to implement a 'queue'
<<help>> Code worked before and now it doesn't!
Record counts
What text property setting controls the "look" of the text in label attached to disabled textbox?
I have a problem running Format in A97
Any real need to go from DAO to ADO?
open source
Merging 2 columns from the same table
Merging 2 columns from the same table
Open form based on field entry
How to validate email-addresses?
Send email from Access
A97 option group or combo-box data question?
Color change in ActiveControl
Testing Internet connection before performing database connections
can someone help me with this SQL query?
Incrementing a maximum value of a field when adding a record
How to loop through controls in form?
Fastest database connection
Access crashes when form is filtered
How to automate Excel with Late Binding?
Subform refresh to changed query
Randomly select group
Is there a way to make a table read only?
Source Control
A97 QBF question...
Off subject - hard drive crashed
Syntax Error 3131 - dbs.CreateQueryDef ?
Access form changes the case of the letter "i" to "I" (capitalizes)
Trouble with A97 query syntax...
"Long binary data" in Access db
Storing selections for dependent multiselect list boxes or check boxes
access 97 and 2003 installed on same computer.....problems
Referencing an opened Excel Workbook
Clear filters
Anybody know how I could show metallic green on an Access form
A97 OCT & HEX FN's - is there a similar DEC Fn or something to go to BASE10?
Do A97 color number values reflect some recognized standard?
testing for boolean
Test
How do I launch Internet Explorer
How to insert bulk data into an existing data base?
How can I tell if I'm on a certain field?
How to select all texts of the document of the format of the selected text?
fill combo based on selection of other combo
Photograph
Photographs
Insert data into 6 different tables
How to use Excel.Chart with early binding?
How to send the current record to Word 2000 with automation
Form "Dashboard" Code Speedup Needed
Paramter in query
I don't know how to make the toolbars not show up in A97
HOWTO: [wierd+wild] columnar reporting w/ varying rows???
Err 429
A97 runtime app behaves differently on 2 win XP boxes...
Update an Access table from dao recordset based on an excel sheet
Week Form
Double mouse click mystery
Runtime Access 97 app - what's the syntax for setting up a shortcut on the desktop?
Import of html tables to access, but fills a column instead of a row.
Converting to Access 2003
Can you create an updatable query with multible joins
Subform - Display Problem
Basic Access user: Link field in one table to field in other?
Write conflict error on subform
Junction Tables
Printer selection in Access 97
Listbox Value is Null when listbox is clicked
On Exit Event Disables Navigtation Buttons
Set variable
Deleting a record from a table.
Down Arrows On Menu Bar
I locked myself out
Searching for data in child forms, across multiple parent records
A97 - where is the system.mdw file located
Trouble copying a picture object from one table to another
How to read name of current database's record locking file from A97 code?
How to Add two Columns from SQL Select?
CancelUpdate message
A97 error 3356 reported when trying to compact database...
How to save a record, help needed
Working with Large vs Small databases
autonumber key violation on insert
ODBC -- Call Failed.
ODBC -- Call Failed.
Graphic front for AC97