Recent content by MattGilbert

You could use DCount. There are examples in the help files. This should do the trick! [This message has been edited by MattGilbert (edited 06-02-2000).]

This might help Private Sub LoopThroughForms() Dim dbContainer As Container Dim conDocument As Document For Each dbContainer In CurrentDb.Containers If dbContainer.Name = "Forms" Then For Each conDocument In dbContainer.Documents 'do what you want for each form 'such as...

Try using the On Change event for the comment textbox. In here you can say... [Othertextbox] = Now This will give the date and time. Or [Othertextbox] = Date This will give just the date.

You could either have a query as the record source for the form that returned everything from one table and just the name from the other or you could set the record source of the textbox displaying the name using something like =DLookup("[Name]","Nameoftable1","[CustomerID]=" & me![CustomerID])...

You could try using the Report_NoData event if you haven't already tried this, setting the label to visible if this event is fired.

This would involve one or more win API calls from within your code - I guess you would have to get the hwnd value for the report window and then programatically set the size. Not to easy...

You could try the following: DoCmd.OpenReport "YourReportName", acPreview DoCmd.SelectObject acReport, "YourReportName" DoCmd.Maximize This should open the report full screen

Check out TransferDatabase in the help files - it might do what you want.

RPC is a Remote Procedure Call - look at http://www.whatis.com/ for a better description - then I suggest the MSDN website and a search on RPC errors.... Hope this help Matt

This might work.... Forms("MainFormName")!SubFormName.Form.Save Let me know!

You might get this message if one of your fields is returning more than 254 characters - e.g. the data from a memo field. 254 seems to be a maximum.

how about creating an instance of your mail server as an object. e.g. CreateObject("Outlook.Application") you can then use its methods and sctions such as .Recipients.Add .Type = 1, 2 or 3 (To, CC or BCC) .Attachments.Add(path to attachment) .Subject .body .Importance .Resolve .Send etc...