Recent content by startup

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