Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. calihiker

    Invalid Procedure Call Error??

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

    Invalid Procedure Call Error??

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

    Type Mismatch Error

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

    Importing Data from text file??

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

    Insert Into Query???

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

    Importing Data from text file??

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

    Need help to find ranges of unused keycodes :-)

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

    Need Help coding For Next Loops

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

    Need Help coding For Next Loops

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

    Need Help coding For Next Loops

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

    Need Help coding For Next Loops

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

    Importing data from Outlook messages into Access?

    Thanks Alot! I'll try it.
  13. calihiker

    Importing data from Outlook messages into Access?

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

    Outlook data to Access

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

    Need Help coding For Next Loops

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

    For Next Loop Problem

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

    For Next Loop Problem

    Cool, thanks!
  18. calihiker

    For Next Loop Problem

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

    Need Help with finding Ranges of missing keycodes

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

    Is there a way to pull ranges with a query?

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

Part and Inventory Search

Back
Top