Search results for query: *

...which compares a regular expression to a string. In the problem, a regular expression will be a series of lower case letters (a-z) or asterisks (*). The asterisks are wildcards. A string for this problem will be a series of lower case letters. I'm reading in a file and the 1st line is the...

Hello, I need to write a java program that will take a string input from a user and output the frequency of each letter in the word. I could use long case statements but I think there might be a more efficient way of doing this. When the user inputs a string, does each letter correspond to an...

hello, I'm a junior coder having trouble with what the subject state. Currently, I'm working on a c# project. I have a form where the user enters in a credit card number and a purchase amount. I have a created a web service so once the information is entered, the credit card number searches...

Hi, I was previously using Outlook Express 6 for email. However, I decided to install Outlook 2002. The problem is what the title states. When I send mail to my account, it shows up in Express and not Outlook 2002. I want it to show up in Outlook 2002. I removed my account from Express and it...

It's a rather long piece of code that involves the DoCmd copy and paste function. I know that the code works fine, its just that after its pasted 10000 records into my subform, it crashes with an out of memory message. Is their anyway to clear the memory? Perhaps a piece of code like...

I have achuck of code that uses the DOCmd copy paste function like a gillion times. If their are over 10000 instances then it eventually gives me an out of error message. Is their anyway i can clear the memory mid way through the process like when it hits record 5000. is their a piece of code...

Would you happen to know where/how i could find the error number?

I have some of the users of my database import excel sheets. Sometimes when they import an excel sheet they get the following error. "not all of your data was succesfully imported. Error descriptions that are associate with rows can be found in table..blah blah" I dont want them to see this...

Thanks it works

I have a subform that has this has the record source SELECT DISTINCTROW [extract].[ID], [extract].[Req #], [extract].[Rec Typ], [extract].[Rev Cd],Crtn Dt], [extract].[Crtn User] FROM [extract]; Obviously its from the table extract. When this form opens, i want it to ask the user "what is the...

Thank you all. It finally works

Tigger thats exactly what i want to have happen. But i dont want to users of the database to have to hit control v. I tried both of those maethods cajun but none of them work. I don't think that my excel worksheet Set sheet1 = CreateObject("excel.Worksheet") is right. Hmm

This is exactly what I have Dim objexcel As Object Dim wkbook As Object Dim sheet1 As Object Set objexcel = CreateObject("Excel.Application") Set wkbook = CreateObject("excel.Workbook") Set sheet1 = CreateObject("excel.Worksheet") sheet1 = objexcel.workbooks.Add objexcel.Visible = True...

It doesn't seem to be working. I did some tinkering with the code and this gives me the same result Where would i put that line of code? Dim objexcel As Object Dim wkbook As Object Set objexcel = CreateObject("Excel.Application") Set wkbook = CreateObject("excel.Workbook") wkbook =...

Here is a sample of the code i am using --------- Dim objexcel As Object Dim wkbook As Object Dim sheet As Object Set objexcel = CreateObject("Excel.Application") Set wkbook = CreateObject("excel.Workbook") Set sheet = CreateObject("excel.Worksheet") wkbook = objexcel.Workbooks.Add...

Hey i got a blank excel sheet to open.. problem sorta solved thanks

...oApp.Visible = True 'Only XL 97 supports UserControl Property On Error Resume Next oApp.UserControl = True ****part not working ---- OApp.Workbooks.Open A blank excel sheet please -- ****part not working I think it would look something like that Thanks for the help

1. I want to try and catch an error. I know i have to use the "on error" box to capture errors. Does anyone know the error number for this error You are about to delete ___ number of record(s). If you click yes.... 2. I have VB code that automatically opens excel. After it opens...

It says that it is a Table/Query. However i use VB code in a button with that says Me.listbox.RowSource = ProductsSelected I hope this helps

Basically i want to add a row in the MIDDLE of a listbox. I know exactly where this row should be. I have a listbox with many columns and many rows. I have a while loop checking for a particular field in this listbox. When it finds this field i want to the following to happen. As soon as it...