Bytes - Microsoft Access / VBA answers - Page 37

Crosstab Query and Specifying Selection Criteria
Help on If statment function using a range to input a value in to a text box
Need help with clearing an error message" Invalid Null usage" in Access
VB issue
Formatting an elapsed time that more than 24 hour
Stumped... "Enter parameter value" when closing form with suborm referring to data in parent
Delete records by AutoNumber
Filling table from form using only ID'S
Adding Image with Command Button
Access Table Links
Subreport Question
displaying record count in a message box
Help with identifying possible duplicates
Excel DSN Query
Unexpected error....
Truncation of memo field from Access Form
Hideing Menu bar in MS Access
change field names
Unit Conversion on Reports
gpupdate
comparing two tables
Trouble printing report
divide number with 0 (zero)
255 Character Max When Exporting
SQL HELP
UnOccupied Rooms
Print Reports
Ms Access Data Storing Problem
Transfer Spreadsheet method in visual basic
Hide and unhide columns in a sub-form
Locating an Object using VBA
Can't get many-to-many relationship to work
Unable to close connection to Access database
Pasting Dissimilar Records into One Text File
Lookup Validation Table Help!
Converting Text to Date
Connecting to MS SQL Server
VB6 applications with Access DB slow
VB6 applications with Access DB slow
Opening Excel file from Access
Set Focus on a control within a continuous subform
Exporting data to a .txt file
FTP server Logon hard code via VBA
Need Code for Access Image Box
Need VBA Code to place color on a bitmap image
Can I control open forms of other users?
Updating a field in a table
OLE Object (bound object); extracting
Multiple Tables?
problem with subform linking
Copying Value From One TextBox to Another
Passing an Object (VBA Question)
The Most Annoying Access BUG on WinXP
Report - Expand/Contract Detail Section
diagram
Default value in a query
Left Join Error
Close Without Save
Asp query (SQL Related)
Parameters added to Report
Reports
Access Database Running slow/ODBC failed call
Better Apporach for filtering data from query
Exporting Reports
Select and limit results in one table?
Building SQL in Visual Basic
Relationship question
SendObject - only works once!
Pasting into multiple fields in table entry
How do I requery a subform from another subform?
Requery another subform
Normalisation help
International Database
Conditional SELECT (IF or CASE)
image in report in access
Numbers in Table
Connecting multiple MS Access databases in Vb 6.0 application
code to print report
MS Access to VB
export problem in excel to access
Import Excel to Access
Pivot Table in Access
Pivot Table in Access
Disable the Continuous Form or RecordSelector
edit only new record and disable autosave in continuous subforms
Help on pushing data!
Can't update RecordSource of subform
No current record after delete
Enable subform based on combo box choice
How do you store/manage/present the documentation for your database?
Help required!
How to use a DLL in MS-Access VBA
switching text fields with one another
Access 2007 ODBC & VISTA 64
Fixing the "Couldn't use <filename>; file already in use" does not last
Row Numbering Code?
Why is Design View, Save, & Code View disabled after copying database (.mdb) file.
Compact backend of databse while front Open
Keeping track of changes in VBA Classes
Creating complex spreadsheet from within Access
Setting the Valid From and Expiry Date of Credit Cards
Clear form on exit without table updates
Search for an existing record
Customer Lookup
Archiving files
Access 97 and Vista
How can I autofil the City and State fields by entering a Zip?
Query retrieving wrong data from text box?
Add Field to Table using Access Macro
Initial Form Pop-up
A small MS Access Application Needed
list 4 tasks
Problem with CONVERT function
Design Question
Slow code execution in Access 2007
small lay-out problem
ClickEvent Function Problem
Copying data WITHIN a form
Automatically Link Tables on Database Opening?
Make command button show new record
Date Retrieving Error
Date Time format
Dependent listboxes on access forms
how to extract duplicate records in diffrent tables??
Adding Fields to Form Problem
Determine if New or Repeat Client
Caps Lock as a Default
Find Record Set Based on a Query from several tables
Pass string from VB Code into query.
YTD Report for clients
Output the results of a query to Excel
ask for parameter ?
How to write code for Median
Form Lookup
Login Code
Access-seaching multiple records in a field
Ms Access Error - Need Solution
Ms Access Error - Need Solution
Allocating points to a sorted list of records
Is it possible to make the MDB non-readable after a certain period?
Want to display odd values from a table field
How to average 3 last records?
Survey - storing multiple choice and free-form text
Restaurant Database
Restaurant Database
disable shorcut keys, disable total field
Concentrating form name with string variable
Autofill information from a table
Reports are based on????
"Open File - Security Warning"
Printing a report from a form
A search that opens the subform of another form to a specific record
SendObjects won't execute twice
save record and next record in one button
KeyPreview
Europe Tests Established Chemicals on Millions of Animals
LookupTable with Referential Integrity and Cascaded Updates
I'M LOCKED OUT OF MY DATABASE
Selecting from a date range
type ahead or typeahead buffer on 2003 upgrade
Cannot lock file - solution found
Design-rehaul advice needed from experienced developers
Relationships and _1 Tables
new record only when form launched?
Button info not showing
Populate 2 records based on a comparison of data
Access Relationship help please
Lookup and Text calculation in Access vs Excel
Default FileName with a Save As (OPENFILENAME) dialog box
Access 2000 Security Warning
Show Pictures on a Form
DTPicker read only error
Listbox ListCount with RecordSet
Are there known issues with Vista and Acc2003
Export from Access to Excel
Auto incrementing
Change Color of Background on Focus
Question about SQL
The Microsoft Jet database engine stopped the process
Client Monthly % and YTD
Open multiple instances of a form in MS Access
Insufficient permissions to use back-end mdb object
Access Reports -- Getting the dates to go horizontally and not vertically
User Defined Functions in Queries.
Passing recordset from module to a query
Client's Monthly Revenue and %
Client's Monthly Revenue and %
Flickering labels
Converting from List to combo box
Access 2003 Edit Record Form (record selection)
Wandering, shifting form window
Access 2003-DTPicker
Continuous Form Update (Access 2000)
Examples of Database
Database Question
Monthly Calendar view as report
Showing all data rows in a recordset
Saving form data in different table
Open Access from VB6 program
how to delete a picture using recordset
About Access forms
getting text from number containing "-"
Substrg command in Access
Stop Duplicates
alter table on access module
Increment Transaction NO.
Putting Two Related Records in One Row
Listbox
To display IN time and OUT time in seperate fields
Using wildcards in a SQL statment
validation rule for number
Calculating a value to display in a form based on values from two different tables
User-generated reports..can it be done?
Queries and Parameters
ms access / two-sides printing business cards
Access / Microsoft SQL Server (MSDE) / Oracle 10g XE
Syntax error
Lost mdw
Forms
viewing images in picture manager
Access 2003 Open Exclusive Error
Counting multiple columns
Creating a Table from with in a Recordset?
Automatic age calculation
Access Input Forms - field validations & password over ride
adding products to an order
VBA doesn't like this...
What's the syntax for this SQL statement
Merging an Access database with Publisher
IIf to change the row source table
Help? can't create active componet! Error????
Best Access VBA book?
Draw Ellipse in Access Image Control
easiest way to input data from contact form into access 2003 databse
Procedure in Access
Java Database programming
Query multiple fields
Query
Create Excel Pivot Table from Access module
How to select Highest 5 counts
Search query in access
Strange behavior: Colum disappears in label report
Want to get unmatched query
How to get the Difference Between Two Time Fields?
Set focus to sub form from main form
Referencing to form's field value in query
Add Jajah to Access database program
Value list relationship in table and forms
Authorizing in MS access
A97 + Vista - need "permanent" admin privilege
Center memo field vertically
REPLACE in WHERE CLAUSE
Tab Control and Dynamic subForm Linking
How to make Criteria in a Yes/No Field
how to download your database to a cd
Stock level Query
Access very slow
convert strings to proper case
MS Access accepting column name as parameter
Calculated Form Controls with Access 2007
Scheduling Db - Prevent Double Booking
Start Job, Finish Job times...
Startup Options problem
Access 2007 templates not working
Conventional Tab Control Use.
Pulling Data from Sub Form with an Append Query
VBA code for selection form
Tab Form - Cannot see tab titles
export a pivot graph from web data acess page
Validation If Null and Empty String
Conditional macro is stopping after first action
timered auto-refresh
DB for Web
Access VB Code to assign AutoNumbering Field to a Table.
Sudden issues with a Access 97 database
Basic Invoicing Form Question
Autonumber in data entry form causing blank entries into table
Edit, Reports, Saving Forms/Reports with Multiple SubForms
vb to create right join
How to sum certain data in the same field
Access Database
Access Database
Count number of lines in a text box for a report
PopUp form or Splash Screen?
Combo box add new customer
Tracing Links Problem and Conversion Errors
formatting text nothing seems to fix errors LOL
Summing values from Combo
Query to Sum Values from the Same Month in Different Years
Selective deletion - delete records based on dates
query design help required
Addition of values from different forms
one form for different class with different subjects
Creating a Form with a Date Range
combo box
Group Numbers
Custom toolbar in access
Family Database ?
How to replace empty cells in Access by NaN or -99
Access tab form entry
Making a SubForm Modal when it has Focus
Querying joined tables for blank records
subtract now() from date/time field in query
OnNotInList - tweaking pasted code
How certain is a repair?
Alter Column command
Credit card processing possible with Access 2003?
Help Please
Linking Excel spreadsheet to Access
if statements??
Access Forms-cannot enter data
test
What am I doing wrong?
selecting data only once to avoid duplicating
A Dlookup alternative that will return all values in a string/array
Query criteriea for even/odd numbers
Sub Passing Variables to Query
query help...
Export ADO or DAO recordset to CSV file
Hyperlinking within a Database
Combo box selection populates form
crosstab query and main table
Complex Access Lookup Table Help
Table Help
Header not visible
Delete queries
Saving Excel spreadsheet to a specific location
General question about Access
Quick syntax question
How to get a total of a particular product
Question on form minimizing
Listbox doubles up on directory contents...why? Access 2000
Disable add new rows
Summing the values using multiple combo box in access
Hi all the members
MS Access: Referencing Controls
User-Level secruity help
How To Change Mhz In CDMA phone
How To Change Mhz In CDMA phone
Suppress the "Loading Image" dialog when opening a report
Task Manager 2007 crashes Word/Excel 2003 reports?
Task Manager 2007 crashes Word/Excel 2003 reports
starting media player from an AccessXP form
NoData for forms
Have you tried Access 2007
VBA Code
Getting started with filters.
Error during On Load recordset code
filtering out "#Error"
Trees? Subprojects? Threads? Or How do I sort multiple levels of nested relations?
Creating a System DNS on the fly
Updating a query automatically when changing combo box value
Updating a field's value based on another field
Auto updating a form and a table based on data( drop down) entered in anothre table
Error running Make table Query
Linking two fields in a single table: If Then statement?
Login and Registration
current Data has be locked by another User
Link Problem (#Num!)
Problems With Reading Table In Access 2003!!!
Single Quote in DoCmd ?
Can we use ms excel or ms access to make a software of accounting(balance sheets)?
Querying two tables (1-to-many relationship)
Unification Tables un a Data Base Table
Losing Focus
???Field name concatenation???
Office 2007 export images to rtf?
Capture Mouse Button States and Coordinates in custom function More options
MS-Access 2003 Back End Maximum Users
MS-Access 2003 Back End Maximum Users
FileDateTime
MS-Access 2003 Back End Maximum Users
Stuck on MS Access 2003
Dynamic Query or Dynamic Right Join
Adding numbers in forms
Comparing successive records in large access file - VB help
DAO to ADODB Listbox conversion. Upsizing to SQL
SQL and VBE
List Box Population :))
Can't open mailsession... No *real* solution ??
change user password
Help with UNION query please?
deducting a number in a field on a form from a table
activating another access application
Adding a new record in a form problem
Trying to create an invoice from access and use oulook to email
Problem with Shell32 and filehandle
Array of bytes
Import Data into MS Access
How do I programmatically import text, excel and mdb files in to an existing Access
database distribution
form help please
Access Drawing Rectangles in Excel
DAO version
Inserting unique data from one table into another
strange issue...
Populate Text Box with values from another table
database access error
overflow error
Form to dynamically allow user to add/edit lookup tables data
Custom Context Sensitive Menus within MS Access
Delete record in subreport
Microsoft access/visual basic- database lockout between users
MS Access on a web farm
access 97 in vista
Login page should work, but....
Split the DB, how do I deploy the "Front-end"?
Acces report to excel
Access Forms "Write Conflict"
Update part of a data string with an Update query -ACC97
Save data in new field
Hyperlink troubles
urgent Help Needed With Access Db
2000 and 2003 on the same machine
2000 and 2003 on the same machine
Search Number Two
Built In Search Dialog...
INNER JOIN argument doubled?
Access Export in Vista
Auto populate field in access form
Update Date
Report duplicates
Adding up hours and minutes problem
Asset Information Database
form to enter data on several tables
Combo Mess
Comparing 2 tables letter by letter in Access
Update or CancelUpdate without AddNew or Edit
Can't trap error in called routine
referencing controls in other forms
Access 2007 Ribbon - Delete Home and Help
dificult
Relationship
Using Winapi
Subform Record Problem
Having problems with forms
Table Relationships for a Report in Access 2003 DB
Limiting a list box to a query, in a subform made of two tables
Scheduling a Daily query to run at midnight
Can you put a filter expression on a lookup?
programming colorcode in forms
Sorting Numbers in Access97
Can't open mail session
Importing Multiple Databases from one folder
New to Access (3 Questions)
Set Up a ComboBox
Changing Date Type when importing Excel spreadsheet
Changing Data Type when importing Excel spreadsheet
Clearing out Date Variables
Dates problem
Autopopulate form field from another table
Clearing out Date Variables
linking databases in two different countries
Double Booking Problem
Linked outlook calendar table
Renumbering two fields in different tables at once
Double Booking Problem
I need help with profit/loss for my database
show minimized specific excel workbook
open self database
Date Format
Convert a date to a text string
ERROR 3612 - multi level group by clause
Question about tab control
World Funniest Video
A reset Button for an Access Form
Linking FE / BE with code using a browsed Path.
MS Access Query monitor
Update Data in Table
Building OnClick event code for command button on data access page
removing line between form header and footer?
CommandBars behaving strangely
Access Distribution in Multi user environment
Export search results from Form to CSV (macro)
What stands for not selected in a Yes/No field?
Combine date and autonumber field in Access
Upsize to SQL wizard question
Slight Changes cause Run Time Error 2465
preventing users from accessing tables and design
Search Form: multiple controls (Access 2003)
dynamic chang of treeview height
Search...
multi primary key using vba.
figured
Basing one combo box on another...how many levels can it sustain?
Shell command and File Not Found
Import tab delimited multiple files using VBA
How to reference field from table
Using Access/Jet databases and forms/queries on the Web
Macro for splitting a field?
code to add user to workgroup
Insert a Round shape
Error Handling while Inserting data
Report Window Buttons Have Disappeared In Access 2007
txtbox 2 combobox using vba
Access ODBC change
Error with INSERT INTO statement for Access 2003
European time
IIf functions in forms
Required filed error messages
Auto-populate drop-downs
OutputTo Word/Excel 2003 Causes Fatal Error
How to: Start Word 2003 from Access 97
How to: Start Word 2003 from Access 97
Count the number of times something shows up
is there something I have that others don't....LOL in the access database that is
export database from MYSQL to Ms Access
Class returns 440 - automation error
Help with access query criteria
Ms Access Dates
What are the first steps to using Access as a front end?
Access 2007 and SharePoint 2007 linking issues
Divide by 0 or null
SQL Command help for Unique records.
Using a colon ":" to Seperate Statements
Convert lotus into a database
Compute Difference in Dates in Access
Call access vb from another program
Common Dialog Control Error
Report only pulling a couple of records.
Difference between dot and bang notation?
trying to force a combo box to update
Using a Do Until Loop to search for and modify data in a table
Access 2000 ADP project
Calculation in an Access Report
Linked image will not refresh when image property is changed.
How advanced is Access?
Order nr in Access
Tabular lists in Tabbed forms
Numerowanie z³o¿one w MS Access
Repetitively asked for parameter value
alert - windows scheduler
search form using combo boxes and relates tbls
Problem with Multiple entries
Printing a hyperlink field (e-mail adress field)
Printing hyperlink fields
Perform an inner join between two tables
Identify cursor position, in query or table windows
Lookup Value loop
Relationships... who needs em anyways?
ShortCutMenu OnAction Show/NoShow Button
Please confirm my understanding for minimizing BE to FE data transfer
auto update form value
Access 2000 visual basic code runs too fast for backup to complete
Close the form with out saving
Access Record Locking
access message box/ VB code.
Type Mismatch Error in Recordset Where Clause
How to Activate Input Mask When Tabbing into Control
When to use Form Activate Event?