Search results

So, I've been doing doing reading on Append Queries and Nulls. I have the following SQL statement INSERT INTO tblTestResults ( EnrollmentID, TestType, Result, CompletedDate, BoldFace ) SELECT tblEnrollment.EnrollmentID, tblTests.TestsID, [Forms]![frmHome]![subfrmTesting]![txtResult] AS...

Are we just talking about: Set rs = CurrentDb.OpenRecordset("SELECT * from qryPermPartyExport WHERE Months <= 1") rs.MoveLast If rs.RecordCount > 0 Then

Could you help me place that in the code. I'm looking and to be honest I'm not sure what this is doing or where it's to be placed. Thanks!

All - I have a query that generates info that I'm using to create a powerpoint presentation (Automated that is). As you can see below I'm using some info in the query to determine how many people fit the criteria. I then check to see if anyone meets the requirements. If they do, a slide is...

You'll need to either call an update query and silence the warnings or you'll need to write the SQL in VBA. DoCmd.SetWarnings False DoCmd.OpenQuery "qryAddStudEnroll", acViewNormal, acEdit DoCmd.SetWarnings True I don't have a sample of the SQL VBA handy as I've...

No worries. A control is anything that manipulates data (text box, listbox, combo box, check box, radio button, etc.) Let me know if you need some more guidance. I'm sure myself or someone here can help.

All you need to do is create a query that contains all of the possible information you want to show. At that point in the criteria portion of the query, you can set it to look for selections made on your form. [Forms]![nameofyourform]![NameOfControl] Then whenever the query is run, it will...

I have a continuous subform that allows for scores to be entered for students. I want to disable all controls to change data for previous entries but leave the new record that a continuous form creates enabled for new entries. I also want to have a button to place on the right hand side to...

Any ideas?

Doah. var1 = Me.ComboBox.column(#)

Alrighty. Got it doing what I wanted with: Private Sub cmdOpenReport_Click() On Error GoTo cmdOpenReport_Click_Err Dim strSQLMember As String Dim strSQLClass As String Dim finalStrSQL As String '=================================================== 'Below we'll get the values for the members...

Paul - Could you shoot me a little more guidance on that. I'm looking and I think I'm just drawing a blank on how to implement. Thanks Air Force Dad!

All - For the life of me I can't get the Multiselect Listbox to correctly pass along all of the item selections to a Query which a form is based on. I've been up and down the forum, and I can't figure out what piece of code to use and how to use it successfully. I've been able to get a...

That was my thought as well. But it's only occurring for one out of 8 users. The back-end data is fine and it's openeing a acclb file when the FE is opened. Users on this network don't have write access to their c: drives which is where the FE resides but that's the case for everyone. Why...

All, I'm getting the following message in Access and it's causing all kinds of headaches for the user. Any ideas why it's appearing and how to get rid of it? Thanks,

You just need to add an expression that will add the three up. It would look something like: TotalCost: [TableField1Cost] + [TableField2Cost] + [TableField3Cost]

All - I have another update query that is basically looking at all of the Enrollment ID's that are associated with a ClassID. If each EnrollmendID has a Graduation date and the Graduated check = yes, then I want to place the current date in the Closed Date field for the Class. I can get a...

All - I have an update query built that checks to see if a date is entered for when a document is mailed as well as a date for when that document was received. I'm trying to setup this query to check and ensure that if multiple documents (Form8) were mailed that each one was marked as having a...

I was struggling with one too for some reason. Glad to help.

=DCount("[ISSI]","tblMain_data","Servicability = 3 AND txtType = 1")