Search results for query: *

I have an Action Form in my application that I want a user to be able to fill out. After filling out the user clicks on an email button which calls a SendObject action to email a report to a particular person. The report is referencing the fields that were filled out on the form. My problem...

Yes, but as users change records I want to be able to move focus back to the top of the detail section or I may at certain times move the focus to a certain portion of the detail section without setting focus to a control. Basically right now, if I want to section to move to the top I set the...

I have a long detail section in a form that the user must scroll down through in order to see from the top to the bottom of the form. Is there a way through code to move the detail section of the form up and down without setting focus to a control on the form?

Ok. I got it to work this way. As I move my mouse over the possible options which are High, Medium, and Low I get the output to my label. Select Case Y Case 240 To 479 lblPriorityDescription.Caption = "High desc." Case 480 To 719...

I want to be able to pass my mouse over the drop down portion of the combo box. Does your Select statement work in the drop down portion of the combo box Lonnie?

Yes, I want it to appear as the pointer moves over the options and before you actually select an option. I thought the combo box would be like a list box and have a "SelectedItem" property but it doesn't.

I have a combo box on a form. The combo box has 3 items to select from. I want a label next to the combo box to populate with a description for each choice as the user moves the mouse over the items of the combo box. Is there a way in the mouse move event of the combo box to see which item is...

I just got it working though it didn't work quite the way you showed. objExcel.Run "procname", "arg1" Not sure about the function cause I didn't need to return anything so I didn't even try that one out. Thanks!!

I have an Excel 97 file which contains some VBA procedures. From Access, I am able to open Excel and open the file that contains the procedures. What is the correct way to call this procedure inside the Excel file from MS Access 97 and also pass arguments to the procedure. Thanks for any...

I have not tried this yet but I found this in another newsgroup. Someone solved it by setting the Record Locks value of the form in question to Edited Record.

Hi Overdrive. Did you ever find a solution to the roller ball problem. I am having the same problem. Thanks, Tim Szrejter

I've seen the SR-2 resolution on the Microsoft Knowledgebase and we are on SR-2 and still having the problem. From what I read in that it mentioned the scrolling of a subform, and our form is just composed of one form with no subforms.

Hi Brian, I am having this same problem. Did you ever come to an easy solution for the mouse wheel scrolling to different records within the form. I also would like for the mouse wheel to scroll up and down on the form but not change records. Thanks, Tim Szrejter

I am having trouble showing an OLE object field in Word 97. I have a table in an Access 97 database which contains many fields. One of the fields is a OLE object, which is set to be a Word.Document and is embedded in the table. The users will input the data into this field through a form...

I need help changing the pointer to an Hourglass symbol in word 97 through code, while some VBA code execution is taking place. The processing of the document may take awhile and I don't want the user to see just a pointer and a blank screen. Will change back to pointer at end of code...

I have a report that is running very erratic. Sometimes it will populate and sometimes it will come up #Error in all the fields. The front end database contains the report and all the code. When the report opens a sub procedure is run which populates a worktable in the front end app. The...

I checked on recordsets. I do not see how that will help though. A report's recordsource must be a table, query, or SQL statement. Still, the only way I have found so far to advance the report to the next record is to physically click on the arrow button at the bottom of the report to move to...

I have written some code to create a table of contents for a report I have created. I have code in the Detail_Print event so that as you move from the first record to the last record in the report it writes the page number and description to a table. Then I can use this table to show a report...