Search results for query: *

This is a sample of some required fields I am validating to see if null - if condition is null then I want the user to see a message box "All Required fields must be entered" and disable the AddNew button else Enable the AddNew button. Is there a way to check the text boxes to see if any one is...

I have a After_Update event on 12 fields (one for each month as follows). The users will add number values into the fields. Is there way to set the after update to prompt the user that they cannot add to the value in this field if it is a previous month??? If Me.Txtinv10 >= Me.Txtinv10 and...

I have set up Users in my MsAccess Security and PIN but where and how do I set up their passwords. I am the admin.

Is there a way to stop a user from adding to values in fields that are months - not allowing them to add but can subtract from values in previous months but can add and subtract to current and forward months. I would think this would be a field lock and key press possibly? Months are in a...

I have can grow set on fields but the field wraps but the detail row does not grow. Is there a way to set the detail row to grow when a field wraps??

I need to get a page break after detail - This is my first group (Market_hdr) - I placed this code in the New Page Before and it is breaking on every page. How do I get to break only after detail? RecordNumber > 1 and {@Market_Hdr} <> Previous ({@Market_Hdr})

I need to combine these two procedures and not sure how. User will Validate amounts but also need to have "rights" to approve which the criteria is in the Sub Can Approve. Where and how do I use the CanApprove in the Validate sub??? Sub Validate() If Val(Me.Projected & "") +...

How do I get the month and year of wdate to show as the month spelled out - If 6 then June and a two digit year '06? CStr(DatePart("m", {table.wdate}, 0) & CStr({table.wdate}, "yy"))

I have column Rpt_ID that is numberic - when I add numeric values by adding new rows - the column does not resort to show numberic order. There is not a primary key and I cannot add one to the table. Is there a way to fix??

I added rows to a table - The column with the numbers did not resort. I am working in Enterprise Manager. Is there a reason for this and how do I fix?

I am using a standard connection like this for DSNless connection is SQL Server. I am still always prompted for Username and password. When I look at the table and connection string - it does reference ODBC; driver....etc. I believe if I took ODBC off of the string I received a diferent type...

I am maintaining a secured database that has security. I need to change the usernames in the mdw table but can't. How can I change/delete or add usernames and passwords once they have been created. Also, there was a username created for Engine and Creator. Do I have to keep those??

As you can see below I am checking various fields to display values on a report. Is this the best way and what am I leaving out?? Do I need to place every instance of Yes or No if all three fields are not Yes??? If {@DefltChk_Display}="Yes" and{@DateChk_Display}="No"...

How can I check each formula for null else Excpchk will be "Yes" Whileprintingrecords; stringvar Excpchk; if{@SubBorrwrDateFetch} {@subMasterDateFetch} {@SubUnitDateFetch} then Excpchk := "Yes" else Excpchk := Excpchk

I am check for Past Due and Expired in teh @status field but what do I add for a check if there is not Past Due or Expired and @status is null. I am using Crystal 10 and @status is a date field... Thanks If{@Status} = 'Past Due' then {table.DOC2DDATE} else if {@Status} = 'Expired' then...

I have a subreport in a group footer and a shared variable from that subreport that I need to use on the detail section. The problem is that it is pulling the information but there is a "lag". I cannot move the subreport above the detail line because the information from the subreport is...

I need this formula to show A or B or A,b if both conditions are met. I am not doing something right. Can someone help - thanks. If {@DChk_Display}='Yes' then 'A' if {@DateChk_Display}= 'Yes' then 'B' else if ({@DateChk_Display}) and ({@DefltChk_Display}) = 'Yes' then 'A'+","+'B'

I have a subreport that I am linking to a main report that ssems to adding a prompt when I link the subreport to the main report. When I create the subreport links - it seems to be placing ? which is a prompt??? How can I change this or prevent????

I have a subreport that has a date field on a main report - I need to use that field in a formula on the main report but I do not see it listed with the other fields so is there a way to do this???

I need to sort a description field based on another field that is numeric that identifies the description. id (is numeric) and description would be the two fields. The description is text. I am using Crystal 10.