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 TouchToneTommy 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: *

  • Users: sozzer
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. sozzer

    Continuous form not updating properly?

    I have a continuous subform within a single form. On click of a button on the single form, procedures run which: i. Bring data into controls on the single form from three tables via ADO (refresh the screen view) ii. Evaluate that data (various if statements) iii. Depending on the output of...
  6. sozzer

    CurrentProject deosnt work in '97

    Hi I have the following code pulling data from a table onto a form. The db was devloped in Access 2003 in 2000 format and runs fine on 2000. However, when in '97, I get an error on the line 'Set cnn = CurrentProject.Connection' I gather that CurrentProject is not available in '97 but is there...
  7. sozzer

    Move down to next cell in excel?

    Hi all Really dumb question.... I'd just like to know the syntax to move from current cell to the next one down. For example, I'd like to run the below through the whole of column B, just moving to next cell after Dim strvar As String Range("b34").Select strvar = Range("b34").Value...
  8. sozzer

    Dial up via broadband

    I have a strange request and not sure if it can be done but any ideas would be greatly appreciated. My work laptop runs NT4, is thoroughly locked down but I can access my email on it if I use the SSL dial up function - not great but it does the job. At home, I have one phone point downstairs...
  9. sozzer

    SQL Dates

    Im in need of some help (again!) I have a database that runs a fantasy football league. Games are grouped by week and on the main results form a combo box enabling selection of a date together with toggle buttons for leagues change the recordsource of the form as selected by the user. However...
  10. sozzer

    Recordsets?

    I'd be really grateful if someone could please explain to me how to reference records in an access table without using a form (using recordsets?). I have been working with access for a couple of years now (with a bit of vba) and am fed up having to use forms to manipulate data, but all the...
  11. sozzer

    Change field color depending on value

    Hi all I'm trying to build a project/ task management app for my own purposes and have the following problem: I have a Status field on a form that changes it's value depending on whether a field named DueDate is showing a value in the past, in the future, or today (overdue, future dated, due...
  12. sozzer

    onclose event fires when filteron?

    I'd be grateful if anyone knows whether a report onclose event is supposed to fire when i apply a filter to a report using vba. My code opens a report and then applies a filter using whatever criteria a user input into a form. But whenever it does this, the onclose event seems to fire, opening a...
  13. sozzer

    onclose event fires when filteron

    I'd be grateful if anyone knows whether a report onclose event is supposed to fire when i apply a filter to a report using vba. My code opens a report and then applies a filter using whatever criteria a user input into a form. But whenever it does this, the onclose event seems to fire, opening a...

Part and Inventory Search

Back
Top