Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. griswom

    Anything analogous to querytable in Access VBA

    crobg, Haven't been able to find a good overall reference. I just pieced my code together from examples I found on Google. Sorry I can't be of more help. Griz
  2. griswom

    Anything analogous to querytable in Access VBA

    crobg, Thanks for the advice. Sorry for the belated reply. Here is the code I ended up using in case anyone else needs this. It requires the XML 5.0 library: Function XMLPrice(sSecurity As String) Dim xml As XMLHTTP Dim sURL As String Dim sResponse As String Dim sQuote As String Set xml =...
  3. griswom

    Anything analogous to querytable in Access VBA

    I would like to be able to connect to a URL in access and store the response in a variable to display on a report. I use this code in Excel: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/d/quotes.csv?f=l1&s=" & [A3], _ Destination:=Range("p32"))...
  4. griswom

    Date Format in Access 2000 from (20010119) to 1/19/2001

    By the way... Test this on one specific record before you run it on all of them. I would hate for there to be some extra spaces in the field length that threw everything off or something... HTH, Griz
  5. griswom

    Date Format in Access 2000 from (20010119) to 1/19/2001

    Hi tav1035, I have been down this road.... Design an update query. Bring down the Date_Received column. In the update field, enter this string... Mid([Date_Received],5,2) & "/" & Right([Date_Received],2) & "/" & Mid([Date_Received],3,2) This should accomplish your...
  6. griswom

    What is DoCmd.RunCommand acCmdPrint printing?

    JBG, I'm not sure if this applies in Access 97, but in Access 2000 you could do docmd.printout acSelection and that would give you only what is active at the time. HTH, Griz
  7. griswom

    Indexed field

    Yes... That is why you are selecting Indexed(Duplicates OK). Griz
  8. griswom

    Indexed field

    Sabavno, This can be done easily. Go into design view on your table, and select the last name field. In the bottom left corner of the screen will be a row that says "Indexed". Change this to Yes (Duplicates OK), and save your table. HTH, Griz
  9. griswom

    OpenRecordSet? (and thanks steve101!)

    xq, try this when you declare the rs variable dim rs as DAO.recordset that should fix the problem I believe. HTH, Griz
  10. griswom

    Something Other than Transfer Spreadsheet! Desperate!

    Hi SteveCarrier and buddyel, Ok to link an Excel spreadsheet, go to the tables tab in your database, right click in a blank area, and select link tables. At the bottom under "Files of type" change to Excel Spreadsheet. Then locate your spreadsheet, highlight it, and select link. At...
  11. griswom

    Something Other than Transfer Spreadsheet! Desperate!

    Steve, Link the spreadsheet into your database. This will allow you to treat it like any other table. You can then search for the values that you need and transfer them to your Access tables. HTH, Griz
  12. griswom

    Form Lost Focus

    Jucius, Thanks for the tip. I'll give that a shot. Griz
  13. griswom

    Form Lost Focus

    Hi All... Is there any way to tell which form just lost the focus? I have a field on a form that I would like to populate with a value from the form that preceeded it, but that form could be one of a few different forms. Any ideas? Thanks in advance! Griz
  14. griswom

    Updating a split database

    Crystalguru, As for the slow speed, it probably has to do with the "Perform name Autocorrect" bug. Go to Tools, Options, General tab on your database, and make sure that this is unchecked. Secondly, does your database use any "Make Table" queries? If these are run...
  15. griswom

    Password protection for a form...Please help!!!!!

    Nate, Open the properties of the unbound password field. On the data tab under input mask, type "PASSWORD". This will make asterisks appear in the field instead of the letters typed. HTH, Griz
  16. griswom

    Password protection for a form...Please help!!!!!

    Hi Nate16, Here is the way that I would do it. Make an unbound field on the form with the button called password. Disable the button on the form. Write some code in the After Update event of the unbound field something like this: If me.password = "Password" Then...
  17. griswom

    How can you perform an Excell Vlookup Function within Access

    PICKLES, Do some research on the DLookup database function in Access help. You should be able to use this to accomplish your needs. Griz
  18. griswom

    Urgent....problem with built in functions!!

    scking, I think that you had the problem pinpointed. I created the database on a local drive and then moved it to a network drive. That must have resulted in the functions not working probably. Thank you all for your kind assistance. Griz
  19. griswom

    Urgent....problem with built in functions!!

    Hello All, I just got a freshly formatted computer, and for some reason this install of Access is not recognizing built in functions such as Date(), InStr(), etc? Any ideas as to why this might be happening? Any help would be appreciated. Thank you! Griz
  20. griswom

    Is this possible...subform and allow edits?

    Hello All I have a subform, and the AllowEdits property is currently set to False. The user needs to be able to create new records and fill in all the fields, but not change them after the record is saved. Ideally, I would want AllowEdits to be false for every field on the subform except one...

Part and Inventory Search

Back
Top