Search results

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...

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...

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...

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...

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...

Dear Friends, for days I try to work out a way to make a form that will allow for the input of a date(textbox with date picker), a amount of euro's in cash Textbox and then a query to calculate the result of that day from the table, then a textbox that will deduct the query result from amount of...

Hi All, Afraid I am going into uncharted territory here myself, I would like to ask for advise. In my application I need to read a serial port value into a TextBox called TxtWeight, I tried to use one of these programs on the internet but this gives me problems and only one out of every 20...

Busy trying to work out my second access program I really did not pay attention to this section. I was here for the help wasn't I? And boy I did get help, therefore it is my pleasure to write a little in this section as well. Years ago I made an Access application for the school where I was...

Hi All, Would like to ask for some advise, I have two subforms that I make visible when needed, now I would like to cycle a third form sfrmQryBuyUpdate. This form is depending on Me.DM False or True and should have priority over the two mentioned in the code.. If Me.Sale = True Then...

Hi All, Happy Valentine :) On my form I have 2 textboxes named as in the code, there is also a query that shows the current order. All is there except for the price, so I thought to input the price ID number in a unbound textbox and run the Update query below. I was wrong, when I click the...

Hi All, Trying to take the last ID on a SubForm and make it appear in a unbound textbox SubFormID.. This without typing it there.. :D e.g; on screenshot, the last ID on the SubForm is 134 and I would like to get that in the textbox. Any help appreciated..

Hello All, For over a week I have been reading this board and google etc, still have not been able to come up with a solution to my problem. I sincerely hope someone out here could give me a clue. In my subform I have a list of materials and weights, price etc. This is gathered from a form to a...

Hi Guys, Sorry to pop this question but I don't seem to be able to find the answer on-line. Lack of knowledge.. :( On my form I have a listbox125 that has a list of materials, it works well and contains different materials that are collected from table materials which contains material...

Hi Guys, Happy New Year to all, and a fresh question to go with the best wishes. On frmPayment I manage the purchase and sale of scrap, I choose records from a listbox [List210], most transactions are buying, sometimes there is a sale. A operator has to enter / override the [buyprice] or...

Hi Guys, I have a weighbridge application that is mostly operated from one form, several operators make dockets on this screen, now I want them to press a cmdButton to register their name in the record, this is the way I do it now; Private Sub cmdWBO_Monika_Click() Me.WBOperator = "Monika...

Hi Guys, Trying to requery my form and come back on the last created record, however I get a data type mismatch in criteria, run-time error 3464 Pretty new to this so I hope someone might help.. The code;

Hi Guys, the last action on my entry form is to select a Sales Rep from a listbox. Is there a way to fire query, or mayby quicker to run the SQL statement. Code for the listbox = Private Sub List203_Click() DoCmd.Save DoCmd.Requery End Sub The Save and Requery are done to update the form with...

Hi Guys, Nearly getting to the end of application with your help, I have a problem when writing the reports. I will try to explain my problem. I have a form that creates a Weighbridge Docket, this form is called Touchscreen. It store Data in a table called Docket. On this form I have a listbox...

Hi Guys, Just get this error "Method or Data member not found and I don't know how to deal with this, it happens at Me.Sale I think the trouble is that this Control is on a form Touchscreen and not on my FunctionPassword form. The On Click event should print a report as selected on the form...

Hi everyone, as part as an application I had to make a touch screen keyboard functionality, without using the On Screen Keyboard as included in Windows as my friend didn't have any typing experience and wanted A B C instead of qwerty. Someone on this board gave me the solution. It was so simple...