Search results

Hello VilaRestal, I tried your code and it works well for one particular reference on List 54. On the other rows on the list it does not. Very strange. I will now try to see what is the new stumble. Thanks for your help once again. LouisB

Good day access programmers, Greetings from Malta. I wonder if I can please get some help. I have a form "Appointments" which has a combo box, two list boxes and various other controls. List 54 updates on the 'after update' event of the combo box using code. This is working well A...

Hi VilaRestal, I have changed the settings in the Trust Center and now the code is working fine and the list box is updating as planned. Your're and expert indeed. Many thanks Louis

I think the problems lies here. I have another database which is quite large and each time I load it there a security warning saying ' certain content in the database has been disabled'. I then have to press options and to enable the database. However in this new database which I am...

Hi, It is possible that the whole problem arises from the fact that somehow my ACCESS 2007 is not executing code. Could I have (have not) done something in this particular database, causing the program not to execute code. Another command button which I have inserted to close the form...

The following is the code I am inserting now into the after update event of Combo44. Private Sub Combo44_AfterUpdate() Dim str1 As String str1 = "SELECT appl, dname, surname, dctIdcard, Speciality FROM Query2 WHERE Speciality = " & Me.Combo44 & " ORDER BY surname" Me.List54.RowSource = str1...

Good day ye wonderful people, Can someone please help ? I have a combobox which is based on a table containing doctors' specialties such as physician, surgeon etc. On the same form I have a list box based on a query. The list box is supposed to show all the doctors with the speciality...

Many thanks for your information. Good to know. However, message boxes are so convenient and easy to use that it is to much of a hasle to create a new form just to format a title bar. In my case it is worth going that far !! Many thanks. I will remember. Louis Buhagiar

Hello out there, Can I format a variable in VBA ? I am including a variable which is picked up in a Dim statement and later use it as 'title' in a Message Box in the same procedure. How do I go about change the format of how the variable appears on the 'title' part of the Message Box. ...

Many thanks for your help. Actually both table Particulars and tabel Barthel have a primary key. The primary key on Particulars is the idcardno and that on Barthel is ID. I am trying to establish a relationship between the two based on idcardno on Particulars and idcard no on Barthel. A...

How do I go about it ? do I send it via this forum ? I will have to empty the tables as information with regards to patients is confidential.

Hi Bob, I have emptied both the Particulars table and the BarthelIndex table and still i cannot mark enforce referential integrity, etc. I wonder what could have gone wrong ! Many thanks. Louis

I have done this before but it does not seem to happen again. I have established relationships between tables before. When I am trying to do it now ( a year later) I do not see to be able to tick the boxes 'enforce referential integrity, cascade Update related fields, and cascade delete...

Dear Bob, Many thanks for your interest in helping out. I have managed to solve the problem by creating two queries. The first is called Query 30. It is totals query and uses two fields from BarthelQuery. The following is the SQL. SELECT BarthelQuery.idcardno, Max(BarthelQuery.ID) AS...

Dear Bob, Many thanks for your reply and your help in finding out the solution to this problem. In the meantime I have solved the problem by first doing a totals query. This is intended to find the max ID (ID is the auto-generated record number). As dates are added with time in chronological...

I have just established a relationship between table 'Particulars' and table 'Barthel'. It is a one-to-many relationship. As a side note the infinity sign on the relationship does not appear. When I execute the query it comes up with the Max date from BarthelQuery for each patient's entries...

Dear All, I am having a problem with creating a totals query. I have a table called 'Particulars' which containes a number of fields that contains details on patients. This includes their names and date of discharge from hospital. I would like to join this with a query called BarthelQuery...