Recent content by avacess

Bparkinson. I will try this idea, although i am not sure where to start. My vba knowledge is converging to zero. ;) George

Uncle, thanks for your time Yes they are listed in a table. In the same table i have a field yes/no for the checkbox. Pleare remember that the form is based on a query. I need calculated fields from the query to be shown on the form. Any idea? George.

query based form ....... i have a multiple item form based on a query. in this form, some tasks are listed. i need to be able to select several tasks and to add them into a table. these tasks are picked up, at the user decision, using a check box, located on the same row with each individual...

Taruz, your a star!!! thank you for your solution. this is what i was looking for.:) george

hi, from the beginning you must know that i am a beginner with access. i come with a very old issue, i saw a lot of threads, but nothing fits my case to solve the below problem: i built the following query: task id - perform at date 1002 - 06/23/2011 1002 - 06/11/2011 1002 - 06/14/2011 1004 -...

Thanks Sudo, you helped me with your last post.

Sudo, Thank you for your last post. Indeed you helped other users (me) with your post. I had the same problem with the Referential Integrity. I couldn't update a field from my table (which is a primary key field) into my target table since referential integrity was still valid. Deleting it, I...

i think i am getting closer. append query as Einstein was saying, i need to put the correct questions. :)

vila, in the end i tried to follow your advice. i created two tables. the tblTasks and the tblTasksHistory. the idea behind i would like to have is something as follows: 1. same tasks from tblTasks are in the tblTasksHistory. in the tblTasks are only the last updates of each task. in the...

VilaRestal, Thank you for your prompt reply. I will take in consideration your opinion. I was looking on the forums for something related to my issue, but unfortunately I couldn't find at anything relevant to such a 'construction'. do you propose anything where to start from? george

guys, i am trying to build a table to store all the history events for a task: like, when was carried out (date/time format), who carried it out, using how many resources, and so on. all these info are different types of formats: from date/time, number and text. i want to create a ContentTable...

jdraw, sure: Below I tried to explain how I defined all the fields, expressions, ... f1, f2, ... - field 1 ... e1, e2, ... - expresion 1 ... T1 – table 1 F1 – time format: short time F2 – time format: short time F3 – time format: short time F4 – time format: short time E2 –...

:( I am trying to use the Dmax function in a query to return the max value for a time field. The expression used is: E1: dmax(“totaltime”,”query1”) Totaltime is defined as a Dsum expression in the same query. Totaltime output are values are in the short time format (hh:mm). The result of...

Re: ... _Is it possible to have a Dsum in a query with the Domain in the same query? Spikepl, Thank you for your time. I created in a query (Q1) an expression (E1) using the Datediff function; in the same query (Q1) I am trying to create a running sum (E2) for E1, with domain in Q1, but...

Friends, I need to calculate the running sum of the time difference. I know how to do it for numbers, but for time fields i have no clue, sample table: ID Start time End time 1 10:15 11:05 2 11:45 12:05 3 12:45 13:00 4 2:50 3:00 5 23:05 2:05 Sample query: ID Start time End...