Recent content by rlan214

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...

yup that did it thanks a bunch :)

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

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

actually i as using [work request] its all good now

looks like i just figure it out i need to use text box my stupid a$$ :)

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...

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...

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

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...

Would DateDiff function work to compare current time and previous time?

sorry my fault

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...

was working on the vb code but im stuck in getting current time - previous time also I want adding to go infinite not just up to 3 does that mean that I have to use another loop ? and another question is that im planning to use this in a query does this mean that I save this as a function ?

will work on it tom def let you guys kno by tomorrow