Search results for query: *

Hi all, I'm trying to write a program 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...

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

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

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

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

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

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

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

I use the variable prodselected for a listbox population. This is the code as of now ProdSelected = ProdSelected & "WHERE [Fixed Block]![Contract Number ID] = '" & "AC" & "'" So this will search the COntract Number ID field of my table for "AC" Now what i want to do is search for AC OR...

I have a listbox which has a rowsource from a table. This table has over 20 columns. The listbox shows all 20 columns but i specifically want 11 columns. Does anyone know how i would do this? Thanks

Ok so i imported an excel sheet into a table, which I will refer to as table1. Inside a form, i which to populate a list box with the information from the table. I can get this to work by using the following code on a command button *********** Dim ProdSelected As String ProdSelected =...

I have a field which is my primary key. If that field is blank and i try and click save record it gives me an error saying that index or primary key can't contain null value. My question is how do i change that error to say something like "Please complete the ticket number field" Where in the...

In my VB code i have a variable of type string. I concat it to a lot of text and i am worried that it might be larger than 255 characters. Is their a way for me to set this string varaiable to have more than 255 characters? Should i declare it as type memo cause that doesnt seem to work Any...

I have this code that opens up another form. I also want it to automatically click a button on that form when its open. DoCmd.OpenForm "Annual Load Follow", , , X ---- DoCmd.Automatically.click.button221 ---- I know thats not going to work but you get the idea Any ideas on how i would do...

Hello, I have a simple question yet I can't get it to work. I have a String with about 50 characters. How would I go about removing the 1st 13 digits ? Thanks in advance for any input.

Just a quick question. I have a subform with a boatload of records. Can someone give me the code to copy the text in a particular field from every single record. So that i can go into a blank version of that same subform and paste it. This would result in the new subform creating a whole...

Let me start of with what we did. We made a form with 2 primary keys: 1. Ticket Number 2. Version Number When the user clicks the duplicate record button on the form, the Ticket Number stays the same but the Version Number" primary key increments by 1 (which is what we want). The Version...

I have a button with the following code If Len(Me.Text25 & "") <> 0 Then Me.list1.RowSource = "SELECT * FROM [Annual Load Follow] WHERE [Annual Load Follow]![Counterparty] = '" & Me.Text25 & "'" Me.list1.Requery End If If...