• How can I email a query output from Access 2003?

    I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do so

    MahmoudAly5 pointsBadges:
  • Multiple user login in one Access 2007 database

    I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my...

    Johnnyt05 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files... Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me out in...

    iiiiiiiiiiiii335 pointsBadges:
  • How to connect Forms 6i with MS Access

    Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah

    SuperRad40 pointsBadges:
  • Problem with Access 2010 and Adobe PDF creating a file.

    I am trying to create a PDF file from within Access 2010. I just converted from Windows XP running Access 2003. Now I am on Windows 7 with Access 2010. The following work on 2003 but the PDF creations doesn’t on 2010. Private Sub PrintInvoiceWithForm_Click() On Error GoTo...

    DPaxton180 pointsBadges:
  • Calling FTP RMTSYS from ODBC in PHP?

    Hello everyone. This is an interesting problem. I have this code and I want to call FTP RMTSYS('') command through ODBC from PHP. Nothing happens. When I issue the command in DBVisualizer: CALL QSYS.QCMDEXC('FTP RMTSYS(iSeries_SERVER)',  0000000020.00000); I get this error: Program contains...

    Avrelivs80 pointsBadges:
  • AS/400 EXIT POINT

    Hi , Has anyone worked on exit point  PGM  . I trying to write one  small PGM for allowing ODBC connectivty to my Box from specific Ip address and Userid  . When i do WRKREGINF i can see lot of exit point dont know which is used for ODBC connectivity  . . Any inputs are welcome  . Thanks ,...

    BISHT321245 pointsBadges:
  • Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
  • using SQL statements…………..

    Hi All, I have a problem. I have a string variable STR which contains SQL statements...... Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable...means I update the values of library and files at run time...in the variable STR.. I want to execute the SQL statements contained...

    navinnegi45 pointsBadges:
  • generating a custom database from an existing database

    from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.

    LVNEONCOWBOY211215 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When i tried to insert 5000lines of HTML code to the variable in jave, i am getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Report / File repository for AS/400 V5R4

    Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition to just...

    CharlieBrowne41,370 pointsBadges:
  • How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

    svankipu560 pointsBadges:
  • SQL Errr

    Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...

    Dawn81600 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Generate binary dataset after weighing cases in SPSS

    Hi, I have some variables that are of binary format (0,1) and of which I produce cross-tabs. In the case that there is a weighted variable, SPSS "imputes" some of the values "weighting" them either as (0) or (1). However, there is no way to know which values have been replaced (I cannot find any of...

    Polyc5 pointsBadges:
  • Dynamically Add Picture Control in a window in PowerBuilder

    Good day, In PowerBuilder, how can I add a picture control on a specific location on a window progmatically or at runtime...?  thanks.

    Bogus215 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 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