Search results

Thank you for you patience! It has been so long since I worked with access and my "advisor" was my brother who passed away - so it has been hard getting back to this. I think all is here now. (hopefully I got it right this time)

Sorry - let me check

Tables are in the database not separated (for this upload)

Thank you - I will try to do this on Friday. I don't understand what table I might be missing. In my original post I showed the code that is working from the subform - my understanding is that I just need to do something similar on the main form on the mandatory check box. And I am sure that...

It is a huge database - I am not sure how I could remove all confidential data. There are many forms, tables, queries and reports and I could not be sure I could get everything removed. Could I trim down the database to only the 3 tables and the form I am talking about?

I am not exactly sure how to answer your question so here is a break down of the tables involved. The Training table has 6 fields, but the only two pertenant to this problem are Training Number (Text) Job Description (Text which is the title of the training Manditory field...

Thank you for your extensive reply. I have to digest this and refer to my tables to confirm the statement. I will do this in the next day or so and post back in the hopes of continued assistance in getting this to work

I have a form with a sub form that is used to enter information about job training. The main form is used to enter info into the training table that includes fields for the training number, type, description, expiration, if it is obsolete and if it is mandatory. The subform is linked to the...

OK - duh - I think I have it. I created a new text field and added the code and it appears to be working. Thank you for sticking with me on this!

Is shows a yes/no

Thanks - I am getting #Type!

I have a yes/no field on a report and it is working fine except I would like only the yeses to appear- not the nos. So if the record in the report is no, the space for the field is left blank. Thanks

YES!! Thank you - I knew it had to be simple but it has been so long since I worked on access. (and I am a graphic designer so therefore right brained and I have to switch to the left and it is not easy for me!) I really appreciate the help here on the forum. Thank you plog and everyone...

Thanks so much for helping! I am sorry that I am being confusing. I am doing a report on right now on one employee to show all of his completed training. The training either expires in a specific number of months (In the Expiration field represented by a number) or does not expire at all...

Any one else able to solve my problem? Please post if you can help. How do I show no record in a field on a report if what I described above is true?

Not sure I understand. Expiration is a field from a table and is not a calculated one, it is a number field that is entered through a user form. The field I created in the query for ExpDate is ExpDate: DateAdd("m",[Expiration],[DateCompleted]) which seems to give the same results as the...

Trying - I get the concept but when I tried to create a new field I get an error Circular reference by alias Expr1 in query's definition SELECT list".. I used the build function and entered this IIf([Expiration],=0,[ExpDate]) And when I entered IIf([Expiration],=0,"",[ExpDate]) I get the...

I have a report that displays training completed for an employee. Some of these classes have expiration dates and others do not. The query that this is based on has fields that are DateCompleted- the date the training was completed, Expiration - the number of months that the training is good...

I got it working!!!! I was not far off.

It has been a while since I worked in Access so I am definitely rusty!. I need to add a field to a query that takes a date field (CompletedDate) and adds the number of months listed in another field (Expiration). The original fields are in different tables but are combined within this query...