Search results

I have imported a table of contacts from an Excel spreadsheet into a "temporary import" table in my database. That all went fine. I then ran an append query to add the records in my "temporary import" table into my contacts table. The import table has email addresses in a "short text" field...

I have records in a table which have a "Score field", with a score from 1 - 10. I want to run a report from a select query that groups the records as Scores 1-3, 4-7 and 8-10. Is this possible - and do I do it through the query or the report grouping? Or do I have to have three queries? Many...

I am using a report to print tickets for clients. Each client gets seven tickets, which I am printing on a "business card" avery set-up which has 10 "cards" per sheet in a 2 across / 5 down format. Ideally, I would like to force a page break after each group of seven, so that the whole sheet...

I have a form with two subforms. Pick a record in the form and subform1 shows some options. Pick one of those and subform2 shows more options, or sometimes none. I want to create a button that does different things dependent on whether there are any records in subform2. How can I reference...

Hello, I use the following code to open a mailmerge from Access to word: CreateMergeLetter "C:\Documents and Settings\Compaq_Owner\Application Data\Microsoft\Templates\MarkMerge.dot" This is the CreateMergeLetter Routine: Public Sub CreateMergeLetter(strTemplate As String) On Error GoTo...

I have a form on which I change or enter tasks in an underlying table. On the form I have a list box [lstTasks] which displays all of the tasks in the table. When I enter or edit a task, I have a button to click which requeries the list box. I want to be able to double click the list box to...

I have a contacts database where each contact has a memo field in which I record details of letters ent, phone calls made etc in this format: # 01/02/05 Letter sent re XYZ # 28/01/5 Telephoned at 13.26 re ABC # 15/01/05 Letter sent re PQR etc. Every now and then, I mailshot selected contacts...

I'm sorry that I haven't searched on this, but I cannot really think what crieria to search under. Basically, my problem is that when I type VBA in my control events and other modules, the cursor keeps doing weird things. Spaces dissapear and the cursor jumps ahead so that suddenly I'm typing...

How can I change the SQL of a saved query using VBA? (Basically, I want a button to reset a query that users might have modified to a "default" setting) Thanks, George

Hi. A few questions about normalising (and yes I did search first, but it's rather a general search term...) 1) If normalising is so important, why aren't Northwind and wizard-built dbs normalised? 2) Can anyone direct me towards a good idiot's guide to normalisation? 3) Can anyone point me...

I have a report showing how many people are working at various tasks. The report has a group header for [Date] and beneath that a group header for TaskID, which has the [fldTaskName] and [fldHours], which is the number of hours that each task takes. The Detail section then contains the people...

Well I find it complicated. I have a table of people, each with an ID, and I have a table of events, each with an ID. I want to design a form in such a way that when you look at each person it gives a row of event fields, one for each event, into which you can put a Number for the number of...

This is probably really basic stuff to most of you, but here goes. (In the past, I have always had tables with zillions of fields, rather than having linked tables, so I have never had to mess with this stuff before...) I have a db with 2 tables. A Main table with, say, contact names and...

Hi. The following code returns an "Item not found in this collection" error so I am obviously trying to use the wrong way to refer to one of three yes/no fields in my recordset, defined by an optiongroup on the main form. Can someone please tell me how I should be doing it. Thanks. George...

I brought a db from my home pc to my work pc. I set the db up on the work pc - everything functions normally. I then import a module into a work db on the work pc from the one I have brought in from home. When I try to run the work db it rejects parts of the code. The same code in the same...

Wizards don't work - Solved It means what is says really. None of my Access wizrds work. None of them at all whatsoever. The buttons are there, but if you click them, nothing happens. I Bought a new computer (this is several years ago, now) with windows ME and reloaded Access from the...

I have a database that is used to tell certain people about certain events (tblPeople; tblEvents) I have divided the country into areas (tblAreas). Each person wants to know about events in one or more areas. I store this in tblPeopleAreas. Each Event should be notified to people interested...