Recent content by josie

Thanks all for replies... there are a few to sort thru. Another late night with the vba and I'll let you all know how I go. Again, cheers for the pointers - much appreciated :p

Hi Paul, I am familiar with you as you were kind enough to help solve a previous problem for me - thanks again :) What I am trying to do is set up a select statement that when you click a button runs a query to selects records from a stock table. This statement needs to have a 'where' clause...

thanks for the response orna.... shall give it a try and see how I go :)

I want to run an SQL select statement from a general module, activate on a button click event. This is my code; 'parameter query to display stock items based on selected distributor Public Sub DoSQL() Dim SQL As String SQL = "SELECT tblStock.DistributorNo FROM tblStock WHERE...

Hi there access gurus :) here's one for you that I am stuck on.... I have a invoice form with a 'Paid' checkbox. As soon as the checkbox is updated in the form I want this change to be reflected in the corresponding table so that I can then run a dlookup to see what the value of the form is...

thanks forum buddies! between the alternate iif statement and the move the report I pulled it together. The code needed to go on the on_activate event to work as I am setting filter criteria from another form. But the feedback pointed me in exactly the right direction. much appreciated josie :)

Um - can't seem to find the report on_format event. I've got on open, close, activate, deactive, no data, page & error. Am I going mad?? josie :confused:

Hmmm.... that doesn't seem to want to work. I get the logic, if me.paid is null then make it false else make it whatever me.paid is. But now I am back to the original error of "Expression that has no value" I put the code you suggested as a replacement to the varPaid = IsNull(Me!Paid) line -...

I am trying to capture the value of a checkbox on the current report. I am using the IsNull to try and get around a "Runtime error: 2427 You entered an expression that has no value" when I use the code; varPaid = Me!Paid I am assuming I get this error because sometimes the checkbox isn't...

Thanks to all for replies! Another problem sovled and another feature ticked off. What can I say.... u guys r great! josie :p

Okay, I think I get what you were saying with the quotes thing Paul. I have given it a bit of a run - will have to do some further testing. Thanks!! :D my many appreciatives josie :)

Hmm.... removed the in the DLookup - still same problem. I don't get it the message box for new stock level is returning the right value. Now all I want to do is put that new value in replace of the old value as stockOnHand in the stock table. Things should be so simple :~ josie

Okay, so now I'm confused... the dlookup isn't looking up the value of the serial no it is only using it for a comparison to lookup the current stock level. and nor the update - again it is only using it as a comparison. if I comment out the sql things work fine as far as I get the right results...

Can't see why I am getting a Error 3464: Data type mismatch in critical expression on the following code; Private Sub Quantity_AfterUpdate() Dim intStockCurrent As Integer Dim intStockSold As Integer Dim intStockNew As Integer intStockCurrent = Nz(DLookup("[StockOnHand]", "tblStock"...

Awesome! will pop that bit of code aside for a ron (latter on <grin>) for the moment coding frantically and going great guns now that I have dlookup working. gotta love this forum stuff - heaps more helpful than the uni one - just a bunch of students stumbling around in the dark. While I would...