Search results for query: *

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

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

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

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

I have been given a Word Document which contains a number of form fields. When you look in the properties each has been given a bookmark. In the past I have used routines which write text to bookmarks but in this case the reply is there are no bookmarks to write to. I have not written...

Hi I have generated a form with tab control. The tabs are at the top left hand side of the form. I now want to add a header section so that I can add a close form control. If, in design view, I add a header and insert a control when I move to the form view the header disappears. The tabs...

Hi I have a form which contains a control which displays the contents of a memo field. This can be half a page of A4 giving the details of the past contact history with a client. When I tab around the form and get to the memo the entire contents of the memo field are highlighted. This...

I have a form which consists of a main form and a sub form. With help, I now have the form loading with the focus on the first field of the sub form. This is great. This form will be used via a screenreader and shortcut keys are so important. It is easy enough to move round the sub form with...

Hi I have studied the results of my search for setting focus on a sub form and followed the suggestions. In the code below after opening the form "frmTechAssesSub" containing the subform "frmJobSheetNo9EditSub" and closing the calling form I want to set the focus on the "firstname" in the sub...

Hi I have a form which is based on a query. This form contains a sub form which is based on another query linked by a common field ContactID. 1) I can ensure that the main form data is saved by using "dirty" but does this affect the sub form? How do I address the subform directly so that I...

Hi I have run into a problem where I can select a group of records from different tables but I can not enter information into the records. I have 3 tables 1) ClientBasic key ContactID 2) ClientAddressLink keys ContactID, AddressID 3) ClientEmployerAddress key ClientEmployerID It is possible...

Hi I have scratched my head on this one for a while. I have a table of names and addresses. I want to build a linked system so that I can display on a single form a client's name and address and their associated socal worker's name and address. What mechanism do you use to display two records...

I have created a tabbed form on which I drop various fields. The problem is that the tab form has a white background and not the normal form background (-2147483633). So it looks out of place. Is there any way of setting the colour? I can not find it in the properties for the tab.

I built a query and tested it. I built a report based on the query and tested it. I decided to add another field to the report so I added a new field to the query. I tested the query and the new field was correctly output. I then opened the report and clicked on the field list icon. The report...

I have a form which has a date field which has a corresponding calendar button. If I type in a date then I can force a save by using me.dirty = false. ie reseting dirty. However if I use the calendar button to enter the date in the field, dirty is not set to true and I can not force a save by...