Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: Help to correct code with textbox in form

    you SET with objects.
    TEXTBOX is an object ,but values are not, so:

    ans1 = txtbox1.value
  2. Replies
    3
    Views
    656

    Re: Access: How to Sort a Query if I used *

    select table1.* from table1,table2 sort table1.field

    you can do this easily in query design.
  3. Re: Changing an Embedded image on a button with code

    make both images invisible, then depending on the button clicked, make that 1 image visible


    sub btnSortA_click()
    imgA.visible = true

    imgD.visible = false
    end sub
  4. Re: Access Query Criteria "Not" not working?

    If everything in Outside is pulled,there won't be any inside. You cannot filter.
    just run another query for Inside.
  5. Re: comma sepration in amount like Nepali Rupees

    you can try this function...

    usage:
    =FmtNepal(B3)



    Function FmtNepal(ByVal pvVal)
    Dim i
    Dim vNum, vOut
  6. Re: Automatic Acceptance of Make Table Data Paste

    there should be no limit of time. The dialog box should wait until the user clicks it.
    but
    before you run the Make query, turn off Setwarnings and it wont ask you for anything.
    ...
  7. Replies
    6
    Views
    255

    Re: What form call the function?

    you have it before the function

    MsgBox me.Name
    call MyFunction

    or put the form in the param of the function.


    public Function MyFctn(byval pfrm as form)
    msgbox pfrm.name
  8. Re: Is there a way to keep all records from one table in Access Query?

    you want an OUTER join query.
    in the query, join the 2 tables,
    bring down the same field from both tables, (that you joined)
    dbl-click the join line,
    set to ALL records from one table, Some...
  9. Replies
    2
    Views
    239

    Re: Design of the sales data report

    I use Access to sum the weeks and show the comparison.

    XL pivot can sum by the timeframe (weeks/Month/year) , but I don't like FILTERing on 1 timeframe at a time.
    I use Access to build all...
  10. Re: Importing Queries to Blank DB created "Duplicate Output Alias" Errors

    Check your AS ExprN
    the query builder doesn't know where a previous query left off....
    as Expr1,
    as Expr2,....

    you cannot have two Expr1's.
  11. Replies
    1
    Views
    217

    Re: VBA code for disable printscreen

    https://www.mrexcel.com/forum/excel-questions/1032074-excel-vba-disable-print-screen.html<strike></strike>


    <strike></strike>
  12. Re: [VBA] Check files and filedates within folder and list them

    usage:
    range("A2").select
    getValInAllFilesInDir "c:\temp"





    '-------------
    Private Sub getValInAllFilesInDir(ByVal pvDir)
  13. Replies
    1
    Views
    616

    Re: Need help with an access max/dlookup

    just show all records, then filter them all at once.
    No dlookups needed:



    '----------------
    sub btnFilter_click()
    '----------------
    dim sWhere as string
    sWhere = "1=1"
  14. Replies
    1
    Views
    478

    Re: quering access report from excel vba

    On a sheet , put the two dates in 2 cells.
    B1=start date, B2=end date

    alter the SQL,:



    if range("B1").value ="" then
    sSql= "select* from table"
    else
  15. Re: Adding A Sheet To Multiple Workbooks With A Macro

    start with the workbook sheet that has the jpg.
    paste this code into the VBE macros
    this code will open every workbook in the folder given in FixAllFiles(),
    then open the next workbook and copy...
  16. Thread: Elookup

    by ranman256
    Replies
    2
    Views
    492

    Re: Elookup

    I think your syntax is wrong....maybe:
    DLookup("PCT", TblL, "[RkT] = 'RTK'")

    the last param is the FIELD in brackets, then the value around quotes.
  17. Replies
    1
    Views
    452

    Re: project number sum listing sql

    Yes, make a query, bring down: proj#, hrs
    Turn on summing,
    set SUM on hrs.
  18. Replies
    1
    Views
    438

    Re: Monitoring fields for changes

    I have an invisible text box on the form, when the form opens it fills with the userID:


    sub Form_Load()
    'get user id
    txtUser = Environ("Username")

    txtOldVal = me.txtVal
    end sub
  19. Replies
    4
    Views
    876

    Re: ACCESS: Linked Table Manager Automation

    Once the tables are linked there's not much needed.
    why do you keep needing to relink?
  20. Re: VBA to create multiple blank workbooks from a list of names in a column

    Sub MakeSheetsFromList()
    Dim col As New Collection
    dim I as integer
    dim vName

    On Error Resume Next
    Range("A1").Select
    While ActiveCell.Value <> ""
    col.Add ActiveCell.Value
    ...
  21. Replies
    2
    Views
    210

    Re: Importing text file data

    Dim sFile As String

    sFile = "C:\temp\Documents\names.csv"

    Workbooks.OpenText Filename:=sFile, Origin:=65001, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
    ...
  22. Re: Returning yes/no if criteria matches horizontally and vertically

    Bob,swimming,
    Bob, hiking, true
    sally, hiking, true
    etc...

    put a true on the training completed,
    then run a pivot table on the data to get your report.
  23. Re: Computation of student Annual Average Sore and Grade

    make query 1, Q1, to calc the total per/person/term
    Q2, to get the total.
    Q3, to calc the % using Q1 & 2

    Q1 & 2 can be a range: either for 1 term, or all terms.
  24. Thread: Please Help

    by ranman256
    Replies
    2
    Views
    203

    Re: Please Help

    adjust as needed...



    Sub ParseFile()
    Dim vFile, vLine
    Dim i As Integer
    Const Q = """"
    vFile = "C:\temp\textfile.txt"
    Range("a2").Select
  25. Replies
    1
    Views
    158

    Re: comparing list of computer name

    Microsoft Access can do this in a simple query.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4