Search results

  1. B

    Want age in years with decimal I.E. 3.5 years

    Plog, fixed it it was my error I had Dim age As Integer I changed it to double and it worked thanks for your help.
  2. B

    Want age in years with decimal I.E. 3.5 years

    Thanks that helped with the negative number, but I still have problems with the numbers being whole not decimals. The only reason I was saving the age to the table was to run a report based on old computers. I agree age shouldn't be a stored value. Was just trying to get it to work before...
  3. B

    Want age in years with decimal I.E. 3.5 years

    Hello, I have searched all over and cannot figure out how to do this, I think it should be simple. I have a table that lists computers I want to know the age of them for replacement purposes. I am using this function to populate a textbox on a form that updates my table. the results I am...
  4. B

    run a function based on which form calls it

    Thank you for the response but, I'm having trouble using the me.name I get an erro that says invalid use of the me object. here is my code Public Function FuncNewTechEmail() Dim FrmName As String FrmName = Me.Name Debug.Print FrmName 'Set NewOld = 1 TmpID =...
  5. B

    run a function based on which form calls it

    Forgot to add i'm using Access 2010
  6. B

    run a function based on which form calls it

    Hello, I have a db that tracks issues at work. and I have created an email function is there a way that I can call it from 2 different forms and then add If Then statements to change parts based on which form calls it? I tried setting a variable called NewOld to say if it was a new issue or an...
  7. B

    email address list from Query

    Hello, I have created a database for Issues at work and when a new issue is created I want to email the correct people. I have it working for the creator the support person assigned, but I cannot get it to work for the technician(s) assigned as in my neewbie ignorance I used a multi-value combo...
  8. B

    tempvars to table

    I was tasked with writing a database for tracking issues at work. I used the web issues template as a starting point but since this database will be used by several people at once I split it. this caused the data macros to not work. I have recreated the forms and added a few but my problem is...
  9. B

    tempvars to table

    Hi all, I am trying to create (recreate actually) a comment field that will write to a separate table with some information from the main form in it. I have tried setting tempvars but not sure how to write them to table I am able to open the table and go to the line to create a new entry but...
  10. B

    Hello

    Hi all, My name is Brian and I am new to Access I have been tasked with writing a data base to record Trouble calls in our tech support department. I have some VB experience but a lot of this is new.
Back
Top Bottom