Search results

  1. C

    Format Date and Time

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

    Conditional Formatting Default Not Changing

    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 ???
  3. C

    Extra Conditional Formatting

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

    Sheets.Copy Range

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

    Copying Sheets to New Workbook

    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?
  6. C

    Making Spreadsheet Bigger Depending On Incoming Data

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

    Null Cells

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

    Combine 2 fields

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

    Conditional Formatting With Months

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

    Editing a Linked Table Through Subform

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

    Calendar Control Shrinking!

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

    Allow Edits

    I have a form with a subform in it. Both have Allow Edits set to yes in their properties. But, when I try to edit the data in the subform, i cant. Wont let me. I have tried coding Me.AllowEdits = True into the subform but still no sucess. Any ideas?
  13. C

    Populating Variant Array With GetRows

    Having some problems trying to populate my Array. Heres the code... Sub LoadArray() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim avarRecords As Variant Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT ID FROM TABLE1 WHERE ID < '10'")...
Back
Top Bottom