Search results

  1. R

    auto update formula and linking it to a cell

    Hi ! I would like to know is there anyways I can automatically update my formula by linking it... The scenario I have a worksheet that has calculation based on another file x I'm doing alot of test cases and I would like to somewhat be able keep on changing the file x's and still get my...
  2. R

    Show only the first 300 record

    Is there anyway to make a query that will only show the first 300 records from a record of 3000 ? So right now I only have 1 unique no which is the item no Help is trully appreciated
  3. R

    chart in a form using a query as the src file

    So I create an unbound object then use microsoft graph then was data already and i deleted it then i right click properties and chage the row source and put my query there but i just get a blank square can someone pls help
  4. R

    DCount or Count

    DCount or Count either one doesn't work with my form So I have this queries already that counts SELECT Count([Work Request].[Work Request #]) AS [Count of ALL WR] FROM [Work Request] ORDER BY Count([Work Request].[Work Request #]); when I try to copy this on my control source it doesn't do...
  5. R

    Creating An Archive

    Hi So I'm suppose to create a subload archive from an imported file(table) everyday. The imported files will include new subloads and subloads from the day before also, so it is possible to have a multiple similar subload This Archive is suppose to be unique subloads only Now my question is...
  6. R

    form button to import file

    So I have this text file that's pipe delimited I would like to know if I can make a button in my form to tell access to import a file in c:\Temp\data.txt using my import spec thanks
  7. R

    Showing query in a form and using filter

    so I have been working on this form for a while and I'm really a newb at this maybe it easy maybe its not but i just couldn't figure this out I'm so frustratated that I'm willing to pay(beer money for help) well anyways I have this form at the side you can see that there are 3 filters 1st has...
  8. R

    VBA help: Couting depending on the difference between rows

    let's say I have a column of time: 10:50 AM 10:53 AM 11:05 AM 11:06 AM 11:07 AM 11:11 AM what if I want to count 1 for rows 1 and 2 since they have less than 5 min in between and 2 for rows 3,4,5 and count 3 for row 6.... and it'll keep on counting as long as there's time I think I can do this...
  9. R

    Is this possible to do in a query ?

    let's say I have a column of time: 10:50 AM 10:53 AM 11:05 AM 11:06 AM 11:07 AM 11:11 AM what if I want to count 1 for rows 1 and 2 since they have less than 5 min in between and 2 for rows 3,4,5 and count 3 for row 6.... Is there a way I...
  10. R

    Forms q

    kind of a newb question but can I show in a form(in a box or something) a number from a querry that I created the sql ver of my query is like this SELECT Count(Inprocess.PartNumber) AS CountOfPartNumber FROM Inprocess GROUP BY Inprocess.Status HAVING (((Inprocess.Status)=8)); thanks
Back
Top Bottom