Search results

I have a client they entered records on a Products Table. Every other necessary information has been entered only selling_Price is left out. Now, they asked me if it is possible to update the entire Products table’s selling_Price with the Value of Purchase_Price plus 30%. The Selling_Price =...

this is a Temp table I use in moving items from products table to Purchase Order Details table Here is the code I use to fine product record: Private Sub FindProductCode() On Error GoTo FindProductCodeError If IsNull(Code) Then Code.TabStop = False DoEvents Else Code.TabStop = True 'Use Domain...

I have a particular form that contains a unique number, let say card number I want to use as a search parameter on a form. I have Textbox for example txtCardno. and a command button to retrieve the patient information. On each form there is a command button that opens the same Form, which use...

I have a challenge I am trusting honorable members of this platform to point me in a right direction. I want to display price of a product scanned to display on a POS Computer attached VFD display LD220. The only information I got from the company that sold the device is that the communication...

Can some one help take a look at this code strQuery = "SELECT tblAppointments.AppID, tblAppointments.AppointDate, tblAppointments.AppointTime, Left([tblSchedule].[DoctorsName],5) AS Doctor, tblSchedule.DoctorsName" _ & " FROM tblSchedule INNER JOIN tblAppointments ON...

I am a developer running a small company in Nigeria west Africa. I have been working with Microsoft Access and SQL for some time now. I was looking for a particular solution on the net to see if anyone have had similar issue before and how the person solved the issue. regards, Engr. Matthew