Search results for query: *

Hi Just a thought some of these fields are flags (logical) an example deceased. will the detection of empty ( false ) still work or will I have to deal with these fields separately?

Thanks guys for this information I will try it out. It should save a lot of hand codeing

strFilterm = " [ContactID] LIKE '" & MasterID & "'" Set rstm = db.OpenRecordset("SELECT * FROM qryAllClients WHERE " & strFilter) If rstm.RecordCount = 0 Then 'Found nothing Clean up recordset rstm.Close Set rstm = Nothing Else ' There is a master...

The search function does not seem to be working at the moment. I would like to work my way through a record selected from a query. Taking each field at a time and comparing it with an equivalent field in another selected record from the same query. Now I can do that by specifing the field name...

I have searched the forum but I can not compose the correct question. I have a database containing 11,000 customer records and about 40megs in size. It is split in two FE and BE. Each user has their own front end. There are about 20 users in the main office and 10 off site. A group of...

Hi I did a search on the above topic but could not find what I wanted. I have module in Access and at a certain point I want to write some text to be displayed in the status line at the bottom of the window. How do I go about that?

Hi Thanks for the help Could not get the code inserted in the Private Sub Report_Open(Cancel As Integer) to work. Kept saying that me.recordset = mydb.rst --- rst was unknown Anyway I redesigned the report and set its record set to the main query and then passed in the where clause in...

Thanks for replying I will try this when I get back to my code. I use the entire record set as I have already preselected the records and the record set "rst" is already open. set me.recordset = mydb.openrecordset("Select ..... from ....") It's the from bit I am stuck on. Do I use from...

Hi I have done a search but did not see or recognise what I am looking for. I have created a recordset of client addresses using a query. I now want to use this recordset to print labels. I can build a label sheet using the label wizard on some dummy table and call it "labelTestReport". I want...

Its OK I did more research Thanks for help

Anyone have a solution?

Hi again I created a new module and named it "clsCommonDialog". Now does that make it a class module; or is there some way of setting the properties of a module to turn it into a class module? Anyway when I try to compile I get the error on Dim cmdlgOpenFile As New clsCommonDialog "A...

Thanks for replying But to show my basic level of VB. I assume cmdlgOpenFile is some form of function or collection. Where would I find information on it. VB Help is no use. Also what would the declaration statements be? I have used "Set Fs = Application.FileSearch" in another part of the...

Hi I have done a search for this but I am not sure of the correct keywords. I have a routine which processes EXCEL files and imports them into the database. However I want to move away from forcing the user to load the EXCEL file in a certain fixed Directory. The window you get when...

Thanks for the reply. Being a complete novice at this could you outline how I lock and unlock the document using code. I tried recording a macro to do this but I did not get past the macro declaration. It seemed to stop once I pressed the unlock button. If successful, would my users then...

Hi I have created a word document which contains a number of form fields. This is retained as a locked template and the staff use it to generate new records when they contact a customer. The fields have dropdown lists which restricts the format of the input. There are other form fields...

Hi I am creating a database for a number of visually impaired people. They use screen readers ( in the main, a programme called JAWS)and so the mouse is not much use to them. This is fine for nearly all the functions of Access. However for a field on a form I want to set the mouse click...

Hi I have never seen this implemented an I am looking for some guidance on how to do it. I have a table containing 4000 names and addresses. My Company organises activities, say bowling nights, and invites clients to attend. I have an Activity Record and an attendee record. I can link the...

Thanks for this. I thought it would be different from a formfield text box and never tried it. Alan

Hi I am using access VBA to open a word document and read the contents of various formfields. I am stuck on the dropdown fields. If I use strName = .FormFields("ddReferred").Dropdown.Value I get the index of the dropdown field. How do I get the actual text in the dropdown field? This...