Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Is a SQL server my answer??
- I currently use several Pivot Tables in Excel to link to Access tables and queries. The Access tables are very large and it's becoming cumbersome to work with the Excel files that are linked. Ex. An Excel pivot that's linked to a 700K row access table is 250MB big, and...
- Tags: Microsoft Office, Databases, dmalbrough@..., server, Microsoft Excel, Microsoft Access, Access Table, Microsoft SQL Server
- Discussion threads 2007-06-04
- Populate Info from table to access form
- I have a form that has SSN / Name / DOB / Servicing office employees table. Then I have the input table with SSN and other fields input table. On the form I have the SSN fields linked and then I call the SSN field on the form...
- Tags: SSN
- Q&A 2005-09-12
- How do I... Query foreign data using SQL Server's linked servers?
- Great option....but not for high traffic applicationsThere is no doubt that this is a great feature. But you should think of alternative options if the application has heavy traffic as the database hit using linked server is a pretty costly one. This is mainly because of retreiving data over the...
- Tags: Databases, sekhar@..., server, ODBC, Microsoft SQL Server
- Discussion threads 2007-07-10
- Copy field from one table to another table
- Hello,I am working with Access 2003. I have a table SpotData with a field names Place and I want it to be copied to a table named Spot in a field named Place. It should be automatically done when saving the data of the form SpotData linked to the SpotData...
- Tags: Microsoft Office, dani.valverde@..., SpotData
- Discussion threads 2007-11-08
- Won't remember linked file in excel
- I have a file that is linked to another file for lookup. All of a sudden everytime I open the file and add entries it opens a file open box looking for the linked file. Even if I already have the file open. I never had this...
- Tags: file-Open
- Q&A 2005-05-12
- SAP SQL Interface Query
- i have on field(which is linked to SAP i.e.it retrieves data from SAP) in SQL Table, while generating the report, i need all the data linked with the Field to be displayed LeftHandSide.Help needed for:Abdul Gaffar.Hello:00966507952593.Email:gaffar.abdul@gmail.com/abdulgaffar@somac-it.com.
- Tags: Programming languages, abdulgaffar@...
- Discussion threads 2007-07-17
- Pros and Cons of Using Linked Server 2005
- HI, We are looking at linked server to create a Virtual Database Layer to fetch data from Several Databases which may be Oracle, DB2 , Sybase or even propritry Databases with ODBC interface. Eventually we plan to create Reports on ASP.Net Webforms from the data fetched from various databases....
- Tags: Storage, Databases, gaurav.anand@..., Linked Server, Linked, database
- Discussion threads 2007-09-06
- Access Query not doing what I need
- I have a database that has several tables that are all linked with a relationship on a field that contains a unique numeric ID. I need to run a query that pulls data from two of the tables and all attempts so far are not giving me the output...
- Tags: access, alcottrj@..., Microsoft Access, programming, queries, query, software, sql, Table B
- Discussion threads 2007-03-07
- Excel / Word object uneven char spacing
- Hi all,I have a series of linked excel worksheets in a word document. I am using small font (8pt times) and all the tables have uneven spaces between characters of words. I understand this has something to do with a kerning problem. Whats weird is if I insert an excel...
- Tags: Microsoft Word, christinb@..., software, Microsoft Excel
- Q&A 2006-04-27
- Displaying a table with many rows on a form Access 2003
- Access 2003 question.I have a Table of projects and a table or tasks. Linked by project number. How do I design a form to display query results to show all the tasks related to a project. And then, be able to update a field on each task displayed...
- Tags: daniel.fabeck@..., Microsoft Access, Access 2003
- Discussion threads 2007-11-09
- Crystal Reports - Problems when encounters a NULL
- Hello - I am very new to crystal reports and I am having problems figuring out why my entire report appears blank except for field headings when it encounters a NULL value in a field that is linked to another table. I've checked the "Convert Database NULL values to Default"...
- Tags: smo06@...
- Discussion threads 2007-01-18
- Transferring Data from one form to another- Microsoft Access
- Hello,After spending hours looking online at various posts, I am at a loss. I am trying work on a couple forms that share the same primary key ("Incident#"). I am typing in the data into the first form called "RunReport". I have a command button further down...
- Tags: Microsoft Corp., toddmehl@..., Incident#, EMSCall, RunReport, Microsoft Access
- Discussion threads 2007-04-07
- Access link to Excel
- I have an excel spreadsheet which is linked to an Access database. when trying to modify the spreadsheet data by way of the access table, all i get is a beep. it will not allow anything to be entered. also, as long as the access table...
- Tags: PRODUCTIVITY, Microsoft Office, Databases, dw3123@..., spreadsheet, Microsoft Access, Microsoft Excel
- Discussion threads 2007-08-29
- Accessing an attached file from an Office e-mail
- I am using MS Access 2003 and am trying to access an attachment from an e-mail. I have linked an Exhange folder containing e-mails and through access I am able to view the informaition successfully in the table it creates. The table contains a field called Has Attachemts...
- Tags: gregmochan@..., Microsoft Office, e-mail
- Discussion threads 2007-07-03
- MS ACCESS help
- we are using a big MS Access table known as freight table which has all the fields like Origin, destn, ship date, paid date, paid amt, trans amount, consignee, client, mode, carrier etc. All the fields are linked to the transaction that took place. Transaction fields are...
- Tags: subbu1678@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-09-12
- MS Access Combo Box Problem
- I have a form using a query looking at 3 tables to populate it. In some of the tables I have fields that are populated from combo boxes with their own recordsources (sql of look up tables containing the code to store and a description. I display the description and...
- Tags: combo box, munrrob, programming, Microsoft Corp., Microsoft Access
- Q&A 2006-08-11
- Shape Analysis for Composite Data Structures
- This paper proposes a shape analysis that adapts to some of the complex composite data structures found in industrial systems-level programs. Examples of such data structures include "Cyclic doubly-linked lists of acyclic singly-linked lists", "Singly-linked lists of cyclic doubly-linked lists with back-pointers to head nodes", etc. The analysis introduces the...
- Tags: Predicate, Springer Science+Business Media, Analysis, Data Structure
- White papers 2007-05-11
- create select query with diff. mdb files
- i created two ms access database to hold my data.how can i create a select query that will include the table from the other database?can someone please help me..............?any strategies/techniques/ideas will sure be of help.thanks.You need two Queries. One with Select command for one table, other with select command for...
- Tags: Storage, Databases, database
- Q&A 2006-01-06
- Problem with Sharing in Excel linked access database
- Hiya,I have created an access database with table linked from Excel. There is only one user who has full control of Excel file. There are many users in the office who can open the Read-Only access database to view reports. The problem i face is, when an user opens the...
- Tags: Microsoft Excel, database, desktop, jazz_siva@..., windows, security, software, it management, networking, ms access, Microsoft Access
- Discussion threads 2007-02-20
- << Previous
- page 1 of 1
- Next >>
