Search results

Don't know what I am missing here? The where line is the issue! Dim SSql As String SSql = "UPDATE tblHour" _ & " SET tblHour.WorkDate =#" & Me.AbsenceHrsID " _ & " WHERE tblHour.EmployeeID= " & Me.EmployeeID CurrentDb.Execute SSql, dbFailOnError

Congrats. Good Luck with your project.

As you have already admitted, it is not best practices. The rule is enter once store once. You already have the data you need with the 2 tables. Either query it or create a Report for it.

Look on YouTube for videos, download some samples from this forum. Google is your friend, use it. Your asking for something not that complicated but yet you don't have basic access skills. Access has built in help as well. Do some homework and post back.

Take a look at this link. https://support.office.com/en-za/article/Create-a-form-that-contains-a-subform-a-one-to-many-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b?ui=en-US&rs=en-ZA&ad=ZA

If you have a table that stores that information, then just create a Listbox form for it. Example: tblUsers EmpID PK FullName Active Y/N LoggedOn Y/N LastSignOn Date/Time

The login form along with the forms code should be able to amply check for that. Read/Write/ etc... Susie is admin Jeff is user Bill is supervisor

The process is the same. That was an example: I have no idea of your setup.

So if I code the db to set the location as trusted will this enable it or would I still have to disable the bypass key? Or can the user themselves set the location as trusted and that will enable it?

Here is an Example: Of course modify to suit your needs. As to the extra field, simply add a field to the record source for the subform. If Me.lstlist.ItemsSelected.Count = 0 Then MsgBox "You must select at least 1 Item" Exit Sub End If Dim strEmail As String Dim varItem As Variant...

Congrats! Good Luck With Your Project.

Forms!frmLogIn.Visible = True Me.SomeTextbox ="" Of course be sure and set to your form name and textbox. HTH

Why would you close it if you need that data? When the same user is logged in?

When you say unbound, do you mean the form does not have a record source? Normally the data is verified via code and checked against a table. Since the form is unbound, when the db is opened again, their will no values in your textboxes. ?

My copy is in a trusted location and even if the user has the db in the same folder and the db is setup with a login form and a autoexec and the shift key disabled, then the db will open but since the login form for example opens modal and you can't click on enable so essentially the db is...

I was wondering if when you open a db that someone else has sent you, normally you have to enable it and I don't mean before opening it. So that if you had an autoexec or code that ran when the db opened you could not use it since the db was not enabled. Is their a way to allow someone to open...

You already have the data you need in the existing tables. As for getting your criteria, that is what queries are for and then build a report off that.

Thanks, not so good at SQL.

I'm missing something here but don't know what. The Data Types match and they are in order. I get a syntax error. strSQL = "INSERT INTO tblHour (Hours, WorkDate, SickDay, SickDte) VALUES (" _ Me.AbsenceHrsID & ",#" & Format(Me.AbsenceDteTo, "yyyy-mm-dd") & "#,True,#" _...

You did not install the needed components so Office wants to install them. Does it work if you let it do so?