Search results

I'm building a patient/therapist scheduling database. The timetable reports are very tricky to do in access and i'm only a novice but in excel I can do them relatively easily. The database is to be used by busy therapists with little expertise in access and excel other than using an application...

I accidentally changed a query to a delete query. I'm not sure how I did it and now I can't see how to change it back. Please could someone advise me? TIA

I was building a simple query and got a type mismatch error. I tracked it back to my main table where a couple of fields which had key numbers in them (foreign keys?) had the data type of text - I guess that's the problem anyway because whatever I try access wont let me change it to a number...

I'm using a form to enter data into a table. I'm getting the data from namestable which is ID, firstname, lastname. I'm using a combo box which displays the firstname and lastname in the pull down list. Only the firstname is displayed in the combox box after selection. Is there a simple way...

I want to put 2 pieces of information in one text box on different lines e.g. the name of a plant and underneath it the latin name. I know how to concatenate them - [ProductName] & " " & [LatinName] - in the Field cell but how can I replace that space with a carriage return character (13)?

Is there a way to draw a table with individual cells in like (like an excel spreadsheet)? I have to print a timetable with around 20 rows and 7 columns and if I have to draw 140 text boxes I'll go mad. In each box will be an event name (in text) happening in that days column at that row's...

I want to apply an autoformat in 2007 but I'm not keen on the built-in styles. Is it possible to find some free ones on line? (Green would be nice!) I did some googling but came up empty-handed. Thanks in advance.

In my database I will have a table of names (e.g. for customers) and in some places I will be using the whole name and in some cases just the first name (e.g. 'Dear John'). I assume this means the first and last names have to be entered in their own fields. In which case, what's the easiest way...

I’m in the early stages of learning access and I’m hoping someone can explain what’s going on here for me. I created 2 tables, appointments and therapists. The therapists table will provide the name of the therapist to go into the appointment table. I created a relationship between the 2...

I'm an access (2007) novice and I'm trying to grapple with table relationships. I understand the concept of dividing data into different tables to avoid repetition but I just can't quite get a grip on primary and foreign keys. I think the bit I'm missing is how to choose the foreign key. I...

I wan't to limit entries in a field to those that appear in another table. e.g. to only allow people's names that appear in a table of staff members. Names will be added to the table from time to time. is this possible or is there an alternative? Should I use a form instead?

Can anyone recommend a guide to building an access database from scratch? I'm looking for something that outlines a general, logical approach to what sequence to do things in, from pencil and paper to final formatting and splitting etc. I'm not too worried about detail, just the sequence -...

I'm building my first database. I've created 4 tables and joined them with relationships. I have a table of therapists and another table listing the type of disciplines they might have (nurse, physio, OT etc). I think I have to add some kind of lookup list to the disciplineID field in the...

Please excuse the basic nature of these questions. I've tried to google them and had no luck. I understand that when you set an ID field as a primary key e.g. EmployeeID, it should be data type of autonumber. When that field appears in another table and you create a relationship with it, should...

In access 2007 I've added a description to a field in design view. I thought this was supposed to display in the status bar when that field was selected in datasheet view but it doesn't. Any idea what I'm doing wrong?

Can anyone suggest an approach to designing the layout of forms and reports so they fit neatly on a screen? I want my users to not need to scroll to get to everything. They'll be using 1366x768. The problem I have is not having something like a print preview to easily judge my layout. The...

i'm designing an appointments database. Each appointment will have a time - year, date and time. I'll probably have at least one report that lists them by week number. So, here are my questions: should i break up the time into seperate fields i.e. year, date and time of day, or use just one...

I use the switchboard wizard to set up a switchboard. At the moment my main switchboard has 3 items and they are all set to 'open form in add mode' and they all point to the same form at the moment (which does exist). When I try to go to form view of the switchboard I get the error 'The control...

I think, from all the advice i'm being given, that i'm trying to approach this the wrong way. Unfortunately i haven't been able to figure out the right way so i'm going to try to reframe my question... What would you say is the best way to approach the following? I want a form which allows...

Please can someone remind me the settings for achieving the following? I have a form which contains fields from my main table and also has a subform containing a query based on a filtered list of my main table. I have a combobox on the form to select a name and pass it to the query to filter...