Search results

  1. iamratman

    Getting current time into field with click of button.

    alriiiighty than. it works now. had to play with it a little. thanxs Brian900 and Vassago.
  2. iamratman

    Getting current time into field with click of button.

    Thanxs Brian, I could use some elaboration here. Command1 would be the name of my button? text1 would be the name of the time field I want to have time displayed?
  3. iamratman

    Getting current time into field with click of button.

    I have been playing with the sample DB alastair69 donated in the sample db section of the site. "The nice timer function". If you don’t start the timer right away you don’t have the correct time. I haven’t figured out how to add a reset type of button to display the most current time in the...
  4. iamratman

    Random Number generator for customer drawing.

    I think as long as I can demonstrate that the process is truly random then it shouldn’t matter how the display works. I will probably try to build something to demo before trying to sell it. It's easier to sell that way. But I do like your argument and will use it. That “medium you strike”...
  5. iamratman

    Random Number generator for customer drawing.

    Hey thanks John, I will have to attempt to build what you are talking about and try it out. I'll have to check on regulations for the visual real time display just being for show. That is a good question.
  6. iamratman

    Random Number generator for customer drawing.

    Hello Smart, thanxs for replying to both my posts. I appreciate the code you donated here, I dont have anything started on this project. I'm simply not sure where to start. Need a bit of hand holding on this.: eek: I searched high and low for a sample db I could learn from for this...
  7. iamratman

    data entry - Auto fill data for exisitng accounts in records

    Smart, thanks for responding and for the info. I am playing with the code you offered so far so good thanxs. I have two problems. 1. How do I get the following code to work with the last name field as well as the first? I have been messing with it for a week yet with no luck. Private...
  8. iamratman

    Nice Timer Function DB

    This is a cool little piece of work. If you dont use the timer right away you dont get correct time. Can a button be added to this so that it refreshes the current start time? If so how might I Accomplishthis? Again very cool thanx.
  9. iamratman

    Random Number generator for customer drawing.

    My company does daily, weekly, and monthly drawings using mountains of entry tickets and a barrel that has seen better days. So needless to say this system has to go. I hope to be able to do it digitally. I would like to do a random number generator to pick the winners based off of a ticket...
  10. iamratman

    data entry - Auto fill data for exisitng accounts in records

    First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot. So now I would like to add some more functionality to this existing project. My DB is for data input of customers...
  11. iamratman

    2 users adding records at the same time?

    ok so i guess it shouldnt be a problem for a couple of data entry stations to the one table. thanks Pat.
  12. iamratman

    2 users adding records at the same time?

    Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry. I am wondering if this would cause a problem for the auto numbering for the ID field.
  13. iamratman

    limiting number of times users can add the same account per day

    Howdy, MStef Ok I worked with that for the past few days and finaly got it going. Thank you very much for that demo db. I needed to have the account number stay the same withthe ID on auto number and invisible. So I changed it to this: (For any one interested). Private Sub...
  14. iamratman

    limiting number of times users can add the same account per day

    During a promotion we are running the customers are only allowed 3 entries into the system per day but the users are occasionally putting some customers in more than that. I could use some kind of function that limits the number of times the account number can be put in on a given date. (Or...
  15. iamratman

    limiting number of times users can add the same account per day

    During a promotion we are running the customers are only allowed 3 entries into the system per day but the users are occasionally putting some customers in more than that. I could use some kind of function that limits the number of times the account number can be put in on a given date. (Or...
  16. iamratman

    Entering data twice for verification

    I like that idea Juan.
  17. iamratman

    Entering data twice for verification

    very cool Thanks you John471, very cool. That works very well. This db is shaping up nicely thanks to all of you and I am learning quit a bit. I can continue to add functions I need if there are willing helpers. The next complaint I am getting is that our customers are only allowed to be...
  18. iamratman

    Entering data twice for verification

    Ahhhhh, very good. Now it works. Thank you Pat. Now all I need is: data from account field cannot match data in score 1 or score 2 I would love help with this if any one is up for it.
  19. iamratman

    Entering data twice for verification

    I apologize for my lack of knowledge here but... I don’t know where to find this: Form_Close () event. On the properties of the form itself there is: On Close event. Also on other functions properties there are ON exit functions. Am I in the ballpark here? Thanks
  20. iamratman

    Entering data twice for verification

    Hello Ian, thanks for the reply. When i run your code I am taken to the debugger with the following error: Compile error: Only comments may appear after End Sub, End Function, or End Property. I put your code on the score 2 on exit event, I asume this is where you meant for it to go.
Top Bottom