Search results for query: *

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

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

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

I have a question about an error I received using VBA in MS Word XP . The error message I receive is; Run-Time '9105' String is longer than 255 characters Here is my code; ' pccmember3 Macro ' Macro recorded 6/22/2005 by meg17-05 ' ActiveDocument.MailMerge.OpenDataSource Name:= _...

I have a question about an error I received using VBA in MS Word XP . The error message I receive is; Run-Time '9105' String is longer than 255 characters Here is my code; ' pccmember3 Macro ' Macro recorded 6/22/2005 by meg17-05 ' ActiveDocument.MailMerge.OpenDataSource Name:= _...

Hello everyone, I have a question about opening a Word XP document from ACCESS 2002 or XP. Basically what I have is quite simple. On a form I have a command button that I set up a Query make table. What I would like to do is when the user presses the button on this Access form, a Word document...

Hello once again: I'm still having an issue merging my Access table into MS Word's mail merge. Okay, what I'm trying to do in Word is have the user select the Name of event, Date of event, etc. I would like to have this using a dropdown box using Word instead of the Mail Merge wizard. Once the...

Hello everyone: I have a question about doing a mail merge in Word XP from an Access Table. Basically I'm trying to automate this merge so that all the user has to do is select their choices from drop down boxes in Word. I have a registration table in Access. What I would like to do is allow...

Hello everyone, I have a question about using Append and Deletion queries. Okay, I have a form where the user presses a delete button and a subform pops up. This form is still using the same underlying table. The user types in the reason for deletion for the record then checks off a...

Hello everyone. I have a gem here. One of my co-workers has a Compaq Presario Model 5070 with a monitor with model 770. The problem is that they were using the computer typing a research paper, when the monitor's screen became black the a small blue box that read "Override". That's it. No...

Hello everyone: I have a question about adding totals from two different queries. I created two text boxes one for the Grand total: =Sum("[PAID]")+DSum("[paid]","noshow query","[PAID]") and one for the other query: =DSum("[paid]","noshow query","[PAID]") Okay, if there is an amount in the...