Microsoft Access / VBA Answers - Page 4

Send return to a form field from VBA
Loop not reading last record in Query
Passing a date variable to an SQL stored procedure
how to duplicate a record which is selected by a query using a button
variable uses an automation type
Is it possible to disable the CTRL-A key in Access 2013
Filter a query, based on multiple lines of text entered into a text box.
OpenReport using a field name from a query
Need a msgbox to display when a record is not found
Updating MS-Access Table using SQL Query
Email Report using Send Object and recordset
Application Focus Lost when returning from Access Modal Dialog
Message box to alert if changes are being made on a form/subform
Parameterizing top N in query MS-access 2007
Add pictures to an access report for parts where pictures are store in a directory
Report from the Switchboard will not print
If Then Statement Looking at a Field with Multiple Values
print a ms-access 2007 report on an image in memory
Is it possible to create a message box in a macro to display comments but not require
Fingerprint database interpretation
How to move multiple records about same person to one longer record?
MS Word Drop-Down List with MS Access Data
Display zero as dash on form while retaining the value of zero?
Choosing between subreports in a report
Disabling Close Button Temporarily
Join Table to another Crosstab Query
Dynamically changing the control source of a field
How to Lock Form only excluding subform TabCtl in Allen Browne's Locking Bound Contro
Trying to combine two pdf using access vba...
Automating adding attachments to email based on MS Access query
Clear Form Fields and ReQuery
Issue with locked multi value comboboxes
How to generate sequential code
Writing an IIF Access statement with an embedded IsNull statement
Looking for an efficient way to build a report
crosstab query dynamic colums date range in days
Undefined function 'Date' in expression.
Retrieve table name from a list box rowsource
How to loop through a dynamic jagged array?
lookup
iif statement involving a check box
Pulling unique values from a query to use in a form to run a report...
Trying to change data type from number into Autonumber
Passing a recordset to SQL
Error: No current record (with array)
Microsoft Forms 2.0 frame - adding images
Need to get rid of the green color"the number in this cell is formatted as text"
Optimum Batch Size Selection
Find Records in Main Form Based On Subform Data
Include fields from 2 tables on single form
Strip Ole Object header and get picture out of it.
Getting a table name from a listbox/combobox with variable tables
count filterd records
Setting the Value of a Checkbox with VBA
Stumped by the Calendar
Unique Identifier
How to ignore certain Customer Numbers and increase a certain kind incrementally?
Single value INSERT from code produces no result
BeforeUpdate Issue
Loop through the cell and give the anser
Minimum Value (Date)
Total hours in Report over 24 hours
Invoking Crystal Report from Access 2007 causing error
Running a stored procedure from Access to populate a local table
Changing date format In MS access from d/mm/yyyy to ddmmyyyy
Help writing IF/ Else statement in Access SQL query
MS Access returning a value from a stored procedure
Embeded Macros or Events
Handling multiple units..!!
Troubleshooting NonOutlook Email Code
Insert logo into E-mail from Access VBA
VB Code to create email from different outlook templates
Possible Coding Problem - Need Help
Dir() giving odd results
To repeat a record 'n' number of times
Store different groups of multivalue lists in a field of a table in MS Access 2013
Return the Greater of 2 Dates in a single column
How to use Input Mast in SQL Statement
current record lost
Passing an entire array to a query
Auto Number Module for Query
To Quit or not to Quit
adding new record using VBA into existing access database
bank holidays on Monthly Calendar
Transfer MS Word Form data to MS Access Tables
Part 2: Macros/VBA created in Access 2003 not working in Access 2013
Combo box linked to foreign key displaying field in primary key table?
Ranking on multiple fields
how do I force the first letter to be a capital letter in access?
ms access 20103 filter or search cannot support khmer unicode
Module Compiling Issues
Repaint onCurrent not working
Macros/VBA created in Access 2003 not working in Access 2013
Problem with running balance
Select Case Help
unique comboboxes
global Database
VBA Module(Access) exe32-not-closing-in-task-manager
How can I get a VBA module to export the results to Excel
skip duplicates
Expression
open query or report with docmd
work with two recordsests
Records Incomplete status
How to synchronize a main form with its sub form
HHCtrl.Ocx Errors in Rich Text message Box
To control excess Inventory Posting
empty recordset
print form
how group dates to min groups
filterd continuous form
how to make "12/02/2016 6:00" as "12/02 6:00" thanks! ;)
Inputbox in Access Report to open only once
Combo box that stores values in multiple fields.
Union or Otherwise Combine Multiple Delete Queries
Appending Consistent Number of Blank Rows to Report
Who is logged on to BE database?
Linked table in BE Database
Structured form
Access 2010 Transpose Help Needed
Hide a Row @ Report ( Access 2010 )
VBScript import data table Employee using odbc connection and save as msaccess data
Macro is failed to find specific record on the second try - Access 2013
How to sum up the time more then 24 hours
copy selected part and past in other field
Query two tables and duplicates with wildcards
Unable to get results using criteria in same field in multiple tables
Transpose data while repeating the Product Names
2501 SendObject Error - Error Trapping Not Working
Make search result records clickable
How could the ESC key triggers private sub( cmdCancelRecord_Click()-for example)
How to Count the number of fields in a form when form is updated or filtered
I need a code to enter "1" into a field in my table when a toggle button is clicked i
Auto fill a field in unbound sub-form datasheet
How to filter using combo box
What is the code to open a new form upon a commandbutton
Moving an Excel formula to calculated field in Access
Any suggestions of where to learn Access?
How To Continuously Update an Excel Spreadsheet at the end of each shift
MS Access Datasheet Views with a different look
How can I export multiple files from a single table using a field name as the file na
Who is logged on?
how to get result in year month and day between two dates?
Controlling Excel through Access VBA
VBA - Random Cell Filler from String List
Instr not working ???
VBA Create Delete relationships
How do I fix my too many fields defined Problem?
Excel to Access
Access beginner: Have Access show prompt window when duplicate entry already exists
Complex join problem
Need Help on Various Small Issues
Table showing number or records in each report for each day
auto complete
pass paramter for recordset
Can't see memo fields lists as available for combo box
Enter a text from Form to another Form
Automatically create records between two numbers
How do I calculate overnight hours in Microsoft access?
Easy Update Option Group
Code found not sure how to use it exactly
Attachment Fields - How to Query Them
Multiple back ends, single front end
How to compare 2 tables to update price and to find extra parts in either table
How to make your form browse through records on your table?
Problem with listing recent opened records
Gmail via CDO with clickable button
how to view large preview of an attachment?
Run 64bit MS Word from 32bit access
Date format from VBA Added to Table not correct and date is changed.
Why is the first record of my subform not saving?
why is my cursor in my subform on the first record and clearing it
Is it possible to set the value of a yes/no field based on dates?
Count Iif with Not Like in Access Report
Invalid Character when exporting to XML
VBA Date Problem
Form to filter reports
Open Report based query which based on Values in Form
Rich Text Message Box Cursor problems.
Result of DAO expression visible as a new column in a table/query
How to determine that any report is active/open or not?
How to add a custom command button tho the default shortcut/right-click popup menu?
Unstable Access
Show a tab of a custom ribbon in ms access only when a report is opened...
How to filter list box so it eliminate items selected before
Access Form is becoming selective on fleld data it adds
email link in field only working on 1 of 3 forms on same database
Problem with Union Query
Get RecordSource of closed report.
Applying payments to invoices to report outstanding debts
Numbering duplicate StockCodes
To create students attendance form in access 07
non standard text import
referencing a non-bound column in a combobox in a macro
Bad Outlook on Access
Report Filtering: How do I Manage 100s of Filters?
Macro/VBA for selecting a value from a bound combobox
Reporting on single gift and cumulative gifts
Leading zero's variable number length and variable number of leading 0's
How to create an in form Calculater
convert Multiple rows (same name) that have many collumns of data. convert this to 1
Characters truncated when using Allen Browne's function "ConcatRelated"
working with external databases
Clear Contents of unprotected Specific Range in a protected sheet
Removing Blank Cell info when save as xml data
Joining Multiple Tables with "LIKE" Data
Reverse page printing
Report page chronology is not maintained with the data table
Program Crash
Update query - missing table field name drop down list
Multiselect list box as query criteria?
Has Anyone Attempted a Report for a Class Attendance Log?
Report - Sort by Percent of Total
Open file like textbox entry
Problem with updting forms
Format zip code in numbers
Basing a query of a text field and combo box in a form
Hyperlink Problem
Convert
Keeping historical Records based on the changes one field
multiple Dlookups for looking on values in multiple tables
Specific Query not loading after bloat
Setting Automatic Dates from a roll in Interval
Finding a piece of code
how to consolidate or merge two rows of data into one row in query result
How to merge tables?
Need help with combo box loop/open report
MS Access text field in form is autopopulating but shouldn't be
Date() not recognised
best way of doing a double query?
How to open Access from the old drive?
Help! I am trying to share a database between 10 users
Subform linked to 2 separate tables
Can you put a button and a toggle to lock and unlock for a certain field in access
Call Tracker MS Access Template
MS Access 2007: 15 years Of Contract
Syntax Error in data validation
Search form with combobox
Elegant way of getting multiple results
MS Access database grow issue
Updating an open form after entering new records
Filtering a report from a sub form
Help with counting visible rows after filter in excel
Filtering Table field in Form using Check Boxes
Group by data found in multiple fields
Need help with SQL statement for copying subform data to a new table
Tab Control Loses Sections after Switching Pages
Properly creating a form without using a subform
Using a Form
Optimize Query
Selection Criteria using multiple combo boxes on form witha subform
Excel backend database and HTML frontend
Database search form / query not sure what I need
multiple search in a single field
Auto birthday reminder in access 07
query with more than one table
Textbox Calendar Limiting
Checkboxes in Forms
Text box in Access report with controlsource from form only shows up on first page.
Expected line or label statement or end of statement
How to calculate the number of working hours each month in a Access query?
Copy field contents to another field based if a totally different field = true
Copy field contents to another field based if a totally different field = true
Cursor position in subform
Cascading comboboxes does not allow selection of all values
adding hours + minutes with dateadd function
Database diary, start of the week is Sunday how to change to Monday
Run Time Error 3075 in my SQL Insert Into
Is there any alternative way to write this query because it causes ms access to stop
Function and Nested loop
How to remove quick access toolbar from access application
Lookup field linked to access database not refreshing
Daily Number and Date
How to remind the user to re-enter the correct date
Code to replace SendKeys in My Code
Update a Field in One Table if There is Data in Another
Access 2013 Runtime
Help about Round() function
Subform doesn't show any records
Send SMS via Access through Internet?
Help in report
dcount or DAO.recordset?
How to open a record inside a horizontal tab with a subform in it.
I need help with Microsoft Access
Validation rules for two clculated fields in a form
calling a sub from another sub and assigning value
ComboBox modification of Table
On.Click button updatte field in open form
AES Question - VBA/Excel
Invisible tabs in Access 2013 runtime
Form not accepting data entry (sporadic)
How to Select the Highest Number or Date
How to Display Intermediate Cumulative Sum By Page Footer
"Make Accde" fail...
Table Loop and New Column in the same Table
Code Worked as Macro but not completely as VBA
How to Reset a report back to default state before closing report
Passing a PK to another table
Changing MDI Background in Access 2010
Sharing a Microsoft Access reference with multiple databases
Export data from a split form to excel or pdf...
Declaring API functions in 32 or 64 bits
Please help me with recordset!
VBA to Populate Table (Update)
If statement to run Message Box
Membership database - need to update usage with Check In button
Error using script to select and print reports in Access 2007
Search function using multiple non-consecutive keywords
SQL query in ms access VBA creation from MS Access Form using Multiple Table Fields
Missing operator in query, DLookUp()
Advice on Normalizing Database
Multiple If statements
Looping an OnError until duplicate error clears.
Format Autonumber
update multiple records
Filter A record with date lower than MaxDate
Using a command button to change state of a value in a field
Countdown box on a form
Aggregate functions
Display a Number from a Report into a Text Box
How to display SQL query results
Many to Many Database - Displaying query results as one entry with multiple categorie
Call calendar from code.
query Double Id's on partial match
Counting values in a table row
Populate form from specific cells of table
2015 was a year with 53 weeks
Separate month and year input to become one field
Relating a primary key to two fields in another table. Can I then query either?
Changing Lattitude and longitude specficness
Show Multiple Columns from ComboBox on Report
Force my Database to Open with Runtime Only
Data entered via a Form not "sticking"
Query, to obtain only last record from child table.
ListBox Sort Records - With out using Command Buttons
Random selection of questions from tables.
Grouping time in intervals using Partition Function
Daily Averages Crosstab, non-standard day
Using last date with beginning and ending date
Else with out End If Error not clear.
Create table in Word Document From Access using VBA
Combobox to fill Listbox
Adding a field to existing table in access using vba
Access 2010 run-time error 3201 cannot add or change record
How do you reliably use RecordsetClone function?
Button to fill field for report
Using one access form column to filter another.
Open blank form (dataentry), but have existing data still searchable
Crystal Report parameters with discrete value dialog box pop up.
Error when testing condition of CheckBox
I cannot get this Access query to run. Can anyone help?
Update data automatically in form.
aggregate / subquery help
Preventing Duplicate Entries in a database
Button to fill Word Document
I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog
Search Form
Yet another insert syntax error 3134
Clear Command Button then Requery Subform
Extracting data form HTML using vba in Access
Declaring a variable used in multiple reports
Tree Code (Element not found error)
checkboxes on form to run query
Click a button and search a query based on item in datasheet
how to make a query doesn't show the records (null) ?
Checkboxes and BeforeUpdate Event
Create a Standalone Access Database
Automatic update of data to minimise errors
how to combin two tables ??
The object doesn't contain the Automation object....
add fields to a form from a table with criteria
Order/Stock Control Database System
Comparing Related Records
Cancel SetFocus on Text Field When Hitting Exit Command Button
Displaying Records in X Rows and X Columns on a form
In VBA Access receiving a feedback from the printer that report page # is printed out
how to only show the records that entered today???
Sum Across Columns in Crosstab
mousehook dll is missing the program to fix this problem
how to filter a certain record to view in a report ??
how the access report shows only the last record in the table ??
How do I count gender if a checkbox in another field of a table is checked in access
How to lock textbox after the file is loaded on it
Normalizing a database for the first time.
how to view report single record per page
Send 2 Queries in 1 Email with DAO recordset
VBA Code to verify data
Complex Search for words in descriptions
Why does VBA code work after "Save" but then not after Exit?
Syntax for the table to get the bin code and qty
MS Access 2013 - Custom Ribbon won't work
how to filter report based on the list you selected from listbox in a form?
How to assign an Outlook task with Access
Inner Join Openrowset in VBA for AS400
Export Query to PIPE delimited text file
How do I set a query's "Use Transaction" property to NO?
programmatically update linked table locations?
Read Log and assign Logout time
How to add details from form to existing row in the access table?
Calculating Project Hrs to Employee
Using Recordset to edit a table
Simple login form w/ different permissions?
Subform report with parameters
Query not updatable...
Update table in as400 using table in excel worksheet
error 3048 can not open any more databases ms access query opening
Inmate Confined List Hide Old Records from Current Ones
Drop feature of the Hyperlink box not working on form in MS-Access
calculation fields acts abnormal
delete reverse duplicates
Does anyone have a favorite Units Conversion Function written for VBA?
Row Source Query in Navigation Subform
How to update/replace values in one table with values from another?
Print button set to default printer setting
How to find a record containing latest date?
Join multiple tables with a query?
Display current records from Continuous form in Report
Exclude carriage returns from expression if they are not needed?
How to change combobox query on click?
Ignore blank columns and line space in query return?
Adding a subform to a Data Entry main form... subform greyed out
Auto log users in w/ AD credentials?
Like operator with unbound text boxes
Separate table for IP Addresses??
Importing data from multiple Excel Worksheets
Dlookup works on all forms, except one.
Report Filtering Issue
Expanding a number range from AC data entry form into table
My iif statement won't work in access - trying to write a simple iif statement
how to convert text to number in excel query
dsum returns null value in a text box
MS Access Calendar - Need help with parameters
modify a form and subform
Select lowest two prices from item list grouped by item id
Only One Record Showing on Report
Table Gridlines Turning Green
Main form ID to subform using Access 2010 vba code
Rich Text MsgBox
Union Form Alternative Image Controls
Modify records from form
Update incremental values in one table from fields in multiple tables
Too Few Parameters Error Confusion
Access Multivalue Lookup field - query works... until called from a Form
Difficulty to create a search box
Loop through records in a bound form
specify folder for save as pdf from print preview ribbon
Change Font in Form's Caption
why i get sometimes the message
Macros, VBA, etc disabled. How to call 1 of 19 subforms from a main form combo box?
how to unhide a hided module in an Excel file?
Is access the best for administering quizes?
Macro pop up reminder
Date search error
Generate primary key with actual date & increment number
Clearing a Javascript Message Box from VBA
Near Surrender! Can't "lock down" database.
Wildcard Fields in VBA
Display an Image on a Report using OnCurrent Event?
Very little Access experience -- Need to keep newest or last line of information whil
Totaling columns of dates and then dividing by the number of
Import CSVs and location from multiple folders and sub folders
Combo Boxes on subform not syncronising
How to add fields, that are not database fields, to an XML out put file
How do I make a connect string for a iSeries Access ODBC?
Need help clicking an HTML button in VBA
FindNext for multiple criteria not working
Insert textbox in Word Document VBA
Need to Split 12-Digit Number Field into 12 Separate Fields
update code for use 64 bits systems
Auto populate empty field
loop through records then add record if none exists based on 2 criteria
search matched and unmatched records
Compare 2 Tables and show how many records do not match using specific criteria
changing control formating if it's value changed in form
DISTINCT not working as expected
Parsing HTML to find format of each word
Formulating Join statement
Record Not Showing in Query When One Field Contains No Value
Single Handler for the Click Event in Multiple Controls of a Form
Function Cycles Multiple Times
How do I make an email with attachments go to the Outlook instead of popping up?
...as expr1,
MS Access VBA OpenReport on screen does not use Grouphead0 and run Select Case
match full field from 1st table to first 9 characters in second table
Menu Bar Formating
Handler for multi Command Button, to make the code shorter
Error Changing DB Properties
Convert large IIF Expression into a Function.
Saving query results into Source
error in sql
Filtering/searching through records
Multiple Searches
Date Functions
Schedule Access Macro to Run Weekly
SQL doesn't recognize a Form Control
How to: Combobox text inserted as part of a texbox standard message.
create function
How can I select line items from a query and append them into another table?
create view duplicate
Automatic Numbering of Records in a Form
Queries Totalling Balances Based on Time/Date
MS Access 2007 VBA: How to go through records in one table and compare to another (bo
Update query (VBA SQL) to replace part of the field
code works in one form but not another
SEARCH without Continuous Form
Add criteria from counting more than 2 field
How to Sum Combo Boxes in the Web App?
Adding Multiple Records to SubForm
Multiple Forms or Hide Controls?
Microsoft Access Forms: Japanese writing Write Conflict how to fix
DLookup Expression for a Form controlled by a table that has ProjectNo controlled as
Drag-n-Drop Filenames with special characters (öäü) into ListView
Count different 2 field in 1 table at Access Query
Showing Individual Calculated Values in Query
Convert a database from accdb to accde
Copying Control in Continuous Form
Memo field will only hold 50 char in subform, but more as form or table
Change Form Record Source
Converting decimal to time
Please help. ref sending multiple emails in access
Hide & Display Splash Form
Partial string match two columns
Runtime Error '2501'
Closing all open objects
database access deny error when VBapplication
Requery Combo Box Automatically From A Query
better display of results
Add a year to formula in MS Access 2003
How do I set a checkbox to equal a text value?
error in UPDATE statement
Multiple criteria from same fileld with combos in Form
Changing Image Based on Field Option
Outlook Linked Access wont quit
Need to have a button disabled until a field is populated on a form
dlookup in form that returns the closest value
Barcode 39 fonts
refresh/requery data in subforms
Deploying a Multi-User Access Database with Different Needs on Different Front Ends
Referencing a public variable in MS Access
I want to use the value in a text box on a form that is unbound to a bound field of t
Pull file details and extended details into a form.
Access VBA to Address1 & Address1 but Check for Partial Match
messge box for certain codes on data entry into a form
Append Query
DIR() throwing run time error 52
how to close the form after the last record?
Subforms
Filter a form based on two fields from click of button
Error Number: 3010
How to fix "has a function containing the wrong number of arguments" error?