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 derfloh 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: *

  • Users: Ireland1978
  • Order by date
  1. Ireland1978

    Member already exists

    Thanks
  2. Ireland1978

    Member already exists

    Dim currentX As Single Dim currentY As Single Dim isDrawing As Boolean Private Sub pic1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) isDrawing = True currentX = X currentY = Y End Sub Private Sub pic1_MouseUp(Button As Integer, Shift As Integer, X As...
  3. Ireland1978

    Loop without Do

    Thanks for all your replies, I used Shakepeare's code....and I'm a she not a he!!!
  4. Ireland1978

    Loop without Do

    Thanks for that. I've made some changes, and my code now looks like this: Private Sub txtName_KeyPress(KeyAscii As Integer) Dim i As Integer i = 0 Do If KeyAscii >= 97 And KeyAscii <= 122 Then If i = 0 Then UCase (Chr$(KeyAscii))...
  5. Ireland1978

    Loop without Do

    Private Sub txtName_KeyPress(KeyAscii As Integer) Dim i As Integer i = 0 Do If KeyAscii >= "a" And KeyAscii <= "z" Then If i = 0 Then UCase (Chr$(KeyAscii)) End If i = i + 1 Else If KeyAscii = " " Then...
  6. Ireland1978

    Getting msg: 'Unrecognized database format'

    I'm trying to write a program in VB6 that connects to an MS Access 2003 database. I have entered the database name into the correct place in the properties bar on the right. Then as soon as I click on the RecordSource drop-down arrow a message box pops up saying: Unrecognized database format...
  7. Ireland1978

    Expected end of statement error

    Hi, Can anyone see the problem with this line of code, I'm a beginner at ASP so haven't a clue! var to_do = String(Request("to_do")); I'm getting this error message: Microsoft VBScript compilation error '800a0401' Expected end of statement /MyWeb/test.asp, line 9 var to_do =...
  8. Ireland1978

    Keys on keyboard mixed up

    Thanks for the suggestions, I changed the settings to UK and it worked.
  9. Ireland1978

    Keys on keyboard mixed up

    Hi, When I press 2+shift key, instead of printing inverted commas (") -which is printed on the actual key- it prints the @ symbol, and what should be the @ key prints the inverted commas. I think it's the way keyboards are laid out in the US or something? It's always been like this and is very...
  10. Ireland1978

    Creating formula in Access

    It does, but there's nothing in it yet as I want it to be generated. I planned on having a button to click once the current sale amount is entered, then the commission would be calculated (via a macro)
  11. Ireland1978

    Creating formula in Access

    Thanks again. When I run this query, a text box pops up and I have to enter a parameter for commission.
  12. Ireland1978

    Creating formula in Access

    Thanks for the replies posted above. I've tried the following: UPDATE Sales_Reps SET Commission = (SELECT EmployeeNumber, COUNT(*) AS ["Number of Customers"] FROM Customers GROUP BY EmployeeNumber) * 50; But I get the following message box: 'You have written a subquery that can return...
  13. Ireland1978

    Creating formula in Access

    I've searched through the forum and can't find anything that helps me. I'm trying to get a field in a Sales Rep form that would calculate commission earned by a sales rep, based on how many customers they have. I just want to use something basic like numOfCustomers * 50. Where do I actually put...
  14. Ireland1978

    Sorting array-can't see where I'm going wrong!

    Thanks for that. I put your code in, and got the following error messages: error C2106: '=' : left operand must be l-value error C2440: '=' : cannot convert from 'char *' to 'char [15]' So my complete code now looks like this: /* Write a program that stores lists of names (surname first)...
  15. Ireland1978

    Sorting array-can't see where I'm going wrong!

    I've only been doing C for a few weeks, and could really do with some help with this please. I'm attempting to write code that will take in first names, last names and ages, then prints them alphabetically to the screen, with the correct first names, last names and ages. I'm just trying to...
  16. Ireland1978

    Beginner: Counting Words & Alphabetic numbers

    Thanks for all your replies. PS. Webdrake, I'm a girl!
  17. Ireland1978

    Beginner: Counting Words & Alphabetic numbers

    Hi all, How would I go about writing code which would count the amount of alphabetic characters entered, and also the amount of words? I know it would involve some sort of loop. eg. Input: How now brown cow Output: Words = 4 Letters = 14 I would ideally like to be just pointed in the right...

Part and Inventory Search

Back
Top