Search results

forgot to add that treatment is not a unique identifier as many people may want the same treatment, this is why I say to use timeID,Date and StaffNo, setting these three as a concatenated key will ensure unique vlaues for each appointment. to list specific appointments, set up a query based on...

To answer this question I must assume you know about primary and foreign keys because if you dont, you will have to look this up, this is a very important part of relational database theory. So here goes nothing... To avoid double bookings you need an appointments table with a foreign key from...

cant find the navigate2 function thingy lol

why doesnt this work Hi, Your email isnt visible, or at least I cant find it the forum says you dont want to recieve emails. my relationships are set correctly, I'm sure of it. I have quite a good understanding of this area. Here is my database setup: tables: Patient: PatientID as PK, Name...

why doesnt this work to be honest I have been dumped with this am I am really struggling. What is the size limit of emailing databases to the forum as so far it has reached about 3.5megs in size. I have 8 tables with all primary and foreign keys and 1:M relationships all set. My lecturer says...

hi folks, I am designing an application for an assignment for college, all seems to be going ok except that I have to teach myself access from a book. When I update a record on a form and go to another page it works fine, but if I attempt the same action ( for example creating an appointment...

hi folks, How do I open html based help file from an access form? I've looked at access help, but it only shows how to put the control on the page, and not how to link the control to the webpage? I'm missing somehting here if someone could help please?

I've been searching for the answer for this one also. I only want the results of the search to be available/displayed. Please let me know if you find a solution. Thanks. Chris

you can? how? what is the syntax please? Chris

HI, thanks, but not quite what I'm looking for. What I want is to search for a name using a textbox and command button, which results in all records containing the same criteria to be listed. For example, if I search for a surname Jones, I want all the Jones' to be listed. Maybe its a lot harder...

Hi, All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show...

Hi, All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show...

The problem I have is not knowing how to set up the search. Any help greatly appreciated. Chris

Hi, thanks for the reply, but this isn't what i had in mind. What I'd like is an empty textbox where the user enters a parameter for the search and a command button that triggers the search which then populates the other textboxes on the form. Hope someone can help. Thanks Chris

hello, could someone tell how to set up a name search on a form plase? Chris

you need an outer join query, to list all and unmatching fields

hello, I am trying to get data from one field in one table to another, depending on the value of a field in the destination table. For example I have field called treatment in an invoice table which has been populated via an append query. Now I need to have the cost of this treatment in the...

hello peeps, I am using an append query to populate a table, the data is migrating ok, but now I want to set a value in one of the blank fields to correspond with the data from one of the appended/blank fields. For example, I am copying a treatment field (from an appointment table into the...

make the criteria of the query for quantity >=1

this is VERY possible and quite easy to boot. Have you looked at the northwind database that comes with access? if not here goes... create your tables, create your relationships, in the table with the foreign key, go into design mode and select your foreign key and in the datatype select lookup...