View Full Version : access answers
- IIf Function based on field value of continuous form
- TransferText
- Drawing objects in Access 2003 - can it be done on forms?
- delete all text starting with ..
- Help with counting occurances of similar text
- Before Update
- Help with an SQL query (opposite to a union query - if it exists)
- File Not Found error when importing forms from another database
- Adding Incremental Records
- Date Conversion
- running an update query from form...can I just use the sql cmd
- subform question
- backend corrupt
- Handling Apostrophes
- can someone tell me what I am missing with strings
- Need check box to change formula used in subform source
- Combining two queries
- Display one to many records in a mail merge
- I used to see a menu item/short cut menu to translate macros to code
- locking down tables
- Blank Form
- Adding a column in report
- Help with simple database concept
- Open the Outlook Addressbook in VBA
- Exporting To XML File
- AppHelpFile key and context-sensitive help
- Tab Form and 'cannot open more tables error'
- Report in Table Format?
- Help with VBA syntax please
- New Access / SourceSafe Bug Discovered
- Query Corrupted? - Access 2002
- Need help writing a double click event procedure
- Attaching Document
- Memo field not large enough
- Creating ODBC Data Source automatically?
- how to check list box
- Need help parsing a string - reverse Val?
- Check box changes formula used in subform
- how to open code builder for default when click on event builder in forms
- Export Query To XML
- Form colors in Access XP look goofy when converting
- Importing Excel
- Displaying and modifying 1:N data in forms?
- How to delete the missing References for VBA
- Some fields of a table are not visible in the design view
- Accessing a Report properties without opening it
- Option Button bug?
- Control Reference
- Aggregate function error
- Arvin Meyer's Good Article For Beginners
- Elookup vs Dlookup, Error 3048
- ComboBox using SQL code
- Migration to Postgres
- Front end grows when saving
- Cannot Delete access file
- [ODBC] How to compact a base ?
- continuous form buttons with different images (from table)
- Pr4int Preview Vs Print
- Help? Subdatasheet bug 'You can't hide a control that has the focus'
- How much to charge
- Missing references in VBA code
- Missing references in VBA code
- the form jump after a AfterUpdate Event
- How can I disable a reference library with VBA code
- We aim to please
- How do i hide a group footer if it's the only group?
- Database as Variable for Param query
- Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
- Protect MS ACCESS DATABASE
- Trim/Remove Unwanted Spacing In Text
- Linking to an external library with VBA code
- How can I concat the name of a control in a way that I can refer to it in code?
- Read Outlook emails using Access
- Anyone wrote VBA for calc'ing determinant of 3x3 matrix?
- Combo Box Display Problem
- posting 20050827
- repost calling a subform from another form(not main form)
- calling a subform from another form(not main form)
- How do you boot connected users from your database ?
- Repost : Reading a Text File
- Wont find infomation from table
- Verify Jet SP
- Sort Is Not Working
- PDF
- Requery
- Queries/joins with more than 2 tables
- generating sequencial numbers
- Concatenate text fields in query
- ER diagramming wish list: send a request to Microsoft
- Microsoft Scripting Runtime
- Problem with my chart in MS Access 2002 using a form and VB
- opening and closing IE
- Combo-box not displaying all entries
- Weird parameter prompt appearing after creating a subreport
- how to print (or not) the contents of a textbox in a report
- Embedded Pictures
- record lookup
- postcode finder, lookup,search
- Disk or network error
- Current concensus on using WSH libraries from Access
- Text too large to be in a field
- How to move to item in ListBox?
- permissions to import after a new workgroup file?
- making and refreshing local lookup table
- How to increase the response time by working with linked tables
- RE-linking to back end
- Annotated Calendar
- Microsoft Scripting Runtime Reference
- Ownership ?
- Conversion Map for Field Type and Field Format
- How to automate this import
- Need Help Checking Values in one table against two min max values in another
- Generate String and output to textbox in report
- Returning a number from a hex value.
- Reference Error: Difference between UK office and US office?
- Change f-e links to replica?
- Strange Problem doing DOS Dir Command in VBA Help Please
- checking input in inputbox
- DLookup Problem
- Access 2000-repeating data for labels based on # in a table
- Tossing someone off of the internet.
- Macros and fields in a table
- Does the physical path of a library matter as long as it's registered?
- problem with a LIKE query
- Group BY - Maximum Fields
- How to sort an array of string
- Finding an Installable ISAM
- Any known issues with UTF8 and UCS2 unicode???
- Setting Updatable Property of QueryDef to False
- Conditional display of records based on user's multiple selections
- Calculated total on subform will not display on main form
- Displaying (scrolling to) a specific record in a continuous form with VBA
- Access 2k/2003: Touble with delete query using WHERE EXISTS
- Updating records in a related table
- 'VB in Access' and SQL: Library Management
- 'VB in Access' and SQL: Library Management
- copy comment from access-table
- NULL data increases table size
- A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
- ARGH! Type Mismatch on Set Recordset
- MDI background color (detail) - XP
- Accounting
- Dumping query result into Excel spreadsheet
- Why this 2467 error?
- How to test the contents of a field or control?
- field is wiped out without warning
- No underlying data to support subform
- Is there an easy way to enlarge an Access report ?
- No underlying subform data to go by
- Extracting format info from database
- Form design for staff schedules that vary..
- ListBox displays values, identical ComboBox does not
- Picture
- Problem programaticaly importing tab delimeted xls file
- Change default table colors
- Change default table colors
- Form/Subform
- Problem turning off action messages in runtime - append query not working
- Assigning Values to Imported Data
- A2K - how to extend default cursor position to ALL textboxes?
- Bypass entering password to ODBC data sources
- Not returning Memo field
- .mde on different Office versions
- ActiveX demos
- Enter Key Behaviour
- dbo qualified name error in Access 2003
- Consensus on using PDA software with Access
- How to limit records displayed in ListBox?
- Who is in my database?
- How to tell if a form is open?
- Registering MPE with Access 2003
- Open Form when DB starts
- Acess developer researching non-Access web based database
- IsNothing() IsEmpty() : Why i can not find it in Access 2003 Visual Basic For Application?
- Problem with AutoExpand - Still Need Help
- API to Access Active Directory Organizational Unit Membership
- Change icon in task bar - Please help!
- Criteria For Subform Combobox Rowsource
- matching with duplicate references
- 60 GB IPOD deal found
- Toolbox
- Prevent Custom Menu From Appearing
- Verify Existence of Field Names before Opening Form
- "VBA project is corrupted", Access2003--Access2002
- Disabling menu option
- Recordset problem due to corruption?
- Can corruption cause this?
- Exporting data to excel via macros
- Error sending email
- Opening a file
- Extract information from various web sites
- FORM function no longer work after upgrade from 97 to 2003
- Code Issues
- Trivial query?
- UPDATE query results not written to database
- determining dimensions of image in a layer
- Access to CSV translation/Conversion Programmer needed...
- Mailmerge via Automation in Access.
- ADODB Connection String with password
- Create Custom Expression Builder / Calculation Engine
- Populating fields from a separate table
- UPDATE query not happy with date fields
- Adding Appointment to Outlook Public Folder
- Simple Running Tally
- Letter Search for field
- Keeping total of items entered
- Assigning an access key to a command
- How can I remove hard returns (CR + LF) in a memo field string?
- 'Data type mismatch error' using Mid function in a query
- Concurso
- add record for each text box entry
- Problem w/AutoExpand in Combobox
- Assigning Values to Imported Data
- Display image on form via network path.....
- Pass through query to stored procedure
- adding records to table from text box values
- running Access Read Only
- Auto FE updater - Wkrgrp problem.
- Subform creates duplicate records in Main Form
- Filter a form on a field in a subform two levels deep
- Toolbar launch of the Print Dialog
- Strip File Name & Folder Name from path.....
- How to use DAO 3.6 DLL
- AccHelp future development - discussion please
- SendObject & Thunderbird
- Accessing a DB on a file server through ASP on the Web Server
- Using DHTML exit control for ie5
- Can you fill a query parameter from a list ?
- Find a word or phrase in a report in Access
- adding strings to a table based on their entry into another table
- Hidden fields become visible when filter by form--how to prevent
- Referencing enumerated fields in sub-forms
- Input multiple line text file into one access record
- VBA SQL Select stmt multiple rows found but not getting RecordCount > 1
- SQL Query to Calc Gas Mileage
- Snapshot Viewer Control in Continuous Form
- Trying to copy a record within a table
- Internet explorer
- query criteria for >today?
- Custom Pivot forms
- How to lock tables with vba code?
- At random selection
- manipulating the values from expression builder and inserting in fields
- Automation Problem Office 97 In Windows 2000 SP4
- Oko IDDE and DB-manager now shareware
- Alternative To Treeview Control
- Trying to open Access 97 application with non-admin NT user
- MDI FORM in MSACCESS
- Transfertext Specification Name *.ini
- Keeping running total of part numbers entered into seperate fields
- Access Caching data?
- FORMS!reference too complex to run SQL query error
- Best way to import and update tables?
- Code to Search Tables Collection for a Specific String
- Query to Determine which record is not part of a Master Record Table
- from access to oracle
- Clear 2nd Combo on form (MS Access 2003)
- Reports preview ok, but print in top-left 1/16 of paper
- Access application with linked table to MSSQL server, data not updateable
- search VBA code from button-click on Form
- Opening MS Access from a webpage.
- deleting a column adox
- Deleting a field
- Excel Automation: I am confused
- Format field data
- Locate folders & files on network server through form....
- SQL syntax: How to insert srting with double quotes?
- late binding ?
- Sub-Subform Problem
- Duplicate tab delimited text file
- How to confine user SQL to imported tables?
- Easiest way to display properly formatted US 10 and 7 digit phone numbers?
- How can I display the group header every time there is a new page of detail records?
- Access security
- Export Query To XML
- XML
- Linked form question
- exporting memo field from access97 to excel97 truncates after 255 chars
- Report the numeric position of the 1st character in a string
- When is MS going to improve the Relationships module?
- Unable to move to different record in continuous form
- I don't want to use "Bankers Rounding"
- How to automatically fill in a web page form field?
- calendar activex control
- form formating question
- One table link breaks every time
- Auditorium setup & equipment 8/22/05
- missing references
- Audit Trail
- capturing web data thru access...
- DDL syntax for dropping relation
- Create Self-Join Query In Design View
- calendar
- list with file names
- extract table field value
- report grouping by week, month, year ..
- Print new record to label printer
- Execute dbFailonError & Cascade Delete
- #Error issue
- Import records from one database table to another
- Can A Single SQL Be Written
- Can't Compact DataBase
- distributing Access
- Linking 2 forms
- Access very slow
- Validation Macro
- How to convert an integer to a string
- Having a report going across the page - with a heading at the start of the row, then values going across...
- Displaying a temporary recordset
- Normalization Question
- CONVERT MONTHS NUMBERS TO ALPHA CHARACTERS
- Access 2003 code corruption problems
- Get MS Outlook Version Info
- Tab control Question
- combo box AtoZ ordering
- Access Project - Lookup in table
- Digital Signatures
- How to create relationships with DAO?
- Printing list of fields
- Making white sections of a picture (used in a report) transparent.
- Repeat A String In A Textbox
- I get an error back when I pass a SQL statement using Nz function to Access
- apiPlaySound
- requery question
- Why doesn't A97 cancel the click event?
- main form disappears after paste-append action using VBA
- Result of INSERT statement not showing up in following SELECT statement
- Text convert Code please
- Referring to SubForm/SubSubform controls
- Timing a form
- Criteria for Access 97
- BiskyMisky
- Is there a 'break' or 'continue' in 'Do Unitl'... 'Loop'?
- I posted this question 5 minutes ago. But it doesn't show up.
- Is there a way for Access to read CRC from other files?
- Synchronizing two forms
- Need help displaying photographs
- Access Has Broken - Help please
- Hide Permanetly the Windows Menu
- Working with report wzard
- Problems with Form fields using Linked Outlook Contacts Table
- Query where used diagram
- Should I use a crosstab for this?
- Referring to a form control in an update query
- How to convert form with vb code to html file?
- display one thing in field while allowing something else to be typed
- Does Number Contain Decimal Point?
- How to query by date?
- Search up and search down behave differently when using Find?
- A97 Font / Report question
- use of Me. gives RunTime error
- the first sunday of a month
- SENDING FAX
- Making same report appear twice on one page
- Problem with skv files
- Daily normal and overtime rates
- A97 How to force uppercase alpha chars in a textbox on a form?
- Link to Outlook Address Book
- ADO Recordset: Undefined Function 'NZ' in expression
- Get status bar text
- Can anyone help me turn this into code?
- Error Importing Text files. Error #3011
- run VBA code in something other than debug mode?
- updating bound & unbound controls on a form?
- Combo box display problem
- Can I set index properties on compound fields?
- Opening Access2003 and printing reports problem
- Can a query "look" at whats already in 2 table fields before appending a rec w/ redundant values in those two fields?
- File name on a form
- Out of memory in Access97?
- SQL Connections
- Trying to calculate a Sum
- A97 update all Command Button and Textbox Caption properties?
- String Concatenation
- Updates from external datasource
- Validation Rules
- Disabling form when a new form is opened
- import field names from fixed width text
- UNIQUE FOREIGN KEY Constraint?!?!
- autoincrement problem
- Split Database Poor Performance
- Function to count workdays
- Summarizing values for "duplicate" records
- Code To Prevent Printing A Subreport
- Report with totals only, no details
- user function in a query
- Authentication Failed Message????????
- Problem with linked tables
- Identifying Access Databases with tables linked from other Databases/Files
- Attach Files to Emails generated in Access VBA
- TransferSpreadsheet using a Query
- Combo Box to Filter Records in a Continuous Form
- Open Form in Ms-Access from a hyperlink by using dhtml control
- Table rounds all numbers to whole integers
- limit data to textbox
- copy data from a selected table to another fixed table
- Deleting a field
- Setting an autonumber programatically
- I can't get the "path" description to work for synchronizing 2 forms
- Exporting a Report to Excel
- Limiting Database - is this a good idea?
- Report Help: Reading Records From Same Field
- copy a record
- Crystal Reports active x control documentation
- adding a memo field programatically
- Subform loses recordset - shows #Name?
- Parameter Query
- API Viewer
- Excellent Resource!
- that's all we need
- printing problems with A97 on XP Pro and A03
- DoCmd.Applyfilter
- refering to a subform control
- Need VBA for file requester please
- Subform AfterUpdate goes to first parent record
- A97 table design?
- wininet vs. ftp script
- How to avoid ftping data all the time
- Mail Merge
- distributed database library
- Set Toolbar Combobox items when Toolbar is called?
- Access 2k3 Forgetting my code? :(
- Global variables are slowing down the query
- Connecting to SQL Server
- "numeric field overflow" only on linked tables...
- MS access coding standards.
- Thanks a lot experts!!
- Is there OpenArgs for Report?
- Formating numbers: I want '9' to be '009' and '19' to be '019'
- test
- CommandBars in Access 2002/2003
- What do the field type numbers returned in the debug window mean?
- Data Exporting
- Viewing Reports
- Limiting the number of records.
- Exporting Data
- printer settings
- Hard return in unbound textbox printing in report
- Need archtectural advice. DB server or File server.
- How to compact the database in VBA?
- Database w/ client access (online) and estimator
- How to compact the database in VBA?
- tricky problem :-) - self references & direction
- FTP with the WinInet dll.
- Database linking
- Losing Import Specifications - Access 2002
- database linking
- Database linking
- Simultaneous Insert
- query on different tables
- Plotting Data
- Access 2003 cannot print help please
- Retrieving Autonumber
- form speed up
- Combo Box Rowsource set at GotFocus
- Access/VBA Conditional Statement
- Access/VBA Conditional Statement
- update record event
- How to delete all the records in a table in VBA?
- Query Error Message
- Open Shortcut Menu from VBA?
- SQL select records NOT in both tables
- Auto quit database after inactive period?
- Filter on/off toggle
- How to emulate the action caused by 'Esc' button is VBA?
- Linked table manager
- Where is the daily post of our charter?
- Schema set up issue
- Performance with combined key in junction table
- Is there a way to change screen resolution in VBA
- Backing up an entire db
- Bisarre join problem.
- Adobe GoLive 5.0
- Insert string (insert without duplicates???)
- Insert string (insert without duplicates???)
- Temporary tables in A2K/ADO
- Temporary tables in A2K/ADO
- DataBase linking
- DataBase linking
- Question about creating replica
- Question about creating replica
- ADH 2002 FormResize
- ADH 2002 FormResize
- Repost: Connecting a table to itself?
- Repost: Connecting a table to itself?
- Query: Count (amount of (xDates later than GivenDate))
- Query: Count (amount of (xDates later than GivenDate))
- Access Bug with SQL Server identity columns
- Access Bug with SQL Server identity columns
- How to add a blank entry in a Query based combobox?
- How to add a blank entry in a Query based combobox?
- How to use the criteria on a calculated field?
- How to use the criteria on a calculated field?
- Advice for an Online Calendar
- Advice for an Online Calendar
- OLE Linking to Word?
- OLE Linking to Word?
- Highlighting Records
- Highlighting Records
- References, Sub forms, Picture boxes, Bald spots
- References, Sub forms, Picture boxes, Bald spots
- Go Back to the previous FORM
- Go Back to the previous FORM
- Select/Update Query
- Select/Update Query
- Showing all records in a table in the details section of a form
- Showing all records in a table in the details section of a form
- Troubles with Threads and Suns jdbc-odbc Bridge Driver?
- Troubles with Threads and Suns jdbc-odbc Bridge Driver?
- Embedded Excel Chart
- Embedded Excel Chart
- Access 2000 Menu customization
- Access 2000 Menu customization
- Access Loses my Forms and Reports
- Access Loses my Forms and Reports
- Subdatasheets. subforms and record selection
- Subdatasheets. subforms and record selection
- Subdatasheets. subforms and record selection
- Subdatasheets. subforms and record selection
- Access won't commit (to SQL Server linked table)
- Access won't commit (to SQL Server linked table)
- Invalid Dates
- Invalid Dates
- Change Datasource of embedded Excel Unbound Object Frame
- Change Datasource of embedded Excel Unbound Object Frame
- Need Ideas For Layout Of Form
- Need Ideas For Layout Of Form
- scrolling control source...any way to fix or disable this ?????
- scrolling control source...any way to fix or disable this ?????
- Forcing a Form View
- Forcing a Form View
- If Statement
- If Statement
- A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
- A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
- Access2003 Crashes when Filtering
- Access2003 Crashes when Filtering
- How to find out if a form exists?
- How to find out if a form exists?
- Error Handling
- Error Handling
- Capatalise the first letter of every word
- Capatalise the first letter of every word
- TabControl in .net
- TabControl in .net
- Recursive File Search VBA vs VB
- Recursive File Search VBA vs VB
- Database size increase
- Database size increase
- Supress Default Primary Key Message