Recent content by gusgaff

I have received great help here previously now i need some more. I've tried manipulating my code in always but cant solve my current issue. My 3 tables are Clientdetails, Clientcontact and Clientdoctor. All the lookups below work fine. clientname is a textbox i use to search the Database...

I have tried it previously in the oncurrent event Gina. I've tried practising with different forms so i'm probably just totally confusing myself. This is the DLookup for the table Clientdetails in which I have stored the path to each photo, in a field called ClientPhoto, I thought if I follow...

Hi, The full path is in a field on the table Clientdetails. Al the photos show correctly when I use navigation buttons. I have disabled navigation and selector bar. I use a search button called (clientname)to input the clients name which in turn will show that clients picture. E:\ is a portable...

Code to display client photo with corresponding client record. I'm using JPG images stored in the same directory as DB not using OLE. Private Sub Form_Load() Me.InsideHeight = 4500 Me.InsideWidth = 9000 If clientname.Value = "" Then Image28.Visible = False ElseIf...

Code to populate all textboxes. Private Sub clientname_AfterUpdate() ID = DLookup("[ID]", "[Clientdetails]", "[Surname] ='" & [Forms]![unboundfrm]![clientname] & "'") Forename = DLookup("[Forename]", "[Clientdetails]", "[Surname] ='" & [Forms]![unboundfrm]![clientname] & "'") Surname =...

Hi all, I previously posted in the General forum but got no reply. (Problem) I have several text boxes which I can populate using the DLookup. I have images I want to display for individual records. I use a search (textbox) to input client name and this populates all other textboxes. I am trying...

Access 2010, Single form.

I have a database with client details and photos. i have a textbox as an input box and seperate search button. I can populate all my textboxes on my form with all client details using DLookup., but i can only get the first record to show the corresponding image to that one client. How can i get...

Cheers Guys, I think i'll stick with the original code from Bob as it works fine. The only thing about non repeating numbers is, as people pay into the draw by direct debit i surely would be breaching Gaming and Lottery Laws (Scotland) as i would not be giving everyone a fair chance every month...

Thank you both vey much everything is sound. As i use auto number for ID i dont think there will be any problems. Or will there? One more question please, if i needed to have non repeating random numbers how would i do that?

I have one table (500 Club) with two fields (ID) (Name) i would like to randomly pick a record from the table and display the results in two seperate text boxes on a form one for (ID) and one for (Name). I intend to use this for a monthly draw at my workplace. Any help would be greatly appreciated.

Just joined and want to say hello to everyone. i only have basic knowledge of MS access.