Search results for query: *

Using the code below, I am trying to get the latest facility info for each facility, based on user input. The facility detail table stores the info, and only has rows for when data changes i.e.: FACILITYCODE MONTHNO YEARNO RATE PLANT_A 1 2006 100 PLANT_A...

I have a report with many fields: |-----| A | B | C | .... | xyz | 1 | 2 | 1 | .... | wxy | 4 | 4 | 3 | .... etc. Question: Is there a way I can have access automatically insert a page break between column B and column C? The page break control in access seems to allow...

I have the following info in a table: |---------| Year | Rate | | Plant A | 2005 | 5.00 | | Plant A | 2006 | 4.00 | | Plant B | 2005 | 3.50 | Not every plant has its rate information changed every year. What query can I use to ensure I always get the most current...

Hello all. I currently have the following table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | I would like to convert this to the following, with PlantID and ProductID as the primary keys. A separate table would contain PlantID and...

I used the Access form wizard to create a form with two subforms on it. Subsequently, I decided to remove one of the two subforms. I did this by selecting the subform in design view, and pressing the 'delete' key. Now, whenever I open the form I get an access error message stating "Microsoft...

Hello all! I have a Range object which I set as follows ('namedRange' is a named range of cells in the spreadsheet): Set myRange = Range("namedRange").Resize(numRows, numCols) Using a loop, I would like to pass to a function each row, with all the columns in that row, for all the rows in the...

This is my first attempt at VBA. I received an Excel file (approx 8 mb) which contained a worksheet and a whole bunch of macros. Using vba, I made the requested edits and saved (and edited, and saved, and edited and saved...) the file. However, when I went to submit the file to my boss, I...

I have a value that is calculated when the form loads. This value is required by all the routines in that module (Form1). I can either store/retrieve the value in a global variable when form loads (i.e. make the variable public for the whole Form1 module), or use property let() and property...

When transliterating foreign words into English, I format them with italics. For example, "The correct way to pronounce groups in German is grup-pen". Now, since most of these transliterations are not valid English words, MS Word flags them as misspelled with the curvy red underline. So when...

Can anyone tell me how to get MS Word to skip words beginning with a Capital Letter (i.e. John Smith)?

Anyone know of an API call that will allow me to change the color of the insertation point of a Rich Text Box? I am using code to mimic a hyperlink, by checking if the text the user clicked on is blue and underlined, so i need to keep the rtb enabled and locked so it can respond to a selchange...

Using Access in Office 2003, I selected the field type OLE Object. I then clicked on the insert...object.. menu, selected existing object, and browsed to a .jpg file on my system. The field in access now reads "package". I would like to display this image in an image control in vb. I have tried...

Does anyone know if using Get # and Put # to place user defined variables into a output file requires that the files be placed sequentially? i.e. can i execute the following, and reliably retrieve the data, or will it be corrupted since the output is not being done sequentially - there is no...