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 Chriss Miller 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. WildHare

    Wireless and Wired to same router-home network question

    Success! It was a combination of the Windows Firewall on the wireless PC, and the AVG suite firewall on my PC itself - I turned off WF, and configured AVG to allow File & Printer sharing and now all appears well. Thanks much! -------------------------------------- "For a successful...
  2. WildHare

    Wireless and Wired to same router-home network question

    Hope this is an easy one. I have a Netgear router which is connected to my cable modem. My PC is cabled to the router, and two other PCs in the house are wireless connected to it. All is fine. But I want to set up some shared folders on the other PCs, and let them use my printer, et cetera. I...
  3. WildHare

    Display an Access Snapshot on a FP web page?

    Is this possible? Can find no documentation or suggestion of it. Have an intranet, one Department wants to make reports VIEWABLE on the 'net, but no changing data. I have the "OutputTo" method working but the formatting leaves a lot to be desired. I thought it might be possible to use a...
  4. WildHare

    Access - Word Merge, Can't get merged doc to print

    PHV - yeah, I don't save it, so your tip saves a step - Thanks! -------------------------------------- "For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P. Feynman More Access Help: http://www.jmhare.com/AccessForum...
  5. WildHare

    Access - Word Merge, Can't get merged doc to print

    Update : Never mind - found it. The Documents collection puts the MERGED document in as Documents(1), and the original as Documents(2) - I thought it was the other way around, when I tried Activating Documents(2)... -------------------------------------- "For a successful technology, reality...
  6. WildHare

    Access - Word Merge, Can't get merged doc to print

    OK, 98% of the way there. Have a simple system to sent some Access data to a Word document, do a mail merge, and print. Everything works except the print. I thought I'd read that once you do a "MailMerge.Execute", the "merged document" becomes the ActiveDocument, so if you do a...
  7. WildHare

    Import .csv to access database

    I think you may have a sticky situation. IF the file you're attempting to import has different record types in it, and you want to import the rows into appropriate tables, then you'll need to write some code to procedurally do this - I don't think you'll be able to directly 'import'. You'll...
  8. WildHare

    create a table

    Actuall, you need one table with THREE columns: Type of Expense (Rent, Water, etc) Type of Outlay (Fixed, Added) Amount -------------------------------------- "For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled." - Richard P...
  9. WildHare

    Print SCRN

    Depending on what else you have on screen at the moment, here's the general idea for what you specifically want to do: 1) Select the record that's being displayed on the form 2) Print the form, using the PrintOut action, which has a 'Form' modifier. I think I've used the FILTER method to...
  10. WildHare

    Form opens at bottom right of screen.

    I'm curious about this. The OP seems to infer that the form itself opens towards the lower right corner of the screen, but then when he states he uses the "scroll bars" to center the form on the screen, I'm totally lost. Scroll bars would be used to move the CONTENTS of a form around within...
  11. WildHare

    Preventing "hot-linking" by other sites

    Is there a way, using FP/2003, to mark an image on my site as "not hot-linkable" by other users. I'm plagued by MySpace and other areas having users linking to images on my site and using my bandwidth. I can Protect my entire site via my hosting company, but that's a pain, because there are...
  12. WildHare

    Mark Record Printed.

    Yes, certainly. How is your report printed now? The simplest way is to add a command button on your form, using the Command Button Wizard to PRINT A REPORT. Follow the prompts for this wizard, and the necessary code will be attached to the button on your form. When it's finished, right-click...
  13. WildHare

    Why can't I enter info into query?

    Julie - it would seem from your description that you have a fairly straightforward One (Contact) to Many (Student) relationship. If your query is pulling entirely from the Contact table, why is the Student table in the query at all? You should be able to do this stuff fairly easily - there...
  14. WildHare

    Properties in a form

    "CYCLE" means "what do you want the form to do when you tab out of the last text control on the form? 1) CURRENT RECORD means go back to the first control on the form, staying positioned at the current record. (RECOMMENDED - bouncing off the record on screen suddenly can be very confusing to...
  15. WildHare

    Why can't I enter info into query?

    Well, Julie, I'd guess it's a relation ship problem. As well as a syntactical problem. All queries are editable. But not all datasets returned by a query are. So your question is really, "why is not the dataset returned by my query editable?" First off, make sure that the dataset is...
  16. WildHare

    Mark Record Printed.

    Amy, here's what you want to do: 1) Add the new field to your table, as Randy700 suggested. 2) Create an UPDATE type query, with the SAME CRITERIA in it so far as the dates that are selected, and add the new field to the query grid. Set the 'Update to" cell for this field to "TRUE" (or YES, if...
  17. WildHare

    Query for missing records

    Jshay, FredKa is correct - you want basically what is called an "outer join" - one that returns records from Table1 that DO NOT have a match in Table2, e.g. the 'missing' records. Check for FAQs or WhitePapers here on Tek-Tips, keying on the "outer join" guy. I also have a quick note on my...
  18. WildHare

    Query Field Rename Causes TransferSpreadsheet error!

    Did you rename fields in the QUERY, or in the table they're coming from? When I first started with Access, this little "quirk" caught me a couple of times, until I figured it out (I think...) You know how, in a query design window, if you have a text string enclosed in brackets, in either...
  19. WildHare

    Searching for records between two given dates

    MichaelCree - Please pardon me for jumping in here, perhaps your problem is solved, and you don't need any latecomers mucking up the works, but after reading this thread, I think I can suggest a perhaps easier and more error-proof way of solving your problem. However, as noted, please feel free...
  20. WildHare

    DLookup for a Label in a Form

    Glad it's working the way you want - the DateTime stamp would have also worked, if I read your prior posting correctly. If each record gets a NOW()-kind of timestamp on insert, then finding the DMAX of that timestamp would, of course, return the "most recent" record - but most recently INSERTED...

Part and Inventory Search

Back
Top