Search results

Yes but you will need to use some server side programming to view and or edit the contents of the database. If you know some HTML or have access to FrontPage 98+ and you know a little VBA you should have litttle problem making the transition, at least for doing the simple stuff.

I could be wrong but I think you would have to put your controls in an array. I don't have time to figure it out right now but it will be something similar to this. Hopefully some one will come in and give you a better example. Dim myArray(3) Dim I As Integer Dim strString As String Dim...

By the way if you need to reverse it on the fly you can do it with this: Dim ctl As Control For Each ctl In Screen.ActiveForm.Controls If TypeOf ctl Is TextBox Then If ctl.Visible = False Then With ctl .Visible = True End With End If...

I think this will do it for you. Dim ctl As Control For Each ctl In Screen.ActiveForm.Controls If TypeOf ctl Is TextBox Then If IsNull(ctl) Then With ctl .Visible = False End With End If End If Next ctl

Sweeto, Here is a sample that does what you want. Dim strString as String strString = Me.Field DoCmd.OpenReport "ReportName", acViewPreview, , _ "[FieldOnReport] = '" & strString & "'" The report will open and only the value that matches the Me.Field record will be shown.

The reason it happens is because Access assumes all hyperlinks should be webpages.

Change the Email Data Type in the tblCompanies to a text filed. If you need it to appear as a hyperlink in the form just fake it with formatting. That should fix your problem completely. By the way once you do that you will see why your links appear they way they do. You may have to write a...

Are you getting the addresses from a table or the form? Is it possible to strip the database of all important info and then zip it and send it to me.

Hayley, what does your email address in the field look like? If you are using the name@domain.com format it should come up correctly.

Sorry I missed this post the first time around but I thought I would post a simplified version of some email looping code just in case others may read this and want a simpler solution then the one you posted. Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail =...

I think that will do the trick. I have to modify a few other things in another table to make it work right but you have definitely put me on the right track. Thanks!

Yes thank you Elana. Here is a stripped down demo of what I am trying to do.

Hello? :confused:

I have a subform that shows all the records in my table. I also have an option group representing the 4 quarters of a year. I am trying to filter the data in the subform based on the current selected option. What is the best way to do this? Here is what I have so far I just need the proper...

GJT, I am getting close but I get this error now: Compile Error: Variable required - cant assign to the expression. Debug highlights the Private Function with Yellow and then puts a dark one character highlight over the - (minus) in the strVal = Left(strVal, Len(strVal - 1)) Thanks for all...

GJT, I must be missing a step. When I try the code you posted. I am getting an error that says Compile Error: Expected Function or Variable. It then highlights the strConvert ![JobNumber] = strConvert(TempString) Any ideas what I may of missed?

I am trying to write code that looks at a field in a recordset. I want to check a string in the RS to see if it has a hyphen or a numeric character at the end of the string. If there is a hyphen like this 3493- I want to remove the hypen and leave 3493. If there is a letter like this 4893-A I...

Here is some sample code for sending an email with record data included in the body of the message. Send email thread

For another example, lets say that you have three textbox fields on your form. The fields are named txtEmailTo, txtSubject, and txtMessage. You can fill your SsendObject command with values from the form fields with the following code. Dim strToField as String Dim strSubject as String Dim...

Hey MS just started an Access Developer center so I thought I would pass it on to you all. The Access Developer Center! I haven’t had the chance to see if there is anything useful on it yet.