Search results

can anyoen tell me why it is when i open a form, the first thing i have to do is press "Escape" ??? eg. i have a form with a list box of items. when an item in the list box is clicked I load the data for the item into the fields on the form. when the form is opened (from a menu, with edit mode...

usually when this happens to me i have forgotten to change the properties for that event to "[Event Procedure]"

that fixed it!!!!!! *does dance of joy* thank you sooooo much!

sorry, i should of mentioned that there's nothing bound to this query; it exists solely to export data out to ms excel for presentation. The data is read off the exported .xls file into an array and then printed to the specified format. I cannot sort it in excel as i need to sort it based on 5...

Hi guys, I got a weird problem. trying to bring back data from my database, i have a query that has worked for the last year perfectly. today, its not. Im asking it to sort via several fields, first is the state, second is the suburb. so what i should (and have) ended up with is a list of...

hi, thx for the reply :) It works fine for an undefined amount of time, then, some action is taken (still trying to figure out what it is - it seems to be a random action) and whilst i could still get the right dialogue up when pasting into the same workbook, opening up a new workbook gives...

hi all. i have this weird problem. i am copying a range of cells with formulas in it. i am doing a "paste special" to paste the formulas, everything fine. then suddenly when i try and do it again, the dialogue is not the "paste formula/values" box but the "paste object" box (it pastes the range...

Private Sub myFormatCell(myRange As String, fontSize As Long, horizontalAlignment As Constants, verticalAlignment As Constants, mergeCells As Boolean) Range(myRange).Select With Selection.Font .Name = "Arial" .Size = fontSize .Strikethrough = False...

thanks anyways :) (for the record i had nearly the same code before i deceided to do it with a function.)

I cant figure out whats going wrong here. im using the example in the help for a base and it refuses to work. Its ment to populate the combo box with all the years from the current year down to 2006 (or just 2006 in the case of this year) here's the code: Public Function ListYears(fld As...

Hi all, I've been making some custom functions for listboxes so they can display data from multiple tables and records on one row, and its really simplified some forms for me. I was about to do another one until i realised that this listbox could potentially have over 2500 rows (it wont ever...

thanks. worked like a charm. used IIF like this: CostIndex: IIf([MaxOfTotal]<20000,0,IIf([MaxOfTotal]<50000,1,IIF([MaxOfTotal]<100000,2,IIF([MaxOfTotal]<250000,3,4)))) to get the numerical value for the corresponding value in the costs table, then use another query to get the rest of the info...

Hi Guys, Im trying to do something that i dont think is possible, but perhaps i dont know the correct command. I have a table, which contains costs. the costs are deceided by a circulation. if the circulation is below 10,000, then the cost is A. if its more than 10,000 but less than 20,000...

Perfect. I thought i had the brackets like that in one attempt but obviously not :) Thank you. %simon

SELECT Fields FROM table1 RIGHT JOIN table2 ON table1.Pubid = table2.PubID WHERE (table1.PubType=[Forms]![frmCirculationByTitle]![comMemberType] Or [Forms]![frmCirculationByTitle]![comMemberType] Is null) AND (table2.lAuditPeriod=[Forms]![frmCirculationByTitle]![comStartPeriod] Or...

HA! as always, i should learn to KISS :) thanks for that %simon

Hi Guys, I have some data in Access that needs to be formatted in excel. This happens twice a year, each time with a new dataset, so i'd like to automate it. I can use Access' "OutputTo" to output the data to an excel file, but i'd like to format it at the same time. I want to insert some vba...

perfect! thank you very much. I didnt even think about changing the font *slaps head* BTW how did you get the number 87? its always been a mystery for me as charmap gives what looks like hex values (omega in symbol is char code 0x57)... do you just convert the charcode in charmap from hex to...

Hi All, I've been bashing my head on a wall for the last two hours. I am auto generating a report and its great until i get up to displaying a label with a caption of "Ω". you cant put the omega character into VB, it just comes out as a "?", so ctl.caption="Ω" doesnt work. I've tried ...