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: hockeyman9474
  • Order by date
  1. hockeyman9474

    OnGotFocus Issue

    Lonnie, What about this? What if I had a column in my table called ID and I made ID=001, 002,.... Then when the record displays the first TB to get the focus was Last Name. When Last Name gets the focus which is immediately, I let Account Number=Last Name(from form)&ID(from table). That way...
  2. hockeyman9474

    OnGotFocus Issue

    You are 100% correct. Only when I create this in the expression builder it changes it to =[Account Number]=[Last Name]&[Account Number], and it doesn't concatenate it. In fact it just leaves there what is originally there. In this case it's the number already assigned to it 001, 002, so on and...
  3. hockeyman9474

    OnGotFocus Issue

    no error message just keep what was originally there, there. Which in this case for the first record was 001. By control source you mean..... I went to the properties of the textbox/event tab/ ongotfocus and created in expression builder. =[Last Name]&[Account Number] All textboxes were...
  4. hockeyman9474

    OnGotFocus Issue

    OK. I think I'm going crazy. I have been spending all day trying to figure this out, but all the whitepapers and all the books in the world aren't helping. Here is how my db is set up: I have a form with textboxes linked to those on a table. It is a client table. To have this table linked with...
  5. hockeyman9474

    if statement moving rows

    thanks john. let me throw this out there as well. each page number has certain account numbers associated with it as well. I need to seperate pages and row will be a header with the account numbers. I have a worksheet for each page with the account numbers in row 1 across the top. I will take...
  6. hockeyman9474

    if statement moving rows

    I pretty good with the basics of Excel. My boss has me doing something now, i'm not experienced doing. Here is what I need: I have a monthly .txt file. I import the information into excel. One column has a page number. I sort by that column. I have a worksheet for each page number. I need to...
  7. hockeyman9474

    writing code to output form to .xls

    dim as a string?
  8. hockeyman9474

    writing code to output form to .xls

    I don't want to set this up as a macro. I would like to write a line to prompt a user to save a form as .xls. Here is where I am: docmd.OutputTo(acOutputForm,New Contract,(*.xls)) it's looking for an (=) sign somwhere. Where am I wrong.
  9. hockeyman9474

    passing a time as a variable

    Actually I found this code on microsofts website but I am still having trouble having the user input a time. I think I nees to use TimeValue() and not inputbox(), correct? Function ElapsedTime(endTime As Date, startTime As Date) Dim strOutput As String Dim Interval As Date '...
  10. hockeyman9474

    passing a time as a variable

    so instead of inputbox() i use timevalue()? I also hardcoded for the length of time to equal the difference in hours. Should this still work with the possability of a time not on the hour? If txtStart = 12 Then txtLength = txtEnd & "Hours" ElseIf txtStart < txtEnd Then txtLength =...
  11. hockeyman9474

    passing a time as a variable

    I am attempting to pass time as a variable. The textbox on the form that the time will be passed into is set to short time. I use input box to get the time from the user like this starttime=inputbox("Enter Time"). Regardless of what is entered the time plugged into the forms' textbox looks like...
  12. hockeyman9474

    check box value

    I very rarely work with checkboxes what is the value considered. For example if a check box or radio button is selected i'm checking If chkbox.(value)=** then I thought it was enabled but I was wrong
  13. hockeyman9474

    can i have a file export one page at a time to different locations

    I get a .pdf document once a month about 55-60 pages in length on average. I need for each page to be saved in .pdf format in a different folder on the same network drive. Which folder it is saved to depends on which car dealership location it is. I can manually export one page at a time, but...
  14. hockeyman9474

    Public Dim Statement

    So the module should start like so: Public Sub btnNext2_Click() Public LASTNAME As String
  15. hockeyman9474

    Public Dim Statement

    Hey guys. It's been a while since I've done this. Can somebody please provide me with the correct coding to populate a variable that can be used on another form. I know that I have to dim it at the module level and make that module public, but I can't remember what the coding looks like. Thanks
  16. hockeyman9474

    Do Loop

    NM figured it out
  17. hockeyman9474

    Do Loop

    I would like to write a Do Until loop that asks an input box to ask a question until only a 1 or a 2 are entered? I think mycoding is wrong. Here is what I have do until number="1" or "2" NUMBER=inputbox("Please press 1 or 2") LOOP

Part and Inventory Search

Back
Top