Recent content by trevor2524

Yes there is. It shows up when I use the build function. Unfortunately. i cant post the database.

Doing that brought back the #name error

I have this i removed the criteria but I'm still getting the #error message =DCount("[Completion Time]"," [Testing]") Does it effect it if the Testing paramater is actually a query?

I did everything you suggested and the inside the textbox I'm getting an #error messge

I'm included the table becaue the form is not bound to that table its bound to another table. I changed the textbox code to the following: =DCount("[Testing]![Completion Time]"," [Testing]",TimeValue("2:30:00PM")<[Testing]![Completion Time]) and I'm getting a Name? error in the textbox

I tried that but unfortunately i'm getting an error. =DCount(" [Testing]![Completion Time]","[Testing]","[2:30:00 PM]") and would this count all records after 2:30?

Hello, I have a query running data that pulls all the Dates and Time for a particular day. The Field is called Completion Time and it is a Date/Time column. I want to on a Form display in a textbox the amount of records that are past 2:30 pm. What do i need to put in the textbox field in order...

That works. Thank you!

is that in conjunction with your orginal sql statement. if you can can you provide the entire sql statement.

Thanks for the respsonse. THe function is getting an error message of subscript out of range at this line of code: "while IsNumeric(Mid(ret(i), i, 1))"

The column has information that looks like this: Phones:25~testinginfo:3~Testinfo:7 testingof:9~Phones:38~Testinginfo:9 The results should look like this: Phones:25 Phones:38

Almost that is actually doing the opposite:. I have the following code placed: UPDATE [Testing Log] SET Appends=Replace([Appends],"Phones",""); Also the way the data shows up is the following: Phones:23 or Phones:25. I would need all that information to stay. So after the query runs all the...

Hello everybody. I have a query that has pulled information from a mseter table. On the query in one columns i have information that is scattered and mixed together. Does anybody know a query i can run against a column with the column header as "Appends" that will remove everything that doesn't...

Can you explain your second option more. That sounds doable this way if more tasks get entered i can just add to the table that is being submitted. How would you make it so that only the items not completed will show up for that day?

Thats correct. I'm going for the visual standpoint of when a user opens the form they see what needs to be done. not having to read a report because then things can get confusing for some users on what row they are reading. But if a button is visible then the user would know that that task still...