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

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

    Conditional Formatting With Months

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

    Conditional Formatting With Months

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

    Calendar Control Shrinking!

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

    Allow Edits

    No sound on my computer so dont know if its beeping. Had a look at the link but none of it applies. The query does use data on the form from a combobox which itself is populated by a query. could this cause problems?
  17. C

    Allow Edits

    The subform is based on a query that contains an Order By clause. May this be the problem?
  18. C

    Allow Edits

    The subform is based on a query that contains an Order By clause. May this be the problem?
  19. 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?
  20. C

    Populating Variant Array With GetRows

    I am only trying to return one field through my query, ID. Does this mean I cannot use Variant Arrays? If not, what can I use? And how can I populate it
Back
Top Bottom