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!

  • Congratulations strongm 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. sozzer

    IE9 missing option: Use software rendering instead of GPU rendering

    This has baffled me for months now IE9 on Vista is missing "Use software rendering instead of GPU rendering" in Internet options > Advanced. The Accelerated Graphics group is not there. The pc supports gpu rendering (hd3450) - and it works - and I can change the behaviour via the registry, so...
  2. sozzer

    Expected literal constant error

    Thank you - so simple! A
  3. sozzer

    Expected literal constant error

    Hi all This might be a contender for the VBScript forum, but it's Access related so thought i'd try here! One of my colleagues has been kind enough to pass me the below code, which stops Access 2003 JET4 SP8 warning messages popping up when launching an mdb. (fantastic piece of script!) It...
  4. sozzer

    Fastest implementation?

    Cheers guys! That deserves a couple of stars...
  5. sozzer

    Fastest implementation?

    I'm in the process of building an application that will allow people to record time spent doing tasks on, and then allow us to automatically generate reports against forecast etc. Basically, about 45 users in different locations are likely to have the db open all day, all of whom will have a...
  6. sozzer

    Sorting a Combobox RowSource derived from a Value List

    Why not just store the entries in a table and use ORDER BY to sort?
  7. sozzer

    extra blank record in subform query

    cos you're in a 'mode' where you can create records and access creates a record ready for you so can always see a 'blank record'. Check it out in a table.
  8. sozzer

    Populating a cell in Excel based on another cell's information

    For what I'm trying to do on a whole Excel is a better venue for me to use" You sure?
  9. sozzer

    create a number of copies of excel file

    if you're not gonna change it much, i'll go with mintjulep's suggestion. If you want to make the xlt an xls at the same time, no probs...
  10. sozzer

    Excel 2000 - Identifying Login and Computer Name

    To approach this from maybe a different angle, what OS are you running?
  11. sozzer

    Subforms

    Are you using the subform name or the subform control name? You need to use the control name.
  12. sozzer

    Access 2000 Calendar Control Default Date

    Me.calControl.Value = Date works for me but i am using v11. A
  13. sozzer

    Open OLE object via code

    Doh! Simple but effective. Have a star for pointing out the obvious to me!
  14. sozzer

    Search a subform

    Not sure you're refrring to your form correctly. See this link which may help: http://www.mvps.org/access/forms/frm0031.htm
  15. sozzer

    Mulitple comb box "tree" x9 but only one query?

    ...After Update property of the each combo box, do this (example is cbo1 setting rowsource of cbo2) Dim strSQL as string strSQL = "SELECT tblExample.* FROM tblExample WHERE tblExample.fldExample = '" & me.cbo1.value & "'" Me.cbo2.RowSource = strSQL Of course, this uses multiple queries but I...
  16. sozzer

    Open OLE object via code

    thanks pampers. i want it to launch from a command button on a form so your suggestion pointed me in the right direction: file1 is the control name and is visible = no With Me .file1.Action = acOLEActivate .file1.Verb = acOLEVerbOpen End With However, word doesnt open the first time you...
  17. sozzer

    Open OLE object via code

    I have a Word document in a field in a table. I've looked around but cant find how i can open this via code, ie on click of a button. I currently have the following which referneces from a specific path name, but ideally i'd like the Instructions file to be packaged within the db, hence my...
  18. sozzer

    Default a Combo Box

    i've never been able to get Default Value to work on combos... Environ ("UeerName") is the way to go to get active user's name
  19. sozzer

    DAO vs ADO?

    Golom Thank you - Self taught so dont always know the correct terminology! Looking through my code, I dont kow why that never occured to me as of course i use SQL with ADO and DAO. Indeed, the problem I have only occurs when using the syntax Set cnn = New ADODB.Connection With cnn...
  20. sozzer

    DAO vs ADO?

    Thanks for the stars! On the subject of ADO, does anyone know whether it works slower than SQL? This may sound mad, but I've got a bit of ADO that runs to update records and then the table is queried with some SQL. Dont really want to convert the ADO to SQL but it's almost as if I need to slow...

Part and Inventory Search

Back
Top