Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

"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...

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...

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...

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...

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...

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...

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...