Search results

Thank you pbaldy

Hello everybody, I've managed with the help of these forums :D to creat a search form, howver how do i get it to update for the next search results. For now it gets all mixed up. Private Sub srchBtn_Click() Dim dbs As Database Dim rst As Recordset Dim strsql As String Set dbs = CurrentDb...

Hello DCrake, This really sounds interesting and I would really be interested to know how you can do that. I might need to do this for our help desk system too. I'll appreciate it. Thank you, Samia

Simon, Its just the ID and filename. Samia

OK Simon, So here's table i did; tblImage ----------- ImageID ImagePath ImageName I then went on to create the query as you suggest: SELECT tblImage.ImageID, [ImagePath]+[ImageName] & ".jpg" AS FotoPic FROM tblImage; so, how do move from here?? :mad: Thank Samia

Thank Simon, how would do that. Sorry, am pass deadline and my mind is blank.

THANK you Simon for this, I'm going your way. However, my question was can I have an entire separate table just for image path (text)....how would I then link/display into main table? thank you in advance :)

Hi Bob, First I must apologise for asking my question this way...but was search for answers & my happen to be similar to this. I'm creating a database that will have so many photos and I want to use relative path. However, for purposes of the users....can I have two tables say; table1 main...

Wis when I put =me.parent!height, I get error #name? Dcrake I did this Me.Height = Nz(Height),DLOOKUP("Height","tblVisit","VisitID=" & VisitID)) and it highlights the comma before dlookup error expected end of statment the whole statement is RED. :confused:

Thank you guys, Dcrake & Wis...I'm going to try out yo ways. Ruralguy, I've just a form for visit table.... meaning you enter patient info then click on a button and enter visit info. Thank you all for trying to help me out. Samia

Yes, Ruralguy, I've both tables. Actually this was work that was done by someone else and I want to keep it the way it is. The field height is in the visit table, that why I get heights entered only for the 1st visit but not the other visits hence the code...

RuralGuy, am open to anything... How would I do this?? :)

Yes. Reason is I dont want to have null values in my db. i.e. what I now have for tblvisits is: Visit Date WT HT 1 02/04/09 49 147 2 09/04/09 47 3 16/04/09 50 4 23/04/09 49 5 30/04/09 48 I want when I loke at my tbvisits to see: Visit Date WT HT 1 02/04/09 49 147 2 09/04/09 47 147 3 16/04/09...

RuralGuy, it can do for me. I just thought like David mentioned above that if it changed at sometime in the future. I appreciate your help

Sorry David, I'll paraprase. Height is entered on the first visit with the other basic info which does not change. So for the subsequent visits, I dont want to keep re-entering the same value that was entered in 1st visit....I want it to just be picked from the tbl visits and filled for as long...

OK done that, but my code still returns error. Can u help please... Thank you so much

Thanks David for the first reply. Should I discard my code? Where should your code come. My code is Height afterupdate. P'se also take a look at my code above, I dont know hwere the error is.

Hi Gurus, I've a table visits in which am entering data...however I've searched for a way of having a value repeat to no avail. On one fo the forums (dont remember which) I got this IIF(IsNull(Height),DLOOKUP("Height","tblVisit","Height"),Height) but it is not working. What I want is when I...

Thanks Poppa Smurf, I'll go with admin issuing usernames. Did you mean I've to create tblAudit?? Didn't quite get you properly. thanks, Samia

Hello, I've two questions. I created an access login form for username and password right, and its OK. My question is? Is there a way I can get to track the login dates and times? 2ndly how would I create a button for new users... I've already entered some two users. I need to create some...