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

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

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

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

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

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

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