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

  1. funkytunaa

    Block Users from Facebook.com but allow Admin

    Proxy would be your best bet. You can hook up pfsense or something which is free and install squid on a fairly basic machine. Easy to install and configure. you can block traffic globally and white list certain IP addresses. But if there's a will there's a way.
  2. funkytunaa

    Time out

    I have a problem. I have a fairly sizeable database, in that it's got quite a few million records. I found a few weeks ago it started timing out on some computers. Each computer has an access front end that does an "open form" and depending on the postcode that the user enters, it returns that...
  3. funkytunaa

    permission to local directory via GP?

    I have a program that writes to a couple of files in it's own directory off C:\, let's call it programx. So I have a folder on all machines with programx installed called c:\programx\ I need to give each user under a specific OU modify access to that folder. Rather than go to each machine...
  4. funkytunaa

    SourceObject

    I inserted a nested subform in the subform on the main form as I needed to put in multiple addresses and now it works fine. Stupid head microsoft. Cheers!!
  5. funkytunaa

    SourceObject

    I wish it were that simple, I've checked the "default view" and I have changed the "Allow datasheet view" to no on all 3 sheets. Main Sub1 Sub2 If I open the form seperately, rather than in the sourceobject, it opens fine. Cheers!!!
  6. funkytunaa

    swapping DVD drive on Acer Aspire 5002 WLMi

    you serious? laptops aren't like desktop machines, inbuilt parts aren't interchangable. only thing you would be likely to swap over is the hard drive and that's not guaranteed being one may be sata and the other ide.
  7. funkytunaa

    SourceObject

    Trying to change a subform by using "sourceobject" Button works but the "subform2" is changed into datasheet view. I have changed the form so it says "no" to datasheet view, but still shows wrong. Should mention this is an upgrade from an mdb database and all was working ok with the old one...
  8. funkytunaa

    Appointment report

    Just thought I'd update on what the outcome was. how I ended up doing it was I used a query to sum the actual appointment numbers, a query that looked up the appointments required and these both together with a query that gave the appointments needed. From there, had a report that listed the...
  9. funkytunaa

    Appointment report

    That seems to be just creating the crosstab report so it gives you columns to work with though the data that populates it comes from a table and as such, is return queried by rows. How do I populate the report? Am I making sense? Or have I been thinking about this too much. I think I need break.
  10. funkytunaa

    Appointment report

    What I have been working on has changed considerably. At the end I need a report like this. Person 05/01/10 06/01/10 07/01/10 Adam 4 3 0 geoff 0 3 2 With Start Date on the report being selected from a field on a main menu and the dates to...
  11. funkytunaa

    Appointment report

    I have a sql database that houses appointment data. I'm trying to create a report that will match up "required" appointments with actual appointments. Currently I've written a query that counts the number of appointments for each date and returns the day name (ie. "Monday", Tuesday etc..tippin...
  12. funkytunaa

    page numbers in TOC wrong when opening template.

    I have a word template that when I open the actual template file, the page numbers are all ok. When I open the template so it creates a new file, as templates do, the page numbers are out of whack. In that that it take page 2 of each of the sections and use that as the page number in the TOC. If...
  13. funkytunaa

    Inserting in TOC problem

    Got it. Each section has different header information. I did an if statement saying if "page i" section isn't there then do this. ActiveDocument.Sections(N).Footers(wdHeaderFooterPrimary).PageNumbers.RestartNumberingAtSection = True and when inserting the "page i" section, change it to false...
  14. funkytunaa

    Inserting in TOC problem

    Hmm, well at least it's complicated. I've tried doing an if statement which says if page ii is there then reformat the page numbering to start page numbering from 1 but that seems to crash word for some reason, so I can't even test possibilities with that. Might be a tomorrow job I think when...
  15. funkytunaa

    Inserting in TOC problem

    It's definately not a typed page number. just when I delete the first section, the second section page number seems to keep continue page number from previous section, which is the TOC. TOC being set to "page 1" the section keeps "Page ii" These niggly things are really annoying. Just a...
  16. funkytunaa

    Inserting in TOC problem

    This is totally true! You are a genius! Got all that simplified now. I'm working off a template that someone else created and they have put way too much crap in here to do simple things..I was dubious about deleting whole sections, but I have and everything is working a heap better. Thank...
  17. funkytunaa

    Inserting in TOC problem

    Ahh, got the style insertion into the TOC. When it inserts though it puts it as page 1, 2 whereas on the styles the page numbering is i, ii etc. Is there a way to carry the numbering style to the TOC? Cheers and thanks!
  18. funkytunaa

    Inserting in TOC problem

    Once again apologies, got a lot going through the noggin. What I want to do, is insert a page/section with some information on it and have that section appear in the TOC. Simple I would have thought. Cheers
  19. funkytunaa

    Inserting in TOC problem

    Appologies, I'm pretty much over trundling through this script :) Below I think is where I am going wrong, in that the script searches the sections to find the TOC and then sets the TOC section start and inserts the Introduction at the start of the TOC, any thing else added in the same way is...
  20. funkytunaa

    Inserting in TOC problem

    I have a vb code that inserts and deletes a couple of different pages then the entry for those pages into the TOC. All works ok for each page seperately, though when I use the code to insert more than one page, ie Intro then Summary page, the second insertion puts the TOC entry "inside" the...

Part and Inventory Search

Back
Top