Recent content by cameron.scrimgeour

Used to using Oracle so not sure how to do this in Access. I need to change the format of a date and time from... 01/08/2009 12:00:00 to 01-Aug-2009 12:00:00 How can I do this? Would usually use to_Date in Oracle, but think I need to use something like the following... FORMAT(#01/08/2009...

I have some conditional formatting set up on a subform. The default conditional formatting is set to green but when the form is run, the areas which should be the default green are still just white. Whats going on ???

I have an access form which has a subform. The subform shows some fields from a table in a database. I have already got the maximum number of conditional formatting conditions in use, but I need another. Can this be done in VBA? The current formatting is like this...

Using the following code to copy 2 worksheets to a new workbook.. Sheets(Array("Sheet1", "Sheet2")).Copy ActiveWorkbook.SaveAs Filename:="NewBook" ActiveWorkbook.Close There are fields in Sheet 1 with more than 255 characters in them. So when the sheet is copied, it cuts anything over the 255...

I have used the following code to copy a sheet to a new workbook... Sheets("Sheet1").Copy ActiveWorkbook.SaveAs Filename:="NewSheet" ActiveWorkbook.Close It works fine but I also have a Sheet2 which I want to copy into the same Workbook. Can this be done easily?

I have a spreadsheet which uses VBA to connect to a Database. Data is then extracted into the spreadsheet. The problem is that if more than 15 rows of data is extracted and put into my spreadsheet, it doesnt fit into the spreadsheets formatting correctly. Is there any way I can code it so...

Trying to check to see if a cell is null but my code isnt picking it up. If IsNull(Range("A22").Value) Then MsgBox ("Cell is NULL") End If I know that the cell is 100% NULL so it should work.

I have a begin_date field and an end_date field I want to combine the day of the begin_date and the day of the end_date into one field... Currently- Begin_date End_date 01-Dec-2008 05-Dec-2008 Wanting - 01-05

but if 2 even months or 2 odd months were next to each other, they would be the same colour. I want them to be different. To alternate each time for a different month and year.

what? No idea what your meaning. Is there not just some way I can check the date in the next row and go... if current row date = next row date then blue else green

ALready thought of that but if the data was as follow... Jan - 1990 March - 1990 Both would be blue, in this scenario I would still want them to be Blue, then Green.

Hi I have a subform in the datasheet view. I would like to have the data in it alternate different background colours depending on the month... Jan-1990 = blue Feb - 1990 = green march - 1990 = blue April - 1990 = green and so on. I think this should be quite simple to do. If I can find...

Hi I have a subform on my form. It is populated by data from a query on a linked table. This is an table that is in my oracle DB. I cannot directly edit the data through the subform and I belive this is because you cannt edit a linked tables data. Is this correct? It would make my form so...

None sorry and cant upload any. The font doesnt get smaller, its the actual dimensions of the calendar that seem to be shrinking with every click.

Really odd problem. Have a calendar in my form using the one access forms provides. But when you use it, it seems to get smalller and smaller after every time you use it! No clue why this is happening.