Search results for query: *

I am getting a "Invalid Procedure Call" message when I run the query..That's it. Not sure what that means?? Don't know how else to explain it.

Here's the sql... What is wrong with this?? SELECT "CP" & [ID] AS [ID#], profile.Email, IIf(Mid([Email],Len([Email])- 2,1)=".",Right([Email],Len([Email])-(Len([Email])-2)),"") AS [COUNTRY PREFIX], profile.Country FROM profile WHERE (((profile.Email) Like...

Hi, I am getting a "type/mismatch" error on this line of code that is supposed o assign the select statement to the rowsource of my list box... Me.lstContactNames.RowSource = " SELECT [All Contacts].[First Name (Personal Name)], [All Contacts].[Last Name (Family Name)] FROM [All...

Here is a portion of what I did...even though a couple lines worked ok, the number of lines I pasted into the module created an error saying the procedure was too large... Can you describe the code involved in order to loop through the lines of code? Right now it is in excel... Thanks, Andre...

Hi, I have a text file that contains MySQL statements for creating a table and inserting values into it. I am trying to figure out how to use the statments in an access query for the easiest way to import all the data into a access table. Is there an easy way to change the syntax to be able to...

Hi, I have a text file that contains MySQL statements for creating a table and inserting values into it. I am trying to figure out what the easiest way to import all the data into a access table. Is there an easy way to change the syntax to be able to use this code in Access? Here is the code...

Ok, now I have a table that contains all the keycode combinations with an addtional field for a sequential numeric id field. The ID field increment by one and follows the order of the keycodes. What would be the next step to determine the size gap between two used keycodes? The problem I am...

Yes, but initially I wanted to make sure it was cycling through the way I wanted to -via viewing the values on the text box and then I was going to take care of the insert stuff. By the way, what a good way to stop code when it is cycling thought so many times? I tried Ctrl + Brk, but it still...

For some reason only this worked, after some trial and error ... DoCmd.RunSQL "INSERT INTO All_Keycodes ( AllKeys ) " & _ "SELECT [Forms]![KeycodeSequence2]![txtKeycodes].[Text] AS Keycode_Text " I guess the line "FROM ALL_Keycodes" messed it up...

I tried adding this code to append into a table that would hold all the values, but it appends "0 records" when run each time... Is there something wrong with this statement? DoCmd.RunSQL "INSERT INTO All_Keycodes ( AllKeys ) " & _ "SELECT...

Thanks! It works great! I wish I had thought of code as simple as that. Though I have to admit, I don't fully understand it yet...

Thanks Alot! I'll try it.

Is there any way to automated the importation of data from a Outlook message into a table in Access (or Excel)? Thanks

Is there any way to automated the importation of data in a Outlook message into a table in Access (or Excel)? Thanks

I need to display a 4 character keycode sequence in a textbox... each postion should start with 0 to 0 then A to Z. For example.. 0001 0002 0003 0004 0005 0006 0007 0008 0009 000A 000B | | 000Z 0010 0011 and so on... I created some code and it is cycling through ok until the third character get...

yep, I did try another way using the choose function and replacing with a letter, but it is longer.. Thanks

Cool, thanks!

HI, I would like to know how I can use a for loop with a variable that can cycle through all letters (a to z).. I tried some code, but it tells me that there is a type mismatch... Here's my code... Dim FirstDigit As Integer Dim SecondDigit As Integer Dim ThirdDigit As Integer Dim FourthDigit...

Hi, I have a table that has a keycode field which is 4 characters long and is alphanumeric. The keycodes in the table are the ones that are already used and I have to find out where there are large contiguous ranges of unused keycodes to be avaiable for use later. Keycodes look like this for...

Thanks for the response. I have already created both those queries and that has shown where the distribution is, but as you say, it shows no specific ranges.. I'm trying right now to assign values to each character in each position, but it is very tedious and slow going... Any other suggestion...