Recent content by rstitzel

I think: Go into the properties of the client's VPN connection. Click on Networking,click Internet Protocol (tcp/ip), click Properties, click on Advanced, check "use default gateway on remote network". Click OK OK OK.

If your using a Microsoft operating system, have you tried using the "scheduler" in the control panel? You can create a shortcut on your desktop to the macro. Just drag the macro with your right mouse button to your desktop. Go to control panel, click scheduled tasks, Add scheduled task...

Just a thought: PAUL JONES is the descriptive name and not the account name. My user account name is rstitzel but my descriptive name is Robert Stitzel. Perhaps the administrator who set up your account typed PAUL instead of CHRIS under YOUR account profile. That would be why you can create...

Under the user's profile you'll see a tab named "Dial-In" Make sure the user you're trying to log onto through vpn has ALLOW ACCESS. fyi

In my first post I mentioned that I tried that keyword but the problem is it's a multicolumn subfile. I'm using the SFLLIN to space the columns. I get a compile error since SFLCSRPRG and SFFLIN are not compatible. Since that didn't work I was hoping there was a way to load the records...

START>PROGRAM>ACCESSORIES>SYSTEM TOOLS>FILE SETTING AND TRANSFER WIZARD This will save ALL your settings into a file. You can burn that file to a disc and save it somewhere. If you computer crashes you'll be able to restore your settings on the new one. FYI

I have a data entry screen with two input fields SLS PROD There are six columns on the page SLS PROD SLS PROD SLS PROD SLS PROD SLS PROD SLS PROD When the subfile loads it load vertically. Subfile records 1 - 12 in the first column, 13 - 26 in the second and so on. But when the user...

I have a program that generates invoices. We want to print these invoices on forms that will be passed through a laser printer. One Copy White (Drawer 1) and one Copy Yellow (Drawer 2). We'll print one page from one drawer and then the same page from the second drawer with ONE print file...

Correction: update janysec/causenumbe set ei2casnum = ei2casnum + 20000 where ei2casnum >= 70000 and ei2casnum <= 79999 and yourdatefieldname = 20061010

update janysec/causenumbe set ei2casnum = ei2casnum + 20000 where ei2casnum <= 70000 and ei2casnum <= 79999 and yourdatefieldname = 20061010

To shutdown: you could create a batch program using the shutdown command and then schedule the batch file using SCHEDULED TASKS under control panel. Syntax shutdown [{-l|-s|-r|-a}] [-f] [-m [\\ComputerName]] [-t xx] [-c "message"] [-d[u][p]:xx:yy] Parameters -l Logs off the current user...

bwtc, Thanks for the idea. I implemented your suggestion and it works great. Thanks again.

I have a subfile that contains a numeric field that is 9 digits long. I want to be able to change the decimal positions "on the fly". If a user select type 1 I want the numeric field to be 9 with 4 decimal places. If it's a 2 I want it to be 3 with 2 decimal place. Is that possible? And if...

Click Tools, Macro, Security If you set it to LOW you won't get these messaages. It's not recommended unless you're running virus protection. FYI

I believe you would need the Developer's edition of Access 2003.