Recent content by Engr. Matthew

Please take a look at attached file and help me construct dlookup i can use to update the VBA code I place the procedure code on Code Exit event procedure. when a product barcode is scanned on the Code field the Items come out and the cursor sets on quantity for the use the enter quantity

the code did not allow cursor to move out from the field I scanned the product code. The code is on the exit event procedure field called code. It suppose to find the item after exiting the code field. I entered your syntax on the exit procedure and try to execute it by scanning a product into...

The table i am retrieving products record into is not among the tables relationships. It is a local table I use the Table in processing data before inserting the records to the normal table. I use the method in bringing Items into the purchase order Details and I use the same method in order...

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

It finally working fine. With the same code Thanks so much.

I attached this code Private Sub lstPatient_DblClick(Cancel As Integer) Forms(Me.OpenArgs)!txtPhone = Me.lstPatient.Column(4) End Sub this code generated error mismatch

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

You can do that but it takes lots of steps 1. create login that give users access to login to your database 2. from your Access project click file, and then click Current Database 3. Uncheck Display Navigation Panel, Allow Full Menu, Allow Default Shortcut menu 4. Go to Google search for...

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

I think you should handle the Login Form and your menu (Landing Page) first. It will be better after you login successfully, then you can determine how the user will navigate around your program the line of code below send me to menu form which is a child for to navigation. DoCmd.BrowseTo...

It does not return the records as usual. I am running it on a link Access query. it is a normal VBA code that build the string and put the result on a text box for use to see the information.

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