Search results

How about a report? You can customize it to look however you want. The next thing you'll want to know is how to open a report to a certain record (from a button on the form)... Give it a shot, and if you need help, let us know.

We might have a mismatch of terminology here. A listbox has no 'dropdown'. When you said you wanted a listbox, that's what I helped with. What would I do? That would depend on the scope of the project. You can use a combobox on your main form, made with the wizard as I described above...

I'm not saying a listbox is what I'd choose, but this should get you started... -Turn on the control wizard on your toolbox menu. -Put a new listbox on your form. -On the first page of the wizard, select 'look up values in table....' -Select the fields you want to SEE in your listbox. (no...

Here is a function (run in Access) that will create an HTML page with a dropdown. It will use Javascript to pop up your pictures in a new, small window. If you run the resulting HTML doc from anything but a web server, you will probably get a warning about active content in the document...

When you say CGI, PHP, etc... I take it your free web host doesn't allow ANY server-side script? ...like ASP? I don't know of a way to do an email directly from a webpage without some script running on the server. (In no way does that mean it isn't possible...I'm a relative beginner at web...

You need a 5hit load of double quotes: (extra spaces added for clarity) filter = "CenterName = " " " & NameSel.Value & " " " " I just realized that Wayne Ryan already answered this question on one of your (triplicate) posts.

Run something like this in Excel... (You could do this from Access) Private Sub CommandButton1_Click() Dim cel As Range Set cel = ActiveSheet.Range("a2") Do While Trim(cel.Value) & "" <> "" cel.Offset(0, 1) = cel.Offset(1, 0) cel.Offset(0, 2) = cel.Offset(2, 0)...

I don't think so. Take a look at this, though... http://www.access-programmers.co.uk/forums/showthread.php?t=102667&highlight=tree (the attachment posted by LagBolt at the bottom)

The value of the listbox has to be the InvoiceID. You can see where you're at by placing in the AfterUpdate of the listbox: MsgBox Me.[Mylistbox] If the value in the msgbox is not an invoiceID, you need to change the settings of your listbox...then you can add code to open your Invoice form to...

You can probably find everything you need at http://www.slipstick.com

Something like this: Left([MyField],InStr(20,[MyField]," ")-1) & "..." Change the '20' to the character position where you want to start looking for a break-point (space). The sentence above this one would become: Change the '20' to the...

Did you try objBook.Close ???

I haven't delved too far into it, but I believe it's 'Session.Timeout'.

You can append the Agent's ID to the link URL, like: http://MySite/Properties/MyProperties.asp?agentID=2 Then in the MyProperties.asp page, you use Request.QueryString("agentID") in conjunction with the SQL string. "SELECT * FROM PROPERTIES WHERE agentID = " & Request.QueryString("agentID")...

There are many ways to improve this situation. One thing I have done is NOT populate the combo box until the third letter is typed by the user. Do this by making a 'Change' event behind your combo box. In the event, do something like: If Len(Me.MyComboBox.Text) > 2 Then...

When you go File>GetExternalData>LinkTable... You get the browse dialog. Just type or paste the complete UNC path in the file name line and click OK.

While I'm thinking about possible solutions, put me down for The Smiths' "Panic".

Something like: Private Sub Investigator_AfterUpdate() If Me.MyCheckBox Then Investigator.DefaultValue = "'" & Investigator.Value & "'" End If End Sub

Use an unbound text box. Set the control source to '=1'. Notice in the text box property sheet a setting for 'Running Sum'. Set that to 'Over Group' or 'Over All'.

I don't know of a way to do that without building the recordset in VBA. My observation on your dilemma: In 99% of my experiences where something *seemed* or *was* impossible, I have found that I was trying to force a poor table structure into a very capable application. Now, I have no idea...