Recent content by Niroth

  1. N

    Change width of Object Box to data value

    Hi, I have a form with start date and end date and I'm trying to create a visual for the duration, so I would like to add a box that will change the width according to the duration in each row. I have this, but it does not work, not sure why? Can you help me? Thank you. Private Sub...
  2. N

    Help Please - how to compare two records?

    Thanks. It's a really great way to do it. :D ETA: Just want to let you know that it works beautifully. Saved me a lot of time and head scratching. :D
  3. N

    Help Please - how to compare two records?

    Thanks both. I understand that it's not ideal, but I'm only dealing with the data for my research, it's not a long term database. After I make all those changes, how can I get the information I wanted? Can you elaborate on how I can build that query?
  4. N

    Help Please - how to compare two records?

    So I have a table: table1: company_name, year_month, company_rating, rating_change For each company, I would like to compare the rating from 201201 and 201202 (and keep going for each month) and if there's a change in the rating, update rating_change to the difference in rating values. The...
  5. N

    Suggestions on best way to merge data from two different tables?

    Can you elaborate on how I can do that? What's the code for the select query? Thanks.
  6. N

    Suggestions on best way to merge data from two different tables?

    Hi, So I have two tables, table1: (company_name, company_code, year_month, rating) table2: (company_name, company_code, year_month, asset, debt, equity,...) What I would like to do is to call up all the data in table1, and then call up (asset, debt, equity,...) from table2 where the...
  7. N

    Input as string, the use that to calculate or conver to long data type?

    Hi, I want to create touch screen buttons, which the user can use to input numbers, but I'm stuck at the "." for decimals, because I can't enter that as long data type directly So I thinking I can either change the string to long data type or use the text entered to calculate behind the scene...
  8. N

    delete an email in outlook from access

    Thanks. Will check out the asp page thingy. Have solved the delete email part right after I posted the question. For future reference to anyone else: dim item as outlook.items item.delete
  9. N

    delete an email in outlook from access

    Hello, I have code that extract attachements from emails in a dedicated folder in outlook from my access fe, after this action, I would like to delete the email, or failing that I would like to move it to a separate folder so that I don't get duplicates. Any pointers? BTW, sort of a generic...
  10. N

    ? simplifying code using quieries

    Question 1: Wouldn't it be better to create a relationship between this table and the table that contain those information, or create a subform that contains those information in this form, so you don't have to enter the information twice? Or if you are not entering the information but simply...
  11. N

    Update many records, each with a different criteria

    Hi, So I'm trying to update different records, each to different value, each using a different criteria, but I want to do it all in one code. I tried something like this from a hidden form base on the table to be updated: Set myrcdst = Me.Recordset With myrcdst Do Until .EOF...
  12. N

    Prevent data being entered in twice

    This is what I would do but I don't know if it's good practice or not: count the record in the table where you store the user and their assigned authority, using these criterias user=me.user (or userID) and authority = me.authority (or authorityID). with beforeupdate event if count>0 then...
  13. N

    Moving a single field from one table to another

    No. That was meant as different records with consecutive values. I haven't have time to implement the code yet, but from what I could see, it seems to be what I need - copy the value from one table, and create a new table with value from that field. I don't think it's crosstab.
  14. N

    Moving a single field from one table to another

    Thanks, I have thought of those problems, but in this case, it's simply more suitable. And I might have found the solution here for those who might be interested later on: http://www.tek-tips.com/viewthread.cfm?qid=1539067
Top Bottom