Search results for query: *

Just found FAQ faq701-4233. Will give this a try.

Hi. I have a database for our 4-H group. I have FamilyID, FirstName, LastName, Active, Address, etc. I have made an expression that combines the FirstName and LastName and that works fine. What I want to do now, is make labels where all the combined FirstName/LastName for a given FamilyID...

Thanks so much for the reply! Is there anything special to map a drive? I will do some reading and try this out. Thanks again!!

Anyone else have an idea on how I can do this? thanks

Thanks for the reply! The above code takes me to the folder, but I can still navigate away from it. (I can click the up folder button and it will take me up a level-- or more if I keep clicking th button) I need it not let me navigate away from the original folder. It would be great if it...

When I create a hyperlink to a folder, for example: "../altered/boo" , it will take me there, but it also lets me hit the folder up button and then I can pretty much go anywhere from there. Is there a way that I could go to that folder, see the contents there, enter any subfolders that...

PHV -- Thank you so much. This was driving me crazy. Ian -- thanks for the response, it didn't seem to work though...

Please Help.... I am having trouble with what I am sure is the very basics of access. From a command button, I want to open another form based on an ID number. I put --------------------- Dim stDocName As String Dim stLinkCriteria As String stDocName = "Messages"...

Thanks for getting me to think in another direction. I ended up changing the relationship between the form and subform and it works great. Thanks also for the reminder of double click vs single.

Thanks for the reply! The above code works great to open the subform to the correct message. How can I get it to open the form and subform together?

I have a form based on a query. The PK = IDMess. I want to be able to click on one of the records in that form and have it open another form/subform (Messages)/(MessagesTemp) and open to a record (in MessagesTemp) that also contains IDMess. I can get it to open to the subform, but I can't get...

Thanks for the help! If I put your code above in the module (I'm assuming that I would take out the Sub and End Sub lines since it is in a module?) Then when I hit the command button it now gives me an error "File not found" and highlights the code below: Shell "explorer.exe" &...

If I change it back to Dim astrFolder As Variant Then I get an error message of "Path not found" and the below line is highlighted. ---------------------------- If Len(Dir(FolderPath, vbDirectory)) = 0 Then astrFolder = Split(FolderPath, "\") FolderPath = astrFolder(0)...

Thanks for the response. I changed the name of the module and changed Dim astrFolder() As String Now I get an error message "Expected array" and it highlights below. ---------------------------- If Len(Dir(FolderPath, vbDirectory)) = 0 Then astrFolder = Split(FolderPath, "\")...

I have copied the below from another list, but have been unable to modify it so that it works. What I am doing is from a form have a command button that opens a folder and then subfolder, based on name, etc. and if those folders don't exist to create them automatically and then open them...

THANK YOU!! THANK YOU!! This is wonderful. Naoaja

Thanks for staying with me. The first table has Title, ProjectNo, TitleDate, Author, etc. Works fine. Then the next table has the fields Libraries, LibUpdate, etc. Libraries is a memo field. What I want is for it to be "preloaded" to say, "This Library contains: Title1, Title2, Title3..."...

thanks for the response, The table that hold the memo field is called libraries. I hadn't linked it to the title. I thought that it would just be based on the query. Does this help at all? thanks! Naoaja

Thanks for the response! I'm not so hot on VBA. Is there somewhere that I could look at an example of how to loop thru the query dataset? thanks again, Naoaja

I have a table/form with records that contain different titles. On another form is a memo field that I would like to have the records listed first and then allow the user to add to the memo field whatever text they want to add. I thought I would have to make a query to get all the...