Search results

Hi there, I have posted with this reply an updated version of the database without the hyperlinks. Just to clarify I wanted access restriction to work when navigating from frmsites to frmlog using the Create Query button located on the top right of frmsites. The bahaviour that I get is...

This does not work as expected. When you click on that label I agree it does bring up a message box stating you have been denied access to that area. But when you click ok to acknowledge that message it still continues to execute the command and open the desired form. The example I used was...

here is the DB, feel free to give pointers where there are mistakes elsewhere.

Hi Mr Crake, Its still not working. I have pasted the revised code below: Private Sub Form_Load() On Error GoTo Err_Form_Load '/Access restricted to admin users only If intAccessLevel <> 3 Then MsgBox "You do not have permission to access this area. If you believe you should...

Hi, I open frmlog from frmsites, when I click the button named frmlog if I am denied access the appropriate message box appears and states i am denied access. When I click ok the dialog box disappears and the frmlog still opens.

Hi There, Thank you DCrake for your assistance, it does work nicely. I have a little issue though. When it denies access to the user the form still opens thus allowing them access. I have pasted my interpretation of the code below, is there anything I have done wrong here? Private Sub...

Hi guys. I am using a great login solution that was made by DCrake. I have attached the database to this post for you to see. My problem is understanding how to implement access levels on each form. At the bottom of any given form I want it to show the name of the user and when the form...

I have to say I am not familiar with that method. Are u able to post an example?

Hi all, I need a solution to set a popup reminder when the database starts. My logic is that someone sets a reminder date in another form and when that date and time comes a popup reminds them. I have seen examples of where the reminder is placed in Microsoft Outlook but cannot seem to get it...

The form is single form but has a subform on it. The controls are correct but with your modification there is an error here: Me.sitesid.SetFocus

This code seems plagued with errors now and now I wondering if I am using the most efficient way to search for a record. Im getting an error now stating there is no field named sitesid in the current record. and it stops on this line: DoCmd.GoToControl ("sitesid")

Sorry Bro my bad it is: sitesid.SetFocus And the compile error is : Method or data member not found

Errors on txtSearch.SetFocus

Hi, I keep trying to run this search script below, but it keeps returning a compile error. are there any gurus out there that can figure it out. I have tried all weekend and cant see what it is: Private Sub cmdSearch_Click() Dim strsiteRef As String Dim strSearch As String...

Thank you for the reply. I really appreciate any advice you guys give me. Its tough trying to learn something new but im getting there slowly :) I wasnt clear when I asked if my structure was correct. What I meant is the top part of the code which I have pasted below. Is this the correct...

If my memory serves me well, this is a nested IF statement, is that right? Did I have the code correct for the way I want to look in the table for the "CLOSED" value though?

Okay I came up with this. But it doesnt work. Have I made an error in the code. Basic I want it to check for "CLOSED" in the field Log_status as well. Private Sub view_closed_queries_Click() Dim qrycounter As String Dim status As String status = ("[tbllog]![Log_status]") qrycounter =...

Hi all, Im a beginner and I have been trying to figure out this IF statement. I have the following: qry = [sometable field] status = [some table field] IF qry > 0 then "Do something" Else "Do something else" I want to incorporate something a little more complicated like so. I want to...

Thanks guys, I appreciate your help. I am a real beginner and trying to learn what I can. qrycounter is random as it reflects the amount of queries open on that site that is displayed.

Thanks guys I am learning and not been doing Access for long. So every little helps. I understand what you mean about the A=1 and B=2 thing. My qrycounter is random as it reflects the amount of queries open on that site. It is displayed via Dcount query on the frmsites page.