• linking report to form by macro

    I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

    Mjward755 pointsBadges:
  • creating reports with forms/subforms

    I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I...

    Sunshine07660 pointsBadges:
  • log sql queries?

    queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

    Ktpierce5 pointsBadges:
  • spool to flat file from SQL editor

    I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?

    Daowebe20 pointsBadges:
  • Change year range on ActiveX calendar on Access form

    Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing...

    Dontgetit105 pointsBadges:
  • Make Table query Produces different result than same select query

    In MS Access what would cause a make table query to produces differnet results than same query as a select query

    Donjuanc5 pointsBadges:
  • View is taking so much time for fetching data

    i have created multilevel view (ie:- a view is inheritng data from multipe view) and its taking so much time while fetching the data. can i reduce time taking for fetching data.

    44063860 pointsBadges:
  • Autopopulating following fields

    I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. How can...

    Dknielson5 pointsBadges:
  • how do i go about using cluster software

    how do i go about using cluster software

    Frendme10 pointsBadges:
  • VB6: Getting List of records from one field of Microsoft Access Table in ComboBox

    VB6: Dear sir, For the following code I am getting "Run-time error'3265': Item cannot be found in the collection corresponding to the request name or ordinal." However, I already connected Adodc1 to my database from where I want the data. Actually, what Im trying to do is, just to get record list...

    ScorpionEyes45 pointsBadges:
  • Updating a field and counting unique field values from another fields all in the same query?

    How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

    Grantp40 pointsBadges:
  • Creating a new database

    I want to create a Part Identification database using images in the left (Navigation) pane which link via hotspots to other images and information which can then be displayed in a new window. I have worked with a database of this nature created by somebody else and I cannot seem to change anything...

    Vanguard115 pointsBadges:
  • Which multimedia database can be used with VB.NET

    i am working on a project "criminl records system, i want to add criminals picture in my form,database,which database can used with this VB.NET application.plz specify how can i connect with my form...

    Vivekagar65 pointsBadges:
  • query function that results in latest date

    Have 2 linked databases, one with name/address/ect, the second with dates service was provided for each address. I would like to query with the result being the address and other data with the date of latest service. I don't know the function that will result in only the latest date. I can get >...

    Wbfiv25 pointsBadges:
  • AccessDataSource and ‘?’ parameters asp.net

    I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an EmailAddress....

    OrangeMiro20 pointsBadges:
  • How to automate getting the .CSV file from IFS folder to local desktop

    I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV files...

    Richapd5 pointsBadges:
  • DB2/400 stored procedures

    Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

    ten20081,150 pointsBadges:
  • design a strategy for implementing various applications in one database

    how can i design a strategy to run multiple applications on one database to ensure a conflict-free database storage?

    Faisal2420 pointsBadges:
  • Trying to learn – How to filter dates…

    I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only get current dates needed. I need to know a way...

    Beginner095 pointsBadges:
  • Where to place the tempdb log file?

    I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

    SQL Server Ask the Experts2,585 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