Recent content by kjspear

Hello, I would like to automate importing a .CSV file into Access. The .CSV file is exported then imported to create a new table in Access 2003. What I'm trying to do is use Form to where the user clicks on a button and that opens up the file dialog box so that the user can select where the...

Hello, I have the following code; SELECT ([Lap ID])&" "& ([Last Update]) AS Expr1 FROM Laptops; What is happening is that the list is not lined up correctly. Ex; 07AJ 4/30/2008 0111 4/30/2008 I'm trying to line them up. The max characters for the [Lap ID] field is 3. But I want the...

That worked. Thanks a million!

Hello everyone, I have a question about using the iif statement. I imported a CSV file into a table in Access. No problems with the import. But one of the fields contain a persons non-schedule work days. The field has seven characters 'Y' and 'N', where 'Y' represents the non-schedule day. The...

Hello everyone, I'm learning VB.NET. I created a form with a text box. I'm not sure how to capture the users data entry from the textbox to store in a variable. Here is what I used' ' Me.TextBox3.Focus() totalg = Val(TextBox3.Text) Me.TextBox3.Update()' What I want to do is...

Hello everyone, I'm currently in college learning VB .NET. The professor instructed us to download VB .NET 2005 or 2008 Express. I downloaded the setupfile from the Microsoft website. However, when I run the setup program,it goes back on the internet to download more files. The problem I'm...

Hello everyone, I've recently upgraded my Win Xp pro SP1 to Win Xp Pro Sp2, finally. Everything worked fine for a week. But now the Windows Firewall is not working (Disabled.) I tried to open it in the Control Panel but receive the following 'Windows Firewall - settings cannot be displayed...

I already have it set so that the user must enter a user name and password to use this computer. The problem is that it's not loading the profile for the Power Users account. When the user logs in, a blank blue screen appears with the hourglass going on and off while the harddrive is spinning. I...

Hello everyone, I have a strange situation with Windows XP Pro. Now before I updated a computer from Windows 2000 Pro, I created a limited access account for a user, Poweruser. In the past, there was no problem. But now when I try to do this, the account is created and the user can log in...

Hello everyone, I have an EPSON STYLUS CX5200 printer. That's the all-in- one type (Printer,scanner, copier) A piece of paper jammed in it. I cleared it out. However, I receive a error light. The LED reads Printer error and that's it. I tried turning it off and on several times but the error...

Hello everyone, I have a question about Excel. My job maintains a delivery route within certain neighborhoods. The line of travel which includes streets are in a Excel database. Is there any way that I can have Excel actually produce a map of the routes? What I'm trying to accomplish is...

Hello everyone, I have a question about Excel. My job maintains a delivery route within certain neighborhoods. The line of travel which includes streets are in a Excel database. Is there any way that I can have Excel actually produce a map of the routes? What I'm trying to accomplish is...

I have a question about the USB port. Recently, I plugged a Flash Drive into one of the USB ports. The system Win XP Pro, recognizes it but then reboots itself shortly after it is plugged in. The computer will boot up recognizes it again and reboots as long as this or an iPod player is in that...

Hello everyone; I have a simple question. I would like to disable the prompts such as 'Create Table or Table Already Exists override?'. What has happened is that in VBA, access will create a query based table. That works fine. However, I don't want ACCESS to prompt the user for specific tables...

Hello, Yes, I've shortend the string by eliminating some code as per Trevil and the others. It appears to be working fine now. Thanks Everyone.