Search:

Type: Posts; User: theYaniac; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: DMin function on an Access 2016 form to find lowest value in multiple controls

    thank you for the replies and I apologize for the delay in response. I have been tied up with work. I was able to get the function working as you described. I appreciate the help, thanks a...
  2. Re: DMin function on an Access 2016 form to find lowest value in multiple controls

    Should this be set as a private function for the text box or a public function for the entire database? With it set as a public function, I get a Name error in the text box
  3. Re: DMin function on an Access 2016 form to find lowest value in multiple controls

    I couldn't get the Function to work, I tried it a an OnEnter Event as well as an OnChange Event. As far as the database set goes, not sure if I have it set up incorrectly or not. I am unable to...
  4. DMin function on an Access 2016 form to find lowest value in multiple controls

    I am very new to Access and I am trying to figure out of I can use the DMin function to return the lowest value found in several text boxes at once. I am building a simple database for tracking...
  5. Re: formulas are in the cell but not functioning when the workbook is opened

    I found the issue. The auto calculate was turned off. I feel really stupid right now. Thanks anyway everyone.
  6. formulas are in the cell but not functioning when the workbook is opened

    I have a workbook for employee time sheets. There are approximately 20 separate sheets in the workbook with cells linked to a master crew sheet. All of the formulas that tie specific cells to the...
  7. using an excel formula in an access table

    I am very new to access and trying to build some calculated fields in an access table (MS Access 2016). I have the following formula in my excel table to calculate monthly rental for...
  8. Replies
    3
    Views
    343

    Password breaker

    Have any of you come across a password breaker that can unlock single sheets in a workbook? I have a large workbook from a previous project, several years ago that I have password protected. There...
  9. Replies
    2
    Views
    177

    AS400 information imported to excel

    I am looking for some help to find a way to import information from the AS400 system into an excel spreadsheet. For those not familiar with AS400 it is a very archaic program. All information taken...
  10. Replies
    3
    Views
    291

    Re: cell data entry formatting

    Thank you, I feel silly for not knowing this.
  11. Replies
    3
    Views
    291

    cell data entry formatting

    I am trying to format the cells in which I enter data. I receive invoice numbers from our department head, the invoice numbers vary in length. I need all entries to be 11 digits in length. If the...
  12. Replies
    2
    Views
    1,229

    Re: missing field in pivot table

    Refresh did not accomplish anything. I have created a new workbook and built all new charts and pivot tables and everything is working correctly. I am still curious if anyone has encountered an...
  13. Replies
    2
    Views
    1,229

    missing field in pivot table

    I have created a pivot table based on a data table. However, in the pivot table fields, one of my columns from the raw data table is not showing up as a selection. I have tried to search for it in...
  14. Replies
    6
    Views
    440

    Re: import information from excel to access

    I have my cost reports set up in excel for each facility at the moment. I would like to eventually have everything in access. For the columns i n the excel sheet that perform all of my calculation,...
  15. Replies
    6
    Views
    440

    Re: import information from excel to access

    positive, I copy and pasted values only on the excel sheet for a test run to link the two together
  16. Replies
    6
    Views
    440

    import information from excel to access

    I am trying to import cost report information from an excel sheet to an access table. I have the fields in the access table matched exactly to the excel sheet i am trying to import from. However,...
  17. Re: sum values in multiple columns based on one criteria

    the columns are going to grow daily. Will the sumproduct sum the values dynamically?
  18. sum values in multiple columns based on one criteria

    I am trying to sum values in multiple columns based on a single criteria. For example I have a summary table that is looking at 4 columns for straight time hours and 4 columns for overtime hours. I...
  19. Replies
    13
    Views
    307

    Re: user form dates

    It works perfectly now. Thank you for the assistance.
  20. Replies
    13
    Views
    307

    Re: user form dates

    Dave, I appreciate you helping with this. The date portion is working perfectly. However, the positioning is now off. I am currently trying to get the positioning back where I need it. When I...
  21. Replies
    13
    Views
    307

    Re: user form dates

    When I insert the function within the code it returns a compile error : Expected End Sub. It is not changing anything where it is now. The following is the entire code entry for the user form:
    ...
  22. Replies
    13
    Views
    307

    Re: user form dates

    Where would I insert the first portion of code you provided?

    Dim sDate As Date
    With Me.TextBox1
    If IsDate(.Text) Then
    sDate = DateAdd("yyyy", 1, .Text)
    End If
    ...
  23. Replies
    13
    Views
    307

    Re: user form dates

    'Begin Data Input to Database
    Sheets("Data").Range("Data_Start").Offset(TargetRow, 0).Value = TargetRow
    Sheets("Data").Range("Data_Start").Offset(TargetRow, 1).Value = Txt_FirstName 'first name...
  24. Replies
    13
    Views
    307

    Re: user form dates

    This attempt was unsuccessful
  25. Replies
    13
    Views
    307

    user form dates

    I would like for a date being taken from a user form to have one year added to the date. For example if you enter 1-9-18 in the text box on the form I would like the date that goes into the data...
Results 1 to 25 of 31
Page 1 of 2 1 2