Search results for query: *

Just found my answer on this page: http://www.howtonetworking.com/Windows/vpnsetup.htm

We are running Windows Server 2003 VPN giving out IPs from a static address pool. Is there any way, either with the static address pool, or with DHCP to give a specified client computer the same internal address (ie 10.100.1.1) every single time it connects? Currently the client gets a different...

Thanks Duane, The GROUP BY was exactly what I needed on the main report. The Subreports were still causing a problem when I used the subreport wizard tool to create them. But then I manually created them as separate reports by themselves and then dragged and dropped them onto the main report...

Some more information: The closest I can get with the report is like this. It keeps repeating the Heading label again for each user, which I don't want. I have the CourseID in a header. Then in the Details section I have the Heading Label and a subreport underneath that displays the memo...

Hello, I have a table that has a layout like this: CourseID(Text)|UserID(Text)|Paragraph1(Memo)|Paragraph2(Memo) What I want is to get a report in this format, but I'm not sure how: CourseID1 Heading Label for Paragraph1 User1 - Paragraph1 - blah, blah... User2 - Paragraph1 - blah...

For a long time Windows user who is learning the Mac (Tiger) I have a couple questions: 1. On WinXP I can use the keyboard shortcut [WINDOWSKEY] + [L] to lock the screen in whatever application I am. I use this a lot, every day whenever I leave my computer. Is there some similar keyboard...

Thanks for the idea mp9. That looks like it would work. I did resolve the problem myself by creating a batch file that copied the two files into one with the statement "Copy C:\Temp\NewAdditions.txt + C:\Temp\NewDrops.txt C:\Temp\Merged.txt" I then call this from VB with the code: Shell...

A union query is nice, but in my case it won't work. The website listed states this: "all queries in a UNION operation must request the same number of fields; however, the fields don't have to be of the same size or data type." My two queries have a different number of fields.

I have two queries different queries which are currently exporting to two separate text files with Transfertext. Is there any way I can make the second query append its results to the end of of the text file created by the first query? There is not a way to combine all the results in a single...

GingerR, Beautiful! What you suggested along with the information from this post http://www.tek-tips.com/viewthread.cfm?qid=764888 gave me just what I needed to get my project working. All I ended up doing was deleting all the data in the MSysIMEXColumns table. The MSysIMEXSpecs already had the...

Is there any way to modify an export specification from VBA? I have a certain table with X number of fields that change as I import a spreadsheet into it (it might be 2 fields or it might be 20). Then when I try to use a transfertext to export it in a different format, I need an export...

After posting I figured out a method that works for me. Here's the code I used: Dim MyDb As Database Set MyDb = CurrentDb Dim MyTdf As TableDef Set MyTdf = MyDb.TableDefs("ConvertTable") Dim counter As Integer For counter = 0 To MyTdf.Fields.Count - 1 MyTdf.Fields(counter).Name =...

I have a table which which is created from an Excel spreadsheet I import and has certain field names that come over from the spreadsheet. Can someone help me figure out how to change these multiple field names in VBA? This is what the field names are after I import: Quiz1, Quiz2, Quiz3...

Thank you Duane for the perfect answer! The "Choose" function was exactly what I needed and I had never knew about it. I can't use another table because it is sort of a proprietary database that I'm just hooking into to view the things I want to. Anyway to explain about these numbers (256)...

I have a series of values in my table. Each record only has one value, but they fall in these number sets: 256-260 512-516 768-772 1024-1028 1280-1284 Now each of these sets has five values, and I figured out how to convert all the numbers into a value of 0-4 and display this in my SELECT...

foolio12, Thank you for the response, which is very helpful. I hadn't heard of UNION queries and it will definitely be helpful. I don't think it will work in my case because there are such complex formulas... (ie, if the kid is this age he has to have these shots, but if he's older he has to...

I need to open up a recordset for my report which only lists those students who have problems with their immunizations, (ie. they are missing one or the other immunization according to what age they are, etc). My frustration is, when I try to create the query to do this, it already has 10 huge...

Last night I transferred my rig to a new case. I hooked everything back up and booted. Immediately the monitor displayed a random mess of blinking squares and flashing lines. Despite this, from what I could hear, the computer booted normally up to the point where it would bring up my Win2K login...

Rjs, What you say sounds like it makes sense. I just don't know how to do it. I'm not the network admin, though I do have many administrative rights, some of which I don't really know about. If you could explain how I could look at or edit these settings that would be great. Or is this...

I do not know much about Novell networks but I will try and describe the problem I'm having. First the background: I'm running Win XP SP1 with Novell Client 4.83 SP2. We were using roaming profiles and my profile saved fine whenever I logged off. I did have to insert a registry key mentioned on...