Search results

Hi, This is how I did it, I have a checkbox Sale Private Sub Form_Current() Me.sfrmBuy.Visible = Nz(Me.Sale, False) Me.sfrmSales.Visible = Not Nz(Me.Sale, False) Private Sub List210_Click() On Error GoTo List210_Err Me.sfrmBuy.Visible = Nz(Me.Sale, False)...

Thank you my Friend, Found some of it on the internet, actually all but this sums it up easier..

For one I am glad you thought me to look in the right place, tried everything else except Double which I must have overlooked . Your a genius..

Hi All, Would someone be able to help me to eliminate rounding decimals in my app. Although I am not the destructive type I am now ready to throw the PC out of the windows.. Would a Dim as Long statement round decimals when used? as all through my table and forms and reports I have consistently...

I know but you have helped too, so worth mentioning together with David and Bob, John, Missinglinq and Gemma.. Without whom I would still be staring at the wallpaper of my computer screen... And of course the others I have missed. :)

And you are great too.. !!:p

Thanks Dave, I have solved my one percent issue with a entry in the system table and Iif statements in the text boxes. As you are right about the back to back sales, I do not store price information with materials as this changes in every record. I do store the buy and sales price in a...

Thanks Dave, Somehow that makes sense to me, can I ask you the question about storing in the buy and sell in one table or two.. From my beginners point of view buy and sell separate seemed like a good idea... However I could be so wrong here.. Would you like to share any views on that.. By the...

Thanks Chris for your that Chris, This application was started without any input from my friend, It evolved from a form based application to a code based application to minimise the use of keyboard and mouse. As a beginner I have made many mistakes and others have helped me solving them. Also...

Dear All, Have this problem as is seen on the attached JPG. On the subform weights are displayed from the a table and a calculation. This is transferred into the table by a Material list, which pops up a form with choices. When one of the buttons is pressed the following code will run...

Due to time restriction I had to come up with something quick so I bought one of these keyboard wedges that can write to a file.. It was cheap but it works and reads the scale under a command button. I just installed this on Wednesday, yesterday was ST. Patrick's day, very big here in the...

Thanks Iman, they contain the actual transactions Table1 contains waste bought by weight, Table2 by item, however they can be sold by item or by weight.. Hope this explains..

Hi All, Before starting to mess up things, I would like to ask some advise, I have to store data in 2 different tables. Table one has the following structure; ID|MATID|FULLWEIGHT|EMPTYWEIGHT|BUYPRICE Table 2 has structure; ID|MATID|WEIGHT|HOWMANY|BUYPRICE The quer(y/ies) should should give...

Thanks for the reminder.. Saved my day.. Like my old teacher used to say years ago, only use quotes when you really have too..

Hi All, Probably very simple but I get above error when trying to run following code.. Could anyone shed some light please// Private Sub cbPrintStock_Click() Dim strView As String Dim StrDocname As String Dim StrWhere As String strDelim = """" StrDocname = "rptStock" If...

Thank you my Friend, and thanks to all for your suggestions I really got a good understanding of this part of working with queries now, I got it finally working. There was a underlying problem that I have not realised. In both tables I had a field named [Dirt]. After renaming the [Dirt] field in...

Hi All, Perhaps some one could give me some advise and help with the following; I read a scale with the following code On_Click behind a command button. Private Sub cbWeightTransfer_Click() On Error Resume Next TxTWeight_1.SetFocus Open "c:\w\rx_cmd.txt" For Append As #1 Print #1...

Problem is that no data is shown at all, or there is no sum based on the day selected or a total sum of the table is displayed, in other instances I can only see single records.. So not the day's total, I will go through the post again and try to recreate from scratch. This is really driving me...

Believe me friend,I tried everything, from new queries to just copying and pasting the text from your message.. I failed miserably, I have tried to change fields to expression, First of all I tried what you wrote and pay attention to the copying an pasting and in the end I only got a result that...

I have tried to solve that with a expression in the query, so there is no circular reference, but honestly.. the problem is that I don't know what I am doing and I might break many rules... I know I might have mistakes in typing over but even after copying and pasting it still wont work. The...