Search results

Try this: Me!txtTapeNum = "BKU - " & Format(txtBKDate, "ddd mmm dd yy")

You can put something like this in the Update To row of the query: [memofield] & IIf([memofield] Is Null,"",Chr(13) & Chr(10)) & "Additional text" Of course, change "memofield" to the name of your memo field.

You can do this easily in your report by using "Grouping". Just go to: View/Sorting and Grouping In the upper pane of the Sorting and Grouping dialogue box, choose the field ( the field with 001, 002 ....), sort ascending. In the bottom pane put a "Yes" in "Group Footer" ("Group On" should...

You can use an Excel web query to download the page. On the Excel menu bar go to: Data/Get External Data/New Web query paste the URL, and Excel will download your data from the website.

stLinkCriteria = "[fldName]=""" & Me![lstNames] & """"

change this syntax: If (Eval("[Forms]![frmEnter Customers]![Company Name] Is Null")) Then to this: if isnull([Forms]![frmEnter Customers]![Company Name]) then

Try this: stLinkCriteria = "[fldName]='" & Me![lstNames] & "'"

You could run an update query and add 10 to your number field. Now, instead of 1,2,3, you have 11,12,13. Then you can update, say 11 to 2, 13 to 1 and 11 to 3.

You could try something like this in the OnCurrent event of your form: Private Sub Form_Current() If Me!country = "US" Then Me!phone.InputMask = "(###) ###-####" Else Me!phone.InputMask = "" End If End Sub

I would store just the address of the jpeg file in the database.

Could you tell us what you are trying to do. Is this code going to run in an Excel workbook?

OK. If you run the first query and you have the "StreeNumber" then: SteetName: Mid([fulladdress],Len([streetnumber])+2,Len([fulladdress])-(Len([streetnumber])+2+(Len([fulladdress])-InStr([fulladdress],"#")+1))) ApartmentNumber: ApartmentNumber: Mid([fulladdress],InStr([fulladdress],"#")+1)

Well, you already have the street name and apartment number seperated for the field "full address" into the field "street": Streetname: Left([street],InStr([street],"#")-1) ApartmentNumber: Right([street],Len([street])-InStr([street],"#")) Unless I am still missing the point.

The # sign is a special "wildcard" character. To search for it you have to enclose it in brackets: *[#]* will find call entries containing the # sign.

It would seem that Excel is interpreting some of them as dates. If you notice in your third example: 00001 - 00014 37270 the number 37270 is how MS programs store the date Jan 14, 2002 or: 1-14-02 What happens when it tries to reconcile the 157th day of January is anyone's guess: 00001 -...

You can create a field in your query that calculates the length of the field "Form Number" and sort on that as the first key and the "Form Number" field as the second key.

Try this link: http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=153636&page=14&view=collapsed&sb=5&o=0&fpart=

If isnull(Me!Notes1) Then Me!lblSeeNotes.Visible = False Else Me!lblSeeNotes.Visible = True End If

Where is says "jpegFolderPath" you have to substitute the name and path of the directory that holds your jpeg files. Something like: Me.[PreviewOLE].Picture = "c\:my docments\images\" & Me!lstPreviewJpgs

Try this link: http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=153636&page=14&view=collapsed&sb=5&o=0&fpart=