Search results

Ok you need: Questions Table * 19 Records, a column for the question #, a column for the question + columns for possible answers Results Table * 19 Columns for answers of question # + Domain (set all the fields to required) Domain Table Although this is a data entry task the table will be...

I'll have to take your word for it. Personally I would still use a combo box then maybe a listbox or option group in the subform. Are you trying to create a multiple-choice test? If so why don't you ask one question per page? You could select a number of questions randomly and filter the rest...

He could do this but really he should question why he is using a tab control at all, it is quite messy and it would be better to use a combobox instead. This would save on space. But when you are filtering through records you don't need 'instances' of the same sub interface. The whole point of...

Try something like this: With objMailItem Set objOutlookAttach = .Attachments.Add(strFullName) .body = .body & chr(13) & chr(10) objOutlookAttach.position = len(.body) end with Havent tried it yet but attachment.position sets the position of an attachment in body of the item and is a long...

This is not a good way to close a form. Use Docmd.Close acForm, me.Name If you want to cancel on the form unload event place: [code]If MsgBox("Close Form?", vbOKCancel, "Close Form?") = vbCancel Then Cancel = True End If[code]

SetTopMostWindow is an api function and therefore you need to import it first in order to use it. I have created a a code module which you could use here

Before_Update is too late to validate information, use it merely for cosmetic things. Use the validation rule poperty of the field in the table.

The second question: Private Sub btReport_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) If (Button = acLeftButton) And (Shift = 1) Then DoCmd.OpenReport "Wine samples", acViewPreview ElseIf Button = acLeftButton Then DoCmd.OpenReport "Wine...

You might want to format the field so you begin and end with asterisks. However barcode fonts are not your only option you can use Active-X and even draw the barcode on the report on print. Try this link.

try this: RunCommand acCmdSaveRecord

It is a good idea to separate data entry and data view, either by using different forms or by switching functions on the same form. Sort out your required fields and validations first. You should really ask the user whether they want to save or not: Select Case MsgBox("Do you want to save...

I would do it as an options frame and use a case statement for value. This will be sleaker because you don't need code each checkbox.

This is a bit of a fruitless exercise like ghudson says this will not secure your database. However to log the access passwords with the network passwords is a good way to investigate possible malpractice.

A subform is a control not a form. It is easy to think of it as a form but in reality it is a control on the parent form. You will find it in the controls group not the forms group.

Your right on this one modest and I disaggre with rich. Yes it will work if you don't have the .value but it is still better sense. The reason being is a control is an object not a variable (also not all controls are obvious). You don't need to put the .value in brackets because it is not a...

:p Like I said if you have real mdi children as is the case with Access 97 (possibly 2000) you have to use that code, if the children are just 'floating' independent then it is as easy as 1-2-3. But never-the-less reports can't be popup because they rely on the mdi parent for the functionality.

Ah don't worry about it modest I'm used to it. :o :rolleyes: If you use control instead of object it should take up less memory. Also use 'control.value =' rather than just 'control ='.

You can update your tables programatically, but why bother when they can be linked. The Global Address Book contains the full list of contacts available in all the contacts folders.

something like: DoCmd.SetWarnings False 'load picture code DoCmd.SetWarnings True Hope this helps

No, this is not the way to go. You can import or link tables using Exchange/Outlook Wizard or create an instance outlook through ActiveX. I have provided an example in the code repository to use a contact name from an address box and with this retrieve the actual email address of the particular...