Search results for query: *

thanks

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 choose tools, security, user and group accounts - I select the username and click Change Logon Password and tab to bypass Old Password and type the password in but I get an error that the old password is not correct.

Ok I can use locked but how - is there a way to lock if user trys to add to amount???

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.

Danvlas, If I use the table - how does access know who is logged in - would I use a query to filter current user??? Say an EVP logs in - how would the code know who they were??

Thanks for the help - am still working through

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...

My connection string is OK - I and I have check everything I do not understand why I am being prompted for Trusted and needing me to input username and password when it is in my string...

Thanks that fixed it...

There is a line drawn in the detail - I took it out and now everything looks fine. But if I want a line - between each row and the fields wrap - what do I do??? Can that be done??

And no to subreports

I am using 10 - row not expanding.

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??

Thanks for the good help. If I use SM and Dir etc that is integrated in the Security workgroup this code will check who is logged on, right????

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 & "") +...

thanks

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"))