Recent content by dead7

I have this field where it concatenates a bunch of fields with tabs between then. The DIAGNOSIS field I need to format to a certain way using this !@@@\.@@ basically putting a period 3 characters in. claimline: [DESCBETOS]![BETOSDESC] & Chr(9) & [ARGUMENT_CLAIM_LINE]![FROM_DATE] & Chr(9) &...

I am using ado access 2003, dao will not work I keep getting errors on that part

How do I say Loop Until I get to last record, I want to loop thru the records copying and pasting in to other app and stop when it gets to the last record I have this Dim stAppName As String Dim lngRetval As Long Dim dblRandomVariable As Double dblRandomVariable =...

caution, where do I put that in my code

How do I in VBA clear the clipboard contents. Clipboard.clear keeps throwing the error object not found

I have this code and it runs this winbatch program. I want it to loop thru the records in this subform. But its running to fast, I thought the timerinterval would slow it down but it is not working. Also when the code gets to the last line when I want it to stop where theres a false (its a check...

I want a made control box on a form with the next previous last and first record buttons, which I can do. but between them I would a txtbox that has the current record number and one for the total records like Record |< < 1 >| >| >* of 4 I need a text box that gives me the current record...

How can get a criteria or refrence to be in a msgbox.

I need to copy a string to the clipboard in vbcode, so it can be retrieved later in my code to go to the clipboard and get it.

How can I access the clipboard thru vbcode to see if there is something on there or its null.

I have a date field that need to be converted to a string in a public function. Does anyone know how to do that, [DATE]. I am getting a data type mismatch. or can I reference a field from a form in a public function like dim forms!formname!fieldname as string, probably not?

Can I concatenate columns in a database with a tab between each column. If so is there a special tab charater to use. sort like this column1<tab>column2<tab>column3

Can you confirm that sapiSleep is a system routine? like in this example... Sub sSleep(lngMilliSec As Long) If lngMilliSec > 0 Then Call sapiSleep(lngMilliSec) End If End Sub

I need code for setting the timer in visual basic, a sample will do.

I need a code that tells whether a form is open if its open then I want to close it. ie if Isopen(frmR) then close end if this isopen does not work