• Master/Child Link problem in Subform

    Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...

    Dataempress115 pointsBadges:
  • Diff. between PF and a sql table

    can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

    Anky10 pointsBadges:
  • Would someone please give me a short description about EAC (electronic access control?

    in terms of functionality and purpose are they related to biometrics and other physical control methods....

    Latin10 pointsBadges:
  • not a valid Query Management variable.

    Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

    Pmh5 pointsBadges:
  • Closing Open Databases

    I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...

    Jagoodie60 pointsBadges:
  • Why are naturl JOIN keywords not an option for producing a self-join?

    Why are naturl JOIN keywords not an option for producing a self-join?

    Meganlh5 pointsBadges:
  • DB Web Interface

    What would be the best language to use if I want to create a web interface for an Access DB? Security will be important, and users will need to make electronic certifications and have graduated levels of accessibility to the database and database output files.

    Nonitguy15 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • The most-watched IT questions this week: Oct. 6, 2009

    Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to...

    Michael Morisy7,943 pointsBadges:
  • How do I configure VMware guestOS(s) to talk to Vista Home Premium as a Host to access DB2 or any other database?

    Greetings all, I have a Vista home premium 64-bit, 4GB AMD ram, etc on a HP pavillion Laptop. My goal is to work with DB2 in testing advanced features such as replication, federation, failover and data partitioning (DPF). I want to do all of this with one physical machine (a spare office laptop)...

    OKONITA15 pointsBadges:
  • Working TRIGGER and TRANSACTIONS QUESTION

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • Ideal memory for DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box.

    We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space should we have?

    ITKE56,495 pointsBadges:
  • The IT Blog Top 10: Oct. 1, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing....

    Michael Morisy7,943 pointsBadges:
  • DB2 Web Query record count

    Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?

    BUEHLER20 pointsBadges:
  • General ODBC Error – Why

    I get an gernal ODBC error when running the below code. It looks like the sqlt is too long, but how can I get it to work as I need the query to be dynamic based on date. sqlt = "SELECT SCHED_TASK_EXEC.TASK_ID, SCHED_TASK_EXEC.TASK_TYPE, SCHED_TASK_EXEC.EXEC_TIME, SCHED_TASK_EXEC.END_TIME,...

    ITKE56,495 pointsBadges:
  • system storage

    Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

    Anky10 pointsBadges:
  • Embedded SQL

    In SQL RPGLE program, I declare a cursor using a view.. The view has name Emp_Pat_Dept_Data(EMPdata) the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names...

    Nutangujar895 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • Optimizing Query that uses linked tables and bound form w/joins

    I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

    Jagoodie60 pointsBadges:
  • HOW TO ADD REPORT IN MENU FOXPRO 2.6

    HI I AM ANKIT, I HAVE MADE A SOFTWARE WITH REPORTS, SCREEN, MENU. BUT I DON'T NO HOW TO ADD REPORTS IN DIRECTLY MENU SO PLEASE TEL ME.

    Netbusinesscorp5 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