Search results for query: *

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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

I got sidetracked off of this thread once everything was working the way I wanted, but I really appreciate the additional thoughts that you offered. They make sense and definitely a better way to do things. Life is a learning experience, isn’t it? Thank you again for all of your assistance. I...

I wrote essentially this same post and it disappeared. Either I'm losing it or Tek-Tips is! If it suddenly reappears and posts and you see it twice please don't think I'm any crazier than I actually am! I have no idea what happened with the formatting issue. For some unknown reason it...

One more thing. I further modified the formatting to read +#,###;-#,###.##[Red];0;"Empty" since I didn't want the word zero, but instead the character 0 displayed. I also tested the text alignment and found something curious. If I set the alignment to Left then all the text including the...

Thank you both so much. This worked...but there's one small problem. The + numbers are text aligned left, while negative numbers are text aligned right. It doesn't matter what I set the alignment as. Is there some way to get the numbers to align normally to the right? BTW Duane, I modified...

Thank you both. Quick question. Is +265 from the custom formatting treated as a number or text?

Really, the subject is the whole question. I have text fields on a report (General Number format), and if possible I'd like to display a + before positive numbers. Any suggestion is appreciated.