Search results for query: *

I have to text fields: field1 has "2102" and field2 has "2201". Although the numbers are different they both contain the correct digits i.e. 2 x 2s, 1 x 0 and 1 x 1. what i would like to do is compare the 2 fields: for example if field1 had "2201" and field2 had "4022", field2 would be short...

I have a report with a memo field "operation" and an open form with a control "keywords". When I preview the report I would like the matching text in the control "keywords" to be highlighted in the memo field "operation" possibly with a different colour. I have tried CategDesc_2k.mdb from a...

Hello, A common problem I feel that will come to all onstream users eventually, I now have several ADR 50 media but no working tape drive to put them in, I have some old data I wish to restore (backed up using Windows 2000 backup), can anyone help (apart from sourcing another ADR50 drive, tried...

I need to be able to either enable page header on the last page of a report (because of pre-printed stationary) or insert blank lines. The last page in this instance is always page 4 . . . I have tried to recognise page 4 on the page header format of the page and then make a sub report visible...

is there a way of finding/storing your mouse position (x, y) at the time of "on-click" or "mouse Up" ?, when using a continuos forms ? regards Leckie

In asp, is there a way of working out the number of days between two dates ie. form1.finishdate.value less form1.startdate.value = no of days and can finishdate.value = startdate.value + 1 any help much appreciated regards Leckie

I have seen some code for dragging and dropping (Copying and Pasting) using the mouse, but can't find it again, I would like to be able to drag a record from one list box to another just using the mouse. ant help much appreciated regards Gezro

Is there a way of copying objects such as forms, reports and query's from one database to another using code ? Gezro.

my code Dim wk As String wk = Format(Date + 7, "ww") fld = "[" + wk + "]" this bit works ok DoCmd.GoToControl fld this won't fld.SetFocus any help much appreciated . . regards Gezro

I have a simple drag and drop module running which works fine between two list boxes, what I would like to see is the contents of what I am dragging to show at the mouse pointer while doing so . . is this possible ? in anticipation . . Gez

I currently have 100k + records to which I need to have a find record combo box for, at the moment access limits the number of rows to 65536 , is there a way of increasing the number of rows in a combo box ?

Dim db As Database Dim set1 As DAO.Recordset Set db = CurrentDb() Set set1 = db.OpenRecordset("archives", dbOpenDynaset) set1.FindFirst "[factory_ref]='" & [factory_ref] & "'" set1.Edit set1.[lock_ref] = Me![partcode] set1.Update set1.Close the above works fine...

I have an application form that applicants fill out when they come for interview, what I would like is a timer event so that when the applicant starts to fill out the form the timer starts, when he presses a "finished button" a hidden control would store the time taken to complete the...

we are using Access 97 on various operating systems, a problem exist particulary with Windows 2000 when a database is opened CPU usage peaks and maintains at 100% , does anyone know a reason for this and possible a cure ?

I have a command button open an image in an unbound ole box, ie. Me![imageframe].Picture = Me![imagepath], how can I check that the file Me![imagepath] is present so that I don't get an error, thankyou in anticipation . .

Is there a way of formatting a section of text to fontbold in a message box i.e msgbox "hello" & [myfield].fontbold=true thankyou

Is their a way of counting the charactors in a text box as a user is typing and updating an unbound field as the user continues to type ? (not after updated) any help much appreciated . . regards Leckie

Does anyone know if one can utilise the "search files containing text" of windows explorer from within access ? regards Leckie

Need some ideas, I need to find a bar code reader that works well with access, is there such a beast ? any help appreciated . .

Problem with trying to save an excel worksheet error message "object dos'nt support this property or method." here is the code I'm using Dim DB As Database Dim rs As Recordset Dim X As Object Set DB = CurrentDb Set rs = DB.OpenRecordset("tblSample") Set X =...