Search results

Hi McSwifty I am really struggling with this one. I put together some code that I thought would work. Here is the original code which works without the checkbox and 'logged in' text field.Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If...

Thanks McSwifty, I will have a look into how to put this together. :)

Hi McSwifty, I have used this method to create a login form very similar http://www.databasedev.co.uk/login.html but do you know if there is a way to stop the same user logging in twice? I have had issue of passwords being shared meaning two users are accessing with the same user and password...

Hi, I have been struggling with this one to. Please can you share your solution? Many thanks

ok, I will work through it

Private Sub Command6_Click() Dim strSQL As String Dim strOrder As String Dim strWhere As String Dim strWhereOne As String Dim strWhereTwo As String Dim strWhereText As String Dim strWhereTextTwo As String Dim dbNm As Database Dim qryDef As QueryDef Dim strSQLChoice As String Set dbNm =...

Hi, yes I have tried that and it just highlights the line I posted but does not specifically note the issue. this is the full code:- Private Sub Command6_Click() Dim strSQL As String Dim strOrder As String Dim strWhere As String Dim strWhereOne As String Dim strWhereTwo As String Dim...

Hi I am also having a problem with the sql part of my code. I am not familiar with sql, so am struggling. I have a search form but when a user uses quotes, comma's etc, this line of the code shows a 3075 error qryDef.SQL = strSQL & " " & strWhereText & " " & strOrder Can anyone...

Thanks so much - your right. I was so fixated on the varCombined. When I checked some had moved a folder. thank you!

This is my full code:- Private Sub Command20_Click() Dim varFilePath Dim varFilename Dim varCombined varFilePath = "\\Southgate\learning$\Content Services\Bibs Services\Copyright \Database\Cover Sheets\CLA\" varFilename = Format(Now(), "dd-mmm-yyyy hh-nn") & " -- " & ID & " " & ISBN_ISSN &...

Hi I have a code that has been successfully working, until today. I have a form which I then export as a pdf to a specific folder. I cannot understand why it has suddenly started to throw up the "runtime error 2501 outputto action was cancelled". The line is stops at is DoCmd.OutputTo...

Thats great, works perfectly! Thanks so much for your help

I tried moving the code to the bottom but it did not like that. MyForm = DLookup("strEmpForm", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) DoCmd.OpenForm MyForm DoCmd.Close acForm, "frmLogon", acSaveNo I added the unload to the other forms as your suggestion as I think this...

Many thanks, that works a treat. Only thing is I thought this part of the code would close the login window when the other form/s open? But is doesnt. It stays open and the other form/s open behind it. I am not sure what else I need to add to allow this to happen. I have various codes to hide...

Hi I am really struggling here. I am having trouble with a line of this code and have search dozens of post and variations on this for an answer but can't seem to find a response which solves it. I used this guide to make the table and password form http://www.databasedev.co.uk/login.html...

Hi I am having trouble with a line of this code to. error 2471 with this part of the code If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then This is the full code I have used as noted earlier in this post. Private Sub...

timf79 Can you advise how to set the filter? I have a control button to email and pdf a record on the form - except it pdf's all the records. I just cant seem to get the filter right so that it just pdf the current record. Can you help? thanks

Dear Bob, thank you for your reply. I do have a subform (which is visible. not on a tab) and a combo box on my form. I also have a button which when clicked, opens a search form and is run by a query. My combo box runs from a query too as well as the subform. Can you advise how I do what you...

ok, thanks

Is this the padlocked laccdb file? When I double clicked it (front end) - it does not open, did not recognise the format? So I set to open i Notepad but it just displayed nonsence text. Should i be setting it to open something else? I now don't see the padlock icon, can't seem to change it back...