In Access, what datatype is most similar to an AutoNumber? That is, you can establish a relationship between an AutoNumber and what other type of field, if any?
Which of these are valid ways to refer to a form?
Forms("MyFormname")
Forms.Index(n) where n is an integer between 0 and forms.count -1 (doubly inclusive)
Forms(n) where n is an integer between 0 and forms.count -1 (doubly inclusive)
Forms.n where n is an integer between 0 and forms.count -1 (doubly inclusive)
Forms!n where n is an integer between 0 and forms.count -1 (doubly inclusive)
Forms![My Form Name]
Forms.[MyFormName]
Forms!"My FormName"
Forms."My FormName"
Forms!MyFormName
Forms.MyFormName
What is wrong with the following segment of code?
(Ignore formatting/indentation/line break errors, and assume that DisplayHelpMessage already functions properly.)
Sub GetOrgAddressFromIndividuals(frm As Form)
'sets org address fields equal to those of individual whose ID is in the info bar
If (IsBlank(frm.Address1.Value) And IsBlank(frm.Address2.Value) And IsBlank(frm.City.Value) And IsBlank(frm.state.Value) And IsBlank(frm.Zip.Value) And IsBlank(frm.country.Value)) Then
Dim dbs As DATABASE, qdf As QueryDef
Dim rst As Recordset
Set qdf = dbs.CreateQueryDef("", "SELECT * from tIndividuals where HiddenID = " & Forms.[Info].[Individual].Value & ";")
Select Case rst.NumberOfRecords
Case 0
MsgBox "Sorry, no linked individuals found!"
Case Is >= 2
MsgBox "Sorry, multiple linked individuals found -- update not possible!"
Case 1
frm.state.Value = rst.Fields("State")
frm.City.Value = rst.Fields("City")
frm.Zip.Value = rst.Fields("zip")
frm.Address1.Value = rst.Fields("Address1")
frm.Address2.Value = rst.Fields("Address2")
frm.country.Value = rst.Fields("Country")
End Select
Else
DisplayHelpMessage
End If
End Sub
What’s wrong with the following batch file? It will run on the system "server" as a scheduled command using AT. It is designed to copy the complete contents of \\server\shared\data to \\system14\srvbackup without user intervention.
net use y: \\system14\srvbackup /ID:STAND\scheduler
deltree y:\ >> \\server\utils\logs\remote_backup_delete.log
xcopy \\server\shared\data y:\backup /s /e /h >> \\server\utils\logs\remote_backup.log
net use y: /close
How would you create a new printer share on the NT server for a HP LaserJet connected to the network via JetDirect?
Word’s File Location preferences (Tools - Options - File Locations) are stored where on the computer? How might you quickly modify them on every machine?
Can you assign fixed IP addresses using a DHCP server? If so, what information do you need about a client workstation to assign it a fixed IP address using DHCP addressing on the host server?
What is the difference between NTFS and FAT? Which provides additional capabilities, and what additional capabilities does it provide? Which provides greater compatibility? Which makes a better boot drive? Which makes a better data storage drive? Why?