• Sending MS Access reports in the body of an email.

    How to send a report in MS Access to the body of an email in MS Outlook.

    Rarto10 pointsBadges:
  • Crystal – number of printed pages based on database field

    I'm relatively new to Crystal Reports, and most of the reports I’ve written are in Ver 7.0, I do have Ver 11, I have not done much with it yet. I have a Crystal Report that is used to generate a shipping label from a packing list in SQLBase. Most of the packing lists have more than line one item,...

    Flame14,925 pointsBadges:
  • Need help with FILEAID in BATCH

    I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order...

    Jonty Walker105 pointsBadges:
  • upgrade cisco aironet access point 1130 from autonomous to lightweight

    please how to upgrade cisco aironet access point 1130 from autonomous to lightweight , how can i do this step by step

    Cisco solutions5 pointsBadges:
  • open a file in access by clicking button

    I have several directory paths in a list box and I want to highlight one and double click on it and have it open the file

    Rmaylath25 pointsBadges:
  • Building A File Searching/ Tagging System

    Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...

    Stevio10 pointsBadges:
  • Database Window Stuck Behind Title Bar

    When I open a specific database in Access, the Database Window is helplessly stuck behind the title bar. I've tried everything to get it out including closing and reopening, moving menus, everything. Here is a screen shot to show you what I mean: http://i35.tinypic.com/2mq7zux.jpg If anybody could...

    Makeshiftmonkey5 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Autonumbering gone wrong Microsoft Access

    I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from a much higher...

    Kball5 pointsBadges:
  • Designing Table Layout

    Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

    CMS5 pointsBadges:
  • VB.net download once per month

    I currently have a label that displays the current month as an int i.e July = 7. I have a database with a username primary key and field 1 - 12 for each month. Each field either has a 0 or 1. I can use a detailsview to with a datasource to view all of the months data belonging to the logged in...

    N7.green5 pointsBadges:
  • datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 pointsBadges:
  • Linked Servers????

    Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another...

    EVX5 pointsBadges:
  • Creating and importing data into a relational database

    I just started programming six months ago. I have a project to import data into a relational database. I have data in an Excel file that I need to import into a database. The application is recruiting software, for government jobs. I have a list of applicants and the jobs they applied for. First, I...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Optimizing Query

    Hi, I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there...

    Sachin VCO15 pointsBadges:
  • Archiving databases on SQL Server 2000

    Could you help me to estimate how long it takes to archive 400 GB records from one of our test databases located on SQL Server 2000? Also, what would be the best approach?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database migration from SQL Server 2000 to SQL Server 2005

    I am attempting to migrate a database from SQL Server 2000 to SQL Server 2005; the size of the database is almost in terabytes. During migration, I would like to interact with the database on the SQL 2000 server. Is it possible to achieve migration without detaching the database from SQL 2000? If...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up and restoring a LIVE database in SQL Server 2000

    I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as part of the main...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 within MS Access VBA

    I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...

    Rjwilcox45 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following