Recent content by funkytunaa

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.

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

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

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

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

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.

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

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

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.

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

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

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

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

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

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