Search results

thanks scott!! Just what I needed, wasn't aware of the Selected Property!! -Ray

Hi there, I have an unbound list box which is populated by a Select statement. I also have a check box, whereby upon clicking, I would like to select all the items in my list box, and de-select all upon un-clicking. I don't understand how to do this!! I am working in the after update event of...

Hi, is there a way to add hyperlinks to areas on a picture? I want to do pretty much the same thing as what 'hot spots' achieve in FrontPage. I would like to select a portion of a picture and assign some sort of link such that when that area is clicked, an action occurs like opening another form...

Hi JonH Thanks for the response! I don't understand what my arguments are supposed to be for this call.

Hi, I currently have a form that contains records resulting from a search based on user criteria. The form displays one record at a time. Is there a way that I can display like 5 records on a form? This isn't for printing purposes so a report isn't really what I have in mind. For example...

hi, I have a combo box that is used to make data entry easier on a form. If the desired item is not present on the list, the user can double click on the field to pop up a new form used to add items to this list. Currently, the user can type in this field, often trying to enter data, and I...

Hi, I have a bunch of Excel spreadsheets that I want to import into Access. The data in Excel is all on a single worksheet, but I don't want it all to go into the same table in Access. I know where I want everything to go, but I have no idea how to write the code to import and split based on...

Hi, I'm relatively new to Access so this is probably super easy! I would like to create a query using VBA, but I don't know how to go about doing it. I know how to set up my strings to be used as my SQL Where statements so that's not a problem. Once I have these, how do I open up a query based...

Hi there, Nobody was replying to my last question so I thought I'd try to clarify and redefine my problem! I currently have a search form that uses the user's input into text fields as searching criteria for a query. I've been using the following for my Where statement: Is Null Or Like "*" &...

hi there, I currently have a query that uses fields from a 'Search' form as it's criteria. One of my fields is 'keywords'. In this field, the user types in various keywords that may be used to describe the record. As it stands now, a user might input: reservoir oil engineering. What I...

Hi, I currently have on my form a hyperlink field that links to a file on a newtwork drive. Instead of displaying the actual path, I want it to display a generic "Electronic Version" link for every record. I realize that I can modify individual records this way using: Electronic...

Hi! I have some combo boxes on my forms that are controlled by fields in an underlying table. The form is used for data entry, and if the data for one of these particular fields is already present, they just select it from the list and avoid needless typing. I currently have it set up such...

Hi, Can somebody tell me explain to me what the purpose of this piece of code is? It came from form properties. Private Sub Form_Current() If IsNull(Me![RecordingID]) Then DoCmd.GoToControl "RecordingTitle" End If End Sub thanks! Ray

Hi, I currently have a form with many fields for user input. These fields are used as searching criteria to narrow down results that my query returns. I would also like to give the user the option to browse the records that the query returns, with the records sorted by a particular field...

Hi there, Upon loading my database, I have a form that acts as sort of a switchboard to display and direct user options. On this form, I have a button which opens another form and closes the source (initial form). What I don't like is that when my new form opens, it's located someplace...

thanks! never would have thought of that!!

Hi there, How can I have the database window minimized opon loading the database? Note that I do not want the window hidden entirely, as in the startup menu options, but rather just minimized to the bottom of the screen. Thanks!

hi there, I have a form with a field that uses a hyperlink data field as it's control source. When this form is put into action, this field displays the entire address of the link. ie. the field may be something like: c:\My Documents\.......\text.doc I don't want the entire address to...

Hi, when I remove the navigation buttons in my form, there is still a border along the bottom and right edges. Any way to remove this? Regards, Raymond Warren

Hi, I'm new to both Basic and Access and I've seen this around here and there: > What does this mean?? I'm wondering because I get a compile error on the middle line of the following code: (I got this code from the forum and > is the only thing I don't understand). Dim lFieldLength...