Search results

Hi Pat, Many thanks for your interest. I appreciate the last part of your note, and do agree that meaningful names to objects will make everything more clear. As to the first part of your statement; I have other objects on the main form like the name of a client and his idcard number. The...

It appears that I have not explained myself of what I have been trying to do. In any case I have managed to find a solution to my problem as follows. The last of three cascading comboboxes is Combo17. On the afterupdate event I have put the following code. Private Sub...

On the subform I will have previous records linked to an idcard number on the main form. What I want to do is that on a choice of the last cascading combobox a new record is populated. For course as soon as one starts to do this the field on the subform related to the idcard number on the...

I have a main form linked to a subform set in datasheet mode. On the main form I have three cascading combo boxes. I would like to fill up some fields of a new record on the subform depending on choices made from the last cascading combobox. Can I get some help on how to reference the fields in...

Hi everyone, Can i change the color format of the datasheet part of a split form using vba? Can I make columns disappear in the datsheet part while the respective field on the form remains in place ? Any help from the forum please ? LouisB

Actually now I have got my code to function as I planned. The bit of code that I was looking for is the following; Forms.FrmClients.NavigationButtons = True I had to do this rather than Me.NavigationButtons = True as the command button lies on another form opened in dialog mode...

Yes it is the navigation button I was referring to. In fact I have managed to make them appear from the format column on the property section. Now I would like to make them appear and disappear using vba code. Can it be done ? many thanks. LouisB

I am referring to the selectors at the foot of the form that show the number of records and the movement buttons like < > that move from one record to the next or to the previous, to one end or to the other. Am I naming them correctly ? ??

Hi everyone, I am working on a form which displays data one record at a time one field over another. These fields are bound to the recordsource of the form. I have an unbound textbox on the form. I am using this to find records to be displayed on the form, depending on string entries which I...

Hi, Can you please explain and clarify the place of the following parts of code ? If Not InStr(sList, sCombo) Then If IsArray(vArray) Then InsertItem vArray InsertItem vArray(i) Private Sub InsertItem(ByVal sItem As String) Many thanks. Louis

Hi ViliRestal, The expert is back! How's your week-end going ? Many thanks for your reply. I think your method is very intelligent and intuitive. To tell you the truth I have never seen a list box also serving as a depository of data in this way. However my experience with Access is...

I have a form on which there is a Combobox (Combo13). From the Combobox I can make various choices each one being a medical investigation. I would like to populate a listbox on the same form, depending on choices which I make from Combo13. I would like to have the list updated so that each...

Cheers. :) LouisB

Hello ViliRestal, I have now found out what the problem was !! Surprise surprise. Text34 was the date entry control on the form. It was formatted as dd/mm/yy. When entered as an SQL statement in the way you suggested it was misbehaving very strangely. I suspect that when the dd was in...

I am trying to upload the file, but apparently it is too big and more then 2MB. In actual fact the db does not have that much data. Tried to split it but the size remains unchanged. Sorry. LouisB

Hello, I'm will be uploading the database now. I thought I have done it already. Here comes... I hope you have received the file ! LouisB

I am trying to upload the database. You enter onto the switcboard. If one presses Clients one comes up with a list of clients (prospective patients). Data is all dummy. One can enter for edit data on patients here. If one clicks on OP appointments one gets into the "Appointments" form where...

Hi ViliRestal, You seem to get hooked on to this problem like myself. I have never uploaded the database. I think this means sending the database on the forum. Actually I have jus started on compiling this database and all the entries are dummy. So there are none innocent. Can you...

I hesitate to ask for help again as it may be something banal which I am missing. I have this list54 which contains names of consultants who will have appointments with patients. The appointments are shown in another List56. When the name of the consultant is chosen in List54 ALL his...

Hi Good folks from Access Forum, This is me. My name is Louis and I dived into Access 2003 in Aug. 2006. I thought I ll do a project and get introduced to Access. It was very hard initially and without knowing my project was way too ambitious for a beginner. I any case try here and try...