Search results

Hi all, I'm sure this is easy to do but for some reason i just cannot get it working. Hopefully someone here can tell me where i'm going wrong. I have two tables in a database and the have a linking unique field. I want to update a column in one table from a column in another where the linking...

I have a table that has (to simplify things) two fields. [Patient_No] [ID] BA4206 1067404 BA4206 1067405 BG1013 1067545 BG1013 1067546 BG1013 1067547 BG1111 1078432 I want to be able to...

Hi all, I have a problem with a delete query i am trying to set up and hopefully one of you experts can help me out. I have a table called [PMI] and a table called [Referrals] The tables have a one to many relationship and are linked by the primary key field Patient_No. I want to delete all...

Hi all Hopefully someone can help me with this problem. I have a table in a database which shows patient contact details. From this table i have been trying to calculate a patients dependency based on the contacts made and there duration. I have written a VB program which will eventually do...

Hi all. I have a problem to do with getting values from a field in a subform and copying the values to a field in the main form that contains the subform. In my subform i have a field in the footer which counts all the records. I'd like to be able to get this value into an unbound text box on...

Hi all I have a table in my database which i want to use so that i can amalgamate the data in multiple database (same structure) to this one table. i have links to all the relevant tables in the database and have append queries which take all the data from each of the tables and append them to...

Hi all I have a main form on which i have a subform whose record source is a query which counts records which fall between a start date and an end date. The query works fine if i just use the standard prompts that access provides. Ideally i want the user to enter the two dates into unbound text...

Hiya Does anyone know why when i have two forms set to non pop up, they both work as they should. as soon as i change them to pop-up forms they do not work properly. as far as i can see the VB code is ran strangley. Was wondering if anyone else has had similar problems. Cheers

Hi again Hopefully a simple question. I have a form that has a text entry box and a button. a value is input into the box and the button then clicked. the button brings up another form giving the user the relevant information. the problem is that when the form is closed the first form then...

Hi all i have a form on which there is a text box which takes in a value. on entering the value the user then clicks on a button which opens another form whose recordsource is the result of a query which takes the previously entered value. i was wondering if there is a way to bring up a message...

I have a problem which i hope someone will know the answer to, its probably really simple. I have a form bound to a table which stores personal details of people, there is a primary key field called "log book number". What i'd like to do is click a button on my form which takes me to a test...

Hi all This hopefully is a simple question. I have a form that books courses. I'd like it so that i can have a button that can be clicked that will take the details from the current record and append them to the table, only it must add 14 days on to the date so the course is booked on a...

Hi all I have a form with a calander on it that i have set up to open a pop up form when a date is clicked. The pop up form shows a continuous form of PC's which have been booked on the date clicked on the calander via use of a query. At the top of the pop up form i am trying to show the date...

Hi all. I have a form that i wish only to open if a particular criteria is met. The code i have got so far is as follows: Private Sub OpenTraineeDetailsBtn_Click() MsgBox Me.NumOnCourse MsgBox Me.Location.Column(2) If (Me.NumOnCourse < Me.Location.Column(2)) Then On Error GoTo...

Hi all I have a problem that i'm not quite sure how to sort. Initially when i started using Access, i had message boxes that would pop up when i was at the end of all records and there were no more in the direction i was going. These message boxes just let me click ok and then dissappeared. The...

Hi people I am trying to get a combo box to display a set list depending on the values in a table. I have a form which takes booking details for PC's and on this form is a combo box which shows available time slots. I want this to be restricted by whether time on that day and on a specific...

Hi all I apologise if this problem has cropped up on other posts, its just i couldn't find anything on it. I have a combobox on a form which is shows two fields from a lookup table. the other fields are not shown in the combo box. The two fields are the surname and forename of a person. Within...

Hi all I have a problem with a form i am building. From an initial form (TitleForm) i want the user to be taken to a screen that lets them add a patients details if they don't already exist on the system. When the user adds a new patient the "patient details form" opens on a new record and...

Hi all I'm having a problem with the datediff() function in Access 2K. I have the following code in an unbound text box: =DateDiff("d",Date(),25/7/2003) I had expected the result to be 24 but instead the text box is showing -37803 Can anyone shed some light on what i may be doing wrong. Thanks

Data between Forms and Subforms Hi people I have a form which will take details from user input and relates to types of training courses which get organised. What i'd like to do is have the last field on the form (Nuber of trainees on the course) populate automatically depending on the result...