Search results

I thank you everyone for the help! :):):) It is working now. You guys are great!

Hello, good day! Reaching out again for help. I can't seem to make this expression work properly. What I need is if the value of the field is: <-2 "Emergency" -1 or 0 "Critical" 1 "High" 2 or 3 "Medium" >3 "Low" The expression I have is...

Thanks I got it working now! = )

Awwwtz it says I have invalid value on the criteria

I have come across another issue, I am trying to add another criteria to filter and now my code is ="[PMC]='" & [PMC] & "' And [cbstatus]='In Progress'". cbstatus is a field in the table of the other form I am trying to open. and the value I would like to filter is if it is In Progress. Not sure...

Thank you very much!, I missed that, I was following a code I saw that used the primary key which is a number. :D:D:D. Thank you, I appreciate it!

Hello everyone! Reaching out for help again, I have a datasheet form (image attached). I have made one of the fields displayed as hyperlink, I am trying to make the "hyperlink" show the "contents" filtered in a form view upon clicking on the "hyperlink". I tried the openform macro and on the...

What is the timestamp field for?

So is it advisable to avoid the yes/no data type? How to map the date time?

Hello, one of the database stores activity time stamps coming from the front end of several users, the other one stores records that needs to be worked on by several users using the front end. I am not sure yet what version of sql server we are going to use and will get back to you on that...

Hello, it's me again.... Reaching out for your guys valuable assistance... So I already have Access database front/back end set up, and we are looking to move the data to sql server. Will there be major changes on the front end that I created? Like the queries and VBA codes that I have on the...

Thank you everyone for helping me out on this, I was busy building the stuff for a while and got it figured out and it is up and running. I really appreciate it! :):):)

Thank you everyone for helping me out on this, I was busy building the stuff for a while and got it figured out and it is up and running. I really appreciate it! = )

Hahaha that is so much hate :D...I think what I need is just like a stopwatch just to show how much time passed, I'm thinking not really a timer on the form...

IT works now great! How do I make it look like it is counting every second?

Hello, thanks for all the insights, I'm trying stuff out, and the datediff() calculation does not seem to work. I have DateDiff(s, Me.Starttime, Now()) coded in the textbox triggered by form load. It is it calculating. What could be wrong? Thank you very much!

How do I close out the existing "open record"? If I understand, I would add a 'Closed' field on the table. How do I input something to make it not null, that it should still be inline with the record I saved? I only know how to add new records through vba but not to update an existing record's...

I think I'm getting this but, just don't know how to get the 'open' records how do I know that the records are open? and how to calculate the elapsed time?

Yes, I took note of the possibility that the timer might mess up what the user might be doing, but they are not really working on the DB, it just serves as tracker, they just all the users do are click on toggles and the logs will be saved, would the timer affect that? Is there a way I could...

I actually already have the back end, and all logs are saved there, however those are not real time anymore as those are activity logs that the users are already done with, the logs are only saved once the users clicked on another activity. I also need to show the "live" running time, like it is...