Search results

hi there, is there some way for me to return the path of the directory in which the database (.mdb file) is currently stored. I need to open an excel file from within the database. I don't know where the database and excel files will be, but I do know that they will be in the same folder. Any...

hi there, I having an extremely hard time accomplishing this, what I think should be, an extremely easy task!! I have a report that opens in print preview when a particular command button is clicked. Some parts of the report are edited/created dynamically upon clicking this button, based on...

hi there. I am trying to access the contents of a file line by line. I am using the 'line input' statement, which as I understand, is supposed to return the lines of the file sequentially. It turns out that when I use it in the following code, it actually returns much more than a single line...

This was a previous thread originally posted by LIndaG. I have the same problem but the replies haven't been able to help me. I tried to email LindaG to see if she was able to figure it out but I haven't received a reponse. Here's the problem (in Linda's words): Any help would be very much...

Can anyone tell me how I can add new slides to a new PowerPOint presentation using my Access 97 code? It seems like it would be easy in 2000+, but I can't figure it out in 97. It has to be possible!! regards, ray

HI, I hope somebody can help with this, I'm stumped! I'm importing a bunch of data from an Excel spreadsheet. Right after I do this I need to delete that spreadsheet. I have the following code: DoCmd.TransferSpreadsheet acImport, 8, "tblFieldData", "H:\temp", True, "Field" ...a few more...

ok everybody, a couple of tough ones (at least I think they're tough!!) Hi, I have a form where a user can select from combo boxes and multi-select list boxes the data types and parameters they want to appear on a report. When my code finishes, the report is shown in print preview. I know I...

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, 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...