Search results

Sorry, I don't use that in any of my db's. Still, you can set a password for each user using this process to my knowledge.

Not sure how you things setup, but all users should have passwords. You should gave a username and password for each user. Example: If IsNull(Forms!frmpasswordadmin!Text0) Then 'No Blank passwords allowed MsgBox "You cannot enter a blank Password. Try again."...

Thank You, that did the trick.

I get this error?

Having a Gump moment again! I need to add the line of code that says SickDay to the first line of sql so that it ONLY adds the current record. 'UPDATE PAYROLL DATA DoCmd.Hourglass True DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE tblHour SET tblHour.WorkDate = Me.AbsenceDte " &...

Maybe try this and see if it will work for you. Dim recNum As Long recNum = Me.CurrentRecord Me.Requery DoCmd.GoToRecord acDataForm, "YourForm", acGoTo, recNum

Maybe this can help. 'Open Form With Picture Of Product. Dim strFormName As String Dim strCriteria As String If IsNull(Me.ProductID) Then 'No Product Entered Yet For Picture to be Displayed. MsgBox "You Must Enter a Product First Then Add a Picture" Exit Sub End...

Don't know how you have things setup but you could use a combobox to filter the form. Access saves the data automatically either when you move to a new record or close the form. As for the count, do a search on DCount HTH

Something like: TabCtl0.Pages.Item(0).SetFocus

Here is an Example: Dim strFormName As String Dim strCriteria As String If IsNull(Me.ProductID) Then 'No Product Entered Yet For Picture to be Displayed. MsgBox "You Must Enter a Product First Then Add a Picture" Exit Sub End If strFormName =...

You could try adding Top to your code. Example: Me.Notes.Top Untested .

Juts confused myself on the syntax is all.

Can't see the forest because of the trees again. What am I missing here? I get a syntax error on the , Me.NoAllowDate.DefaultValue = "#" & ("[txtday]", "tblCompany") & "#" Correct Code: Me.NoAllowDate.DefaultValue = "#" & DLookup("[txtday]", "tblCompany") & "#"

So, filter the Listbox by Category. Example: Using a Combobox to filter SELECT [egroup], [egroup] FROM qryEmailClientsByGroup UNION SELECT "*","<< ALL >>" FROM qryEmailClientsByGroup; HTH

Sounds like maybe the db is corrupt. Do you have backup copies? Remember, when you split a db and then copy it or move it, then you have to make sure that the location(s) are the same.

Try this link if you are a registered user. http://www.utteraccess.com/forum/Who-s-Logged-Who-s-Con-t1897146.html

I suspect that the back end it is not properly linked to the front end. Open the front end in design mode and use the Link Manager.

Right click the file itself and check to make sure it is enabled.

Generally that happens when you copy a file over and do not enable it,i.e. change the file properties.

In the words of the 3 stooges, I'm trying to think but nothing happens! :D