Search results for query: *

did that , I also tried an else command I think since I am doing it before change is the problem and since I never end up after the change with NEW Job I cannot accomplish it at that point but here is code that also doesn't work If me.jobname = "** New Job **" Then DoCmd. (whatever)...

seems like it should but doesn't work will not allow edit of ** New Job **

works great but need to be able to input data during inital start so does this work? If Not Is**New Job**(Me.JOBNAME) Then MsgBox "You have already entered a job name." DoCmd.CancelEvent Me.JOBNAME.Undo End If

Response to luceze is as follows: Project when created is **new job**, then the estimator names (enters the project name overwriting **new job**) the project which of course has a autonumber associated with it. What happens is during input they mistakenly type in the field which creates lots of...

I am using access as a custom estimating program and all projects are named. this is done by selecting the "new" button DoCmd.GoToRecord , , acNewRec Forms![JOBMASTER]![JOBNAME] = "** New Job **" DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70...

I am having a hard time explaining the problem so here goes: I have an [ITEMNO] which can be copied forward in the table and I use a [CONO] to mark the change and also I added a yes/no variable which can occur three times or in otherwords I have three possible yes/no, I can IIf it just fine but...

I am trying to write a query that works like this var1 = y/n var2 = y/n var3 = y/n ItemNo So what I want to do is this IIF(var2=-1,[ITEMNO] AND VAR1=-1,[ITEMNO] What I have is several Item no all the same with a diffrent change order number and 3 variables y/n to mark them, I cannot...

I have thought about it and what I need to do is this IIf([COITEMNO]=EXISTS (THIS IS WHERE I AM LOST),[COITEMNO],[ITEMNO] I don't know how to look at the CO table for a duplicate number so that I can have the report use the correct dollar amount to credit. I of course would IIF each of the...

I have a rather complicated question so I hope I can ask it correctly. I have written an estimating program for a construction company. Due to the large amount of pricing changes I have also added a change order form to the program so here is basic tables for original project or as I call it...

Thanks all I had to do was us an existing report and change the format of the date field to ww , worked great. Thanks for the quick response

I have a request from an employee to display a date as a numbered week of the year ie: 01/01/03 =1 01/02/03 = 5. I would be very appreciative if anyone has the code to do this. Many thanks in advance.

Thanks for the response my intent is to display the calender in a form and have it show all dates that projects are scheduled to be installed. This would be all records not a single date. Rather than have the date shown depressed which appears to be the default of the active x control, I would...

I am intrested in using the active x control that is provided in access "calendar control" to display all projects and dates of installation. I have a single table which includes "shipdate" "id" and would like to show the id# at the appropriate date. The table is...

Thanks for the Help, I have fixed the problem by a very simple fix, I was using the [ITEMNO] variable and it was unnecesssary by dumping that portion and only using the [CONumber] it works fine. Thanks again

I am trying to get this code to work If Forms![COJOBMASTER]![COTAKEOFF]![ITEMNO] <> DMax(&quot;[ITEMNO]&quot;, &quot;COTAKEOFF&quot;,&quot;[COJOBID] = &quot; & Forms![COJOBMASTER]![COTAKEOFF]![COJOBID]) And Forms![COJOBMASTER]![COTAKEOFF]![CONumber] <> DMax(&quot;[CONumber]&quot...