Search results for query: *

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) &...

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 =...

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

I need to connect Access to an Imaging program, which we have not selected yet. I have a database with a primary key field in every table that ww want to link to a folder and list of documents for the key field and have if retrieved in the viewer. Basically we'll have a form were the primary key...

Can you take away the X in the top right corner to close a database?

I can not delete a record out of a table that has turned into what looks chinese writing. I get this error "The search key was not found in any record" This seems to be happening quite a bit. Is there a fix for this?

How do you only show the first record in a filtered form if you get back 2 records that are the same.

Trying to have a form open only if the recordcount is > 1. does this look right or am I off base. The field Im concerned with is a claim# field. If there is more than one claim then an additional form should open if theres more than one claim, thats why Im using the recordcount. If...

I have a form that when you open it it saves the record, How can I stop it from doing that if I dont want the record saved I tried If IsNull([BENE_NAME]) Then Me.Undo End If Is there a save record false or maybe onclose event to say dont save the current record unless a field is filled in

How Can I build a report that is bigger than the allowed 22" in the detail. I have a bunch of detail that is only in label boxes and some pages only have labels on it.