Recent content by kirbott

In the Load event of the form include something like this: Const HEADERHT = 1000 Private Sub Form_Load() Dim NumOfRecordsToShow As Integer NumOfRecordsToShow = 5 Me.InsideHeight = HEADERHT + (500 * NumOfRecordsToShow) End Sub HEADERHT is a constant that is the...

Dim stRowSource as String Dim i as Integer For i = 0 to Ubound(arrayname) - 1 strRowSource = strRowSource & ";" & arrayname(i) Next i listbox.RowSourceType = "Value List" listbox.RowSource = strRowSource Where arrayname is the name of your array and listbox is the name of your listbox...

Place the sum function in the control source of the field: = Sum([sales]) You can refer to the currently Activeform in your code as Me if the code is part of the form's class module: ie. Me!sales refers to the sales field of the current form

We have an MSDE database for which I have built an Access Project reporting tool. The database was recently upgraded to MSDE 2000. I am now unable to view, run or create new stored procedures in this database, though I can link to tables and views without a problem. It appears that a ";1" has...

I too would be interested in the code provided by Arnauz. If anyone can help.....please. Thanks.

The InputBox function returns and empty string ("") if Cancel is selected. Simply place an If statement before your DoCmd.SendObject line: If BudHdr <> "" Then DoCmd.SendObject...... End if Hope this helps.

I am interested in an autoexec routine that will automatically install an MS Access 97 add-in if the add-in is not already installed. Anyone?

I would like to find the equivalent macro command to the existing macro command in Access97 "RunCommand.SaveAs. In particular, Access 2000 will only allow the user to save the object to the current database using this command, however in Access97 you have the option to export the object to an...

I am trying to use the GetOpenFileName API function in Access. The procedure works fine in the Windows 95 O/S but in Windows 98, I keep getting kicked out of Access when I call the function. Any suggestions?

I am trying to export an Access table as a space delimited text file, but the specifications will only allow me to set left justified columns in the text file and I need right justification. Any suggestions?

When I preview a report and print it, the lines between sections of the report and around textboxes are displayed and printed, however when anyone else in my office prints the report, the line work is omitted from the hardcopy even though it is visible on their screen in the print preview...

I am trying to set the LinkChildFields and LinkMasterFields properties for a subform in the OnOpen event procedure, but I cannot find the correct method. Can anyone help with this?