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 wOOdy-Soft 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. josephwalter

    How to keep users from changing proxy settings (group policy)

    I have set the desired proxy settings and default home page using group policy (under User config | Windows settings | Internet Explorere Maintenance | URLs and Connection (respectively). The changes have taken effect. The Address box to set my homepage is grayed out (disable) and I cannot...
  2. josephwalter

    Lexmark Optra S 1650, MarkVision 11: User unauthorized for this device

    I just upgraded to version 11 of Markvision Professional, which I've been using to control my Lexmark Optra S 1650 printers remotely. Prior to the upgrade, I could access the Operator Panel via MarkVision. Now I get the following error: "User unauthorized for this device. User the Enter Device...
  3. josephwalter

    how to make a circular gradient

    i'm using a photoshop tutorial to figure out how to make a "waiting animation" (a circle of spinning circles), except i'm doing it with gimp. see http://www.vladstudio.com/photoshoptutorials/?8 i'm stuck on the step where i need to add a gradient layer, that will make the first circle fully...
  4. josephwalter

    Adding subreport results in multiple Enter Parameter Value prompts

    i have 2 reports that run fine on their own, but when i put one in the footer of the other (as a subreport), access promptes me 4 times to the same value Query1 is the record source of Report1 "Enter Report Date" is a parameter to Query1 Query2 is built on Query1, and is the record source for...
  5. josephwalter

    monitoring DNS, want list of sites being accessed

    I'm setting up content filtering with DNS (the same method commonly used to filter out ad servers). I know this isn't the best way to control access to the Internet, but I'm doing it more as a deterrent. I'd like to monitor what domain names the DNS server has been dealing with. Windows Event...
  6. josephwalter

    Combo2 depends on Combo1 ... On Open, user prompted for Combo1 value

    I've got two Combo Boxes on my data entry form. The value selected from the first will limit the choices in the second combo box. Combo2's Row Source uses the values of Combo1 as a criteria. When I open the form, Access prompts me for the value of Combo1 (understandably - the form's not open...
  7. josephwalter

    Method 'FileDialog' of Object '_Application' failed

    A button on one of my forms is supposed to open the File Open dialog box. It works fine on user's computer when I have Access installed (as part of Office XP Professional), but it doesn't work with just Access Runtime. User gets the error "Method 'FileDialog' of Object '_Application' failed."...
  8. josephwalter

    highlight current control as user tabs through form

    I'd like to change the background color of each control on the form as the user tabs through them - in order to highlight where he/she is at on the form. I know I could code a change in the BackColor property under the GotFocus and LostFocus of each control, but that doesn't feel like the most...
  9. josephwalter

    Chart in DAP only displays one group's data

    I have a Data Access Page (DAP) that reports the results of our manufacturing By Crew. Here's a short example: Date Product Crew Results 3/1/04 xyz A 50 3/2/04 xyz A 51 3/4/04 xyz A 49 3/5/04 xyz B 52 3/6/04 xyz...
  10. josephwalter

    DAP error: Column in CALC expression not defined in rowset

    I've added a textbox to the Section Header of my Data Access Page (DAP). The expression I provided in the Control Source property was obviously invalid: "Column (column_name) was used in a CALC expression but is not defined in the rowset." So I deleted the textbox. I still get the...
  11. josephwalter

    ALTER TABLE ... SET DEFAULT Syntax error

    I'm trying to execute the following in Query Analyzer: ALTER TABLE VR_MAIN_O4 ALTER COLUMN OPERDAYS DEFAULT '0' I get the error "Incorrect syntax near keywork 'DEFAULT'." I tried changing DEFAULT to SET DEFAULT, and I tried taking the single quotes off the zero. Nothing but syntax...
  12. josephwalter

    DAO transactions with parameter queries

    There is no transaction control on my Macros (they execute a half dozen queries at a time), so I want to convert them to VB procedures. I've done a lot of VB coding before, but I'm having a bit of trouble with this one... I would like to use ADO programming techniques, but I'm having problems...
  13. josephwalter

    Copy Default Values

    I have two tables that have the exact same fields. One is named MAIN_03 and the other MAIN_04. The '03 tables holds 2003 data and the '04 holds 2004 data - I don't like it, but I'm not allowed to change the table structures. When we copied the '03 table to create the '04 table we didn't get...
  14. josephwalter

    how to display ADO data control Property Page at run-time

    When I'm developing a program in Visual Basic 6, I can select my ADO data control and click the build button next to the ConnectionString property. This brings up a nice Property Page that has all the controls on it I want, plus it has a Build button that brings up the Data Link Properties...
  15. josephwalter

    No data shown in Access Page, but Query is okay.

    My Access Page is coming up without any records for me to scroll through, although the query it's based on has just over 20 records in it. What's causing this? (Not sure if it's relevant - but the query is an aggregate query).
  16. josephwalter

    Can I sort before applying the LAST function?

    A record somehow got entered out-of-order. Now the Last function in one of my aggregate queries is returning the incorrect row. Here are the details: Table Name = tblData Date Period Week Balance 07/26/03 7 4 150 07/20/03 7 4 100 07/21/03 7 4...
  17. josephwalter

    obscure errors querying linked server from workstation

    I have a linked server set up on SQL Server that is pointed at an Access 2000 database. I've successfully created a view in one of my SQL Server databases that queries certain data from this linked server. I can run the view from the server machine with no problems, but when I try to run it on...
  18. josephwalter

    Linked Server - Error 7399 ...

    I've created a linked server from an unsecured Access 2000 database to SQL Server 2000. Under the security tab, I've got all users being mapped to the remote login 'Admin' with no password. When I try to view the list of tables in the linked server _from the server_ it works fine. I can query...
  19. josephwalter

    How do I Install Access 2002 Runtime (only)?

    I want to put runtime on my users' machines and distribute copies of my Access 2002 (XP) .mde files, as needed. I can't figure out how to (or if I can) install runtime as its own program. I don't want to make packages for each database front end and include the runtime files in each. I want...
  20. josephwalter

    renamed fields - can references to old name be auto updated?

    I'm supposed to rename the fields (and table names) in a database that I've inherited. But if I do, none of the queries, forms, reports, or VB code will work properly. Is there some kind of program that I could use to carry forward the name changes - rather than spending an eternity going...

Part and Inventory Search

Back
Top