Home : Bytes IT Community / View Full Version : MS Access
- internet
- database connectivity
- Re: Moving a VBA function to SQL server
- Why double underscore after control name
- how to choose the max between two dates or fields
- Linking Access to Sharepoint site
- Query for Percent Sign ('%') in Field
- Question on SendMail object
- Listbox displaying 0 and -1 instead of Yes/No
- Open as Read-Only
- DVD form entry and search Access (2003) database
- Open Form based on List Selection
- MS Access & Lotus Notes
- Using a control on a form to determine criteria for a query
- Unbound Form to update multiple tables
- Print a report 3 times with 3 different fields visible
- How to create Calender Month View
- Inserting a PPT slide into a Report Form
- Dealing With Different Currencies?
- Parameter Queries
- Microsoft Visual Basic Run-Time Error '2471': Unknown
- Filtering Forms
- Saving Properties in a report
- Print mailing labels and update date field
- A2000 & A2003
- Disappearing Act
- Parsing the keyboard buffer.
- Option for themes.
- SQL Server nText Memo Field With Access Form
- Only 50000 records returned from query
- Date as Parameter - Between 4/1 and 4/18 doesn't inlclude 4/18records
- Como obtener datos del gestor de correos predeterminado y el puertoSMTP
- Como obtener datos del gestor de correos predeterminado y el puertoSMTP
- Imported Tables and Relationships not shown in Relationships form
- Parameter Queries
- Which event procedure
- Date in criteria not processing all date records
- SPAM
- Display checkboxes in Query for boolean
- External Document Selection in Access - & - VBA to rename externalfile names.
- Code to Delete All Macros
- Re: Advice on securing a sensitive Access database
- Access Query on SQL Linked Tables
- Re: Need to get to a specific record
- Auto populate a field
- Populate listbox rowsource from function
- GSM dual bluetooth mobile phone Nokia,iphone,CECT unlockedwww.iselling.cc
- #Deleted record wierd problems
- How is there an 'error' with 'no message'
- Re: Subform filter restricts Parent?
- Help with Image List control
- MDE / MDB Split Databases best way to go?
- I added Date$ to a query field and am getting shaky results
- Re: Write/GetPrivateProfileString in 2003
- Re: Displaying Unused Time Slots
- Using VBA's Dir function this way: Dir Nul
- Good Reference for SQL Equivalent of FormatCurrency([Exclusion],0)
- adding new fields
- Access 1997 or 2003 or 2007?
- Databases Crashing - Any Ideas?
- Refresh back end tables when front end is opened
- Query OLAP metadata
- What would cause an error handler to work only once
- Formatting a number as hours and minutes
- XML and Access
- Criteria works for FindFirst but not for Dlookup when text containsdouble quotes
- The New Rich
- Funky Save Record Stuff
- Need for a recursive query
- Re: Advice on securing a sensitive Access database
- SSN format
- Access 2003 db compatibility w/ Access 2007
- Change font on report
- need help with inserting a set of records
- Preserving Relationship window
- Handle Triggers in MS Access 2003 with SQL Server as Back-End
- Re: Why the Spam?
- Delete Query without the confimation prompts
- Need Help to Create Object
- Re: Why the Spam?
- Connection pooling issue with pass through queries
- Many to many relationship
- Save up to 60% On 3d Modelling, 3d Graphics and 3d Animation Services
- Cannot save Form changes with VBA
- Resetting RunningSum OverAll
- move from top of page
- Freezing printing report
- connecting text boxes with lines
- Send info to cellphone
- Ascii Line Separated File Format - Export
- e-mailing a single record in a report
- Change 'Default Value' of many fields in many tables at one time
- Are Macros Evil?
- Old trouble with embedded images
- A2003 problem with boolean showing as -1 in list
- Online Matrimony
- DoCmd.OpenForm "FormName", acNormal, , , acFormReadOnly
- Declaring variables
- Access 2007 date control very slow
- combo box failure
- Remvoing numbers from a text field
- Using Functions from other Databases
- Loop through several tables and delete
- How to use a variable to get a controls value.
- Prevent form from automatically moving to new record
- IFF FUNCTION
- Use Catalog.Create to make an earlier version .mdb
- allowing the <escape> key to break out of a routine
- SPAM
- Access 2000 mde on Access 2007 runtime?
- variabele uit module
- Updating a subform after data entry
- Why won't my Form appear?
- Missing Operator syntax error is SQL VB code
- OT. Stupid Developer Tricks
- Access 2007 email as PDF
- Search multiple fields
- How to retrieve info about a linked table?
- How to obtain part of a date range
- A2K app in A2K7
- Disable Combobox Button
- Database bloat in shared A2007 DB
- Error 3709
- Tick box
- compare string to a number in sql
- Help Needed To Prevent Double Booking
- importing file from the server to a table
- Automatic backups possible (A2003)
- Deleted fields and now cannot export to Excel
- Best way to check if RTF2.OCX is installed ??
- HELP: Weighted Average Share Price
- LEFT() problems
- Problem making things visible
- Maintain select record in multiple subforms
- Application form for new projects
- Make an array of toggle buttons
- Question on updating a form
- dbhiddenobject doesnt work
- Is There A Way To Stop This Behavior In A2007?
- Access 2007 RunTime SP-1... What about back-end DB?
- Trouble updating table from a select query
- How can I force qry field to display Yes/No or True/False?
- Microsoft's development ethic.
- IP-VLAN database
- Can Anyone Duplicate This A2007 Problem
- Default Indexes on TransferText Method?
- Access 2007 navigation
- Read current count value (TimerInterval property
- you have want to system
- Access 2007 Alternate Background Color On Continuous Forms
- Filter by form problem with Yes/No Data and SQL Server
- Validation based on previous records
- Conditional Running Sum
- Maximize only one form?
- Off Topic: Safari Browser and Google Newsgroups
- Access 97 Security - Remove
- win xp support group?
- Fill text box based on combo box selection
- Subform Control
- Report/subreport/subreport repeating problem
- Import Columns from SQL Database
- Update All Rows on Continuous form Based on Selection in Footer
- Update All Rows on Continuous form Based on Selection in Footer
- Disable Close Button
- Tony's Auto FE Updater
- Group Page Numbers
- Permission Windows
- Why can't I see Export To when I right click my report
- Combining several tables in MS Access 2007
- A method for handling regular payments?
- Emulate 4th argument of OpenReport method in OutputTo method?
- is there a tool to display relationships between tables
- Random Query/Report/
- Parentheses in function call
- Average IF?
- Make Excel-file Read Only
- Update one form field when another field updates on a form
- FedEx integration
- Remote Desktop Connection
- Code runs 3 Times?
- Insert record from Access to Oracle
- Link from one database to tables of other database
- Show past 3 years
- a kind of Sum Query
- Saving an image to a temporary file?
- force pivot table view from control button
- ....
- Data Shifting Between Records - 2
- Adp and SQL Server is there a way to query SQL permissions to controluserforms?
- Getting to the chosen subform record
- is it better to query or to filter?
- residtribute
- Return (display) only part of a field
- Lebans RTF2 Active X control - How to load contents from DOC or RTFfile at run time
- Arrow buttons in continous form
- Sending a captured .dib file to an image box without storing it
- Import "Contacts" Tables from 500 MDBs
- Access 2007 / ADO Provider for Internet Publishing
- Displaying and Saving image to an automated filename
- Digitally sign Access 2007 .accda Add-In
- Possibilities for Attendance-Tracking Calendar Form?
- Data Entry Outsourcing Services: Profitable and Reliable Advantage
- Help with Error 3420 when Moving to Next Record after a Requery
- Calculating\Displaying Time over 24 hrs
- Comparing Combo Box selection across Tables
- Strange Query Behavior with Indexes
- Having trouble deleting a row using VBA query
- Subform in MainMenu Form
- Email list from Access to Outlook: How?
- frame object error
- How certificate an aplication
- Tabbed Subform Requerys to First Record
- Print out a treeview
- WiMax Solutions has strengthened its organizational structure andestablished ... WiMax Solutions is devoted in the sales and promotions ofprestigious ...
- Lookup Field in a Table set to required
- Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
- a2k - best way to make a copy of records to the same table?
- Positioning a pop-up Calendar
- large 2003 app
- Wrapping Text - Export from Access to Text File
- Calendar Control !
- tree menu
- making multiple line notes in VB editor
- DB2 Dbase Locks
- Cannot convert large 2003 program
- Weird record level locking with a self join
- Using Access to view and edit SQL Server table with Bigint primarykey
- Booking System - Vacant room report
- convert large access 2003 app
- Rows disappear when converting from Access 2007 to Access 2000
- Will Jet work for this?
- TABLE needed to match nicknames with actual given names
- Recipe for those who are in diet
- Rectangle Marker
- Outlook - Access integration
- Read Excel Spreadsheet Names from Access
- Instant Replication?
- Averaging a column of numbers in a report
- input form display problem.
- Experience with Zoho Creater and/or Dabble DB
- Double code
- Crosstab and maketable query
- using code for Quick Access Toolbar position
- Change value of checkbox at runtime (using VBA)
- I found affordable health insurance.
- Connecting to MySQL at Startup
- undefined function while retrieving data with excel (in dutch and in english)
- VBA Code for Is Not
- dynamic report columns
- Ready to use Database Structures
- Would this be easy to do??
- Can/should Status field be on Parent table in 1 to many Relationship?
- Custom icons on my custom toolbar?
- Using RDA method in SQL server 2005
- break on unhandled errors??!
- Choosing a field's record based on date
- Need remote access
- disable a97 controls upon reaching "new record"
- sharing a database on 2 pc's, one vista / one is xp
- detect if database was opened to database window view
- Write statment and Shell statement
- Network connection front end to back end
- User and friends database structure
- What would you recommend as a harmless test to determine state of SetWarnings in A97
- A97 form blows up, #258
- Update Subform when mainform info changes
- Help with this auto numbering field
- Advance Import of Data
- Access 2007--Disable Autofilter in Datasheet Subform
- what is your processor speed.....its high or low....
- Table locking up in Access 2003
- Has Anyone Else Noticed This In Access 2007?
- A03: Can't Link ODBC Tables
- Stores Balance
- Selecting Specific Records In A Multiuser Database
- Expression Not or Not Like
- Using DoCmd.FindRecord
- renaming "Exit Access" command to "Exit" in Access 2007
- problem disappears when I step through code
- Tab Control Code Question
- Access 2007 jpeg display problem
- Using AND and OR in querystring
- cron or schedule
- Service Call Area
- SQL for running average calculations
- combo box issue
- Select/highlight text and search
- help with week days
- Top companies recruiting this weekend - Apply with updated resume
- Access Application For adding/editting SQL Records
- How to work with the command "Refresh"
- How to force the curser to a next field in a datasheet form
- Data entry outsourcing takes good care of your core business
- how to limit mspaint run from hyperlink to a a single instance?
- Unable to import or export a table
- DoCmd.RunCommand acCmdDeleteRecord Problem in A2007
- Access closes when compacting and wont repair
- 97 Access Database to Office 2003
- connecting comboboxes in a subform
- how INDEX works in Ms Access
- determine if recordset is empty BEFORE running movefirst
- Report printing problems
- "When I say that I am off to do my puzzles ... all the family alsostay up the other end of the house. We have had a few "harsh" words someevenings."
- Blob in Access
- Normalization question
- nz for blanks in queries - formatting
- linking by table description name
- Combo box pain
- Slow Office Automation
- Frightening problem using Access 2003 code in 2007
- Syntax for using Nz function to handle blank fields in a querycalculation
- simulate keypress
- linking subforms
- SELECT * FROM table1 WHERE ;
- Multiple pieces of data in one field
- Any keyboard shortcuts you routinely disable in your apps?
- Modifying layout of pivot table form
- 2007 Query
- resetting the recordsource
- SQL Server 2005 Licensing concern.
- populating an unbound field in a continuous record form
- How to clear a combobox in VBA
- UnBound Combo Box Behaviour
- Is FormHeader Active ?
- searching in a continuous form: wanted a placeholder
- access2007 combo stops filtering
- i can't get my updatequeries to work.
- Rick Fisher's Find and Replace question...
- Requerying ComboBox in NotInList event
- WALK IN INTERVIEW AT RELIANCE COMMUNICATIONS
- Walkin Interview At Persistent in Bangalore on 8th and 9th March 2008
- TCS FRESHERS WALK-IN MAR 8/COGNIZANT (CTS) WALK-IN MARCH 12 (THROUGHNITEO IT SOLUTIONS)
- Anyone using Sharepoint Services as a backend to an Access frontend
- File / Record Lock Error !!
- Controlling the 'On change' event for a numeric control.
- Problem with SP during F&R
- Control Scrolling Of Continuous Form
- Convert an Access2002 database to Access2007
- Smoothen screen update
- printing multiple copies of a report
- preventing user to access/see/import/linking tables
- http post tbl records to server
- Strange Image behavior
- Form/Subform In Continuous Form
- Adding hour/minute time in MS Access
- Need Pre-Populated Grocery Database.....
- Using a recordset with Oracle
- hidden database window shows on exit
- Record Locking if time is after 7am and 7pm
- Do You Know If She Is Cheating?
- Is Report Successfully Printed ?
- does access resets margins when distributing reports?
- rs! question
- Saving Form Criteria
- Access 2k code doesn't run under Vista/A2k7
- Security Startup Dialog
- Locking in Queries for Reports
- Interactive job sheet
- Unique total for each row
- Access 2007 crashing with right click on subform
- check box into a text field on a report
- Trouble getting memo field printout exactly the same layout as theform
- 'Undefined function Dlookup' error with Sagekey 'Access 2002 MsiWizard'
- New in MS Access, need help
- Removing Customize Dropdown on a Custom Toolbar
- If me.dirty...
- unusual Ques. !!
- Access versions later than A97 allow more than 255 crosstab fields?
- Record Lock of Code problem?
- Use keyfield in linked SqlSever query
- Could not update; currently locked --> On INSERT !?
- How To Disable Or Hide the A2007 Quick Access Toolbar
- update subform filter by onchange event on main form
- use of two record sets in ms access 2000 one for retriving and the another for updating after correction
- DAO Compile Error
- too many indexes in Access 2003 database
- opinion question - deletes
- Should we Convert to Access 2007?
- office 2007 / Access 2000
- Storing A Number
- Best License Manager for your MS Access 2k7 Based application
- Why aren't my posts appearing?
- Is Access my man?
- Webservice help needed please
- Access front as front end for oracle
- DSN Behaving Badly
- Convert a String to a Form
- got myself in a corner with sub sub form and links
- SQL Help - Update Statement
- how to access the notes view programmatically ?
- Parameterized query from within query
- Combine queries that is now using Union All
- Font Size Vista vs XP in Report or Form
- Margin area in textbox not set correctly with conditional formatting.
- ms-access97 & sql server2005 - error "the data has been changed"
- Limiting a Text Field's Input Size !
- Urgent IT related openings with Corporate MNC companies all overIndia
- SQL Problem
- Using cmd buttons to jump to a record
- Interesting activeX problem / solution
- Continuous filtering with a module?
- queries
- Linked Access DB to SQL 2005 Express
- Toolbarnames, localization problem
- Access 2007 sub forms
- Export report running under Runtime 2007
- Access 2007
- Want to downgrade from Access 2007 to 2003 Version
- in which report object event does a certain activity occur?
- Use unique key for Sqlserver view for updates
- XP-like information / message
- How to update DB in use..
- Access/Office 07
- Double Lines in Datasheet view
- Create a relationship in code
- MS Graph (or equivalent)
- Query full; need extra record source!
- Help required
- MS Access Connect to Sybase ASE database
- Why Same query results in two different # in SQL Server vs MS Access
- dymo labels?
- List Source Queries in a Query
- Change forecolor of field in subform Access 2007
- Repair/Compact Database
- Sum in SubSubform #Error Message
- Comparing Two Identical Tables - Loop Through fields in a Recordset
- Access 2007 - how can you view a query output in side by side windows
- link to mdb
- htmlbody
- Transferdatabase and UNC
- continuous labels and report setup
- Table & Form
- Table & Forms
- Having trouble with query...
- Disable Lebans' RTFControl, How ?
- Freshers Recruitment & Walk-in For Freshers Feb 23-24
- Protect my database
- Problem with Access 2007 Ribbon
- Prevent Linking to SQL Server Tables
- Disk or Network error on Terminal Server
- Format conversion from number to YYYYMM
- Calculation of time
- a problem
- Calling a custom DLL function
- Complex Query Building Help
- Seeking VBA equivalent of launching MSPAINT c:\image.bmp with XP's START button
- Tabs on top of Tabs
- Cancel Row Insert
- not allow dublicate records
- Upgrading Access to 2007
- Access 2003 Error: 3218 Could not update; currently locked
- Help- Problems with rst.Edit
- check new customer is exist in table
- EISWT-08 Draft paper submission is deadline is just few days from now
- easy edit forms
- Error 3167 Record is Deleted **
- Keeping track of which queries are open
- Self Joins in Access - Error Encountered.
- Close button bug
- find position in range of values and display on form
- compile error in hidden module - module1" error when creating MDE
- Help with this query
- Consolidating records in a table
- Strange behavior: Form slowly moves down
- Change "Find" Settings in Access 2007
- Using Access through a Web Server
- Access or MySQL
- report repeats himself three times
- Access 2007 navigation pane (with Access runtime)
- Change a query's SQL code from excel
- slowdown of query with <>0 parameter in summed number field
- Calculating seven days from a Start Date
- Filter a group
- Checking to see if an .exe file is loaded
- Live exchange rate data into Access?
- preventing user to access/see/import/linking tables
- How To Find Next Autonumber Value
- All or Filtered using a CheckBox
- Refresh all forms if open by multiple users
- Automatic filter reset
- Force Users to log out.
- Access Database Online? (basic)
- Relationship
- Running macros in Access 2007 Runtime on Vista
- Open source method for converting from EUC-JP to Unicode
- Display EUC-Encoded field on Access 2007?
- Remove filter does not work...
- using wild card search
- Table ID Count
- advise about STRUCTURE for a beginner
- Table help
- Access Runtime 2007 - Installation failed
- A2K: problem with limitfieldsize code that restricts number of input characters
- Sooooooooo Slooooooow
- How to get Access form names into an Excel file?
- access accepts the MINUS operator
- Here,computer oriented programs only.
- Formatting a String Variable into columns
- Memo Field
- Trusted locations ACC2007
- Security Warning - this file may not safe...
- How to distribute an MS Access 2003 App?
- Chart static values from list box, is this possible?
- Not Sure How This Can Be Done
- Excel Spreadsheet to Access Question
- Importing date/time values
- Parse a path for a file name in Access
- One user getting read-only error
- Trigger On Click Event of a button from another form.
- Strange combo problem
- Persistence, Binding, Annotations in java: an example with Netbeans6.0 and MsAccess
- access complained: this is why...
- Compact MDB back to Access 97 format with code?
- and
- Lebans RTFControl, how to 'get back' to Word ??
- Auto FE Updater Problem
- Date Problem
- Access 2007 ribbon dropdown
- Access 2007 command buttons do not function - database in Access2000 format
- SendObject, but for a spreadsheet?
- How can I select only the rows I need?
- How can I get "CONSTANT" behavior from a variable (Constant magic)?
- Compact on Close Problem on Server
- Presentation of a date field in a report
- "Phantom" report
- Access Split Database - Others cannot lauch database from UNC
- insert fails on linked SQL table (timeout)
- access97 & .copyFromRecordset different when using sql server 2005
- continuous form: records do not automatically fit nicely
- SQL SCRIPT SHARE
- loop vs SQL
- default value i et felt i en form
- transactions and linked tables (advise requested)
- Adding icon image to button at runtime
- Linking Outlook
- Crosstab click opening a report
- Error-Project or Library not found
- Exporting specific fields from tables
- Combo Box Help.
- On Record Source update event???
- dll File
- Preventing Additions or Edits ... need help
- Access 2003 remove digital signature
- Can I create a gmail filter to forward certain email to a group
- Can access sum two fields in a form...
- XPDL integration into Access Application?
- preventing users to import data from another mdb file
- really basic access question
- once upon a time... : linked tables
- Cumulative totals in reports