I have a query that gets me the totals sales per item. I have a tblShowSales with items (From a drop down list, I believe I should NOT be using a drop down list, correct?) and the quantity. The query Groups the items, and get the sum of the items. But the problem I have, is that the query either A( takes a LONG time (10-15 minutes to run) or B( doesnt run at all and access crashes. And before you ask, yes I have the fields indexed. Also tblShowSales has only 13K records, ive seen people complaining about this same thing is 13M records. So what im I doing wrong?
Query taking WAY to long to run
Inscription à :
Publier les commentaires (Atom)
Labels
- .NET language Walkthrough (training) for MS Office 2013
- "Drill Down" Multiple Field selection
- "duplicate values in the index
- "New Product" Form wont open
- "This Recordset Is Not Updateable"
- "We" are not wasting our time here.....
- [SOLVED] ?????????
- [SOLVED] ?????????_??????????
- [SOLVED] ???????????
- [SOLVED] ??????????? _????
- [SOLVED] ????????????
- [SOLVED] ????????????-???????
- [SOLVED] ?????????????
- [SOLVED] ?????????????_??????????
- [SOLVED] ??????????????
- [SOLVED] ??????????????_????
- [SOLVED] ??????????????_??????????
- [SOLVED] ???????????????_??????????
- [SOLVED] ????????????????
- [SOLVED] ????????????????_????
- [SOLVED] ????20????????????????_????
- [SOLVED] Access Linked to SQL Server partial failure - is there a known limit to query
- [SOLVED] Air Classic BW Kuwait
- [SOLVED] case-insensitive text
- [SOLVED] cheap nike air max ltd
- [SOLVED] Checking the box for only one record
- [SOLVED] Combo Box Conundrum
- [SOLVED] Convert OST to PST
- [SOLVED] create query finish distace xls
- [SOLVED] Data Entry Form help needed
- [SOLVED] Delete record problem
- [SOLVED] Good or Check formula in Query
- [SOLVED] Index or duplicate key violation
- [SOLVED] LOG AND CODE Formula
- [SOLVED] Matched Query
- [SOLVED] Need help with text field comparison
- [SOLVED] nv13phd4
- [SOLVED] OST to PST Conversion
- [SOLVED] Passing Datasheet Value To Another Form
- [SOLVED] prif4qja
- [SOLVED] Problem with DoCmd.TransferSpreadsheet
- [SOLVED] realatioship in query
- [SOLVED] Subreport group heading repeats after every record
- [SOLVED] Subtract 1 month from a date
- [SOLVED] uaf0ai1y
- [SOLVED] uynqffke
- [SOLVED] VBA to open Outlook
- [SOLVED] vvyn2dfq
- #name?
- #Name? Error in calculated Field
- #Name? error in unbound
- #NUM! Replacement
- % of late/early
- 1) with VBA
- 10 U.S. senators seek investigation into H-1B-driven layoffs
- 2 different outcome using the same bit of code?
- 2010 Questionairre tracking question
- 2015 June Access Seminars in Denmark and Spain
- 256 char limit from query
- 2950 error in Access 2013
- 3 page report
- 3rd access db won't open at runtime
- 3rd Party API - Can Access 2010 handle this?
- 424 Error on Field to Word Doc Merge - Please Help
- 64Bit app to run on 32Bit OS
- A CMD button to clear a table column
- A form to add
- A form with buttons to store actions and dates?
- A macro that opens Exports the selected data to a form
- A query with Distinct against a SQL view with Distinct truncates string
- A way to accurately size a pop-up form
- A2003 Samples
- A2007
- Accdb to Accdr and Runtime? / Updates?
- Access - Get subForm datasheet value of row
- Access - Query when DataSelected
- Access "Anti trim"
- Access 2003 table data import into Access 2007 Table
- Access 2007
- Access 2007 on Cloud
- Access 2010 - Referencing a 3rd party interoperable provider from VBA code
- Access 2010 and Open Office
- Access 2010 Bug in Packaging Wizard
- ACCESS 2010 Update Query Not Working
- Access 2010 v Access 2013 - does FORMAT work differently?
- access 2010 vba help
- Access 2010/Visual basic
- Access 2013 bugs?
- Access 2013 Navigation Buttons and Quer
- Access 2013 Web App - Requery Problem
- Access App (not web app) on Sharepoint
- Access based database
- Access Crashes When Connecting to DSN
- Access Database Password protect how to
- Access DB W8 network Connection lost
- Access does not break on Errors
- Access Error: You dont have appropriate permission to perform this operation
- Access Export issue
- Access FE SQL Exress BE securing
- Access Image on Report - Poor Quality
- access on sharepoint
- Access QRY
- access query
- Access Report only printing some image files
- access security
- access sql
- Access Table Linked to Sharepoint List
- Access to Excel is getting slower
- Access Update Screen Reg Key
- Access VBA Crashes
- Access Web 2010 - accessing Sharepoint Author and Modifier
- Access Web App New Email Function Query
- Access Web App Questions
- Access web form
- Access.References Name or Description
- accessed from form
- Accessing a split database from home
- accidently entering the same value into combo box
- Achieve Data
- acNewRec or Me.Recordset.AddNew ?
- Activate
- Active Directory/MS Access VBA Issue
- ActiveX in report
- Adapting Access frontend to new Sql backend
- Add
- Add a filter to a subform
- Add a textbox value to a value in a table
- Add different fields to a form
- Add field to Linked CSV directly
- add multiple records at once to a child table from a form
- Add Narrative Based on Other Field Values
- Add new field in every table (100 tables)
- Add rows to a table based on record count of another table
- Add Same Field to Multiple Forms
- Add sums together in report
- Add two fields and store in another field
- Adding Subdatasheets from a table to a form
- Adding table to back end using VBA
- Adding text boxes in form
- Admin Menu
- Admit and Discharge radio buttons
- Advanced search
- Advice on Connection - where should it be?
- after requery?
- After Update on Form Open with Openargs??
- Aggregate Query HELP
- all records for last "monday"
- Allowable postings question
- Alphanumeric Sort Order
- alter table with autoincrement field
- Alternative to AutoNumber
- Alternative to SendObject to achieve automation
- Am I doing this right? Scaling up database to cope with 35+ users
- Amortization Schedule
- and a popup for Multiple Entries...
- Annoying ‘Enter Parameter Value’ pop up
- Another CDate() question
- Ansi sql
- Append data from one table to another
- Append data to table
- Append Query - Unique Records
- Append Query depending on check box
- Append query does not run from code
- Append query for temp table
- Append Query not appending entire table
- Append question
- Append table with autonumber primary key
- Appending records
- Application.printer very slow
- Apply filter to subform
- applying one text box value to collection of another text box
- Appointments
- Appropriate place to find a developer?
- Archiving Data - Best Method?
- Are 2 forms required for new entries and edits
- Are games a fun source of Information?
- Argument Not optional - But no reason
- Array Index / Offset Query
- Ask for help in the relations between the table
- Assigning Alphanumeric "Request ID" Based on Form Drop-down Selection
- Assistance with UCase and person surmanes
- associate items with 2nd names
- Attachment
- attachment data type in SQL Server 2014
- Attachment Field
- Attachment links
- Attachment storing in file server
- Attain the week number beginning at the current week
- Attendance By Class Form
- Audit Trail
- Auto Create Emails in Outlook based on Data in Access
- Auto create word letter from access report or query.
- auto fill
- Auto fill leading zeros
- Auto Height of Subform on base of records
- auto insert date when anothe field is changed.
- auto populate a date when clicking on another field
- Auto populate date in field based on selection in combo box
- Auto resize memo field in subform
- Auto-populate current date and time when other fields completed
- Auto-populating form
- AutoCount
- Autofill a textbox with curent date.
- Autofill on variables
- Automate the row selection criteria
- Automatic Alphanumeric Increment field
- Automatic date entry for field changes.
- Automatic increment and reset
- Automatic mail to be triggered from Access
- automatically have checkboxes cleared the next day?
- Automating Emails
- AutoNumber Set
- Back-end encrypted with Password Issue
- Backend files - accde or accdb
- Bailed out Royal Bank of Scotland pays Huge bonus despite 3.5B in Losses
- Ballot results capturing
- Barcode in Subforms not readable
- Been a while !!
- Beginner trying to create a database
- Best Dating Site for Hot boy & Girl
- Best Free Online Dating Apps
- best version
- Best way to accomplish bulk add to a table
- Best way to edit Calendar Form
- best way to update a combo box after adding a new record
- Beta Tester
- Between Date() And Date()
- Between problems
- Bigger... plusses?
- Birthday Remainder VBA...
- Blank Fields and Tables for Future
- Blank Form
- Blank out name last typed by user in a drop down box
- Blank Spaces in Listbox
- Breakup a Table
- Bring form to front in windows
- BrowseTo opens form as NewRecord depending on opened record
- Budget table design
- Budgets...
- Building a new database
- Building FE-BE Database
- Business Day Code HELP PLEASE
- but not computer B
- but VBA emailing same report = 4 pages (bad!)
- Button overwrite last record
- Button to go to desktop from form
- Button to launch a form from a report
- Buttons for Navigating Datasheet
- Bypass Access Message Box - Not In List
- Calculate multiple fields for one result
- Calculate Next Monday
- Calculate total number of days between two dates in a query
- calculated field in a query
- Calculated field using time
- Calculated Fields not Updating Automatically
- Calculated fields not working
- calculated text field
- calculating a date while taking into account holidays
- Calculating a Percentage in reports
- Calculating average weekly hours
- Calculating Fiscal Year Sales in a query
- Calculating Hours Minutes from Decimal
- Calculating Sum in Query
- Calculation in a QUERY
- Calculation through VBA
- Calculations
- Calendar in MS Access 2007
- Calendar Synchronization - Access 2010 to Outlook 2010
- Calendar/Appointment database
- Calender
- Calling code form another form
- Calling commandbutton_click event from a module
- Can Grow in Report
- Can I create a report a little like a cross tab query but without adding anything up
- Can I create a report a little like a cross tab query but without adding anything up?
- Can not share the back end data base under Multi user enviorment
- Can someone help me with why this code isn't attaching the file attachment?
- Can you export a report without page breaks?
- Can you put a custom button on the QAT
- Canada
- Cancel appointment
- Cannot locate source of table references
- Cannot open database with 2013-How to upgrade mdw
- Cannot read from forms
- Cannot run Union query
- Cannot typ in fields.
- Cans and Bottles - OR - Cans or Bottles?
- Cant Go To Specific Record Error
- Captions on form
- Capture picture from webcam
- Capturing Who Amended the data
- Cascading combo boxes (multiple filters)
- CDO message Error Number - 2147220973
- CDO SMTP Email Relays
- Challenging import into access
- change and search/look up records.
- Change Command to Toggle - Run Time Error 2115.
- Change formatting of an unbound text field on continuous form
- Change ODBC Connection of a saved query using VBA
- change record that is part of composite key
- Change the display of field values on a combo box
- Changing linked table names
- Changing recordsource
- Chart and Pivot Table access 2013
- charts
- Check Box Problem
- check entry is new versus lst box
- check if a field with number data type is blank
- Check if All Forms are closed
- check if there is connection to server
- Check open database in vba
- checkbox password
- Checkboxes Choice..
- Checkboxes showing on report (Print Preview)
- checked or unchecked?
- Checking For Blank Textboxes (Variables)
- Checking for special characters
- checking if textbox value exists and then going to that record
- China
- Choose between test and live back end files
- Ciao from Italy
- Circular calculated control?
- Citrix - Spawning a IE or Exe directly on client system
- Class variable resets when adding new record in subform
- Clear Form Data Without Saving
- Clear only one filter
- Clear text entered by user when form is submitted
- close access application aftera specific time
- close all powerpoint files from an access application
- Close Form help Needed
- Close form with required fields empty...
- Close Workbook
- cmdButton Captions
- Code Burnout!
- Code for Date Picker Use AND User Date Entry
- Code for last weeks data
- code for OnClick zoom a image
- code for refreshing form?
- Code Keeps Running
- Coding a button special function
- color row in subform if a value filled in
- Color text field based on the value of a combo box
- Column filtering on linked table (SQL Server)
- Column total
- Combo box drop up rather than down?
- combo box error
- Combo Box Issue
- Combo box not return description to table
- Combo Box Selection with Multiple Query
- Combo Jumps
- ComboBox not appearing on Subform
- ComboBox Selection
- ComboBox value updates another combo box
- Combobox with dates
- Command button Enabled by a condition (Form RecordCount))
- Command button to open desktop folder
- Comment History
- Compact on close - back end?
- compact remotely using batch
- Compacting the Database
- Compare FineReport and Crystal Reports
- Comparing One Record to Another
- Comparing two tables
- compatibility of ACCDE on different PCs
- Compatibility problem from 2010 to 2007
- Compile different database name
- Compile error expected array
- Compile Error: User-defined type not defined
- Complete beginner
- completion - transformed Query always gives 100%
- Complicated Code I am sure
- complicated query
- Computer performance for video streaming and Youtube movies
- Concatenating 5 fields to one on report
- Concatenating data from multiple checkboxes
- Conditional formatting based on two fields
- conditional formatting issue
- Conditional Formatting Not Working
- conditional formatting on combo box
- Conditional Formatting Two Fields in Report
- Conditional Formatting: DateDiff date based on subform date values: Access 2010
- Conditional Link Master and Link Child
- connecting a main form to a subform
- Connection Error TO DBase Database
- Consolidate Addresses by Similarities
- Contacts Web Database datasheet comments problem
- Continuous Form Cursor Jumping Around on Entry
- Continuous Form in Tabs
- Continuous Form Not Updating Tables Correctly
- Continuous View Form - ID a row ?
- convert 19 digit string to hex string
- Convert Currency (Or Number) Into Words
- Convert Date to General number
- Convert to number
- Converter
- Converting Text Dates using CDate() and Querying on the Converted Date
- Copy
- Copy Access 2003 to Another Folder with Macro in Access 2007
- Copy Database
- Copy paste excel file from Access VBA
- Copy value of calculated control to update table field...
- Copy values into following fields
- Copy zipped file and unzip
- CopyObject table link?
- Correcting look-up fields
- Correcting Table Structure
- Correlated query to find cheapest manufacturer
- Corrupted Auto Number - Help!
- Costum Sort order in Subform
- Could this really work or is this make-believe
- Coummunity Management Database issue (issue in a Form)
- count
- Count active members grouped by month
- count line items
- Count Query for QBF
- Count() doesn't work on one computer - does on others - same configuration
- Counter change
- counter Customer?
- Countif type code
- counting multiple columns in a query
- Covert an Excel Holiday spreadsheet design into an Access Database version
- Crazy Query
- Create a Form to Update a Table . . .
- Create a Join using LEFT string manipulation
- Create A loop to add new records and decrease amount by one
- Create a New Record on One to Many custom form
- Create a validation rule based on another field
- create log for table to capture changes by users
- Create multiple expanding/Collapsing Sections
- Create new customer in Quickbooks
- create report to cut-n-paste into word table
- create table based on textbox
- CREATE TABLE function
- Create X number of records with a button
- Creating a "Table" report
- Creating a batch file
- creating a classroom schedule
- Creating a complex query using VBA
- Creating a level per show
- Creating a lookup
- Creating a New Record Within a Subform
- Creating a report range
- Creating a text file from VBA and exporting data to .txt
- Creating an automatic alert when query is run
- Creating an invoice
- creating different filters for scrolling through forms?
- creating form with two option buttons
- Creating PDF from report opens Adobe reader
- Creating XML file from Job Order form.
- Cricket World Cup
- Criteria Question
- Cross tab query column sort
- Crosstab Queries Columns Heading limitation
- Crosstab Query Question
- Crosstab Rpt with conditional formatting
- CTRL -
- Cumulitive Sum
- current date field form form to field
- Current record report
- Currently Month and Next Month
- Curroption in VBA project
- Curved Text?
- Custom sounds on Windows AND Access 64Bit
- customer history
- customer ID link
- Customised chart built by Function: Report vs SubReport Problem
- Customize object name
- Customize right click menu
- Customizing Access parameter Query - No Data
- D.C.
- Dale E Hayes
- Data Entry Form Question
- Data Entry System - Struggling to produce the concept
- Data filtering by form/subform using same record set
- Data picker does not work correctly in subform which is in reports header
- Data source name not found error
- Data sourcing
- Data Type mismatch fot text fiel when using datepart function incriteria
- Data Varification
- Database Design
- Database design - beginner!
- Database design in theory
- Database engine does not recognize payment as a valid field name or expression
- Database Error
- Database for Wind Turbine Equipment
- Database Platform
- Database security
- Database status flags
- Datasheet view
- Datasheet view custom fields duplication
- Date + 3 days
- Date comparison query
- Date fields change to pound signs
- Date filter - If Date is in a future month
- Date filters using combo box
- Date()-3 **but** exclude weekends
- DateDiff and varchar dates and "Data Type Mismatch"
- Datediff Function
- Dates
- Day Name from Date
- DB Errors
- dbseechanges
- dcount in ms access
- Dcount using date comparison
- DCount with And Syntax
- DDE Request from Excel a value
- Decimal Entry Rounds Down - Want to Round Up
- Decimal on Form
- decimal on forms
- decimals on form
- default
- Default Error Messages
- default value
- Default Value "0" in Query Extended Price filed
- Default value in Datasheet view
- Default value of field not translating to table
- Delete in table from input box
- Delete Qry
- delete Query
- Delete query error could not delete from specified tables
- Delete records from a table
- Delete Records from list box
- Delete records in subform based on checkbox in parent form
- Deletion Query to delete records in one table dependent on another table
- Dependant Drop Down List From Date
- deploy and split database
- Descending Comments in Memo Field
- Details section alters of own accord
- Detect broken backend connection at startup
- detect lost odbc connection
- Developing Access DB - Am I going about things the right way?
- dialog box for certain values entered
- Different front end design
- Digital CAC (Smart Card) Signature
- Dim Statment question
- disable design/layout view
- Disabling automated macros
- Disappearing Custom Menu
- Disney lays off IT workers
- Display & Populate in 2D matrix
- Display background image via mesagebox
- Display flag corresponding to selection in combo box
- display Grid view images on report
- display message
- Display of only selected options in a multi-value control
- display the count of 'today occurences' from a table in a form?
- Displaying And Scaling An Image From A URL On A Form
- Displaying the results of a formula
- Division giving the wrong answer.
- dlookup
- Dlookup in a subform
- Dlookup in form
- DLookup in Query
- Dlookup in report / or query
- Dlookup multiple Criteria
- DLookup problem in Form.
- Dlookup value from 1 table with date ranges from diff table with a single date
- Dlookup with Combo Value
- Dlookup with multiple condition...
- DMax + 1 (using minimum number)
- Dmax for empty table
- DMax on mainform referencing subform
- Do you believe in The Supernatural?
- DoCmd.GoToRecord
- docmd.openform triggering wrong form
- docmd.runSQL code help - INSERT INTO with multiple WHERE clauses
- DoCmd.SendObject
- DoCmd.TransferSpreadsheet ( export data from a table in access to excel)
- docmdTransferText and adding links to the document
- DoCmn.RunSQL versus CurrentDb.Execute
- Does Query Speed Depend on Order of WHERE Clause
- Does TSQL have a 2nd instead of TOP 1 to return one record
- dont let append query add the same records again
- Dont show subform footer
- Double booking preventation
- Double bookings
- Double Click Event
- Drop down lists to change all data
- Drop down to filter with an "all records"
- DropDown List for Reports
- Dropdown list not working
- Dropping Words During Export
- DSum not working after December in Financial Year
- Duplicate field allowed only with checkbox = true
- Duplicate Records
- Duplicate Records in Combo box
- Duplicate values error :(
- Duplicates
- duplicates not always hidded
- duplicates on report
- Duplicates on repost
- Dynamic Queries based on multiple group membership
- Dynamically generating a report title based upon a date criteria
- Easy question
- Easy way to write Nested IF THEN ELSE IF Statements...
- Edit
- edit exported excel report
- Edit My data
- Editing Date
- efficient tutorial
- eliminating middle initial
- Email a Single Record
- Email Notification with Record ID
- Email to selected items in a combo box
- emailing a report
- emailing reports - outlook warning problem
- Emergency plz help.
- Enable or Disable criteria
- enable/disable an checkbox on continious form
- enabling cascading comboboxes in datasheet or continuous form
- Encrypting - Decryption Password SQL Table
- England
- English OAP Needs Help!
- enter parameter value
- Enter parameter value.
- Enter Paramter Value
- Entertainments Agency Database
- Entity Relationships Tutorial
- Equip check in check out qry PROBLEM
- ER diagram
- Error
- Error 2486
- error in query
- Error in Table
- Error msg
- Error With my code
- Evaluation Notice
- Event code building
- Example Database using Lotus Notes
- Excel - Speed up VBA process for loop in formatting - the numbers
- Excel Connection to Access Query
- Excel converts boolean 0 and 1 to FALSE and TRUE
- excel data connection not updating
- Excel imported data
- Excel spreadsheet on a tab in a form
- Excel VBA String (SQL) to Retrieve and Insert an Image Saved As Attachment in Access
- Excel VBA Workbooks
- Exceptionally simple update query not working
- Experiences and Helps :)
- Expert Access Programmer
- Exploring MS access
- Export a Query in Spreadsheet Format
- Export a table from accde to accde file
- export record to .php and send to MySQL via hidden browser
- Export Report to Excel - blank fields
- Export report to powerpoint
- Export Report without highlight color
- Export to excel - datasheet captions and visible columns only
- export to rtf not correct (or same file exported)
- exporting a form to excel
- Exporting Crystal to Excel using Access VBA
- Exporting Currency Field Without Decimal Place
- Exporting data from the clicked field on one report to another report
- Exporting from Access to Excel Run Time Error 31532
- Exporting to Excel
- Exporting to Varying Output Filename
- Expression Builder Expression Not Summing
- Expression Builder Showing Subform as a Report
- External access to application.
- Extra page on report...stumped
- Extract House Number
- Extracting from an unusual string
- F8 to step through doesnt work in access 2013 vba
- Facial recognition software
- Failing loop
- Fairly new member
- Field and all records change same time
- Fields missing on Tab order form
- Fill multiple date fields in the form with the first value
- Filling the empty fields in printed report with (xxxx) or (- - - - -)
- Filter based on two combo box selections
- Filter by Form button on Form?
- Filter by Month and Year
- Filter Form1 using drop down from Form2
- Filter on a form
- Filter out empty records
- filter report
- Filter showing incorrect data
- Filter view on current month
- Filtering a report
- Filtering Arrays
- Filtering ComboBox Issue
- Filtering forms.... :/
- Find all records on a Form
- Find and replace full records
- find and replace out of a list
- Find data only for 3 products
- Find Duplicates Not Working
- Find Record (go to) Command
- Find record in a subform
- Find text on loaded html page
- Find what has been added
- Finding Mouse Coordinates
- Finding number in string
- Finding records in sub-forms
- Finding the previous active control on a form
- First post in a table change contain automatically
- Fiscal Year Query
- Fixing the heigth of a pop-up form
- Flagging up dates
- for each
- for Edit and Update what changes are required
- Force Unbound Check Box to False/No Gray Fill
- Forcing page break on subreport after 2 records
- Form and Sub-Form - Join Table
- Form and Subforms
- Form asking for number but table is text
- Form BackColor
- form BeforeUpdate/BeforeInsert clarification
- Form combo box populating underlying table incorrectly
- Form Corruption
- Form Disappears
- Form dont open in Edit mode
- Form Field Always Null Even When Showing Data
- Form field not printing
- Form header not showing in Continuous view
- Form Issue
- Form Layout
- Form link is LOCKED? I need help
- Form lookup help
- Form objects
- Form opening inside an Access window in the background
- Form overlapping query
- Form Page Header
- Form population
- Form Reference Error
- Form Refresh
- Form restritctions
- Form size
- Form Template with Pre-Filled Set of Values
- Form that compares tables
- Form times
- Form to filter report
- Form will not save
- Form/Textbox size
- Format - Convert a weeknumber+weekday to a proper date format
- Format a Form when a filter is active
- Format Date as Day. Mon
- formating the ControlTip Text
- Formatting Date within Do.Cmd.RunSQL
- Formatting report
- Forms - multiple record
- Forms and Dynaset
- Forms Help
- formula in report
- Formula paste error
- formula problem
- Formulas in Textbox
- Fracking
- Freedom - ?
- freindsfeed-soufiane
- French accents
- Front end copies itself to desktop after closing db
- Full Head Transplant
- Function problems to solve Part 1
- Funny Problem
- General Date field criteria
- General help setting up tables please
- Generate Query Definition
- Generating a new F# and creating an empty folder on new data entry
- Generating a random time from list in query
- Georgia
- Get Current Row Number (Cursor Location)
- Get form to open to new record
- get latest price
- Get Me.Page in Report Preview
- get records from day before after 5 PM and today before 8 AM...
- Get Sum(totals) after exporting to Excel
- Get summation of a formula based field
- getting a string with a month/year from a date
- Getting a Value from what I think is a Subform
- getting entire reports to show on a tab control
- getting my layout in a datasheet form to stay
- Getting Total of a field in a continuous form
- Getting Totals from five reports to creat one report.
- Give a control a unique criteria
- Giveing me an error when inputing date
- Glad to be here
- Glitch in user-level security for one user
- Good Day All!
- good forum for angularjs
- Google announced purchase of Microsoft Access
- Google map on Web Browser Control - Web Form on Access 2010
- Grab primary key and use it in subform
- Graph in a report
- Graphic object display error
- Greeting from the UK
- Greetings from Atlanta
- Greetings from Holland
- Greetings from Portland
- Greetings from Washington
- Greetings!
- Group Reports based on Expression in Unbound Textbox?
- Grouping and totals
- Grouping Levels
- Handling Concurrent User Access
- Has anyone seen this behaviour before
- Have to click button twice
- Having Name Show on Form After Logging in
- Having problems with the "Null"
- Having trouble creating a medical testing tracking system
- Having trouble retrieving record value
- Having trouble with syntax for Nz(DSum statement
- Hello
- Hello ... quick question
- Hello all
- Hello all!
- hello all...
- Hello Databasers
- Hello everyone
- Hello everyone...
- Hello form Thailand!
- Hello Forum
- Hello from a newb
- Hello from Baghdad
- Hello from Brazil!
- Hello from British Columbia
- hello from california
- Hello From Canada
- Hello from Cardiff!
- Hello from down under!
- Hello from Edinburgh
- Hello from Florida
- Hello from Grenada!
- Hello from Hunan
- Hello from Illinois
- Hello from Ireland
- Hello from Kazakhstan
- Hello from London
- Hello from mid Wales
- Hello from NE Florida
- Hello from North Carolina USA
- Hello from Ohio
- Hello from Philippines
- Hello from qfillmart
- Hello from scotland
- Hello from Spain
- Hello from Switzerland
- Hello from the Carolinas
- Hello from the south
- Hello From the USA.
- Hello from Utah
- Hello group
- Hello MS Access Forum
- hello there
- Hello there!
- Hello to all
- Hello to everyone
- Hello to you all!!!
- Hello world
- Hello World!
- Hello World! : )
- Hello!
- Hellp
- HELP - Connnection Reset by Peer
- Help getting a subform to open to a new record when a button is clicked
- Help Importing Excell data to Access table
- Help needed for nested iif in microsoft access 2010
- Help needed to run monthly cleanup of contact details in membership database
- Help on Appending Tables
- Help on multiple issues in form
- Help on starting the best db ever!?
- HELP SQL Code for Union Query
- HELP SQL+WHERE+UNION QUERY+Duplicate Entries
- Help to Get Value Automatically from Other Table
- Help to Modify this vba code.
- Help with a field calculation please
- Help with a Read-Only .ADP
- Help with a VB code
- Help with Airport Transfer Database
- Help with an update query
- Help with code please
- Help with coding
- Help with Forms
- Help with Normalization
- Help with Queries (Macro)
- Help with Queries in Access 2010
- Help with RTF problem
- Help with searching matching forms
- Help with subquery
- Help with textbox property tag
- Help with the Insert Query in VBA
- Help with using multiple forms
- Help with Visual Basic 7 project
- help with wild cards
- HELP! AddWorkingDays Function
- Help!!
- Help!! Open Excel Wkbk
- Help!!!
- Henry from Ghana
- Heres one for all the Forum Gurus...
- Hey from Kent
- Hey hey all !
- Hey Me!
- Hey There
- Hey!
- Heyo
- Hi
- Hi All
- Hi All.....
- hi everybody
- Hi everyone
- hi everyone!
- Hi Folks
- Hi from 20 year pro
- Hi from Aquaman
- Hi From Cape Town South Africa
- Hi from Croydon
- Hi from Finland
- Hi from Johannesburg
- Hi From London E14
- hi from new mwmber
- Hi From Nottinghamshire.
- Hi From Simon
- Hi from Slovakia~!
- Hi from Stockholm
- Hi from Sunny South Africa
- Hi from Tom
- Hi from Wales
- Hi Guys
- hi learn access so far that i dont remember anything
- Hi people :)
- Hi There
- Hi there!
- Hi!
- Hidden Information Input and Storage
- Hide #Error on complicated calculated field
- Hide database
- Hide field in Unfiltered Report
- Hide Report Page Navigation
- Hide toolbar and status bar on logon screen
- Hide Undo button until data entry on form...
- Hiding Access Query from Excel
- Hiding Social Security Number in form
- Hiya
- hola muchachos
- Horizontal Formatting of a Report
- Hotel Database Design Theory
- Hotel Rate Table
- How can I add VB code to refresh form after change?
- How can I change font name
- How can I create and see the results of a SELECT query in VBA?
- How can I deal with this text file?
- How can I get Module to Run?
- How can I put the cursor on the newly created record
- How do I edit relationships in Access 2007
- How do I force paste action to strip out any hidden characters?
- How do I return a value based on another with subforms?
- How do I sort correctly
- How do you display time in order?
- How do you make the column width on a subform match the property settings?
- How do you sort contatenated fields on a report?
- how insert 8 month in table by 1 button
- How is this?
- How not to count duplicate records in report
- How to
- How to add a search box to a form bound to a query not a table
- how to add sequential dates with ref nr with append query
- How to arrange columns in a report (visible/invisible)
- How to calculate fields with restrictions
- How to calculate the number of days from two dates in a table
- How to check the recordcount
- How to copy a record from table A to table B?
- how to detect if user has a touchscreen
- How To Determine FlashDrive Letter
- how to display large print in a zoom box ?
- how to do it?
- How to enable multiple filters
- how to export cross tab queries by date parameters
- How to Export to a .csv file
- How to find Access 2013 version number
- How to get data from forms into a table
- how to get vba querry output in to variable
- How to handle user forgot password
- how to hold record with time and go back to it later.
- How to jump to another field based on answer
- how to link two table on part of field
- How to move the data from a table to another
- How to Obtain Calendar
- How To Perform Search From Navigation Form
- How to properly use IsError in query
- how to reference all records in a subform?
- How to refresh a field automatically?
- How to remove values from lookup values on vba
- how to run an sql from a subroutine in a subform
- How to search this site for past post.
- How to set the active window?
- How to show row values as column values in access
- How to split colum value (with comma) to multiple columns
- How to split hypen from text in Access 2010
- How to sse value from form as Globall variable
- How to unified same tables for 3 different MS Access file
- how to Update ODBC linked tables on ms access
- How to Upload a Stripped DB.
- How to use command button to select image and show it in an access form one after one
- how to use the data
- Howdy
- Howdy Everyone
- Howdy from Pennsylvania
- Howdy From Texas
- howdy!
- HR Interim Database - for Oracle import later?
- Hunting
- hyperlink text in memo field
- Hyperlink to tabbed form..
- Hyperlinks changing
- I am New Here
- i am using a desktop inventory template and i would like some help in creating multip
- I am Yousef
- I Broke my db!! (Removed submenu on login form)
- I can no longer print reports since upgrade to access 2013
- I need help!!
- I need some help.
- I need to get the Top 10 per State and County
- I pretty sure this should be a query... can anyone confirm
- I want to work in USA or Newziland
- IBM Notes
- Identify Access instance-Bring it to forefront
- if date filled in field
- If no results then move to next qryDef....
- If statement calculated fields help
- If Statement Help (Finding a text string 76___-_____-___")
- If statement with multiple criteria
- If Statements in MS Access Tables
- if user selects wrong value
- IFERROR function equivalent in Access
- IFTTT
- IIF Function
- IIF Statement not working
- IIf statement with dates
- IIf(IsError(
- Im in too far
- Implement vba code on sharepoint Access web
- Import Excel into a table
- Importing a letterhead into an Access Report
- Importing and managing relational data
- Importing currently linked tables (combining front and backend)
- Importing excel data in access table
- Importing Excel to2013
- Importing from Excel
- Importing Navigation Form between Access 2003 databases
- Importing/Appending records into existing table in web app
- imports foreign workers H1-B Visa Lobby increases numbers
- Improve user experience with fractions
- in the same query
- Include special characters in export
- Inconsistent Error: Access Cannot Open More Databases
- Indexing. When does it happen.
- Initial folder of open file dialog
- InitialiseEvents problem Plz Help
- input forms and query forms
- Input in pivot like form
- input mask
- insert HtML file in to body of email (inside loop email)
- insert into a table from
- insert into a table from a from field in ms access
- Insert into one to many
- Insert multiple groups of Text fields in table
- Insert Page Numbering in Form
- Insert unbound field values into a table
- Inserting a function within a sub in VBA
- Integrative Management of Erectile Dysfunction
- Internet 'rationing' needed as UK consuming at least 8 per cent of Britain's power ou
- intro
- Introduction
- Intros
- Invalid use of bracketing error
- Invoice totals- monthly maintenance
- Invoicing / Inventory
- Is innovation in gaming dead?
- Is there a way to shut down a PC (Win 8
- Is this a design problem or SQL problem?
- Issue with Cursor moving on multi Subforms in a form
- John Big Booty
- Join Error Help
- Join the data of two tables using query
- Just a beginner to Access
- Just a quick survery on best way to do a directory
- Key value violation with macro append from spreadsheet
- Key violation
- Keyboard Macro
- Keyboard shortcut Closing Query
- Knock You Up
- Last record in the Table
- Last xx Records
- Learning Macros and VBA
- Left Justify String
- Left Table vs Right Table
- Leonard Nimoy died at 83
- Limit data entry to one of four available combo boxes
- Limit Date Values to Quarters
- Limit dropdown list to specific record
- Limiting Date Values User Can Choose
- Line breaks in a memo field in report
- Linked sharepoint tables don't sync?
- Linking
- Linking an existing form to new Table
- Linking Databases
- Linking dialogue forms
- Linking document to record VBA
- Linking External Tables to Current Database
- Linking Multiple Linked Fields
- Linking outlook tasks to access 2007
- Linking queries to reports
- List box row source queries
- ListBox Selection hard to recover
- listbox/ combobox on a subform in Access
- Listing Field Properties with VBA
- Load folder content into attachments
- Loading only the tab page you require for speed purposes
- lock record after update
- logged in person on all forms?
- logic question on table/form layout
- Login form Security
- Login name - update field on subform
- Look up Combo box
- Look Up Wizard Displays Numerical Value Instead of Text
- Look-up Column in Text box access form
- looking up data from other tables
- Lookup Fields and Tables
- Lookup Fields in Tables
- Lookup using part of a field
- Loop question
- Loop thru Combobox
- Loop thru Combobox Assistance
- Looping Coding Issue
- Looping in a form
- Looping question
- looping through all items in a list box
- Losing functionality on the FE after splitting
- Lyn from Massachusetts
- Macro Filter Not Working
- Macro for sending emails
- Macro If statement
- Macro to check for existing records
- Macro to save to a Sharepoint site
- Macro/Form Open Action
- mail merge for a single record
- Main Form and Subform Totals
- Main Form Jumps Back To 1st Record When Moving To Next Record In Subform?
- Make a field on the form invisible?
- Make folders from query
- Make form skip record that someone else already has open.
- make pdf file from a report
- Make text in a listbox flash
- Make two records that are Similar
- Making my database executable for others.
- making report monthly
- Manipulate Table with LINK to Data from SQL
- manipulating multiple subforms
- many times
- Many-to-many with checkboxes
- Marking a record by what tab is was entered on...
- Masking doesnt respond
- MC access is slow
- mclane from Seabrook
- Membership Database - Companies v. Individuals
- Merging Pdf docs using access 2007 vba
- Merging records into one record
- Merging Tables
- Merging two Queries?
- Message box for duplicate entry...
- Message box if we never change the textbox value...
- Microsoft Chart Object in Report - Formatting Line Weights
- Microsoft licence types
- Migrating OLE to Attachment
- Migrating split 2010 dbase to 2013
- Modify Database Options in VBA
- Module Help!
- Moon Worm - infects Home Routers - redirects advertisement and security access
- More sorting options in reports
- Moveable for wont move
- Moving a window
- Moving table to existing backend using vba
- MS Access 2007- Migration : Need suggestions
- Ms Access Treeview node click issue
- msain.dll missing all of a sudden
- MsysObjects Remove Bracketed Values
- Multi Column Combo Box
- Multi field filter on a form
- Multi Form Search
- Multi list to select reports send by email
- multi page report
- Multi User Duplicate
- Multiple checkboxes in a form to build a string
- Multiple counts between 2 dates in 1 query
- Multiple Data sets on chart
- Multiple DLookup Syntax
- Multiple sorts on one group
- Multiple Users for the noob
- Multiply time my quantity
- My 2nd form opens "Filtered" but nothing shows
- My query does not return what I think should be the Null Values
- My search form displays blank table
- MySQL Head Banger :@ !!!
- Mysterious Error 3071
- Mystery Parameter Request
- Name
- Navigation Issue with RecordsetCount
- Navigation Pane Issues
- Need a formula correction
- Need Advise! Calculate in Access
- Need Help for Defining new date(number) Format !
- need help how to set up a house managing program in access
- Need Help in DataMacros... Especially with LookupRecord?
- Need help on Insert
- need help using the max function in aggregate query
- Need help with an array
- Need help with report formatting
- Need Help with this Insert query
- Need Help with VBA Code to Export Unique Record In Form to PDF
- Need monthly totals
- need Object to send emails
- Need query to pickup last two months
- Need Ratio of Two Numbers in a field in a report.
- Need record of changing another records in database
- Need some help on Dlookup
- Need to disable the Delete a Record shortcut
- Need to enter only unique values between two tables
- Need your Ideas
- Needed Professional way to link three tables using forms
- Nested Iif query
- Nested IIF statements in a query expression
- New Apt
- New database Query or Form
- New Member
- New member ...
- New member with very little access knowledge
- New poster/old person
- New to Access
- New to Access (SImple Form and Table) MSDS search and database
- new user
- Newbie
- Newby in distress
- Newcomer
- Newcomer post
- Newcomer to Forum
- newrecord property
- Next Sorting Problem
- No Automation object "Form"
- No Current Record Error
- No Duplicate Vendor #s
- No Error Codes
- No results in query criteria
- No scroll bars in forms on Web database?
- not able to work with desktop button when access is open
- Not being prompted with log on window
- Not Like "*/CTO/*" not working
- not seeing my invoice number
- not what is dispalyed
- Note Popup on change of data
- Novice question about tables
- Null value filtering syntax help
- Null Value in INDEX MATCH
- number less than 1
- Number Sequence
- Object Dependencies Missing
- Object required
- Octothorpes Syntax Error ?
- ODBC connections between computers in a LAN networking
- Off2013-Cannot open a database created with a previous version of your application
- office upgrade
- Offshore rostering
- Old New member
- On click event for a text box
- On closing picture on form hangs
- on current of a different form
- On Lost Focus
- OnCall Scheduler
- One form for a Single Entry
- One Large Table Problem
- one to many delimma; variable in one cascading to the many
- One to Many Table Calculation
- One-Way ticket to Live on Mars - What kind of people will go? POLL
- Online Private Quiz
- Only display specified records
- Only one record can be current
- Only show entered data
- OOP User authorisation class wanted
- Open
- Open a record from Listbox in another form
- Open another database and send Variable Back
- Open another form based on ID if no records
- Open database and switch to it
- Open Ended Questions for Debate.
- Open file and print
- Open folder nested inside main folder
- Open form - Warning messages pop up
- Open form to specific record
- Open linked Form directly..!!
- Open query recordset
- Open RecordSet...
- Open recordsets as public or global variables
- Open Report 2 if Report 1 is empty
- Open Report w/ Subreport based on Unbound Form
- Open Same Report from Popup and Home Form
- Openform Is Closing Form
- Opening Another Access DB
- Opening Design view of Append query without timing out the source query
- Opening Forms based on results of a union all
- Opening OLE Object in Access
- Opening Report via Parameter
- Opening second form from form one
- Openning a Form from Another Form via Combo and auto loading the form data
- OpenRecordset and ODBC linked tables
- OpenRecordset ODBC error
- Operation must use an updateable query error
- Operation must use an updateable query message
- Option Buttons
- Option Group Label
- OptionButton Property Disable
- OR and BETWEEN
- or relationship" Error. Help needed
- or use Views in SQL Express?
- Oregon
- Outlook Issue
- Outlook Restrict Method From Access
- Overriding " Enable Marcos"
- overwrite the data of the fields imported from Excel in Ta
- Owners regarding having a mechanical failure a
- page and pages
- page break
- Page Footer in Access Report
- Parent form unable to navigate subform
- Pass combobox to another form always = Null
- Pass value from form to calling form
- passing a variable to a query
- passing parameter to stored procedure from a form to generate report
- Passing parameters to report doesnt work
- Passing two Cobobox value to two texbox in form
- password to forms
- Paste .xlsm file by browser option enabled
- Pattern matches across 2 table columns
- Performance Issues: comparing 2 db
- permisssions in ms access
- pick field based on number of clicks
- Pie and reporting
- pivot chart
- PK and FK insert
- Planet of the Apes is real - they are destroying the Internet
- Please Help - Sorry If Duplicate Request
- Please help how to calculate order detail
- please help me to solve this problem
- PLS Help!! Sumif formula in MS Access
- Png transparency!
- Pop Up Error Msg box sounds
- Pop-up
- Pop-Up Calendar
- Populate a Table With Report Names
- Populate Text Box from table based on combobox value
- Populating a Form with Record Data
- Populating Text boxes
- Popup Form disappears on multi monitor
- Popup image
- Possible lookup problem
- Possible to compact DB (2013) while open
- Pre-populating a subform
- Presentation - Remote full Access with Azure - is there any interest?
- Preserving characters from Excel Import to Access
- Presidental Tracking db
- prevent double booking
- prevent multiple lines
- Primary Display Field in Autocomplete controls
- primary key
- print every line from the query
- Print fields Iif
- Print report several times by changing field information
- Print Selected Record from Subform in Switchboard
- Print Single Report from Form
- Printer Icon to Tool Bar
- Printer Page Break when data ends
- Printing a pdf of the master report and skip subreports with no Photo and descriptive
- printing on the same row
- Printing one record from a form
- Printing specific fields from record.
- Printout action
- problem in tables relationships
- problem in vba code writting
- problem input multiple tables from form
- problem using navigation form
- problem with 2 simular subforms
- Problem with Dlookup field returning #Error
- Problem With Form Buttons
- Problem with tables
- Problem with text box value in form
- Problem with using parameter in query with calculation from date
- problem with VBA after migrating to SQL 2014
- Problems with Duplicate Queries
- Procedure to Call Form in Pop Up Mode
- Produce a report matrix
- Programatically joining templates?
- Programmatically find and select an item in multi select list box
- Programmatically run documenter on all objects
- Progress Bar
- Progress Bar not accurate
- Project Chronicle (Structure)
- Project time Registration database
- Prompt Export Save Location
- Property pane refuses to show
- Pull data from query (or table) using VBA
- Pull Text From String
- Pulling data into a report from another report
- Push data from Access to SQL
- Putting Text Into Combo Box
- Qery based on combox to show all records
- Quality Control Database table/relationship design
- Queries with Check boxes?
- Querry
- Query
- Query 2013
- Query Based on A CrossTab
- Query Checks for Date in Column Header
- Query criteria for Combo box
- Query Criteria Help Please
- Query Criteria IIF Statement Multiple True parts
- query expression troubles
- Query Expression using sum of another calculated field in query
- Query Expresssion Not Working
- Query for all employee movements
- Query from a Form
- query help
- Query help please
- Query help show all from table
- Query Help!
- Query input must contain at least one table or query error
- Query inserts wrong data in the table
- Query is too complex
- Query Issue
- Query Loan Calculation
- Query on a SQL Server view - stopped responding to specific letters
- query remove null rows
- Query report changed data
- Query Results from Mainform to Subform.
- query returns "DELETE" as field value
- Query runs slow on SQL table
- Query taking WAY to long to run
- Query that shows price valid on specific date
- Query to a
- Query to calculate different timestamps for matching criteria
- Query to filter records between dates
- Query to from problem
- Query to produce boolean
- Query to return most recently created records
- Query to return number before letters
- Query to select all data regarding a clicked field
- Query to show only records with all parts received
- Query to update table but no result
- Query totals: Min
- Query update
- query using LIKE
- Query with 2 different selects
- Query within a query
- query year
- querying on datetime - Syntax Error
- Question 2010 accdb in 2013
- Question about database normalization
- Question about fields
- Question about including null data
- Question about tables
- Question Access - Export to CSV file
- Question Access 2007 Database Keeps Closing
- Question Access consuming 100% CPU and unable to exit gracefully on Windows Server 2008 (MS Ac
- Question Access database may be corrupt
- Question access query
- Question Am i doing the Optimal Solution for a summary page?
- Question Application Dev Settings
- Question Auto fill multiple fields in a form from 2 Tables
- Question auto reject of holiday
- Question Automatic Checkbox???
- Question collect data via email
- Question Custom Notes on Orders
- Question Data Trends in an Access Database
- Question Entering data into a form
- Question How to convert an ADP to ACCDB
- Question linking - relinking
- Question Lost data
- Question macro to manipulate unstructured data like Excel does
- Question Move Table to Front End
- Question NOT queries?
- Question on DB Bloat and persistent connection to linked DB
- Question Personalised Staff Rota
- Question problem with creating a really simple inventory database
- Question Save as when Opening Accde
- Question Stock FIFO example
- Question Sync Databases nightly
- Question System Development: In-house or outsource?
- Question Table structure for multi location warehouse
- Question UNBLOCK not helping
- Question Where did my workgroup go?
- Question Yahoo Broke
- Quick Search
- Re-Activating In-form buttons after filter
- Re-centre a form?
- Re: Nowy kolor dla stałych bywalców
- Read-only values on continuous subform best pratices
- READING mails from POP3/IMAP folder
- reading the array to import the files in access 2010
- reading VCF files in VBA
- Reasoning behind TWO combo boxes for the same field?
- Recap Story
- Recommendations: database design and tools
- Record Count Alternative
- Record Navigation Button issue
- record wont display on report
- Recordset as a datasource for a form
- Recordset Filter
- Recordset help?
- Recordset is not Updateable
- Recordset Not Updateable
- Refer to another row in a table
- Reference
- reference "parent" description in hierarchical data table
- Reference field on form
- Reference issue
- References.AddFromFile
- Referencing a subform in VBA
- Referencing all records in a subform
- referencing only one record in a multi record subform
- Referential Integrity Relationships - in vba
- Referring to text in a table on a subform
- Refresh a Combo Box
- Refresh Form Data
- RegEx in TSQL
- Relating 3 tables
- Relational database design
- relationnships
- relationship issue
- Relationships Help
- Remote Data to be collated
- Remove Blank Row on Continuous Form
- Remove column from form
- Remove Filter and Stay at current Record
- Remove Item From Combobox
- Remove prompt while running report
- Remove special characters
- Removing a section of a string
- rename command buttons from a table
- Rename field values with values from another table
- Rename Table Name to First Column Heading
- Renaming fields from one table value to another
- Repeat data from a given date
- Replace Alphabet..
- Replying (but not sending) a .msg email saved on HD?
- Report based on a combination of 2 queries.
- Report built from union query
- Report creation
- Report detail repeats records
- Report Displaying Multiple Duplicate Records due to Subform
- Report filters
- Report Format Using Left Property and Page
- Report Freezes On Loading - Access 2013
- Report giving duplicate subreports
- Report Last Occurance
- Report not grouping correctly? hiding duplicate values
- Report or mail merge
- Report print group
- Report print preview sometimes prints background form
- Report Prints #Name? Instead Of Dates
- Report prints too many pages
- Report showing multiple actions across multiple years
- Report sub totals not correct
- Report to Show Two rows for Each Record
- Report view = 1 page (good)
- Report: Count of one field if another is a certain value problem!
- Reports analyse with Excel in citrix
- Reports are showing errors in the data fields
- Reports Context Menu
- Reports view
- Requerying values in a subform after updating combo box in main form
- RequeryRecords on Summary View
- required " yes"
- Required field suddenly needed durning filter
- Required help on Lookup fields
- Reset Combo Box
- resizing columns
- Restricting user to view specific record after logging in to login form
- Retaining drop down value for next record
- Retrieving Last Record In A Table
- Return Characters to the right of space
- Return records with no data in a cell
- Ribbon hiding!
- Rich Text Box
- RichTextBox Members Not Found?
- Rounding in caculated field
- rounding negitive numbers up to 0
- Routers Suck
- Row Number
- Row Source value
- rows to columns
- Run 2 Queries on "On Click" event
- Run a report or a query
- Run Outlook Function From Access
- Run query multiple times (different data parameter) to generate single dataset
- Run Time error 3464
- Run-time error 424
- Run-Time Error 94 - invalid use of null
- running a query based upon a listbox selection
- running balance on form
- Running Total with Limit?
- Runtime 3186 Lock by Admin on Machine
- Runtime Database with Sharepoint
- runtime error 2046 and others
- Runtime error 2110 but only on last control
- Runtime Error 3061 in Acc2010
- runtime error 3134
- Runtime Error 3144: Help!
- sales of the same item resulting in duplicate of stock entries
- same BE
- Save
- Save data from one form into a different table?
- save listbox columns to table fields
- Save Record in Shared database
- Save Value of Field and use it once form closed
- SaveAs differnt name
- Schedule Report
- Scheduled task on windows server
- script to compile database
- Scrolling stopped and Details pane displaced.
- Search and count in a form
- Search Box in a Report
- Search Box in a Report???
- Search criteria query
- Search engine..
- Search not working
- Search Records and Add Multiple Date/Time Stamps
- Search with Check Box
- Searches that return a form
- SearchForRecord macro
- Searching Access
- Searching For A Value In A Column Row Using The "In" Clause
- second Combobox
- Secure User Login System..
- Select all dates between two dates (AC2007)
- Select data for continuous records in a report
- Select Multiple Items in Combo Box in Form
- Select multiple list items from a paste
- Select Query producing inaccurate results
- select query return "text" instead of "boolean value"
- Select Top issue
- Send email from access vba using outlook V2
- send OpenArgs as Array ?
- Send SMS via mobile in access
- Sending email to distribution list/group via VBA for Outlook
- Sending email with SendObject
- Sending object with Null Field
- SendObject Lost
- Separating a mixed length string
- sequence numbers
- Sequential Numbers For Records
- Set a date depending on a choice from a combo box / option buttons
- Set A Public Variable In Another Database To True
- Set description on table fields in code
- Set value of combobox through vba!
- Setlist Generation
- Setting a default value in a drop-down list
- Setting control property with VBA stopped working
- Setting filters - updating on multiple sub reports?
- Setting properties in a sub-form
- Setting Startup Form with vba
- Setting Subreport filters from Parent Filter
- Setting up Outlook Reminders
- SetValue Macro
- Sharepoint Section
- SharePoint Table Issue
- shell to/from other MS documents
- Should I have one separate table for each combobox source?
- Should you archive records?
- Show a different but related value from a field in a form
- Show a query in a datasheet
- Show All Records in Datasheet subform on Form with combobox Filters On Load
- Show hidden tabs based on Listbox Column Value
- Show last page
- Show multiple records on one form.
- Show only 2 decimal places *IF* the last digit is a zero?
- Show the lock status of a record with VBA
- Show total of query results with percentage
- Show users loged in the database
- Show users logged into database
- Showing 0 if no results
- Showing unlinked data.
- Simple Form Design Question - Surely!
- Simple Query Criteria- Plz Solve it!
- Simple question (please check the pictures)
- simple report question (why am I brain dead?)
- Simple Summary
- Site Problems
- Sizing ChartArea MSGraph Control
- skipping duplicates
- Slooooow Append Query
- So happy to have found this site...
- Solid line at bottom of the cell - how to get rid of (not obvious!)
- Sort Form from List Box
- Sort months logically and not alphabetically
- Sort Row Headings for Crosstab Query
- Sort/Filter dropdown being disabled
- Sorting by boolean fields
- South Africa
- Specific fields from Access to Excel VBA
- Spell Check Options for Runtime
- Spilt the master table into four
- Split a field
- Split database security
- Split Memo Field in a query
- Split/Sub Forms
- Splitting DB Problem Please Help.
- Splitting DB question
- Splitting DBs
- Sql
- SQL "INSERT" Statement In VBA
- SQL Connection string
- SQL crosstab query with multiple grouping levels
- SQL doesn't run in vba
- SQL error
- SQL Help
- SQL null dates
- Sql syntax help
- Sql table to Combo Box...
- Standard(?) outlook import/export macro
- Start / Stop calculations
- Starting With A 0 In A Number Field
- Stepping through a table row by row
- stop design veiw
- Stop Form Feed in Report
- Stop Value From Rounding In A Table
- Strange complicated Query
- Strange NULL problem with a "Like" statement
- Strange query additions
- Strange setup attaching Jobs to Invoices using forms/subforms
- string
- String for query
- Struggling with search form and query
- Stuck at ADODB Collections
- stumped again :( multi-value combo
- Sub form apply filter
- Sub form design
- Sub sub form referencing
- Sub-form query
- Sub-Forms data not saving
- SubForm
- Subform combobox sorting question
- Subform date filter that shows all values if left blank
- Subform doesnt update after values being updated by another form
- Subform DS click field
- Subform edits
- Subform event to update automaticaly Form
- Subform format
- Subform generating multiple records
- Subform in a tab control form
- SubForm Issue
- Subform naming - best practise
- Subform not displaying record
- Subforms master/Child link
- subfrom coditional formating if one field has value
- Submit Button Code
- Subquery
- Subquery where subform is shared between 2 forms
- Subtract value from one table from each item in a group in another table.
- Suddenly Stopped Working
- Suitability of relationships
- Sum not working
- sum of the same field
- Sum to work out annual leave
- Sum() adding 1 to the overall result?
- Sumproduct
- Switching a form from data entry only to data editing
- Sync Subform Data with Main Form
- Syncing Combo boxes
- Syntax Error
- Tab Page Making me crazy
- Table Confused :(
- Table Desing Enhancement Help
- Table for specific records containing hyperlink ID
- Table input mask error
- table relationships & sql
- Table with dates and dayname
- Table with Fiscal and Percentages Calculations
- Table with IDCustomer and different primary key
- Table with multiple 1 to many relations
- Tables Versus Queries
- Tabs
- TempVars?
- Test for null date
- Testing Permissions without Errors
- Texas
- text at the bottom of the report
- Text Box Grouping Access 2007
- text box location in form using VBA
- Text Box on Form - Query Date Format Problem
- Text box Percentage format
- text box to show time taken
- Text box value base on ListBox
- Text column holds value of ID
- Text highlighting
- Textbox - Autosize - Access 2007
- TextBox [Date]+30
- Textbox and selecting issue
- Textbox displaying the Min()
- The Identifier cannot be found (in subform)
- The minimum required version to update the data is 14.0.0000.0000
- The value you entered isnt valid for this field
- The Walking Dead
- then combo box should have a certain value in it
- Theoretical Limits MS Access 2003
- Third combo box optional
- This Weeks Birthday(s) Query
- Timed log off
- To Attend or Not Attend...THAT is the question
- To automate a process
- To Clear the Fields in form and from the table with a button
- to open tab on another form.
- Toggle switch on header of form
- Total if ALL items sold
- track the neew data
- Tracking User LogIn/LogOut
- Transfer data from InfoPath to Access 2010?
- Transfer page footer summary values to the next page
- TransferDatabase
- Trim a Column
- Trouble with Calculated Field (whole number)
- Trouble with generating specific reports
- Troubleshoot Dlookup
- Trucation Error while importing Data in Access 2007
- Trusted Location
- Trying this on my own - Access Database
- Trying to auto populate a subform
- Trying to fetch combobox text in the email body of outlook
- Trying to retrieve combobox text in the email body of outlook
- Trying to update rowsource of Combobox based on value selected on another ComboBox
- Trying to use 3 fields on a form to see if record already exists or not
- TSQL Logic test if DateTime2 variable has a Date
- Tue
- Turn off Bluetooth and WiFi
- Turnover Calculation
- Two Features Work Independently but Not Together
- two page report with different data layouts
- two price
- Two tables fields into one query field??
- Two tables in query
- Two tables to result in single column with field Name identifier for each record
- UK!
- Unable to add new record to table
- Unable to find parameters
- Unable to See Datasheet Data
- Unable to set password
- Unbound TextBox Character Limit
- Uncharted Territory
- Undefined error on back-up copy
- unexpected action
- Unexpected field format
- Unique Data in Access Table
- Unit Stake / Rounding Calculations....
- unneeded code
- update a column with its last value and concat to the value of another column
- Update a lot of values in a table at once from a form
- Update column in table based on another table
- Update executed via VBA
- Update graphs usedrange
- Update multiple columns using docmd.sql "Update" command
- Update Multiple Records at once
- Update Multiple Value
- Update of Textbox in Main form from Subform Textbox afterupdate
- Update Parent form after subform updated?
- Update Query
- Update query percentage prompt
- Update query running notifications
- Update Query Syntax Issue
- Update query to add dats to table NOT overwrite!
- Update Query to change dates
- Update selected records
- Update Table 1 Certain Fields based on Table 2
- Update to True
- Update Trigger
- Update value from form
- Update Value In A Table From Another Table
- Updating a large table
- Updating Record with form help
- Updating records based on file location
- updating report based on crosstab query
- Updating Stock Quantites
- Upgrade from 2003
- Upgrading to Access 2013
- Upload Images
- Urgent
- US Marshal Smashes smart phone to avoid being recorded - the new norm?
- USA
- USA - Converting from LLC to INC - Advantages
- Use 'Instr' to search through two fields
- Use Array as Report Data source
- Use Drop Down to Open Different Reports
- use if condition expression when true as result
- Use List Box to Open Forms
- Use LIst values in query
- Use only the first letter from a word
- use the LIKE in a field to find a value
- User Account Form - Encrypted password
- User Login Form
- User Rights Issue
- User Woes
- Users
- Using .Caption instead of .Name in VBA
- Using a date field to create folder name
- Using a VBA function in SQL Query
- Using Access 2013 to make changes to DB in Access 2003
- Using Access VBA code to copy between unbound- and bound fields
- Using Access VBA to convert Crystal Reports to Excel
- Using Allen Brownes Concat module - how do I order by a field not in the query?
- Using AND
- Using append query after entering new record
- Using array to store selected items in list box
- Using autonum field as ID but not as Primkey
- Using custom function in VBA
- using data from open form to new form
- Using IIF and OR in a Query Criteria
- Using Module or function to find null values
- Using Query to Put Data in E-Mail Body
- using sumif to sum multiple columns?
- Using Text Box to filter Report
- Using Textbox in Form to Update Subform Table
- Using the '.Value' Property
- Using the Simil function for best match
- using vba to create a new record
- Validation Error
- Variable Not Being Passed to Form by Macro
- Variable report fields
- VAT Deduction formula
- VBA
- VBA afterupdate to find and goto duplicate values
- VBA autocomplete based on %
- VBA Certification
- Vba Code - (when) Are Brackets Needed
- VBA code for concatenation
- VBA Code Required to Update Field Value In Form B from Underlying Field Value Form A
- VbA code to find previous date
- VBA code to pull data from a different table
- VBA Code work on computer A
- VBA codes with repeated rows in report
- VBA Combo Filters
- VBA COmmand Button Code not working
- VBA for AuditTrail Returning the Primary Index of a Record Changed
- VBA If else problem
- VBA import to excel add criteria to set range
- VBA Looping
- VBA managing USER's Rights/Access
- VBA open DB
- VBA Progress Window
- VBA Project Issue
- Vba sql Date Time identifier
- VBA to create outlook appointment Block If error
- VBA Tracking issues User Login
- VBA when clicking on record
- vbLf
- Verification Rule based on data in another field
- video materials database (urgent)
- View All Questions Asked
- View Post
- Viewing Reports from Queries
- Viewing Text in Tables and not Numbers
- Viewing The Output Of SQL Statements (i.e. "Debug.Print")
- Virus exposed - in your Hard Drives Firmware - brand list printed
- Visual Basic 2012 textbook help
- Walking to get Fit and lose some Weight
- Want to have an event happen when ctrl+r is pressed
- Want to scroll through records in Access 2010 with mouse wheel
- Want to Select Records with Minimum value
- Wanting to add "On Hand" quantity in Order Details to Access 2010 Goods web inventory
- We can no longer reduce going to be the plane
- Web App Data Macro Issue
- Web App on Iphone
- Web Queries
- WebBrowser Control and Google maps
- Website Queries Access Database
- Wed etc
- What do Americans make of this?
- what does this mean?
- What is the deal with Access 2013?
- what to do next?
- What's Wrong with this CODE!?!?!!?
- Whats your (non-work) project and hows it going?
- WHERE in a Control Source property
- Where You From
- Where... IN statement not returning records
- which are also lookup values
- Why do we need union queries?
- Why is my form adding records on its own
- Will Apple 18K Gold Watch be the 2015 Product of Choice?
- Will This Work ?
- Windows 8.1 freezes at starting
- Windows search box
- with different criteria
- Word naming and emailing attach from Access 10
- Working with Access Forms Outside Ms Access
- Works on MS-SQL not Access
- write the same data to second table in different folder
- Write unbound form field to table
- Writing Formula in query on existing fields
- writing from form footer to table
- wrong answer in query
- yearly and weekly
- you cannot add or change a record because a related record is in table
- zero divided by zero = #Num!
0 commentaires:
Enregistrer un commentaire