Search results

1. If you are going to use characters like hyphen or underscore place the field name in square brackets and if in doubt do it anyway. I.e. strCond = "[STUDENT-DSN] = Forms!FrmEnhancedEnrolment!StudentID" You can understand how - can easily be mistaken for an operator. 2. Make sure AllowFilters...

Report.SetFocus DoCmd.Maximize .... SwitchBoard.SetFocus DoCmd.Restore

Fair enough. Yes C++ is quite difficult VB is more logical, however it doesn't in-build an understanding of graphics so many of VB users are oblivious to the actual process involved. I think what you have proven is that access is a good databasing program but customer expectations of a user...

I'm sure they could come up with something but it is not simple considering the original concept, you know how people moan when things change. Pretty much the frame control in Visual Basic Device Context Yes Did you do join up the dots when you were a kid? You have an array of vector points...

Here is a basic solution that works (tested in Ak97). I suggest you draw within an MS Forms frame as a sort of bounding box. If you use the forms DC the line will only be partially visible because of all the child objects associated with pages, etc. In order to fix you have to code a whole lot...

No problem. Sometimes it is question of terminology. ;)

:( Aww this pains me. The purpose of interfacing is to make the job of the user easier. Input masking should only be used to aid the user to make the correct entry. Why do they want a different input mask doesn't that make a mockery of the id system in the first place?

Yes E.g. if you are using a table as your row source: SELECT DISTINCTROW [Contacts].[Home Phone], [Contacts].[Work Phone], [Contacts].[Email] FROM [Contacts]; Then simply set collumn heads to yes. :)

When you use a table there is a placeholder for new record which hold's the default value of each field. When you make a query it draws up it collects the records and orders them (regardless if you specify) so it doesn't have a placeholder. So default values will not be passed form's datasheet's...

In form's properties set cycle to current record/page. ;)

Do you have separate user groups or are you just putting a password on the database? If a particular group or user does not have edit rights there is not way they are going to be able to modify the design without attempting to decrypt or hack their way in. Are you trying to protect the design...

Do a search before you post. Study these Dim objOutlook As Object Dim objMsg As MailItem [snip] Set objOutlook = CreateObject("Outlook.Application") Set objMsg = objOutlook.CreateItem(olMailItem) [snip] With objMsg .To = 'whoever .Subject = "subject of...

Ha Ha Ha!! :D Classic quote :D

You can interface directly using a port object. However most bar code scanner packages come with intermediary software (including drivers) you can take your output (barcode number) from this. How this may works depends on the company search. You are best calling them and asking.

Mjmartin I have given this some thought. Subforms are not designed to be overlapped. Like I said there is going to be one of the subforms on top however its border is not going to be drawn where it overlaps and it is tough to change the index of the subform because it doesn't have a handle. I...

How many of these are zooming?

You'd think they would spend more time updating the software rather than the help files. :rolleyes:

But not recommended by Microsoft apparently. :confused:

Good point you'd think they would follow their own advice. :rolleyes:

You can print a report with any kind of layout, pictures you want with the field linked to the table or the form itself. Are you trying to print just the current record or all of them?