Search results

Hi I have a form with some textboxes and a subform. I use a text box to enter a number and when press enter I need to run some code and then return to the same textbox. Anything I try I am not able to do so. It is always put the cursor to another text box. I update the properties of all text...

Hi I got an Order Table and OrderDetails table. I have an Order form with a "BarCode" text box and a subform OrderDetails. I need some VBA code "AfterUpdate" for the BarCode text box to update the field CheckBox in the subform when the product's barcode is equal to the BarCode textbox. As you...

Hi, I'm building a new DB for my company. It will be handling inventory, Stock in and Stock out Is it better to have two tables for products that came In and out or just one with Quantity calculation? Thanks in advance

Hi I need to make a query to calculate a price. The formula is PoductPrice * Vat. But VAT is not the same for every product and there is some client that has a discount on VAT. Check the table below. Some clients belong to column A values and others at column B How to make the query to choose...

Hi I need to build a form with a subform to collect data and save them with a "save button" into two tables, else not (do not save the data if the "save button" won't pressed) Thanks Jiannis

Hi, I'm using a query to append data to a table for both invoices and credit notes in the same list. On this table, I need to have a document number field increased based on the document type. In this table, I have fields, DocType (values INV or CRN) and DocNumber For DocType Invoice, I need...

I am new to Access and VBA. I'm POSTing some data using the bellow code I receive an XML response. Sub POSTreq() Dim req As New MSXML2.XMLHTTP60 Dim reqURL As String Dim Db As Database Dim Rst As Recordset Dim Tbl As String Dim restxt As String Set Db...

Hi, I'm, I own two sapperate bussinesses running access DBs. One is handling orders (company A) and the other one is handling storage and distribution (company B) . I am looking for a way the two BDs interact each other. Let me explain. 1. Company A makes a bulk order for an amoumt of...

Hi. I need to use a combo box as criteria for a query. I manage to do that for one value but what if I need to check for multiple values? Excample. Criteria is a number 1, 2, 3, 6 and 12 When i need only one value for excample 1 is fine. What if I need two or three values as criteris (1 Or 2 Or...

hi! Is there a way to conect access database with a softphone? I have an IP PBX and a soft phone and i need to click on a form and auto dial the contact. My DB contains all the data I need and also PBX. PBX running asterisk software. Do i need a module or something like TAPI that call windows...

I need some help with Drag & Drop Feature. I am usin access to enter orders tha I receive by soft FAX wich is saving all faxes as .tif in a folder c:/fax_inc. I am working in two different monitors. One is displaying the fax image opened from its folder location, from which I am entering the...

Hi I am trying to send mail to some doctors that contains different data for each. I created the following module I collect the data I need from a query as recordsets but I am facing two difficulties. 1. I have to have outlook open in order get the module work. 2. The first recors in the mail...

Hi! I am new to access and my knowlege are limited and I am facing a probleme. I have an access DB for a small company. I have an order table and an order form. I receive my orders by FAX on my PC as an image and I want to link each image with each order on the table. I create a field in my...