Microsoft Access / VBA Answers - Page 105

Snapshot Format not a SaveAs/Export choice in Access 97
new to access, but not to visual basic
Print the current record of a form
Couldn't find file 'System.mdw'
Gathering workstation data
ODBC Driver for .adp
How to Obtain the Height of a Form?
Delete all objects from database other than tables
How to Automatically Resize Form Controls When Resizing a Form
Date problems yet again - sorry Gurus !
Autonumber mess, figure out the number
Stuff a string
Parameters in QryDef in Acc2000
Form error
suddenly "on Error" doesn't work anymore
how do you know where the call is coming from
Detect adp connection state before opening
To Complex of a query
importing Data from access
I Cant Return a Next Due Date based on two items of criteria?
Reports and If()
VB error: this will reset your project do you want to proceed anyway
Sending a Form by e-mail
Putting fields on the first label...
Code : DoCmd.OpenQuery - and bring result back to form front
Print report to .pdf
How to Re-parent a Record
Opposit of a maketable query
Print MS Word Merge Document from Access?
Change focus between Property Sheet and Form Design
notification of upcoming date; filling in form letters automatically
Het zal toch niet zijn wie ik denk dat het is?
Determine Compile Status / Compile Target db using Vba
Determine Compile Status / Compile Target db using Vba
Importing data from text files of non-standard layout
using access as a front end, building a stand alone exe
PLEASE HELP!- Linking multiple forms to ONE record
Date format confusion
event sinking with Word question
Jet engine install
access 97.out of memory error..help. tia
Help! Creating Reports Using Multiple Tables
Access 97 vs XP
Good source to learn ADO?
Form Timer event fails to fire on heavy database access: Access 2003 bug?
Accessing the New entry portion of an access form
Is it possible to "remember" log in credentials? (Many MDB's sharing one MDW)
Query takes ages to run...
Table data issues
docmd.openform not working
deleting duplicate records with only one field different
Select Query
E-mailing a form using Lotus Notes
Application-defined or object-defined error in Access 2000
Access 2003 Conversion Errors
Adding Time
Setting an object to existing form generates 'can't find form' error
Recording locations of an object.
invoices from 2002 & not from 2004
Arjen Jongeling, een oude bekende
Check Box Problem with Make Table Query
Colored Background in Command Buttons. Is it Possible?
Nur ausgewähle Spalten/Felder aus Formular drucken?
Table Value Setting..conditiontal
docmd.runsql
What is the future direction of Access?
Change Screen Resolution using VB
Minimizing forms in a dll
List Box on Form
There was an error executing the command
Question about Field names
backup/recovery: compression command line multispan utility
Open an exclusively opened mdb, any way?
Converting Back to Access 97
Having trouble importing an XML file
HelpFile F1
Lookup textbox within form ( Parameter Value error )
Count by date/id across tables??
Excel functionnality in Acces
FileMaker 5.5
Tony Toews Performance FAQ
can this be done
you must specify the name the macro's macro group was last saved under
Access && JET
using location in report parameters
Query-Dates and duplication
Rounding Up problems
Network error, Access 2003
Need help with extracting table data into database from web
Subquery
Afterupdate & execute problem
database over internet?
Help with reports
Trciky DB tables question
Constant variable: How? Where? Help!
A problem occured while Microsoft Access was Communicating with the OLE or Activex Control
Input mask
updating people's FE by sending them the recently modified objects
expression built sting / Parsing text field
sub-report loses its sort
Selecting sub-reports by date criteria
Access lookup's
Better error messages for Input Masks
A "Gradient" for Form Sections
Updating Queries, Forms, Macros, Modules
Table design question
Autonumber in query
inputbox and dlookup issues
hacking to the core of access
Database Copyright
Loading from web
ComboBox RowSourceType containing UDF => call back oddities
Multiple instances of the same database...
Assistance with Posting Inventory Average Weighted Cost
concatenating two fields - problem with leading zeros
databases that grow like cabbage
SQL Statement Help
Call Function On Main Form to Sub Form
empty screen opening Access 2000 database
Call Subform Function From Main Form
help!cannot lock the subform
Multiple instances of the same database...
Access 2000 forms
Joins !!
Query Question
Autonumbering
totals
Delete Query - Criterion in unrelated table
Example of a University database
Access 2000 ----> Access 97
Service accesing a remote access database
auto update
auto update
ADO Cursor performance
How to create MDB file according to the version of the Access installed
Opinions on Software called ViewPoint
What's wrong with this simple code?
Problem deleteing linked tables
JET/DAO tables bound to forms in Access 2000 ADP: Anybody doing it?
copying controls from a form to a tab control
Bizarre problem referencing form by name
Which choice did he make?
How to make Command Buttons 'pretty'???
COM Add-ins
Unbound listbox in continuous subform
Date Problem
Exporting Colours from Access to Excel
Just how good are you really?
sum number of rows in different queries?
Connecting Access Db on Solaris
Access & Security
Copy one column to another???
Can I use wildcards in TransferText import?
Access Data to Outlook
Sending One Field To The Printer
displaying the data of three tables in one form
Query set within a specific amount of days
VBA.Trim() and long varchar columns
Cost Center Time Reporting Application
Event procedure using iif for line breaks.
Form controls
Question about Primary Key
Re. Embed or save ms word into OLE field
where I made mistake on compact the current database?
Please Help
Data Sheet Row Colors?
Compare 2 tables and only show the changes in result sheet
Open source alternative for MsAccess?
Active Directory - Access XP
Query to list near neighbours
How to get directory for CurrentDB
how to flatten sql query?
Deleting Workgroups
What's the 'best' was to print a complex calculated field on a report?
Limitations in exporting to Excel?
Moving stored procedures
Access 2k database keeps changing security permissions
How to set Enabled property - wont allow if control has focus
Strange annoying problem - long chunk of code
Strange annoying problem - long chunk of code
Form freezes.
ACCESS 2000 Question
Add record to Subform when not on Mainform
Me Statment Help
Waiting for MVP Happy Dust?
Length(field_name) in Access?
A way to use crosstab query fielld names as column headings?
embed or save ms word file into ole field table
Data Access in multiple history tables across multiple mdb's
Missing Records
break points in Load_Form event in Access 2000
MDE Creation on Win98 & WinXP
access 97: ftp code problems
Locked data base? Please help
change load order of form/subform
MSDE Error on attempting to create new Access 2000 project
Mini Labels
Access Project - Primary Key / Foreign Key question
Pages In Access
cancel as integer and the like: why and how
Continous Form constantly moving when loading
Your small effort make big change
Unbound Data Entry Problems
Enabling Tab Stop Makes Form Control Disappear
Close Button Problem
Database Form Question
variables in use
should i index linked fields
spellcheck on exit?
Report Header in Mailing Labels...
how do you programmatically create a relationship WITHOUT creating an index?
Upsizing to SQL 2000
Quirky Record
could not update; currently locked by another session on this machine
Want updates in .mdb file to update other .mdb file too
Using lookups or rates problems
conditional formating
Access97 on 1 GB+ System
Strange Characters in Memo Boxes
I want to change the spezification for transferText Delim
Constant ODBC Call Fails
Convert embedded Word docs to linked
Need to send an email in code
Calling a text box in Code Editor
Computer Books, Inc MS Access Books - up to 80% off
Could not find installable ISAM
First Field in Multi-field PK of Linked Tables not displaying in Unmatched Query Wiz
Problem Setting A Field To Null
Uosing different rates for employees in various stages
Looking up values
Can't read MS Access databse
View only selected fields
Report from a single record
Replacing Characters in the Field
Compare tables
I need to trick a requirement of an exclusive access in Access 2000
Subform
Stopping before EOF
Preventing running automacro from VBA
A2K - prevent "/" being input
Importing Excel to Access
List Box
How to send a picture with outlook via access
DoCmd.OpenReport RPT_TEST, A_PREVIEW, QueryAsFilter fails in A97
Help! cannot delete records in the table "PRODUCTS"
Can Access do this..?
Cancel Change In Option Group
auto update
A2K - note field in report not fully expanding
Error when trying to download using ftp module
default values
Adding a new field to an existing form
left join driving me crazy
Access + Postgres SQL
Code Help PLease
SQL server classes in St. Louis Area
Unable to open / design saved form in Access 2000
book on stored procedures for SQL Server 2000
Adding a table column using VBA/ADO
Database Held Hostage!
Back End/Front End Puzzle
How do I cause a "record find" to open before a form?
Form_BeforeUpdate procedure
O.T. First time ever for me to have an eCommerce site...
use a word file as my form for my database
Access 2000 adds brackets [] to queries
Running At? (OT) - DAPs and ASP
Subform
Error 2001 You canceled the previous operation
Creat an MDE file?
HELP, HELP, HELP........plz: Finding and displaying records
Cancel Change In Option Group
Unable to return data for some views in Oracle Applications using Access and ODBC
alternatives to #if ... #else ..... #end if statement
Mid function perhaps??
how can I speed up this function with a dcount in it?
Make Table Query - unique records from other two tables
More Queries...
Remove identical records from the same table
Data Across The Network
Network Down
what is wrong with the goto command?
what is the difference between attributes and properties in things like fields?
I have a global var named WhichFormOpenedMe. Its value is "frmMainMenu". What syntax do I use with the variable to perform this: [Forms]![frmMainMenu].SetFocus
when to use indexes
When is it a look up table and when is it an real entity?
Loop doesn't find all occurences of search, need help with recordset
Deleting Records
Help with Totals in Report
Automatic update of linked ODBC tables
Developer Extensions Question
Help - Log Transaction
2 databases & synchronization....
Multiple Users
Using wild card in Iif statement
Linux
Two Databases
Any way to check current On Error status
Disable Outputting message popup
Error 3220 - Function Is Not Available In Expression In Table Level Validation Expression
Expression builder and Loaded Forms folder
Listbox with checkbox displayed
Copy/Paste Extra
Mini Inkjet Labels
Access2003/OL20003 BCM
How to make a search engine in a form
RunSQL vs Execute rehashed
Access won't close after using DLL
increasing and changing the tick box
testing for Key Violation
determining a report's page orientation with VBA
Wierd Access behavior while deleting a record
Aligning Form/Report Controls in Access 2003
Emails With access 97 BUT NOT OUTLOOK
GetString method
Using Listbox contents as query parameter
Conditional formatting with subforms
99% CPU Usage...but for real this time...
E-Mailing A word attachment using Access
Access Developer's Edition
Open Reports & Fit
Query and pulling out certain parts of a field
Delete button is not working
parallel reports after random selection
Problem in a report?
AC97 - Replication - File Sharing Lock Count Exceeded
Access + MySQL = ODBC-call failed... sometime
Combining multiple records into one
Report printing
Access and SQL server
Easy q: Moving data in 1 field to data in another field (all records at once)
No Current Record message
how do you get a file off of a web server?
Split information in fields
split information in fields
modifying lay-out of word-document with automation
Dire need of Help!
Recordset in subform based on field in parent form
happy Sonday (spider)
MS graph changing min and max axis values
Access 2000: Is this corruption or not?
Excel to Access - code issue HELP!!
Form records to Report
Access 97 - is this possible?
how to put text under a key
Ms Access Reports Letters and Envelopes
Over-riding autonum
Automatically join MDW
Check Status of SetWarnings
TransferText truncates Double datatype to 2 decimal places
Query slow for one user, not others
DateTime Access bug?
How to avoid clip board message when duplicating record
Selected Property MS ACCESS 2000
Calendars
Error: 429 ActiveX component can't create object with Outlook 2003 automation
Query Quandry
Open Form from Previous Navigated Form
This is odd!
Requerying a list box - but not seeing the updates applied on requery!
How to test if cursor is in text box?
using form control values in queries
Add 1 to Serial Number
Subselect from 2 tables from 2 different databases
Procedure exits prematurely
Is Access Dead?
Unbound Textbox Character limit
Docmd.SendObject, Lotus Notes and Exchange
How do I parse XML files?
Help! Another report criteria stumper. "The field is too small to accept the amount of data..."
Help! Table locking issue in report with no sub report etc.
Help! I have a table locking issue in report with no sub reports
OLE File Associations
almost the same name
DCOUNT and DateRange Parameter
syntax help for the gotorecord Method
syntax help for the gotorecord Method
Time BETWEEN function
Behavior Problems with MySQL
emailing from access
Report to List All Objects Modifieds After Spec Date/time
DoEvents?
Sending Mail
100% CPU Usage + "This action will reset...."
Data Access Page - an introduction
Use server log on name
Where do companies like Yahoo get their mapping information from?
Exporting to a text file
Front end comparison
Format problem on entry
My Access applications are getting messy.
String Intersection
Booting people out of a front end
Disconnected ADO recordsets lose their data
Records *not* in a set
Mics: String matching, Zip code - alternative city names
Control visiblilty of a text box on a Tab Control
Multiple Users
Help! Packed app can not run on other computers
Migrate Raima embedded database (7) to Access
Need a combination - top 3, and group by...
How do I detect that there has been no activity on a form
string with quotes
Report Problem
access-vb problems...
Data Access Pages From Forms
Send Object with No Col Headings
delete a record in a subform?
Listboxes and long items
hi
Always on Top MakeTopMost
Conversion from Access 97 to Access 2000
Changing a text box to a combobox on an open form.
Query and Table Problem
system call
MSFlexGrid and data from spreadsheet
creating an HTML library of objects
datediff function
Tab Forms with Multiple Rows
Off - Topic... need help recovering inadvertently deleted mdb file off Windows XP machine
datediff question
Compatibility issues
Query current record
Help with sharing a database! Error 2501
Change security message
Converting backend to SQL
Need script to populate Northwind.mdb
Function name stored in a variable
SQL Problem
timing response times in milliseconds
date/time problem
open a subform
What are my choices?
Still have Type Mismatch Problem
How to do this?
Race Time Part II
Count problem
Time difference
combobox in subforms
criteria in query part of field text only
How to use Enter key as command button?
converting string to number without rounding decimals
Retrieve officepath while runnening access
SendObject as snapshot problem
combobox
Access Forms
importing dos-hebrew files into access
how to make the top row of combo box = 1st entry
database field on form never sending "on change" event
Default library files for a project
CALCS
Move files based on file names in table
Access Runtime and Security
Access 2003
Can this be done?
Self Destruct Code
Student Coursework - Grading System
Remove Access scroll bars
OLE Linked, Unlinked, Image at Runtime
Best way to import a spreadsheet with "junk" in numeric fields?
Help
happy Sonday (spider)
How many recordset can be opened simultaneously for a MS-Access 2000 Database
Temp table explosion
Is there an ftp client out there for access 2002?
Mainform/Subform Refresh/Requery Quirk
comand buttons not sorting after filtering form
Is there a way to "freeze" a column in a multi-column Listbox?
Problem with Type mismatch
newby help needed
Programmatic Built-in Commands
Insert into error with java and MS Access
Events Assistance
Combo Box To Search Subform
Why does compact and repair only compact the front end?
Query Calculation Based on Values in Another Table
Cannot add Attachments
MS Access Security/Workgroup problem
Reset Autonumber
problem with opening my access database
Getting column names of a table in C# using OleDB
Email Log, starting point
Subtract certian number of weeks from a date field?
User Permission
Binding Combo or Listbox to txt or dat file
help! who knows why "error while registering C:\WINDOWS\SYSTEM\MSADO21.TLB"
429 – ActiveX can't create object
Joins problem
ldb file is visible after databases are close
max fields
Open Access Options without displaying database window
looping problem
Help needed transfering query -> CSV
Outer Join Dilema
if anyone knows..how do you move info from a listbox? It just seems to select it and do nothing.
Link to data on CD
Printing a Form
What is OEM?
counting assemblies per year
AccessXP developer upgrade
FoxPro drivers and Linking to access question
Shell function in VBA
A Better Combo Box??
Access 2003 - Required Fields, Case Select, Return focus
Controltip text in continuous form
DB table design Q
Using CDO Mail with 2K or 2k3
429 – ActiveX can't create object
cannot open access database from a hyperlink using Internet Explorer
Need to crawl website
using access 2K on a network
Programatically Delete A Subroutine
Export to Word or Excel
Redundancy
Area Codes, this should work, right?
Excel data to a one - to - many relationship
Ms Access
Access front end, sql 7 backend, dsn on novell server
Calling Forms
Diary of a class module
Uregent... problem in SQL query
Urget.. problem in SQL Query
Please can someone help me get a list of absent employees ??
Right outer join help
Data Cleaning
Disable macros?
MS ACCESS - JOIN Query
query filter using many fields
date in reports
Highlighting Text In Textbox
Help wanted, distributing Access 2000
moved from the wrong location
TransferText
Shell (sharing window focus on Access and non-Access application like telnet)
TransferText Maintains Old Format
ACCESS2k: requery second combo box to show a new value list
Possible to use a crosstab query in a report (A97)?
Import Excel SS into Access
Password Verification Form...
Why no access for MAC when there is Excel et al ?
Populating Access fields with information from an Excel spreadsheet
Capturing alot of check off data
Access and Citrix
Return All Records
Updating table from data in two other tables via a query
Access: when subform's query has no data. Creates an error message in main form
Help! Access automatically saves any changed data on tables
Access 2003 / Windows xp Pro amd images
Backend Database Performance
the strangest problem