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
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’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
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
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 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
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
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
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
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
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
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 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
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
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
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
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
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
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
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