Search results

Sql -> Vba That is a good point and I did add it to the statement. strSQL = strSQL & strSelect & strFrom & strWhere & strOrder & ";" However, I still get the same error. Error #3131; Syntax error in FROM clause. Did you take a look at the alternate method that I'm trying? Thanks, PC

Sql -> Vba I'm thinking that there might be an alternative to putting the entire SQL into VBA by referencing the query directly. Can someone look at this code and let me know if this is possible. I get an error in the FROM clause; however, can someone tell me if this can be done...

I'm having trouble converting SQL to VBA. Can someone help? Original SQL SELECT tsubPermissionList.UserID, tblMainData.TrackingID, tblMainData.WorkOrder, tblMainData.ActionDescription, tblMainData.Facility, tblMainData.Status, tblMainData.ResponsibleParty, tblMainData.[WHS ID], tblMainData.[PM...

Thanks Paul, I still had to do a little testing. The reference is to the subform control on the main form and not directly to the subform. It now works. Correct: [Forms]![frmMainEntry]![fctlWOArchive].[Form]![TrackingID] Not Correct...

Thanks for the link. I've see that chart and the explanation from http://www.mdbmakers.com/forums/showthread.php?t=2650 All the charts from various forums describe referencing between main forms and subforms, but I'm looking for the way to reference from outside the main form and sub form to...

I'm trying to link a form to open when a field is double clicked on the main form. When the form is opened it should open to the current record that is present on the subform. In the opening form, I tried using a parameter query as the record source that references the current ID field on the...

I'm trying to develop a filter for a report based on the content of a textbox on the initiating form. The following code in in the report's Activate event and I can't get it to work. Can someone help me? Private Sub Report_Activate() Filter = Nz((([Facility] Like "*" &...

That did it!! Thank you izyrider. And thank you to the other guys who contributed their help. The solution is: Nz([Status], "") Not Like "Complete" PC

Thanks guys for your responses. I'm making progress. My filter combined several comboboxes and I use a Debug.Print to show how they're doing. Test 1: WHERE [ResponsibleParty] = "John Doe" And [Status] Not Like "Complete" Test 2: WHERE [ResponsibleParty] = "John Doe" And [Status] Not Like...

Thank you guys. That seems to be the answer. I used [Comments] Is Null Or [Comments] Like "" and got it to filter correctly. If its ok, I have another question on another part of my filter building. I'm filtering by [status] and have a problem. For status there are four possibilities...

It Really Null? I get a syntax error now. I changed using two of the double quotes in [Comments] Is Null Or Like "" to two of the single quotes [Comments] Is Null Or Like '' and I still get a syntax error. I tried [Comments] Like "" and the results are the same as [Comments] Is Null. Thanks, PC

In using a filter criteria "Is Null" or "Is Not Null" I read in the help for A2K that if the text or memo field has a space typed into it and no other text, that the filter critera states that the field "Is Not Null". I'm looking for a way to check for an empty text or memo field that has no...

I'm building a filter using comboboxes and I'm having trouble with two of them. One is to filter by records that are completed or by records that are not completed. The other combobox is to filter by records that have comments or by records that have no comments. Filter7 Row Source Type...

A have a prototype application that I'm incorporating into my Access 2K databases which needs a little VB help. This is a text reader and once it starts, I can't stop it until it finishes reading. For the user to start reading and decide that they've heard enough, I need a way to interupt the...

This link might get you a little closer to what you want. It's not exactly the same, but close. Good Luck, PC

This link might get you a little closer to what you want. It's not exactly the same, but close. Good Luck, PC

A little more progress, but I'm having trouble with the volume control and the speed rate. Also I can't get the write to file or read from file to work, probably because the original code is in a different version of visual basic. Any help on this is appreciated. See attachment. Thanks, PC

I've made some progress, but I still need help. I'm trying to make the voices change and I'm also trying to get to recognize my speech through a microphone. Can anyone help? See attachment. I'm using the documentation from...

I'm trying to apply some code that I've found on Text Reading and Speech Recongnition. I've attached the demo that I'm working on and I was hoping someone could help me get it to work. I think its in a different version of VB. The code is from: SAPI 5.1: Voice - Enabled Applications With VB...

If the query syntax is correct, then it might be the subform reference. I'm trying to reference a control ReviewID on a subform fsubReviewRequests through the subform control fctlReviewRequests that resides on the form frmMainEntry. strFilter2 = "[ReviewID] = " &...