Search:

Type: Posts; User: davie1982; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: VBA Code simplification - Creating folder with month/year

    Hi, yes, that's how i'm currently organising my spreadsheets (all created through access) and it's quite helpful! Everything is nice and easy to find, which is nice especially when you get requests...
  2. Re: VBA Code simplification - Creating folder with month/year

    Thank you for help/advice.

    I should've thought about the format() function earlier but I just couldn't think of it.

    Thanks
    :>
  3. VBA Code simplification - Creating folder with month/year

    Hi all

    I have some long code here that I want to try and simplify/shorten, if possible. It's attached to a button on one of my forms. The code works great as it is though. Any suggestion?
    It...
  4. Re: Query - Filter out multiple bar codes to show only 1 bar code per product.

    Nvm i figured it out - put 'First' or 'Last' into the grouping field (Total) and it brings only 1 record.
  5. Query - Filter out multiple bar codes to show only 1 bar code per product.

    Hi!

    My query is this -
    I have 3 columns.

    Barcode | Product Type | Product Name | Colour


    1234567890123 | AAA | Example1 | White
    1234567890124 | AAA | Example1 | Black
  6. Re: Date query working incorrectly (Reports - Charts)

    It all failed, but I fixed it. The format I was using in the [txtstartdate] and [txtenddate] was dd/mm/yy. Changing this to dd/mm/yyyy solved my problem.
  7. Re: Date query working incorrectly (Reports - Charts)

    If it helps.. here's the sql code


    SELECT (Format([fldDate],"Short Date"))
    AS Expr1, Sum(qrySiloTotals.Fastpick)
    AS [Fast pick], Sum(qrySiloTotals.[Silo 1])
    AS [Silo 1],...
  8. Re: Date query working incorrectly (Reports - Charts)

    Ah there will be the problem... because of the nature of the front end system. To enter it manually like that will defeat the whole purpose as the dates for the report will often vary and many other...
  9. Re: Date query working incorrectly (Reports - Charts)

    No. I want to bring up 6,7 and 8 november but doing 06/12/11 in start and 08/12/11 in end only brings up 7 and 8. Start and end are both unbound textboxes. I press a button that opens up a report...
  10. Re: Date query working incorrectly (Reports - Charts)

    Hi i tried that, but the chart is blank :( It still does the same thing.
  11. Date query working incorrectly (Reports - Charts)

    Hiya.

    I have this code in a chart on one of my reports in the SQL query as a criteria.


    >=[forms]![frmdatestuff]![txtstartdate] And <=[forms]![frmdatestuff]![txtenddate]

    For some reason,...
  12. Replies
    2
    Views
    532

    Re: Prevent change but allow overwrite

    And i found my own solution which seems to solve everything.



    If Target.Column <> 4 Then Exit Sub
    Select Case IsNumeric(Target.Formula)
    Case Is = False
    Target.FormulaR1C1 =...
  13. Replies
    2
    Views
    532

    Re: Prevent change but allow overwrite

    I'm doing some trial and error work right now, but i've come up with an issue.



    If Target.Column <> 4 Then Exit Sub
    Select Case IsNumeric(Target.Formula)
    Case ""
    Exit Sub
    Case...
  14. Replies
    2
    Views
    532

    Prevent change but allow overwrite

    Hello.

    I have the following VBA code within my worksheet:


    If Target.Count > 1 Then Exit Sub 'this means only reacts to single cell changes
    If Target.Column <> 5 Then Exit Sub 'Target...
  15. Replies
    2
    Views
    267

    Re: worksheet change using ranges

    Just what i needed, thank you!

    And now i understand how it works aswell.
  16. Replies
    2
    Views
    267

    worksheet change using ranges

    Hiya, i'm currently attempting to write in a worksheet change event.

    In column C I have a number in each row. This number is the 'maximum' (it differs a lot) amount of product that can be put in....
  17. Replies
    3
    Views
    438

    Re: Username and Password SQL Connection

    mm, it's not that.

    When you go to refresh the data on the spreadsheet it requires a login and password to the SQL database which is always the same. Is there a way to store these 2 in the vb code...
  18. Replies
    3
    Views
    438

    Username and Password SQL Connection

    Hi

    Basically, i have an ODBC query and i would like to hardcode the server username and password into VBA.

    Code:...
  19. Replies
    1
    Views
    239

    Add name to picture

    Bit confused here...

    VBA to add a picture:



    ActiveSheet.Pictures.Insert("C:\Picture1.jpg").Select


    How would I be able to add a name to it?
  20. Thread: Auto Save

    by davie1982
    Replies
    2
    Views
    782

    Auto Save

    Hiya, i got a shared workbook which i would like to add some code to make it save every 2 minutes. I have no idea how to go about it but this iswhat i want...

    Timer(2 mins)
    activeworkbook.save...
  21. Replies
    1
    Views
    661

    Re: Manipulating MS Query with VBA

    OK, that works.

    I've made my code here:




    Sub test()
    Dim strOpenClosed, strAccNo As String
    2
  22. Replies
    1
    Views
    661

    Manipulating MS Query with VBA

    Hiya, this is pretty much Excel related.

    I offered to use MS Access for what i'm doing but everyone prefers Excel.. here goes...

    I have a query to the Sage SQL server. It brings back all open...
  23. Replies
    0
    Views
    435

    Shared Workbook Questions

    Hiya,

    I have a shared workbook that's linked to the main SQL server. Of course i have to put it on exclusive to refresh the data, but that's not so important. When i'm wondering is.. if i stuck...
  24. Replies
    2
    Views
    238

    Re: Condition Format with range...

    perfect, thanks
  25. Replies
    2
    Views
    238

    Condition Format with range...

    Hiya, i can't find the answer i'm looking for.. i want to, within columns X to AE, use a conditional format to change the colour of the rows only if there is data column AE.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4