Bytes - Microsoft Access / VBA answers - Page 57

Printing a record from a current form
Drop List Question
VBA question - how can i retain the double quotes from a text file after opening it through a recordset?
Reference a field labels caption?
Dynamic Crosstab...SOS
Interesting Problem......... or not so for the advanced, lol
Combining databases
Could someone point me in the right direction to use DAO to list all forms, their textboxes and two properties for each textbox?
Securing both front end and back end
interesting question - module - chart - form
calculated text box
data entry forms writing directly to the tables?
How to prevent Access app from closing with X button?
ODBC access driver
Programmatically copy custom shortcut menu bars (command bars)?
Multiple users, selecting unique record from table
Store Array to Access w/o Parsing Each Row
Showing the difference between two times in Hours, Minutes and Seconds
Where are the Access Developers?
Best alternative to MS Access on a shared drive
If Statement in an Access Report
Clear a combo box on error?
import or link from Excel disfunction
MSACCESS.exe process does not stop when user exits Access (revisited)
Checking For Internet Connection
Cannot open a database created with a previous version of your application (Office 2003)
Access Form: lock user on text field ...
StartRow in Import/Export Specifications
Methodology
On record change
Union Query
Kallal-printercode - works with Citrix?
Access to Arcview 8.3 GIS link
A97 InputBox controls - how to limit?
Simplest recommendation for filtering records returned in a combo box on a form?
Allen - Your report list box
Set Subform sourceobject and recordsource
Mysterious "Sub or Function not defined"
Report: how to get rid of border
help on converting front end for web/browser access
Run an ArcGIS VBScript in MS Access
E-mail from within Access
Passing Information
Preview a PDF?
Sql Server 2005 and Access 2005?
A2003 corrupts - 97 didn't
MS Graph versus pivot graph?
declaration
If Clause
comparing arrays
Contents of a Hyperlink Control
Decimal Data type in Jet DDL SQL?
A few more questions - saving, canceling, object control
A2K - update query needed
Multiple Instance of a form limite
Editable query / continuous form with aggregate fields: how?
Filtering in Sub Report
SubForm is not visible
How to determine whether module is class module?
Is there a "browse" dialog? not to be confused with Open File
A2K - limit on lines that can be printed in immediate window?
Jump from a Form to a control (filed) in a SubForm
query
Insert a space into postcode
Track date of Updated records
Whats the best way to add a bit of a help file into an access file
VBA in SQL -- finding near duplicities
Sub-groups in a field
making virtual fields along with real fields in select statement
filtering a query by values in multi-select list box ?
The Wizard is unable to create your report
e-mail link in form
Displaying MEMO fields
Displaying MEMO fields
Need Help around
report with different structure
problem with Update query that has to fetch the values from another table
Yes/No field
Commit : database changes in Ms access.
Commit : database changes in Ms access.
SELECT MAX(field) FROM table BUT MAKE SURE IT IS NOT LESS THAN 2000
Programmatically changing RecordSource - too risky?
Combining two text field into a long list
Calculating Strait Line Depreciation
Combo Box design question
Selected controls on a form in design mode with VBA
ODBC: How to install Access 2.0-Drivers when Access 2003 is installed
Email list into BCC field
OLE automation: Excel Template question
Intrinsic Constant Definitions
how to import text field from MySQL db to MS Access 2003 using ImportXML
official certification
open database
Update new Password to table via Forms & Macro
A2K - how to create my own unique internal employee id
'X' button on the form top right
Record x of y
information about ActiveX controls
MDB file bloats while updating records
locked table
How big can an Access table be?
A2K - simple append of one record to another table needed
How to display a query in a list box using a record set?
Seems simple - But how (Stored procedures)?
Removal of Internet (web) bar at the top of the window
mail merge date problems
problems with totals in pivot tables and poivot charts
File system error
Why not use lookup wizard?
Getting the user profile folder
2 data files for mail merge into WORD?
Wonder how to open debug-window from A97 VBA?
Printing to hDc in VBA
Date time picker - findrecord based on value
Screwed up syntax
Combining Columns
Copy a string to clipboard via VBA
summing on a form
Misbehaving text box
Combo box, command button placement questions
Ecology and Access
Missive
INSERT Question
Setup: One Serial and Multiple Installed Software
Printing a detail of a single record (ie report)
Scheduling Query/Clashing Events
Print a external file
Access and FTP
Changing Password using forms without userlevel security
automating the import of a xls file
I didn't know this could be done (rename the Detail section of aForm)
HELP NEEDED ASAP - Updating table row by row (ADP)
Access query
query criteria
Making choices in a subform
Append Query problem
Sub keeping ACCESS.EXE open
[odbc] Retreiving full unicode data using Access ODBC driver.
Suppressing popup message after a TransferText
building a custom query using check boxes on a form
Hyperlink to jpg files - nothing happens (?)
mousemove over subform
Help! Trying to change code to use Application Object
OnTimer event interval - I need to run it when form is opened
Including all cases
Link an image on the web to appear on a form
Listbox - how to tell if item unselected?
Behaviour of the form filter option in the toolbar
enable controls on tab control form
Event When User Clicks On A Control On A Tab's Page
Count query
Conditional Formatting in a Form
Building an Activity report
A97 changes the link child and link master fields on a subform control w/o consulting or informing me
Should I repaint subform or mainform?
Building Access Apps with User Definable Fields
Is there a way to display current date and time on form?
A fairly dense form needs real estate. Don't have it. Want to resize ONE control only
center a form on display
Table of Contents stopped working (MDB -> ADP)
append question
maximaal aantal records uit query laten zien
Enter line feed in Search+Replace?
Why would a DCount of FieldName in saved query return a number greater than number of rows in qry?
textbox cursor placement
Placing the Same Value In Multiple Forms
Report error
Relinking problem
Access table OutPutTo Word bookmark
Complex Query Keeps Running Not Returning Data
Complex Query Keeps Running Not Returning Data
Add picture to Wrd Doc
Compacting on A2K vs A2002
table relationships
Experience with Visual Studio Tools for Office?
Problem using mixed data from Excel
creating a delete button
Run code in report
Speed benefit calling source db from query?
Convert Text to Int
Mystery number 9360 in report
DLookup("[PVIN]", "tblPreliminaryVINs", "[PVIN]=Forms!frmVINODO!SerialNum")
mixed languages and JET sp8 ...
Turning Excel data into a 1-M relationship
Removing "marks" from database
Adding new records in bulk
Connecting to Outlook PST or Exchange in a distributed application
Arcmap
Tricky Scneario
FORMATTING THE FONT OF AN EMAIL MSG
run access.exe on server side
Redmoving a spreadsheet and replaicing it through Access
help with a difficult query
highlight keywords in search result
Maximize form on open
NotInList problems
Access to ASP/VB.net converters
Bypassing a dialog
Linking Forms
Can't repoint linked tables
Subform and .dataentry property issue
First MACRO executed in an Access application
Now()
numbers rounding up in table
A2K3- quick SQL help needed
Transferspreadsheet Trapping Error for Duplicate records
Help Creating Small Table In Memory
Dlookup problem
new record
A97 - how to transfer a file from https?
Why is it a bad idea to create new databases or tables every year??
page breaks, printing and vba
Summary query causes Access to crash
Displaying a Cross Tab query on a Form
Updatable query - Many to Many
Need configuration help
Group Data/Copy Row Two Field to Row One Field
network error connection
Why does fso.MoveFolder fail with "Permission denied"?
Find the last number of a record
simple function record into array
Access VBA project locked
SQL Server - Filter
Whut I dew?
Array Help
Array help
SQL Format leading zeros
form layout
struggling with a query
Array help
Default Survey in AT YOUR SURVEY form
Access links, hyperlinks and headaches!
field that uses the now expression for date and time does not enter the data into my table. Why?
ucase or an expression that makes lowercase letters turn to uppercase automatically
ucase function
General sort order
MS Access 2002 problem: linked form fields in ODBC queries
Outlook Contacts
Compact db corrupts link to another
Search for plain text variables in word document
Locate plain text variables <*> in word doc
Back Style Property on Tab Controls: Disabled?
How to change the properties of Text box depending on the value of combo box.
access field merging
Locate plain text variables <*> in word doc
Search for plain text variables in word document
Help needed on picture files in access
Search for plain text variables in word document
Database Schema
Corrupt VBA project in the database
Cannot access form fields from VBA
AppPath in A97?
run-time error 3073
A2K3: design for pupil incidents database, help needed
Week number to date??
Create A List Of Dates In A Month
How to control scanner from Access?
New to ODE 97 Help Workshop Utility - How to compile a short test topic file?
Transparent background of image on A97 report becomes opaque when printed. Hmmm?
Lookup Date Table for Mising Date
Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB
How do I setup a Countdown Field in Access 2003 Form
Is a txt file Read-Only?
Date Countdown Field
linear Interpolation of data in a tabel
Seeking opinions on code that utilizes internal represention of dates
Maximizing Access Report From VB
append issues: clear table code?
How do I handle this referential integrity situation?
How to use OutputTo with named query?
Autonumber Format/Reset/Etc.
Continuous Form
Indexing Service and Access Files
SQL query - combine sum() with getting latest record by date field
radio button/combobox focus
Insert OLE object in Access 97
Graph/Range help needed...
copy value from previous record!
Access database used as OS interface?
Linking Databases - Methods?
linear Interpolation of data in a tabel
cannot lock database
Automatic Date Entry
windows dialer and access
Query and display record number only in a webpage
a97 - problem transfer file from server with https
Could Not Lock File Error 3050
Week form
Screen resolutions needed for development enviroment
Could Not Lock File Error 3050
WeekDay help
Access Report to multiple PDF files
merge with word using query with user entered paramiters
Why does Alt-Return bring up properties sheet?
Putting MS Access on the Web
Why did Access just close when I tried to save a form
POST to website with authentication
replace Rs.AddNew with INSERT
Passing search parameters with hyperlink to an ASP page
odbc timeout
SQL syntax - leading zeros
Merge to MS Word
Export Filtered Form to Excel
Digital Signature for Access 2003 Project
Changing Data Type - Text to ReplicationID
Data Entry Only Form
help with funtion (expression builder)
graph
design question
One table or three?
Modules Access 2003
Modules Access 2003
Interpolate data from tabel
Update Links
Autogenerating chart
A funny problem to have
Set background color of a column in a subform in datasheet view
sorting between two spreadsheets
Change "lookUp Method" to code used in a linked table
How to have the face of button changed when pressed?
Images w/ transparent background in Access?
Which hardware upgrades are more important
Create folder inside Queries & Forms Tab?
Where can I find reference documentation for Access?
Problem with Query data in report
A2K - how to detect any change to a database to avoid unnecessary code execution
Can I read the value of a textbox control on a report?
Converting student scores to grades not that easy?
"docking" forms
Strange problem loosing data based on physical machine
A2003 - Tab to Tab Focus
how to update new password to existing table in a custom login form using macros or query?
which approach? (cofused with tables)
Creating dynamic sql
form controls not really null??
Line intercept - mschart
Using combo box element as search criteria
reading data in to Access From Excel
How to automate PaperPort?
availability of Jet DB engine on Win 200, XP, Server 2003
availability of Jet DB engine on Win 200, XP, Server 2003
Weird NotInList behaviour
availability of Jet DB engine on Win 200, XP, Server 2003
Search multiple MS Access database files via asp.net web application
Basic query question regarding parameters and grouping.
Autoincrement versus GUID
Programatically accessing "object groups"
Multiple database problem in A2003
Report/Form event "On No Date"
Queries with identical SQL code behave differently (one is expandable)
Add column color in datasheet view
Add a defined number of records to a table
creating email attachments
Access to Quickbooks
Add record in grouped data access page
Is David Fenton right about error handling? (re-post?)
Access autopopulating field based on condition
Is David Fenton right about error handling?
Tooltips not working
reselect random items
Linking databases using ADO
setfocus and report creation problem
Best solution? (too few parameters. Expected 1.)
Problems while making MDE
export to excel with criterias
#Name? Error... trying to link two fields in same form
MS Access to Oracle Database Conversion
Subreport visible property
Field on Form = next record
Validating "Orders" form
Subvalues -- like submenus? How can I do it?
No fields selectable for report
calling C# .Net dll from VBA
Create table from query?
How to add a record in ms access
How to add a record in ms access
Unbound Nested Subform Simulating Continuous Form
different permission for different users for password using tables and forms
Need help with accounting database
Active X not in Toolbox
Which is best - recordsets/VBA V SQL statements for updating data
How do you record multiple values into a column??
File Name in Add-In Manager?
Moving data from one list box to another via a button
??? for Wayne Gillespie on FTPClient Class Module.
MS Access: a true RDBMS
How to get cursor focussed on field field after new record?
After closing Design View, the table appears instead of form
Autonumber ID not yet visible when starting new record
attaching picture to table
Happy New Year
Erl
Change event trigger
detail section in a report
Licensing versus Customization
Importing Text File that is vertically oriented
After insert of date how to auto jump to next field
Only get 1st record viewed in Report.
DAO peculiarity in A97?
Calculate Date Difference and display message box
rendered date
VBA for ACCESS
Find and Replace against set of rules in 2nd table
Carry data over to new record...
=Iff(([Me]![Gender])="M","Male","Female")
Edit multiple tables with one form per record
Help with blank fields
Help needed with ONLY VBA Code or Query
Year Numbers
Reports
Report / Query Problem
Using MZtools Freeware for VBA
Run Update Query silently in background
Run Update Query silently in background
Create Macro to import fixed width text from clipboard or text file and update table
reset number on new year
Runtime error has occurred
Creating Runtime DBs with Access
move relationships from dev to production db
How can I Display Visio Drawing?
one to many howto????
ComboBox Progressive Requery
Minimized Database window moving way off screen
merging tables
navigate form with arrow keys
calculating age from DOB and adding to table
close form macro
slow query
Combo Box Progressive Requery
How to increase the performance by working with linked tables
Help with SQL query
Clearing a combo box
Hyperlinks inside an Office Assistant bubble?
Hyperkinks inside an Office Assistant bubble?
SendKeys help required
subform refresh
How to import..
Adding a range of numbers from a form to a table
datepart problem in VB code
Problem with DateDiff
add one to string in sql query
Access 97 / XP sharing problem
2 Beginner Access question
Reversing a COlour Code
Sorting a SubForm
Trouble with order by clause in report
Off Topic - Access to Postgres
TransferDatabase problem
Nulling field in subform
Tips to document Access program
Lebans ReportToPDF solution Help
Date Validation: IF's vs Case
Probably a very simple problem, but it's got me...
Adobe Acrobat & pdf.ocx - The Paperless Office
failure in saving new added field
A very basic search form in access
2 queries OK by themselves, FAIL in Union
How to store folder path as Hyperlink?
VB code to perform custom query of MS access table and display alert
Run-time error
Access Report is giving extra blank pages
data in a tex field on an unbound form
trying to copy an Access 2003 pivot table to excel or word .... or something
'Converting Varchat to Int' problem
Relationships
Not sure I understand what Response.buffer is really about
MS Access adding dates
Create Dynamically Built Data-Entry form to enter data into two tables
Timeout while DDE linking to a VB application.
query not working when i add an alias
Runtime version overwrites full access
calling excel function LinEst from VB
Access to VB
How to do a hyperlink inside of ...
Choose Month & Year when giving report criteria
Synchronising/replicating access with sql server
serialize/deserialize Access report object
Choose Month & Year when giving report criteria
Pivot Tables Access vs Excel
Use Select Query variable against a table and return value to same select query
DeleteDuplicateRecords
Progress Meter does not refresh during series of OpenQueries
How to join two fields
Left(field,Numchar) or Right not found
Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
NZ always returns a zero-length string when used in a query expression?
backup databases
Access 2003 unable to link to ODBC but 2002 on same machine can
Duplicate record check
Hyperlinks
Sending SMS from Access
UserForms
forms only show primary key
Scroll bar strangeness on subform
Calendar Control turns white on new record
automatically append new records
OldValue not set
form property for subform
Help required formatting a date field in a SELECT statement results
A2K3 & object dependency refresh
What's with ADO?
Assigning common id based on evaluation of two columns
Select ALL from an unbound form for query parameters
Totally lost on Date Sort
Crosstab Query: Sort Column heading based on other column sort
Cross tab Query: Sort Column Heading based on other column Sort order
Split Database Security Problem
Query has a problem with December??
error -2147217904 - how to fix :o( ?
A2K - passing more than one value into a popup form
MS Access, PostgreSQL 8.1.1, connection string
ODBC, connection pooling
Using seek to find if a record exists
error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
Can lines collection be used to assist me in automatically numbering lines?
GetSetting function breaks when code-signing
Invisible textboxes on subform
Database design question
Filtering on a form
Checkboxes verses field list boxes
How to pull the newest record for each student out of a table
after update not triggered
Opening form in datasheet view
OT. Happy Holidays to you all
CurrentDb problem in report
Need to add trailing 0's
Problem with Left function
Query Shows No Records
Developing in Access 2003 with conversion problem
setfocus to access application
Packaging for multiple office versions
MS Access Send To recipient (not as attachment but as HTML)
A97 Runtime - I wish to disable F-11 key from displaying database window
Sorting many fields in a form
How can I enter several lines of text as a criterion and return several lines from my table?
access 2003 validation rules
lInking subforms
Unable to edit form - Many-to-Many relationship
What is a Library mde/mdb?
on open and before exit events
Access2000 data Entry Unbound Form With Subform
Contingent formatting
Developing in Access 2003 for Access 97 users
Saving information on reprot to new table?
How to stop library mde being reused
Can't link forms
An aid to inserting a Date, Small calender pops up
Scroll bars are not appearing in certain situation.
Customer keeping track of invoices received and paid.
Access 97 Problem: only one printer shown in the printer screen