Search:

Type: Posts; User: Robbo

Page 1 of 13 1 2 3 4

Search: Search took 0.63 seconds.

  1. Replies
    5
    Views
    283

    Re: VLookup of date and time

    yes if you change the time now its working was just the format of the date which wasn't working correctly

    cheers
  2. Replies
    5
    Views
    283

    Re: VLookup of date and time

    think have resolved it

    had to change date formula to

    =DATE(MID(Data_log_10[@Column1],51,4),MID(Data_log_10[@Column1],48,2),MID(Data_log_10[@Column1],45,2))

    and seems to pickup correctly now
  3. Replies
    5
    Views
    283

    Re: VLookup of date and time

    Hiya

    doesn't quite work correctly its just showing me the last entry

    =VLOOKUP(A386&" 22:0",Jumbo1!G:H,2)

    DB_FLOW_PARA.s_ProcessValues.r_Totalizer_1;"24.09.2020 20:08:23";28997...
  4. Replies
    5
    Views
    283

    VLookup of date and time *RESOLVED*

    wondering if any one can help the best way to do this

    23.09.2020
    24.09.2020 JR 16484 24.09.2020 14:08:26
    25.09.2021 24.09.2020 14:08:26

    so formula for number is

    =VLOOKUP(A385&"...
  5. Re: If Now > Time(8, 0, 0) And Now < Time(8, 10, 0) Then

    think worked it out

    If Time() > TimeValue("06:00:00") And Time() < TimeValue("14:00:00") Then 'Days
    ThisWorkbook.Worksheets("Home").Range("D8:D17").Locked = True
    ElseIf Time() >...
  6. If Now > Time(8, 0, 0) And Now < Time(8, 10, 0) Then

    Trying to get excel to open and check the time then run some stuff

    If Now > Time(8, 0, 0) And Now < Time(8, 10, 0) Then 'Days
    ThisWorkbook.Worksheets("Home").Unprotect Password:="123"
    ...
  7. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    still didn't get any further on with this? anyone got a VB6 app which could start me off
  8. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    yeah offline and lock out think best to keep info in an access database for recording sourcesafe seems to show in *.ini files
  9. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    if you look on here the best thing I could find was on plant source code was called

    File/Document Management System

    however only let me use one and was set in directory which couldn't change ...
  10. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    gonna have a look at source safe, but would mean have to install on other pc`s for everyone to use?
  11. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    its not version control of VB, but version control of a file or folder, lock out when updating then increments and upload back, will have to put a logon front end etc but need something that works...
  12. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    ive been looking and found a file management application but didn't work quite rite, is there anything in VB which I could customise, sample was using a access database but only worked to one...
  13. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    really need a software version control in vb6 so can backup files, folder and lock increment backups have login access and reports who has file out what changes where made really need help with this...
  14. Replies
    12
    Views
    1,529

    Re: Version Control Application VB6

    can any one help
  15. Replies
    12
    Views
    1,529

    Version Control Application VB6

    need a starting point basically needs to be able to back up a file/s or folders, check in check out, control users and version control, lock if user has the files out, report let them know who,...
  16. Re: Help Access 2000 Subquery on report, want to put into text box?

    all sorted had the ignore dulpicate entrys on turned off worked yippy

    did it al myself no help from ere!!!
  17. Re: Help Access 2000 Subquery on report, want to put into text box?

    more info

    in text box i have this

    =DLookUp("Attended","Personnel","Date Like [Date of Training] And Title1=Title")

    and the first line gets -1 however i need to do a count on this "Attended"...
  18. Re: Help Access 2000 Subquery on report, want to put into text box?

    to help the sub query is this

    SELECT COUNT(Attended) AS Attend
    FROM Personnel
    WHERE Attended=-1 And [Date] Like [Date of Training] And Title1=Title;


    and goes on report as

    Attend
  19. Help Access 2000 Subquery on report, want to put into text box?

    basically want to put the value of the sub query into the text box have tried using the dlookup but didnt work

    have tried referenecing the child tag, no look, have run out of ideas

    if you can...
  20. Replies
    2
    Views
    624

    Re: Excel 2003 VBA Condition Format

    hiya had to do a different way as it not on change of one cell maybe 2 maybe 20, so did on activate, then check the range each cell and then change there colour if they match just means you have to...
  21. Replies
    2
    Views
    624

    Excel 2003 VBA Condition Format

    have this bit of code and works well when your typing in each cell however these values will be pasted in, multiple at a time,

    and come up with a mismatch error

    any ideas how i can get round...
  22. Replies
    9
    Views
    1,142

    Re: Excel VBA Range and Values not goin IN?

    hiya cheers for your help got this to work



    Public Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column >= 6 And Target.Column < 16 Then
    Select Case Cells(Target.Row,...
  23. Replies
    9
    Views
    1,142

    Re: Excel VBA Range and Values not goin IN?

    problem is now im checking the range, which i did on first example
    then have to select the cell i want to check so target is selectiong the correct number?

    so depending where i click it will do...
  24. Replies
    9
    Views
    1,142

    Re: Excel VBA Range and Values not goin IN?

    ok well the changes are in colums 6 to 15 the total i want to check is in 16 (value) and the formatiing of color index is in 17

    this doesnt quite work correctly
  25. Replies
    9
    Views
    1,142

    Re: Excel VBA Range and Values not goin IN?

    hiya wud i be best doing this by cell then?

    whats esyest way to ammed the code its been a long day
  26. Replies
    9
    Views
    1,142

    Excel VBA Range and Values not goin IN?

    Any one help

    trying to get this to work can change the fon and cell colour but cant put a value in the CELL
    the C B A and AA

    everytime have in the code they move it back to the top so only...
  27. Replies
    0
    Views
    588

    Excel 2003 issue CountIf multiple

    been on this for about and hour and cant work it out

    have 2 columns

    on with

    C1
    C3
    C4
    C5
  28. Replies
    3
    Views
    790

    Big prob plz help excel

    basically i run a reprt from SAP and export to excel





    basically i need to find the top 10 from the list for example LINE C1 PALLET WRAPPING MACHINE and frequency and maybe cost, need easy...
  29. Re: EXCEL VBA: How To: Copy Hyperlink while Preserving Target Format [RESOLVED]

    can u helpm with my problem

    have the hyperlinks in a cell just tryin to put the hyperlink in the body of an email, can get text but want the link

    code is =




    Sub NEWACTION()
  30. Re: Powerpoint 2003 One sheet certificate need to Print loads with different names

    this is a code i have even put a delay in there


    Option Explicit
    Dim icount As Integer

    Sub Auto_Open()
    TextBox1.Text = ""
    TextBox1.Text = InputBox("ENTER NAME")
    ...
  31. Re: Powerpoint 2003 One sheet certificate need to Print loads with different names

    P Module Certificate.zip:
    Your file of 639.9 KB bytes exceeds the forum's limit of 500.0 KB for this filetype.
  32. Powerpoint 2003 One sheet certificate need to Print loads with different names

    ok basically i have a powerpoint sheet as a template, i want to put a box or sumfin on it and when print out, do a look up or sumfin as per the names so have one each and just one template, save...
  33. Replies
    1
    Views
    366

    Re: Oracle to CSV to Excel

    think ive solved

    import external data

    comma delimited, but change the columns with larger numbers over 16

    to text rather than general and it seems to work
  34. Replies
    1
    Views
    366

    Oracle to CSV to Excel

    have a really weird problem, was wonderin if anyone can help

    export data to CSV

    then open in excel 2003

    SSCC BATCH_CODE DESCRIPTION EAN_CODE
    350001446166311000 9245B TESCO NAS TROPICAL...
  35. Replies
    2
    Views
    340

    Re: Access 2003 Database Reports

    any help wud be apprieated
  36. Replies
    2
    Views
    340

    Access 2003 Database Reports

    have a strange proble and need help if i can do or not, if so how

    have 2 tables

    Training and personel

    where i run a query report

    SELECT Training.Title, Training.[Date of Training],...
  37. Thread: Adodc

    by Robbo
    Replies
    6
    Views
    515

    Re: Adodc

    AdodcLine.RecordSource = "SELECT * FROM " & cboSite.Text
    AdodcLine.Recordset.Requery

    am doing this but doesnt seem to work???

    what am i missing??
  38. Thread: Adodc

    by Robbo
    Replies
    6
    Views
    515

    Adodc

    AdodcLine.RecordSource = "SELECT * FROM " & cboSite.Text
    AdodcLine.Recordset.Requery

    cboLine.Clear
    For intLine = 0 To AdodcLine.Recordset.RecordCount - 1
    'Add from Table Shift...
  39. Replies
    1
    Views
    497

    Re: Excel Matrix Values Problem

    have made this a bit easyer now

    as you just have to select C1, C2 etc and 300, 750 and comes back with one result but how do i do this cheers
  40. Replies
    1
    Views
    497

    Excel Matrix Values Problem

    basically ive got a matrix of values

    one slection box which selects c1,c3 etc

    the other 250, 300 etc etc

    i want to bring back the values, maybe in a drop down box

    for example if C1 is...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width