Search results

I tried what you requested, even changing the wild card to % and still same error...

My appologies, I usually am able to figure these things out after a little guidance but this one vexes me. Here is the string I put together that still populates the same error: If Not IsNull(Me.txtfilterProdYear) Then strWhere = strWhere & "([MstrProdYear] Like & Chr(34)*" &...

Ok, I tried adding the chr(34) to my code using the example in the link, but it doesnt work for me. I guess I am using the wrong syntax or something. Where in the original string would I replace with the chr(34)? Ken

I am a rookie with this stuff, can you provide a little detail on what the Char() means and how it would be implemented into this code? Thank you in advance.

Hi All - I am receiveing a runtime error 438 during the following part of my code: If Not IsNull(Me.txtfilterProdYear) Then strWhere = strWhere & "([MstrProdYear] Like ""*" & Me.txtfilterProdYear & "*"") AND " End If I think its because the data in MstrProdYear is a number...

Still doesnt include the end date... I mean, it makes sense because 'between' in my opinion means just that...between I dont know, I suppose it is just a minimal detail that can be lived with.

Ok, so if I enter begin date of 08/15/2012 and an end date of 08/17/2012, I should receive records from 08/15, 08/16, and 08/17, right. When I enter it here, I do not receive 08/17/2012, only the dates prior. I would like it to return the end date as well.

Awesome, that worked, I have one more question, is there something to change the code to include the end date in teh results. As it is right now, it only offers the dates in between the range but I would like it to include the end date too.

Thank you for the quick reply, but now that I have entered this code in the click event, I get the following error: Syntax error in date in query expresssion '[DateTimeStamp] BETWEEN #08/15/2012# AND #'. ??? Thanks, KJ

I have a form that has a subform which is based on a query, not linked to the main form. Here is the query: SELECT tblSalesDetail.SaleDetailID, tblSalesDetail.SalesPrice, tblSalesDetail.PostedVouchers, tblSalesDetail.DateTimeStamp FROM tblSalesDetail WHERE...

Excuse my ignorance, but how do I save a 2010 accdb to a 2003 mdb? I have never done this before.

Thank you both for the assistance thus far I added the requery statement as described and still I make a selection out of the combobox and the subform stays at the first record it pulled up. Hopefully it is something simple. KJ

Thanks Bob, I thought that it would be the case as well but it isnt working. Is there a chance that since the combo on the parent is unbound and gets its data from a query would make a difference? Also, what is the proper syntax to requery a subform from the on current event of the main form...

I have a parent form which has detailed product information, on this form I have a combobox which allows me to search for and goto a particular record, this works just fine. I have a subform which has purchase order transactions related to the particular product on it. Both the Master and...

Yeah I completely missed your implication there...I have been staring at this darn thing for a long time and my brain was melted. I appreciate the help! I will certainly be back again. KJ

Ding Ding Ding, it appearst hat I need to leave the login form open, and just hide it. It seems to now be working.

So, I put it on the Load event and I still get the same runtime error. Do I need to leave the login form open or does that matter? Reason I ask is I thought I read somewhere that when a form closes (unloads) it refreshes and therefore the login information would be unloaded if you will. Thus...

No it is called from the form I want access restricted to's oncurrent event. It follows the following flow: Login --> Main Menu (Access Restricted based on Security Level) code is in oncurrent event --> xyzform (certain views restricted based on same security determined at login) code is in...

So is the oncurrent event the appropriate place for the code then? I have tested it live and that is when the errors pop up?

Ok, so userid is set as my Auto Number field in the table. The funny thing is when I run through the process to test it, as soon as I click the command button that opens the form with the offending code on it I get this run time error: Run Time Error '2450': Microsoft Access cannot find...