Search results

Thanx for the quick response, cookie. How is it possible in a query and not a table? I may have to go with a continuous form if I can't find a solution. Certainly not my form of choice. Thanx

Howdy all... Is it possible to wrap the text in a column heading/field name to accommodate a narrower results column? Thanx ;>) Karen

Great idea, SOS...I'll give that a try.

Any other ideas on this, please???????????? I'm really under the gun here. Thanx ;>) Karen

Yes...I do include the full path name but if, for example, the user copies the file from it's existing location and paste's to a new location on their hard drive, the path in the links change to look at the hard drive rather than the shared drive location. I know that, if the user actually...

Hello... I have an excel spreadsheet that contains many links to documents saved on several different shared drives. This spreadsheet has many users and oftentimes these users save copies to their hard drives, or elsewhere. Is there any way I can specify that all hyperlinks remain as absolute...

Oh, ok pbaldy; I'll take a look. I didn't think this really applied to what I wanted to do since the attachment(s) are, in fact, associated with and stored within the db. Thanx :) Karen

Thanx for your reply CEH... I have a table "Canned Emails" with fields including EmailID, Subject, Message, and Attachments. I have a second table "Sent Canned Emails" with fields including Sent ID, Email ID, Date, and To. I have a form based on a query of the two tables, which includes...

Morning all... Wondering if I can adjust my code, below, to add form attachments to my email. Here is the code I'm using... Private Sub Send_Email_Click() On Error GoTo Err_Send_Email_Click Dim strTo As String strTo = Me.To Dim strSubject As String strSubject = Me.Subject Dim strMess As...

Morning, all... Does anyone know how to remove the "search" control that is automatically included in the navigational area of Access 2007 forms? It adds little value if the search results in more than one record...there's no ability to select "next", etc. Thanx, all - HAGD Karen

Morning, All... Is there any way to skirt password-secured code modules so they can be opened in design view and changed? We have a work application set-up by someone who is no longer here. Thanx for any work arounds that may come to mind. Karen

Never mind. Although not included in a menu selection, I was able to identify the icon under the Arrange menu. Thanx :) Karen

Can someone tell me how to group text or other objects on a form using Access 2007? With previous versions, it was an option under the format menu. Thanx :) Karen

Thanx for the quick reply, Keith. Can you elaborate or perhaps give me an example of how the code might look? Thanx again :)

Hey, All... I've been tasked with development of a book library for my team. Several team members have requested that I include a function that would allow the user to go out to one of the book sites, i.e., Amazon.com, and pull the ISBN, author, etc. information from that site based on the...

Hey, Gurus... Is there a way to have form fields populate from a url? For example, if the user on my form enters a book title and pushes a search button and is taken to say Amazon.com and that book title. The form would then be populated with the ISBN, author, etc. from that url. Is this...

Thanx for the quick response, Bob. It actually came to me in Excel but they want responders to use Access so that there is no backend data importing required. If the db is split and the survey form set-up to go to a new record when opened, would that work, since each respondent would be...

I think I read through most, if not all, posts related to surveys but didn't really get an answer to my question. Can someone tell me the best way to have users input survey responses? My survey will consist of approximately 60 questions (most being yes/no or a numberic value). I expect to...

Hi, all... Just can't seem to figure this out. I have a main form with two continuous subforms. The first continuous subform is a reference only form with no data entry required. The second subform only contains 1 field. I want the user to be able to click on a record in the first subform...

Nobody able to help me on this? If you can, I'd certainly appreciate it. Thanx ;<)