Search results

You are awesome, it works! Thanks

I see what you are saying, except for the fact that the [idUser] field in reality is not a number, it is a PK text field. So in my Condition: strCondition = "[idUser] = " & strUser This can also be interpreted as: strCondition = "txtUser = " & strUser Make any sense?

I am attempting to use the following code to validate whether or not a user has logged into the database before. It pulls the users windows log in username and checks to see if it is in the tblUsers file. I haven't placed anything in the results of the condition because I haven't acheived a...

I am building a database that is used for tracking audit results. I currently have the following tables: tblAuditType >idAuditType - UID >txtAuditType - Description tblAuditCategory >idAuditCategory - UID >txtAuditCategory - Description >idAuditType - int(lookup tblAuditType)...

Thanks for getting back to me - I've actually also tried using the method you mentioned. I'm not sure if it isn't working because I am using Access 97? Let me know. Thanks again!

I currently have a if statement checking for values greater than 0 if(x>0) Then Statement Else EndIf Is there a way for me to set the property Bold to the text box in the case that x >0?

I think that makes sense, let me try and repeat it in my own words to see if I correctly interpreted what you said. So what I actually need to do is remove all rights to the admin account in my database so that the workgroup file is the only enabled security file that can access the data and...

I understand the portion about opening the workgroup file prior to opening the database, but if the user is able to get to the database without a custom shortcut, isnt there a potential of the database being opened with admin rights?

Ok, so everything sounds all fine and dandy now, but I'm still not 100% clear on workgroup security. I understand that I can create and join to a new workgroup file - but what if my user rights on my computer or any other users computer are not allowing that. My windows permissions do now...

Thanks for getting back to me on this issue. So that part of the workgroup security makes sense. Is there a way for me to require that the database be opened under a specific workgroup file that I have created? If the file is not present at its current state - the user logs in by default as...

I currently have a database set up that is run off of a shortcut linking to a specific workgroup file that I want my users on to create user level security. is there a way for me to check which file access is using to confirm that the correct workgroup file is being used? I would like to set...

Can someone post a copy of a sample mdw file so that I may observe the design of the database? I am very new to the concept of db security and would like to take a look at how the design is constructed. Thanks!

I currently have a form [frmE_PMSA] that has fields dtmDate, intHoursWorked, intHoursToGo, intWeeks, intHoursWeek. On my form I would like to set up another field that is bound to the table that will upon clicking it, retrieve the data from the previous record [intHoursWeek] and run a...

I am sorry, I'm a total newb to writing vb. How do I create a wherecondition in my open report function that will query based on my dates?

OK, So I've moved the [stDocName = ""] portion into a method, and now I'm getting the following error message: "Compile Error: Expected Function or Variable" and it yellow highlights my Private Sub btnPreview_Click line and grey highlights my Evaluate() text after the stDocName = Evaluate().

Error Message The expression On Click you entered as the even property setting produced the following error: Invalid Outside Procedure.

I am attempting to evaluate what my user has inputed in the fields availabe on my form [frmQuery]. The two available fields are [dtmBeg] and [dtmEnd]. Here is the code: Option Compare Database Option Explicit Public stDocName As String stDocName = "" Private Sub btnPreview_Click() On Error...

I have a tab control with buttons nested inside of it calling to open a form - but when I go to test the buttons, they do not open the form that the wizard selected. I get the error message: invalid outside procedure. If i copy the button into the main portion of the form outside of the tab...

Is there a way for me to change the tab color and the tab menu color on a tab control object? I was able to change the color for the back ground, but not the buttons or the bar that the buttons sit on. Any ideas would help! Thanks!

I was wondering if it is possible to load multiple forms into one subform? For example: I have form [SO2Menu] and form [Critical]. Can I have one subform in a main form that by the click of a button ill load either menu depending on the users selection?