Open Access 2007 files with Windows 2000 OS
The run time version of Access 2007 can only run on XP SP2 or better. So your choices are limited on 2000. You can run a virtual machine with XP SP2 and work in there or upgrade your system. You can not downgrade your database. The run time version of 2007 can be found here: [...]
View Answer
| May 13, 2009 6:36 PM
Access 2007, Microsoft Access, Microsoft Windows 2000, Windows 2000 desktop
The run time version of Access 2007 can only run on XP SP2 or better. So your choices are limited on 2000. You can run a virtual machine with XP SP2 and work in there or upgrade your system. You can not downgrade your database. The run time version of 2007 can be found here: [...]
View Answer
| May 13, 2009 6:36 PM
Access 2007, Microsoft Access, Microsoft Windows 2000, Windows 2000 desktop
run vba code as admin
You can use the VBA command: Shell() to execute SysInternals <a href=”http://technet.microsoft.com/en-us/sysinternals/cc300361.aspx”>ShellRunAs</a> or <a href=”http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx”>PsExec</a> to execute command line instructions on local or foreign machines. However, that would require storing the elevated credentials somewhere Access can read them,.. there may be Security-safe ways to do that, but I’m not familiar with them. Alternatively, if you’re [...]
View Answer
| May 13, 2009 3:18 PM
Access, Microsoft Access, VBA
You can use the VBA command: Shell() to execute SysInternals <a href=”http://technet.microsoft.com/en-us/sysinternals/cc300361.aspx”>ShellRunAs</a> or <a href=”http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx”>PsExec</a> to execute command line instructions on local or foreign machines. However, that would require storing the elevated credentials somewhere Access can read them,.. there may be Security-safe ways to do that, but I’m not familiar with them. Alternatively, if you’re [...]
View Answer
| May 13, 2009 3:18 PM
Access, Microsoft Access, VBA
Calculating prior Query fields
You may need to create a function of your own instead of using the DLookup. In the function, you could make a SQL query to find what you need. Depending on how your PK is setup, you might be able to do something like this: Function GetEndMeter(CurRowID as long) ‘Pass in the current record’s rowid [...]
View Answer
| May 13, 2009 10:14 AM
DLookup, Query optimization, WHERE statement
You may need to create a function of your own instead of using the DLookup. In the function, you could make a SQL query to find what you need. Depending on how your PK is setup, you might be able to do something like this: Function GetEndMeter(CurRowID as long) ‘Pass in the current record’s rowid [...]
View Answer
| May 13, 2009 10:14 AM
DLookup, Query optimization, WHERE statement
Access 2007: VB code to make a button press link to a specific record in another form
On your listing form, have the button run the OpenForm method. In the detail form, have the Form_Open event either set the filter property or set the RecordSource property. Using the Filter property: Sub Form_open me.filter = “Component = ” & Forms![ListingForm]![Component] me.filteron = true End Sub With the filter, the user could remove the [...]
View Answer
| May 12, 2009 3:31 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
On your listing form, have the button run the OpenForm method. In the detail form, have the Form_Open event either set the filter property or set the RecordSource property. Using the Filter property: Sub Form_open me.filter = “Component = ” & Forms![ListingForm]![Component] me.filteron = true End Sub With the filter, the user could remove the [...]
View Answer
| May 12, 2009 3:31 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
Access: Form to input dates
This could be done; but it would take some work. Because the Mon, Tue, Wed, etc. would not be bound to the table at all. You would need VBA code to insert into the table and also to read from the table to display on the form. Could you simply have them key the date [...]
View Answer
| May 12, 2009 2:27 PM
Access forms, Access Forms Database, Microsoft Access
This could be done; but it would take some work. Because the Mon, Tue, Wed, etc. would not be bound to the table at all. You would need VBA code to insert into the table and also to read from the table to display on the form. Could you simply have them key the date [...]
View Answer
| May 12, 2009 2:27 PM
Access forms, Access Forms Database, Microsoft Access
Clustered and Non clustered composite index
It depends. Generally, you do not need a second, non-clustered index on the “first” column of a multi-column clustered index, unless that index is also being used to apply a “unique” constraint on that column. An index on the second column of a two-column clustered index may well make a big difference in performance in [...]
View Answer
| May 11, 2009 9:38 PM
Clustered Index, Database, Non-Clustered Index
It depends. Generally, you do not need a second, non-clustered index on the “first” column of a multi-column clustered index, unless that index is also being used to apply a “unique” constraint on that column. An index on the second column of a two-column clustered index may well make a big difference in performance in [...]
View Answer
| May 11, 2009 9:38 PM
Clustered Index, Database, Non-Clustered Index
Updating Combobox after new data added
which language you are using? are you looking for concept or code
View Answer
| May 11, 2009 5:01 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access
which language you are using? are you looking for concept or code
View Answer
| May 11, 2009 5:01 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access
Label Traxxx Client – Anyone heard of this program?
You can try contacting Tailored Solutions, Inc. They’re the company that develops Label Traxx. Their technical suppport email is techsupport@tailored.com.
View Answer
| May 11, 2009 2:47 PM
Database, Information needs analysis, Label Traxx
You can try contacting Tailored Solutions, Inc. They’re the company that develops Label Traxx. Their technical suppport email is techsupport@tailored.com.
View Answer
| May 11, 2009 2:47 PM
Database, Information needs analysis, Label Traxx
Querying database tables with their descriptions
I think this could do the trick: <pre>SELECT o.name, e.value FROM sys.objects o JOIN sys.extended_properties e ON o.object_id = e.major_id AND e.name = N’MS_Description’ WHERE e.minor_id = 0 AND o.name = ‘you_table’;</pre>
View Answer
| May 11, 2009 2:36 PM
SQL, SQL queries, SQL Server Query
I think this could do the trick: <pre>SELECT o.name, e.value FROM sys.objects o JOIN sys.extended_properties e ON o.object_id = e.major_id AND e.name = N’MS_Description’ WHERE e.minor_id = 0 AND o.name = ‘you_table’;</pre>
View Answer
| May 11, 2009 2:36 PM
SQL, SQL queries, SQL Server Query
How to use DateDiff to calculate costs?
It should be something similar to this: <pre>SELECT tHP.resource_ID, DATEDIFF(“h”,tHP.fromTime, tHP.thruTime) * tU.cost FROM tblHourPeriod tHP JOIN tblUnit tU ON tHP.resource_ID = tU.resource_ID WHERE <conditions></pre>
View Answer
| May 11, 2009 1:56 PM
Database programming, DATEDIFF, Microsoft Access
It should be something similar to this: <pre>SELECT tHP.resource_ID, DATEDIFF(“h”,tHP.fromTime, tHP.thruTime) * tU.cost FROM tblHourPeriod tHP JOIN tblUnit tU ON tHP.resource_ID = tU.resource_ID WHERE <conditions></pre>
View Answer
| May 11, 2009 1:56 PM
Database programming, DATEDIFF, Microsoft Access
Copy/paste a record with VBA in Microsoft Access
I think the best way to do it in VBA is to use the RecordSetClone property. This way you can manipulate columns before you actually insert incase there would be issues with primary keys. The recordset clone returns all records that you currently see on the form. So this would account for filtering too. “TableName” [...]
View Answer
| May 11, 2009 1:52 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications
I think the best way to do it in VBA is to use the RecordSetClone property. This way you can manipulate columns before you actually insert incase there would be issues with primary keys. The recordset clone returns all records that you currently see on the form. So this would account for filtering too. “TableName” [...]
View Answer
| May 11, 2009 1:52 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications
empty fields in a query
Bananahead – I would begin each field’s select statment with “is not null” then as you have it. Naturally delete the final “else” Good luck! JuJu On second look, I think just deleting “else Null” will give you the results you want. The “else Null” is telling the program to enter the word “Null” when [...]
View Answer
| May 8, 2009 5:29 PM
CASE statement, NULL, SQL Query
Bananahead – I would begin each field’s select statment with “is not null” then as you have it. Naturally delete the final “else” Good luck! JuJu On second look, I think just deleting “else Null” will give you the results you want. The “else Null” is telling the program to enter the word “Null” when [...]
View Answer
| May 8, 2009 5:29 PM
CASE statement, NULL, SQL Query
Update a flat file through CL
Hi, There is a way to do this, but it involves using the QSHELL environment and it’s not very easy to follow. If I need to do something like this I normally write a small RPG program that accepts the CL variable as a parameter and writes a record to the flat file. Regards, Martin [...]
View Answer
| May 8, 2009 1:42 PM
CL, CL/400, Flat files
Hi, There is a way to do this, but it involves using the QSHELL environment and it’s not very easy to follow. If I need to do something like this I normally write a small RPG program that accepts the CL variable as a parameter and writes a record to the flat file. Regards, Martin [...]
View Answer
| May 8, 2009 1:42 PM
CL, CL/400, Flat files
QYKMIMPK Usage
Hi, Afraid I’ve never tried anything with certificates on the AS/400. Do you get any other messages in your joblog? The CPFB006 message text is pretty vague about what the cause could be. Could you post some of the code your using for the call to the api? Regards, Martin Gilbert.
View Answer
| May 8, 2009 1:13 PM
AS/400, CFPB006, DCM, Import, iSeries, QYKMIMPK
Hi, Afraid I’ve never tried anything with certificates on the AS/400. Do you get any other messages in your joblog? The CPFB006 message text is pretty vague about what the cause could be. Could you post some of the code your using for the call to the api? Regards, Martin Gilbert.
View Answer
| May 8, 2009 1:13 PM
AS/400, CFPB006, DCM, Import, iSeries, QYKMIMPK
MS Access 2002 Excessive Growth
How many rows are you manipulating. What is it doing? inserts,updates, deletes? If you are manipulating alot of records – constantly inserting, updating, deleting, the DB grows due to temp space being created to do these things. This is built into Access and it is why there is a Compact feature to get rid of [...]
View Answer
| May 7, 2009 9:21 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic
How many rows are you manipulating. What is it doing? inserts,updates, deletes? If you are manipulating alot of records – constantly inserting, updating, deleting, the DB grows due to temp space being created to do these things. This is built into Access and it is why there is a Compact feature to get rid of [...]
View Answer
| May 7, 2009 9:21 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic
Access IIF Statement Not Returning All Records based on Option Group
Change your query so that instead of the IIF being in the criteria, put it in the select. And check the True/False field of the table. So you would have a column like this: ManHrstoReturn: IIf(Forms![FormName]![OptMHs]=3,3,IIf(TrueFalseField=True,1,2)) Then in the criteria, simply reference Forms![FormName]![OptMHs] So what this is doing, is if you want both by selecting [...]
View Answer
| May 7, 2009 3:08 PM
Access 2007, IIF statement, Microsoft Access
Change your query so that instead of the IIF being in the criteria, put it in the select. And check the True/False field of the table. So you would have a column like this: ManHrstoReturn: IIf(Forms![FormName]![OptMHs]=3,3,IIf(TrueFalseField=True,1,2)) Then in the criteria, simply reference Forms![FormName]![OptMHs] So what this is doing, is if you want both by selecting [...]
View Answer
| May 7, 2009 3:08 PM
Access 2007, IIF statement, Microsoft Access
Dummying a dataset with a concatenated list of datasets
The easiest will be to comment (not DD Dummy) the 5 files that you do not need. DD Dummy may bypass rest of files. Example: //SYS040 dd dsn=File4,disp=shr //* DD DSN=CA.AT880D //* DD DSN=CA.AT814D //* DD DSN=CA.AT814D.P090 etc Let us know if it worked. I am always interested to hear about IBM mainframe, COBOl, JCL, [...]
View Answer
| May 6, 2009 4:43 PM
Concatenate, Database
The easiest will be to comment (not DD Dummy) the 5 files that you do not need. DD Dummy may bypass rest of files. Example: //SYS040 dd dsn=File4,disp=shr //* DD DSN=CA.AT880D //* DD DSN=CA.AT814D //* DD DSN=CA.AT814D.P090 etc Let us know if it worked. I am always interested to hear about IBM mainframe, COBOl, JCL, [...]
View Answer
| May 6, 2009 4:43 PM
Concatenate, Database
What new features would you like to see on ITKnowledgeExchange.com?
We all are on these type of exchange lists and it would be useful if the questions could ALL be listed at the top of the email. In this way I could glance quickly down the list and see if there are any questions I could answer or were interested in following. Ideally the list [...]
View Answer
| May 5, 2009 5:35 PM
AS/400, CRM, Database, DataCenter, datamangement, Development, Domino, Exchange, Linux, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
We all are on these type of exchange lists and it would be useful if the questions could ALL be listed at the top of the email. In this way I could glance quickly down the list and see if there are any questions I could answer or were interested in following. Ideally the list [...]
View Answer
| May 5, 2009 5:35 PM
AS/400, CRM, Database, DataCenter, datamangement, Development, Domino, Exchange, Linux, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
DateAdd Function
Can you post your query ? <b><i>I guess</i></b> you are comparing [Enter Date] to [StartDate] and not to DateAdd(“yyyy”,[Length],[StartDate]) —————————–
View Answer
| May 5, 2009 4:56 PM
Access 2007, Access 2007 functions, DateAdd Function, Microsoft Access
Can you post your query ? <b><i>I guess</i></b> you are comparing [Enter Date] to [StartDate] and not to DateAdd(“yyyy”,[Length],[StartDate]) —————————–
View Answer
| May 5, 2009 4:56 PM
Access 2007, Access 2007 functions, DateAdd Function, Microsoft Access
MySQL on AS/400 V5.3
Hi, The MySQL Site provides the installation steps. But it looks like MySQL is supported on on i5/OS V5R4 or later releases. http://dev.mysql.com/doc/refman/5.1/en/installation-i5os.html http://devzone.zend.com/article/609-MySQL-on-i5OS-Example Currently there is a 30 day trial available and once trial period is over you will have buy the license. Hope this helps ///////////////////////////////////////////////// Hi, MySQL can be installed on V5R3 [...]
View Answer
| May 4, 2009 10:03 PM
AS/400 connectivity, AS/400 database connectivity, AS/400 development, AS/400 interoperability, MySQL
Hi, The MySQL Site provides the installation steps. But it looks like MySQL is supported on on i5/OS V5R4 or later releases. http://dev.mysql.com/doc/refman/5.1/en/installation-i5os.html http://devzone.zend.com/article/609-MySQL-on-i5OS-Example Currently there is a 30 day trial available and once trial period is over you will have buy the license. Hope this helps ///////////////////////////////////////////////// Hi, MySQL can be installed on V5R3 [...]
View Answer
| May 4, 2009 10:03 PM
AS/400 connectivity, AS/400 database connectivity, AS/400 development, AS/400 interoperability, MySQL
