• Data transfer between databases

    Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic...

    JOEJOSE5 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • School Wi-Fi

    Hello. I am an Austrian pupil who is being educated to become a computer scientist. My current problem is that my school (about 750 people) needs WiFi. The WiFi is supposed to be usable with any Wi-Fi device (Phone, Tablet, laptop,...). However our teachers are supposed to operate without any...

    EvgymStudent15 pointsBadges:
  • How to limit exact file name for data access on AS/400 through ODBC

    How to limit exact file name...we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.

    ODBC35 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • How to download data from DB2/400 table

    Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

    smlegacy15 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • Linking tables in databases that change each month

    The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

    cyberGirl19665 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Incrementing a key field without autonumber

    I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?

    HNDstudent5 pointsBadges:
  • Database

    Special database object can not be located?

    trust5 pointsBadges:
  • and IIf statement in a query

    How do I write an IIF statement in a query, that does the following: if date1 - date2 is less than or = to 0 then Y else if greater than 0 then N

    Raleigh35 pointsBadges:
  • Want to move into Technical Side

    Hi, I have done my B.Sc in Chemistry and then MBA in HR. Presently I am working with consultancy as IT Recruiter and having around 3 yrs exp. Now i don't want to continue with Recruitment and want to sift into Technical side. I am thinking to do DBA or Datawarehousing course. Can anyone guide me...

    Hrakhilesh10 pointsBadges:
  • Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • How to implement a database on the users computer?

    Suppose I want to develop a database for a client/firm/user or any person. I develop the DB using SQL, now I want to display the end result or the outcome on the clients computer without displaying the coded part, i.e., he/she doesn't need to know about the codes and commands, he just manages db...

    granada15 pointsBadges:
  • AS400 Subfile session or device error

    DOW *in12 = '0' Seton 2526 Write blank Write foot1 WRITE MSGSFC Exfmt sfc01 call 'L1000C' These codes are from my program when i'm executing these pgm im getting seesion or device error. I checked with debugging , when the execution comes to the EXFMT line its showing the error.. Pls giv me some...

    Sureyz2,735 pointsBadges:
  • Question on time series

    The daily output of your company over a four week period is shown in the table below: wk 1: monday 187 tues 2203 wed 208 thurs 207 fri 217 wk 2: mon 207 tues 208 wed 210 thurs 206 fr 212 wk 3 mon 202 tues 210 wed 212 thurs 205 fri 214 wk 4 : mon 208 tues 215 wed 217 thurs 217 fri 213 (a) plot the...

    Tanvi280420 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.

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

Following