Thank you for the help. I have since realized a design modification that would make this much more efficient and not require this query at all.
Thank you!!!!
Jesse Jones
Last Activity: Feb 13 '13, 06:18 AM
Joined: Jan 22 '11
Location: Los Angeles, California
-
Delete query with multiple tables and left join
Can someone please help me with this SQL? I am very ignorant, but am trying to learn! lol
I am trying to delete the records in tblMinsitries where this criteria is met. This works as a select query, but not as a delete query. Please help!
...Code:SELECT * FROM tblMinistries LEFT JOIN tblCallLog ON tblMinistries.tblMinistries_ministryID=tblCallLog.tblCallLog_ID WHERE (((tblCallLog.tblCallLog_dateStamp)<>tblMinistries.tblMinistries_lastAccessedDate
-
Thank you! It is now working as
This is working beautifully. I'm afraid I got a little too ahead of myself in asking this question before I was completely out of options. I'm sorry. Thank you for the...Code:DCount("tblAttendance_present","tblAttendance","tblAttendance_eID = " & [tblEmployees.tblEmployees_eID] & "AND tblAttendance_Type = 'SDY' AND tblAttendance_present = Yes")Leave a comment:
-
Expression to count number of times event occurrs
I am using the following expression in an access query. The goal is to count from tblAttedance how many times a particular employee (eid) is present (present = yes) for a particular type of event (SDY). Can someone please help? All I keep getting is #Error!!
...Code:DCount("tblAttendance_present","tblAttendance","tblAttendance_eID = " & [tblEmployees.tblEmployees_eID] & "AND tblAttendanceType -
Jesse Jones replied to Transferring the value of a form's text control to another form's text controlin AccessIs it possible to send two different controls through?
I would like txtDate on frmAttendanceDa ta to pass through to txtGroupDate on frmAttendanceEn ter
and cmbEvent on frmAttendanceDa ta to pass through to txtGroupEvent on frmAttendanceEn ter.
Is that possible?Leave a comment:
-
Jesse Jones replied to Transferring the value of a form's text control to another form's text controlin AccessThank you both so much. You have been very, very helpful. Everything is working great!Leave a comment:
-
Jesse Jones replied to Transferring the value of a form's text control to another form's text controlin AccessThank you for your help. I'm sorry I'm so ignorant. I must be missing something because that string doesn't work, and I'm honestly not sure how it could (because I don't understand it). Here is the total code that runs on click of the login command button on formLogin.
...Code:Private Sub cmmndLogIn_Click() 'Ensure an EID is entered If Me.txteid = "" Or IsNull(Me.txteid) Then MsgBox "You mustLeave a comment:
-
Jesse Jones replied to Transferring the value of a form's text control to another form's text controlin AccessThank you for the link. I'm sorry, but I am a complete programming newbie, really. Just a few months experience with any programming of any kind.
What I am trying to do is pass the value that is in the control "txtEID" on formLogin to a control "txtEIDGrab " on fromSwitchboard . formSwitchboard opens after the credentials are verified through a VBA sequence that runs on a command click on formLogin. If the credentials...Leave a comment:
-
Jesse Jones started a topic Transferring the value of a form's text control to another form's text controlin AccessTransferring the value of a form's text control to another form's text control
I have a login form that I am using to direct particular people to a customized switchboard. All of the login process is working perfectly. (I am not doing this for security but for simplicity, so there is no concern about the faults of VBA for security.)
What I need is to get an unbound text control on the formSwitchboard to lookup the EID that was entered on the login form. How can I do this?
Thank you in advance! -
Sorry. I found my own code I had posted on here from the last time I did this in response to someone else's problem.
Duh.
http://bytes.com/topic/access/answer...rname-password...Leave a comment:
-
Jesse Jones started a topic How do I get this unbound contol to lookup a password based on a parameter?in AccessHow do I get this unbound contol to lookup a password based on a parameter?
I have a form the records a process that we require to be authorized by a manager.
We want to check this authorization by a password. I was thinking a good way to do this is have a hidden, unbound text box lookup the proper password for the EID of the manager that entered their EID on the form. I was thinking have a VBA event that runs on exit from the control in which the manager enters their EID. Then, a simple if function that compares... -
Found it. Never mind. All imported. Thank you!Leave a comment:
-
Is there a simply way to find validation rule violations?
When I designed my database, it was the first I had ever built and my knowledge was practically none. I designed it for use by around 20 people and to hold approximately 20,000 records. Be it a blessing or a curse, the demand for the usage of this database has grown inconceivably quickly. I now have 100 users (around 50 at a time) and hold over .5 million records. This number grows by approximately 20,000 ever day.
In light of this,... -
Your answer was very helpful. Thank you.Leave a comment:
-
How to edit returns in my query?
I have a query that is returns results properly. It is pulling from one table and meeting certain criteria. The problem is that it won't let me edit the results on that query.
Can anyone please help me?! -
Yes. This makes sense on the main form. However, the subform requires every record be changed.Leave a comment:
-
Thanks, NeoPa. The only problem is that I did have all clients using "Edited Record" as the default. Also, the backend was the same. The database did use record-level locking. The problem is that it was still locking. Badly.
Unfortunately, they do need to be able to update data, so the snapshot recordset type won't work. Thank you for your tips. Do you have any further thoughts? How can I get the forms to not be pulling info...Leave a comment:
-
The actual database is 2007. We are using it through 2010. All front end users are operating 2010.
Okay. I didn't think that lock property was the problem, but it was worth asking. I'm at a total loss.Leave a comment:
-
Actually, I just had to type "350" in the returns box in the query setup group in the ribbon at the top. Duh. Just hadn't seen it.
Thanks for the tips!Leave a comment:
-
Would a control "Lock" property cause the table to lock up?
I have an access 2007 database. As many as fifty users may be using it as the same time. We are (as usual) having tons of locking problems. The database was designed to be used by 20, but the additional users are due to sudden, unexpected growth. I'm in the process of designing a SQL Server solution, but I need this to work in the meantime.
The form ALL USERS USE is a call form that populates from a query that pulls information from...
No activity results to display
Leave a comment: