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

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    You are absolutely correct. There are 5 records. It's a new development, but there are 5 in there!
  2. TheresAlwaysAWay

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    This solved my problem. Thank you so much!
  3. TheresAlwaysAWay

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    To complete the thought, the record that is on the screen of a form at that moment is stored in the CVReferrals table, but the value that I am inserting is simply taking what is on the screen in that form and inserting it to the table. That is very likely where the problem is and I'm gonna...
  4. TheresAlwaysAWay

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    Thanks. No I'm thinking about it, you're absolutely right. There's no reason to draw the record from a table. It's only the record that's on a specific form That may be the key gift and I will make that change. But just so you know, there are no records in the system yet. This is a new...
  5. TheresAlwaysAWay

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    None. It is a brand new table but I'm just creating for the first time
  6. TheresAlwaysAWay

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    I have what is to the eye a simple append query. I'm posting a picture of the query structure with the message, and a picture of the table content. The SQL for the query is:: INSERT INTO CVInsQuotes ( CVID, Company, Quote ) SELECT [Forms]![CommercialVehicles]![CVID] AS CVID, 'National...
  7. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Thank you for all of your help and your input. It's simple to do when you know how! You've given me exactly what I was looking for.
  8. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Andy, one other question. In your code you chose a fixed number, 15, to represent the Session ID. I was trying to replace that with a variable, "Nz(DMax('[Session]','[Sessions2]'),0)+1" and it fails. Can you spot why? The complete line I replaced it with is: CurrentDb.Execute "INSERT INTO...
  9. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Thanks, strong. It worked. I still can't get my original account reactivated, but at least password has been reset and it seems I'm good to go.
  10. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    The CurrentDB.Execute was the ticket. Did everything I wanted it to do. Thank you for all your help. I'm gonna try strong's suggestion to reset the password. I've received email links in the past to reset and they fail every time, with a message that "Something's gone wrong" and I've sent...
  11. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Andy, it works perfectly as a Debug.Print, but when I switch it to DB.Execute I get the following error. Error 424. Object Required. When I select Debug the whole Insert Into line is highlighted. Not sure what I'm doing wrong, but literally the only change I make is to change MyTable to...
  12. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Thanks for your help with login. So far I'm still logged in and able to answer. I've been locked out before and I don't want to test this until at least this thread is complete. You have helped me in the past and I know your coding is impeccable but I really want to save the results to table...
  13. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    One other thing. I created a simple table with six fields. ID, to keep Access PK happy; Session, to identify which session each of the rolls belongs to; Roll, which is a sequential number of 1-1000 to identify which roll each total represents; D1 and D2, obviously the face of each die...
  14. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    No, I need the sum of each roll, just like craps. Two dice are thrown, and each has a 1 in six chance of any given face showing, and then the two dice are summed to provide the total for each roll. The one requirement that I have is that I want to be able to save the results in a table so that...
  15. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    Thank you. I haven't had a chance to test this yet because I ran into an even more pressing problem. I tried to log into Tek-Tips from my phone and I was prompted to change my password. There were several false starts, and suddenly I get a message that the account is locked and I can't find...
  16. TheresAlwaysAWay

    Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?

    I'm fooling with a game program idea in Access that requires rolling of dice 1000x and summing the two of them, roughly equivalent to 1000 rolls on a craps table. I used the Rnd function successfully, but it doesn't run hands sequentially to store them in a table for future reference. I'm...
  17. TheresAlwaysAWay

    Can Access be used to generate and respond to text messages?

    Didn't see your last message until now. Great idea! Thanks.
  18. TheresAlwaysAWay

    Can Access be used to generate and respond to text messages?

    That does sound pretty cool but I really think that I need to do this from within Access. Access has to determine which customers get the message and control the entire pop-up operation of the messages and perhaps the drawing of pre-written messages from a table depending on circumstances. I...
  19. TheresAlwaysAWay

    Can Access be used to generate and respond to text messages?

    Thank you so much! There's a wealth of knowledge there, and I believe that it has provided me enough information to proceed. I don't have a green light from the owner of the company yet to implement this. I was investigating what was involved and whether it was even possible. Regardless of...
  20. TheresAlwaysAWay

    Can Access be used to generate and respond to text messages?

    We have a long-established A16, SQL Server 2016 DB for an insurance company with about 20 users. I've been asked to investigate whether Access has texting capabilities. It's an easy matter for me to create the list of clients to whom we would like to send a text message. I'm trying to find...

Part and Inventory Search

Back
Top