Search results

  1. V

    First of the year date

    Thanks again. Now that I think about it it's kinda of stupid to show 01/01/2011, because your right, first of the year would always be 01/01/ something. Done bothering you and thanks again for your quick response.
  2. V

    First of the year date

    Wow this cool. I need to readmore! It shows Staurday. I been trying to make it show like 01/01/2011. I reading up on dateserial
  3. V

    First of the year date

    Thank you for the quick response. Okay So how would I get a controlbox on the same form to always show the first of the year without picking a year. I can do easy dates!! The query I'm working on works between the first of this current year and first of past years.
  4. V

    First of the year date

    I have a control box I want to populate with the first day of the year. You have to pick a year form a list and then I need it to show the first day of the year no matter what year is picked. Just can't figure it out. I'm hoping once I get shown how to get the first day I can use the little...
  5. V

    Merging two unlike tables

    Not sure what A,N,I,D,T columns are. The field names can be change in either table to match, (copies) and then I could just change them back. thx
  6. V

    Merging two unlike tables

    Not sure what your asking? I could have easily appended the data from table a to table aa if the field names match, but you can see that table a field names end up in one column called field names in table aa and the data is in the next column.
  7. V

    Merging two unlike tables

    The date was enter in a maintenance program line by line, not very quickly. I'm tyring to speed up the process. I'm stuck wit the program. Hope this helps.
  8. V

    Merging two unlike tables

    I am trying to get the data from table A into table AA. Not sure how this works. Tried queries, but no luck. Thanks for any ideas or help.
  9. V

    Round value

    Try this also ROUND((YourData)/5,2)*5 This gives you: 34.11 34.1 34.12 34.1 34.13 34.15 34.14 34.15 34.15 34.15 34.16 34.15 34.17 34.15 34.18 34.2 34.19 34.2
  10. V

    Round value

    mfuada Here is some coding that I used for rounding. Works quite well. Not sure who gave it to me though. See attachement
  11. V

    Automail from Access

    Lissa: This is the code I have been using for SMTP for awhile and it works great and is simple. Public Function SendEMail_CDO(strBody, strSubject) 'strFrom, strTo, strCC, strSubject, strBody, strAttachment Dim mail Dim config Dim fields Dim strTo As String strTo =...
  12. V

    Reworking data in a table

    Yes that is Correct. I am trying to merge all the records. Just not sure how. thx
  13. V

    Reworking data in a table

    The value "00050S" repeating in field 1 is not a primary key. There is none. I'm not sure what your getting at. thx
  14. V

    Reworking data in a table

    Hello: I was handed a table where the data is layout like this: Field 1 Field 2 Field 3 00050S 10-71434B 0.05 00050S 10-72855 0.003125 00050S 10-83105-6A 1 00050S 10-83126 1...
  15. V

    Removing last digit on different length numbers

    Thank you pbaldy. Left(FieldName, Len(FieldName) - 1) It worked and it was so simple. Still learning things and appreciate all the help
  16. V

    Removing last digit on different length numbers

    Hello: I have a need to strip off the last digit on a group of numbers: Example: 0871 --- Just remove the one 13463 --- Just remove the three and so forth. I have tried Mids,Lefts,Rights and some combination of those, but I cannot get it to work. thank you
  17. V

    Removing first two characters.

    Wow. so simple and it works. Thank you!
  18. V

    Removing first two characters.

    I have a sequence of numbers like 08123, 0912345, and 0712. The first two are the year and the next numbers is just a counter that adds one each time data is entered. I now need to seperate the years from the numbers, but the last digits can have two digits, three digits or more. I have...
  19. V

    Print out a report in Access through Excel

    I have a form in Excel with a command button on it. Is there a way to make it print out a report that is in Access. The reason I need to do this, the windows based scanners I have do not handle Access, most scanners don't so I thought since it can open an Excel spreadsheet, could I just put a...
  20. V

    Information not showing when database is linked

    Added "Me.cboCSFNumID.Requery" to form current event I have added that line to the link database and it temporary solved the problem. I do not have to requery anything else to make them show scrolling through the records. It's a pretty simple database. I just don't understand what is the...
Back
Top Bottom