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: vols77
  • Content: Threads
  • Order by date
  1. vols77

    database not working

    I have sent a database via e-mail and the end user is able to open the database but nothing works. It is as if the vba coding has become disabled. I do know that his computer does not have a printer and I have heard that if there is not a default printer that access may not work correctly. Is...
  2. vols77

    Recordcount

    What is wrong with the below? If RecordCount < 2 Then Me.Command44.Enabled = False Else DoCmd.GoToRecord , , acPrevious End If Basically I am wanting to disable the button if there are fewer than 1 record (to avoid the "debug" error if there are no records and someone clicks the button) I...
  3. vols77

    Open report with criteria

    Forgive me if this is the wrong forum but this does deal with reports so I thought I would give it a shot here. The below code opens the report fine, however, how would I incorporate text22 and text24, which are two fields that the user can use to enter a date range. Also, if possible, how...
  4. vols77

    Yes / No Msgbox

    I really could use some help. I need a yes/no msgbox to appear if the field "BOL" is either blank or they have entered then erased the value. Yes/no because if they go to the next record or exit the form, the record will not be savedf. It has been an extremely long time and I will admit my...
  5. vols77

    Saving records

    On the form, there is a button "add record" that when clicked, the new record automatically fills in the field "Job", what I am tring to do is to prevent the user from saving the record unless the field "BOL" is filled in. I have tried several things but can not seem to figure it out...
  6. vols77

    Open form to certian record

    Just to make sure I explain this I like to use a list - sorry if it seems "elementary" to some... 1) The form to enter / update data [form name = Jobs] is set up as a datasheet to best resemble Excel. 2) Switchboard has a button that says to Update / Add to existing job 3) I need a list box to...
  7. vols77

    Filling in blanks

    When a text file is downloaded, it groups items such as Part Desc Dept Qty The problem is that in the text file say part A is listed in 3 different depts then it looks like: Part Desc Dept Qty A El 1 1 2 4 9 6 Totals: 11 B...
  8. vols77

    Removing the last 2 characters from field in excel

    For some reason the text file that I get to use in excel has any negative numbers like 37801 - therefore, when I try to add in excel the number is simply skip which is causing all kinds of problems. Is there away in formula to tell excel to leave off the last 2 characters then multiply by -1...
  9. vols77

    counting records in a form

    in a form is ther away to have access number the detail lines . I.E. the records contain names so on the form if possible I would like to see 1 John 2 Bill 3 Jack and so on... the primary key in the table with the names is a autonumber but the sequence is not in order since I have...

Part and Inventory Search

Back
Top