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...
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...
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!
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.