Search results for query: *

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

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

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

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

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

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

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

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

I have some Borland database files from an application and I would like to open them up or convert them to view in Access. Access doesn't by default support this it appears. Is what I want to do possible? If so, how? Thanks Startup

I have 2 problems I'm experiencing with my video but I cannot figure out why they are happening. My system specs are: MB = ECS K7S5A Graphics = Visiontek XTASY Ti 4200 64Mb OS = W2k SP3 Monitor = KDS @tview 700? 1) Periodically when I boot the computer, immediately, before even the graphic...

This is a curious problem. I have a bunch of records in a table that have an asterisk (*) character at the beginning of them. I want to use the Access 2000 Find and Replace function to delete these characters. However, when I enter the asterisk symbol in the Find field it finds every single...

On several computers I've owned through the years I've gotten the feeling, though not actually tested it, that hard drives slow down over a period of time (like 2-3 years). The speed decrease is not due to OS garbage as I've reformatted and reinstalled the systems, it just feels like things load...

I just got a new computer with Win XP at work and now my KILL statement which I used successfully on all file sizes before now fails miserably on any files that are larger than about 200Kb. I receive the message, "Run-time Error '70' Permission Denied." I know that files are not read...

Anyone have the VB Code to create a unique username from the Firstname/Lastname fields in my table? It needs to have the following criteria: 1) Basic username = 1st Initial + 1st 7 characters of last name 2)If username is a duplicate, a number starting with # 1 will be added to the end...

When using SendObject to email a Report in Snapshot format as an attachment, Access gives the attachment the same name as the Report. Is there a way to modify this name so I could have the attachment created with its own custom name? Rico

Anyone know a way to export a report to the Snapshot Viewer (SNP) format with visual basic? All the transfer formats I can find in Microsoft help for the DoCmd.TransferText commands are: acExportDelim acExportFixed acExportHTML acExportMerge acImportDelim (default) acImportFixed acImportHTML...

Hello, I have a table with values like the following in one of the columns: AA AA BB CC CC CC EE How would I create a SELECT statement which would grab a unique instance of each field? The resulting output I want would be: AA BB CC EE Thanks, Rico

Does anyone know how to make a form always appear on top of all other applications and windows which are open? I want to have a small form which will always be visible even when Access is minimized and I am viewing other applications. I don't know if this is possible with Visual Basic or some...