AS/400 data to Microsoft Access database
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client’s AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How [...]
Answer Question
| April 21, 2009 8:11 AM
AS/400 import/export, Microsoft Access, Microsoft Access import/export
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client’s AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How [...]
Answer Question
| April 21, 2009 8:11 AM
AS/400 import/export, Microsoft Access, Microsoft Access import/export
Access 2007 table versus forms
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
Unique ID for existing table
I want to add a column to an existing table where its values should be unique and auto generated in a sequential order
Answer Question
| April 21, 2009 11:15 AM
Auto increment, Database design, Database programming, SQL
I want to add a column to an existing table where its values should be unique and auto generated in a sequential order
Answer Question
| April 21, 2009 11:15 AM
Auto increment, Database design, Database programming, SQL
Network forensics
I am currently a final year student studying forensic computing. i was hoping someone could give me some information regarding network forensics, i would like to know if there is a need for development in this area, what is the current views on networking with regards to gathering of forensic data over a network, and [...]
Answer Question
| April 20, 2009 3:30 AM
Forensic analysis, Forensics, IT careers, Network forensics, Networking careers
I am currently a final year student studying forensic computing. i was hoping someone could give me some information regarding network forensics, i would like to know if there is a need for development in this area, what is the current views on networking with regards to gathering of forensic data over a network, and [...]
Answer Question
| April 20, 2009 3:30 AM
Forensic analysis, Forensics, IT careers, Network forensics, Networking careers
backup of MySql with VB.Net
How can i get backup of MySql in VB.Net?
Answer Question
| April 20, 2009 11:49 AM
Backup, MySQL, MySQL backup, VB.NET
How can i get backup of MySql in VB.Net?
Answer Question
| April 20, 2009 11:49 AM
Backup, MySQL, MySQL backup, VB.NET
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 [...]
Answer Question
| April 20, 2009 8:21 AM
Access, Form, macro, Microsoft Access
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 [...]
Answer Question
| April 20, 2009 8:21 AM
Access, Form, macro, Microsoft Access
Career change
I gotr my associates in IT back in 2002. Did a little data admin for about 6 months and has not worked in It field since.I graduate next month after going bk to school with BA in IT.I’d like to do security.What do i need to get back to the IT field.
Answer Question
| April 22, 2009 4:47 AM
IT careers
I gotr my associates in IT back in 2002. Did a little data admin for about 6 months and has not worked in It field since.I graduate next month after going bk to school with BA in IT.I’d like to do security.What do i need to get back to the IT field.
Answer Question
| April 22, 2009 4:47 AM
IT careers
How to implement a “is a”/generalization relationship in an ERD?
I’m using SQL Server 2005 Developer edition.
Answer Question
| April 22, 2009 2:19 AM
Database design, Database Development, ERD
I’m using SQL Server 2005 Developer edition.
Answer Question
| April 22, 2009 2:19 AM
Database design, Database Development, ERD
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?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
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?
Answer Question
| April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs
Multiple Join Update
Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number, prod_group_id number) My [...]
Answer Question
| April 24, 2009 11:47 AM
JOIN statement, SQL, SQL queries, UPDATE statement
Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number, prod_group_id number) My [...]
Answer Question
| April 24, 2009 11:47 AM
JOIN statement, SQL, SQL queries, UPDATE statement
ODBC Connection to iSeries
Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package [...]
Answer Question
| April 20, 2009 7:08 AM
Crystal Reports, Data Transformation Services, iSeries Access, iSeries connectivity, iSeries interoperability, ODBC, Open Database Connectivity, SQL Server DTS
Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package [...]
Answer Question
| April 20, 2009 7:08 AM
Crystal Reports, Data Transformation Services, iSeries Access, iSeries connectivity, iSeries interoperability, ODBC, Open Database Connectivity, SQL Server DTS
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 [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access 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 [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
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 [...]
Answer Question
| April 17, 2009 10:01 AM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
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 [...]
Answer Question
| April 17, 2009 10:01 AM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
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.
Answer Question
| April 16, 2009 9:05 AM
Database Views, Query optimization
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.
Answer Question
| April 16, 2009 9:05 AM
Database Views, Query optimization
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?
Answer Question
| April 17, 2009 3:13 AM
AS/400 Spooled Files, Flat files, SQL, 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?
Answer Question
| April 17, 2009 3:13 AM
AS/400 Spooled Files, Flat files, SQL, SQL Editor
how do i go about using cluster software
how do i go about using cluster software
Answer Question
| April 16, 2009 10:14 PM
Cluster, Cluster management, Clustering
how do i go about using cluster software
Answer Question
| April 16, 2009 10:14 PM
Cluster, Cluster management, Clustering
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
Answer Question
| April 16, 2009 7:20 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
In MS Access what would cause a make table query to produces differnet results than same query as a select query
Answer Question
| April 16, 2009 7:20 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
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. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
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. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
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 even though [...]
Answer Question
| April 15, 2009 1:11 PM
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 even though [...]
Answer Question
| April 15, 2009 1:11 PM
Database
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 rsMessageIn.State = [...]
Answer Question
| April 15, 2009 10:59 AM
Query optimization, SQL, SQL Aggregate error, SQL queries
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 rsMessageIn.State = [...]
Answer Question
| April 15, 2009 10:59 AM
Query optimization, SQL, SQL Aggregate error, SQL queries
