dlookup
In Access, the DLookup function returns a value from a specified set of records (or domain). The syntax for the DLookup function is: DLookup ( expression, domain, [criteria] ) expression is a field, calculation, control on a form, or function that you wish to return. domain is the set of records. This can be a [...]
View Answer
| July 6, 2009 3:30 PM
DLookup, Microsoft Access
In Access, the DLookup function returns a value from a specified set of records (or domain). The syntax for the DLookup function is: DLookup ( expression, domain, [criteria] ) expression is a field, calculation, control on a form, or function that you wish to return. domain is the set of records. This can be a [...]
View Answer
| July 6, 2009 3:30 PM
DLookup, Microsoft Access
What does a Solutions Architect do?
I was offered a solutions architect position a few months ago, and these were the main responsabilities for the position: <b>Responsibilities</b> The main responsibility is to ensure that all deliveries to customers, which also include documents, solution proposals, offers etc, are made in a professional way from a solution point of view, all in order [...]
View Answer
| July 6, 2009 1:41 PM
IT careers, solutions architect, Systems analysts
I was offered a solutions architect position a few months ago, and these were the main responsabilities for the position: <b>Responsibilities</b> The main responsibility is to ensure that all deliveries to customers, which also include documents, solution proposals, offers etc, are made in a professional way from a solution point of view, all in order [...]
View Answer
| July 6, 2009 1:41 PM
IT careers, solutions architect, Systems analysts
Delete OLD files from Table not having date or timestamp
I’m not aware of any method that automagically keeps track of that information. If you do not see a field(s) that relates to a create Date/Time stamp, then have a problem. Are you journaling the file? That would keep track of changes made to the file. Use DSPFD and search for ‘jour’. <pre> File is [...]
View Answer
| July 3, 2009 12:45 PM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL
I’m not aware of any method that automagically keeps track of that information. If you do not see a field(s) that relates to a create Date/Time stamp, then have a problem. Are you journaling the file? That would keep track of changes made to the file. Use DSPFD and search for ‘jour’. <pre> File is [...]
View Answer
| July 3, 2009 12:45 PM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL
cpytoimpf CSV file showing garbage
If you can, post the command so we can see what it looks like. In the mean time, make sure that the STMFCODPAG parm is set to *PCASCII ================================ The files should have the CVS extension - Can you open the files using wordpad from the PC? - Phil ================================ The file did have the [...]
View Answer
| July 2, 2009 1:54 PM
CPYTOIMPF, CSV, IFS
If you can, post the command so we can see what it looks like. In the mean time, make sure that the STMFCODPAG parm is set to *PCASCII ================================ The files should have the CVS extension - Can you open the files using wordpad from the PC? - Phil ================================ The file did have the [...]
View Answer
| July 2, 2009 1:54 PM
CPYTOIMPF, CSV, IFS
what is the responsible of the junior network engineer?
That really depends on the employer. You would need to see what the definition is according to what the HR department says and how they define that role formally. The role could be widely different for different companies for many reasons. Everything your boss tells you to do.
View Answer
| July 1, 2009 10:44 AM
Careers, IT careers, Junior Network Engineer, Network Engineers
That really depends on the employer. You would need to see what the definition is according to what the HR department says and how they define that role formally. The role could be widely different for different companies for many reasons. Everything your boss tells you to do.
View Answer
| July 1, 2009 10:44 AM
Careers, IT careers, Junior Network Engineer, Network Engineers
Career matchmaking – program development
That would be just about every job site out there. Monster.com, dice.com, etc. All these are free to the job seeker. The company with the opening to fill pays a small fee to post the jobs up there.
View Answer
| July 1, 2009 1:55 AM
Database, Database Management Systems, Software development
That would be just about every job site out there. Monster.com, dice.com, etc. All these are free to the job seeker. The company with the opening to fill pays a small fee to post the jobs up there.
View Answer
| July 1, 2009 1:55 AM
Database, Database Management Systems, Software development
To be back in the IT career
Somewhere to start would be PHP or ASP.NET programming. They are both web based and you’ll be able to transfer at least some skills over.
View Answer
| July 1, 2009 1:49 AM
HTML, IT careers, IT jobs, JavaScript, Lotus Domino Server 6.x, LotusScript, Web development
Somewhere to start would be PHP or ASP.NET programming. They are both web based and you’ll be able to transfer at least some skills over.
View Answer
| July 1, 2009 1:49 AM
HTML, IT careers, IT jobs, JavaScript, Lotus Domino Server 6.x, LotusScript, Web development
Access Reports to PDF file
The <a href=”http://www.bullzip.com/products/pdf/info.php”>Bullzip PDF printer</a> allows you to merge PDF documents. It may meet your requirements.
View Answer
| June 29, 2009 8:06 PM
Access 2007, Access reports, Microsoft Access, Microsoft Office, Office 2007, PDF, VBA, Windows XP
The <a href=”http://www.bullzip.com/products/pdf/info.php”>Bullzip PDF printer</a> allows you to merge PDF documents. It may meet your requirements.
View Answer
| June 29, 2009 8:06 PM
Access 2007, Access reports, Microsoft Access, Microsoft Office, Office 2007, PDF, VBA, Windows XP
0 Row affected
You need join dbo.[Elution_Report_Template] with dbo.[Elution_Report]
View Answer
| June 29, 2009 4:26 PM
Database engineering, Query, rows affected, SQL, Update
You need join dbo.[Elution_Report_Template] with dbo.[Elution_Report]
View Answer
| June 29, 2009 4:26 PM
Database engineering, Query, rows affected, SQL, Update
Filtering a Subform
Best way is to first create parent form and than add subform object from tool bar to form. It will automatically start the wizard where you will have to tell which field to link between parent and child form. Post completion of wizard you can go to design form and change the appearance of form. [...]
View Answer
| June 29, 2009 3:51 PM
Microsoft Access, Microsoft Access Filters, Microsoft Access subforms, Subform
Best way is to first create parent form and than add subform object from tool bar to form. It will automatically start the wizard where you will have to tell which field to link between parent and child form. Post completion of wizard you can go to design form and change the appearance of form. [...]
View Answer
| June 29, 2009 3:51 PM
Microsoft Access, Microsoft Access Filters, Microsoft Access subforms, Subform
Pictures in a DB
First of all what database are you using, MS SQL, mySQL, Oracle, etc? This is one of the reasons that it is recommended that you don’t store images within the database. Most people store them outside of the database, and store just a pointer to the file in the database.
View Answer
| June 29, 2009 12:43 AM
Binary data, Database administration, Image databases
First of all what database are you using, MS SQL, mySQL, Oracle, etc? This is one of the reasons that it is recommended that you don’t store images within the database. Most people store them outside of the database, and store just a pointer to the file in the database.
View Answer
| June 29, 2009 12:43 AM
Binary data, Database administration, Image databases
Update DateStructure Field through SQL Query
I think you need to provide more info on what you are trying to do. Are you trying to update a specific record or are you trying to change the structure of an entire field or what? Oops sorry, I hadn’t noticed that this had already been said by someone else.
View Answer
| June 26, 2009 2:49 PM
Data structures, SQL, SQL queries
I think you need to provide more info on what you are trying to do. Are you trying to update a specific record or are you trying to change the structure of an entire field or what? Oops sorry, I hadn’t noticed that this had already been said by someone else.
View Answer
| June 26, 2009 2:49 PM
Data structures, SQL, SQL queries
Information Security Degrees
I cannot answer this question for you but I think a good option would be to talk to some recruiters/headhunters and get their perspectives on this. My thoughts on this are that any education is good but real world experience is best. I would take a look at these degrees from this angle and then [...]
View Answer
| June 26, 2009 1:15 PM
american military university, amu, Degree, information assurance, Information security careers, Information Systems Security, IT careers, IT education, nsa cae, Security careers, umuc, university of maryland university college
I cannot answer this question for you but I think a good option would be to talk to some recruiters/headhunters and get their perspectives on this. My thoughts on this are that any education is good but real world experience is best. I would take a look at these degrees from this angle and then [...]
View Answer
| June 26, 2009 1:15 PM
american military university, amu, Degree, information assurance, Information security careers, Information Systems Security, IT careers, IT education, nsa cae, Security careers, umuc, university of maryland university college
dynamic temporary table variable usage
What’s the error message that you are getting? There’s no limit in SQL to the number of temp tables you can use in a single batch. However I don’t see a temp table (or table variable) in your select statement.
View Answer
| June 25, 2009 8:43 PM
Dynamic SQL, INNER JOIN, SQL tables, SQL variables
What’s the error message that you are getting? There’s no limit in SQL to the number of temp tables you can use in a single batch. However I don’t see a temp table (or table variable) in your select statement.
View Answer
| June 25, 2009 8:43 PM
Dynamic SQL, INNER JOIN, SQL tables, SQL variables
Deleting Nightly Database Backups (dumps)
There’s a cleanup task which you can add to the maintenance plan which will delete the older backups from the folder.
View Answer
| June 25, 2009 5:03 PM
Database Backup, Database backup and recovery, Database maintenance, SQL 2005
There’s a cleanup task which you can add to the maintenance plan which will delete the older backups from the folder.
View Answer
| June 25, 2009 5:03 PM
Database Backup, Database backup and recovery, Database maintenance, SQL 2005
Failover issues in a SQL Server 2005 mirrored database
What driver are you using for the DSN? If memory serves you can’t create a DSN using the SQL 2005 driver and give it the failover server’s information. The SQL 2008 driver includes this ability. Try downloading the SQL 2008 driver from the Microsoft site and installing that, and changing the DSN to use this [...]
View Answer
| June 25, 2009 5:02 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring
What driver are you using for the DSN? If memory serves you can’t create a DSN using the SQL 2005 driver and give it the failover server’s information. The SQL 2008 driver includes this ability. Try downloading the SQL 2008 driver from the Microsoft site and installing that, and changing the DSN to use this [...]
View Answer
| June 25, 2009 5:02 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring
Toggle button in Microsoft Access form
You can turn the toggle button invisible by setting the focus somewhere else (Combo0.SetFocus) then making the toggle button vanish (Toggle0.Visible = False) in the OnClick procedure. The toggle button is still there but you can’t see it.
View Answer
| June 25, 2009 3:52 PM
Database programming, Microsoft Access, Microsoft Access forms
You can turn the toggle button invisible by setting the focus somewhere else (Combo0.SetFocus) then making the toggle button vanish (Toggle0.Visible = False) in the OnClick procedure. The toggle button is still there but you can’t see it.
View Answer
| June 25, 2009 3:52 PM
Database programming, Microsoft Access, Microsoft Access forms
MS-Access
To start, are there any other groups given write permissions to the network folder and if so, is that person a member of one of those groups? Also, verify that the mdb inherited the read-only permission.
View Answer
| June 25, 2009 1:15 PM
Access 2003, Access Database, Microsoft Access, Windows XP
To start, are there any other groups given write permissions to the network folder and if so, is that person a member of one of those groups? Also, verify that the mdb inherited the read-only permission.
View Answer
| June 25, 2009 1:15 PM
Access 2003, Access Database, Microsoft Access, Windows XP
CSV file to database table
i used to convert my csv flat file into spreadsheet and import from sql server. But first I had to re-design my sql table from the flat file data and normalise it. The flat file normally contains all the data in one flat format with each field delimited by some char (eg comma). for eample, [...]
View Answer
| June 25, 2009 1:51 AM
CSV format, CSV input file
i used to convert my csv flat file into spreadsheet and import from sql server. But first I had to re-design my sql table from the flat file data and normalise it. The flat file normally contains all the data in one flat format with each field delimited by some char (eg comma). for eample, [...]
View Answer
| June 25, 2009 1:51 AM
CSV format, CSV input file
Access Database Capacity
It’s recommended that you not try and put more than 1 Gig of data into a single access database as that’s about the most the Jet engine can effective handle.
View Answer
| June 25, 2009 1:39 AM
Access Data Volume, Access Database, Access Database Capacity, Microsoft Access
It’s recommended that you not try and put more than 1 Gig of data into a single access database as that’s about the most the Jet engine can effective handle.
View Answer
| June 25, 2009 1:39 AM
Access Data Volume, Access Database, Access Database Capacity, Microsoft Access
