Search results

Krava.. Correct... I fixed that so now it shows the text and not the ID number. Thanks R~

Bob.. I hope I did what you suggested... I created a query with the fields I wanted to combine and then created another query with that query with the other fields, here is th sql for that: SELECT tblInvestigator.InvestigatorID AS tblInvestigator_InvestigatorID, tblInvestigator.InvLName...

Hi again.. Last question here is the code I am using: SELECT tblApplicant.FOSLName, [FOSLName] & " - " & [AppLNAme] AS FOSLName FROM tblApplicant GROUP BY tblApplicant.FOSLName; I wanted to combine to fields from within the same table, same as the above code but it won't let me. What am I...

Bob.. I was so close.. thank you again! R~

Bob.. Did the group by but it still showed the spaces and listed the names multipal times. (I made sure to use unique names for testing purposes). R~

Bob.. That is what I figured re:names.. I am trying the other now. Thanks again R~

Bob.. I looked at your code and applied it to do the following: SELECT tblInvestigator.InvestigatorID, [InvLName] & ", " & [InvFName] AS InvestigatorName FROM tblInvestigator; to: SELECT tblApplicant.FOSLName, [FOSLName]AS FOSName FROM tblApplicant But, instead of just giving me what is...

I did the same here: http://www.access-programmers.co.uk/forums/showthread.php?t=120778 And here is a good tut on doing it also: http://www.fontstuff.com/access/acctut08.htm R~

Bob.. Thank you very much and yup the code worked fine and man is it fast too. The running of the query etc.. Thanks again R~

Good lord.. that was quick and yes that is it! What was I doing wrong? I looked at the code and it looks pretty much the same as what I had with the expection of the report info. I just had it based on a the query as a whole.. If I want it to have a command button can I just copy over...

Sure can... Here is what I what like to do, and I have done it in the past, but.... Have a drop down list of the investigators. So the end user can pick which investigator they want to pick. Once the have selected the investigator they hit the command button to open a report that shows...

Bob... Hmm.. That is interesting re: having the look up table. I didn't think I could get more then one instance if it isn't in the table. Now how can I get this to work, what am I doing wrong? I have used this exact same setup (changing the names of course) in three other databases...

Bob... But if I base the cbo off the query won't that give me say 4 versions of test, 4 versions of testing etc, instead of just one of each? If I base the cbo off a table that is just used as a look up I will only get the investigators displayed once. I have changed the bound to 2 and...

Are both forms open at the same time on the same machine? Or are they opened at different times? R~

Hi all.. For some reason I cannot get this to work and it is driving me crazy. Here is what I have. A combo box on a form (frmTest) that is drawing from a table, tblInvestigator. This part works. I then have a query that has the following line of code in it to draw from the form...

ansentry Thank you, I just downloaded it and I am looking at it. Thank you again R~

Light.. Yup I think it will happen.... It has happened a couple of times already when I was showing another project to the end user....so now I put it in lol... Thanks for your help! R~

It seems to be working.. Here is the code: Private Sub txtSocNumber_DblClick(Cancel As Integer) On Error GoTo Err_txtSocNumber_DblClick DoCmd.RunCommand acCmdSaveRecord Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmApplicantFullDetails" If...

Edit.. Sorry my connection is super slow and when I am refreshing I am not getting some of the posts right off the bat.. I am trying Lightrays solution as we speak R~

Bob.. Yes the subform... Ok what code would you add? so that once the SS# is entered it jumps to the next field? Thanks again R~