Search results

I'm using Microsoft's AutoFillNewRecord function found here http://support.microsoft.com/kb/210236 that you may already be familiar with. The problem is that I get a type mismatch error when using it with sub forms. My main form is "Products" and I want it to use the function within a subform...

Hello all, Here's what I'm trying to do: If a value exists after input, display the message that it already exists in the "archived" version and then open the form of the archived table and display the record of the existing value. Here's the code I'm using: Private Sub...

Hello, I Have a simple database that combines three tables (Style, Fabric, Products) that are linked with referential integrity relationships. The issue is when I change, for example, a cost value in a Fabric field and it changes all the associated records in Products with that corresponding...

Hello All, I'm using the code below to verify if a Product Number has already been entered into the form. Private Sub ProductID_BeforeUpdate(Cancel As Integer) Dim varX As Variant varX = DLookup("[ProductID]", "tblProducts", "[ProductID] = '" & Forms!frmProducts.[ProductID] & "'") If Not...

Hi, I have a "products" main form that contains three subforms. The first subform displays "opening inventory" information and the second subform displays "transactions". The third and last subform displays a running total of additions and subtractions from records in the first two forms...

Hi, I'm getting a "Type Mismatch" error on the code below after adding the fields [ProductDescription] and [ProductColour] in the expression. All three fileds are of the text type. Dim strDocName As String Dim strWhere As String strDocName = "rptProducts" strWhere = "[ProductID]='" &...

Hi, I'm having trouble calculating query results using tables and their primary key fields. For example, the primary key fields of my linked tables are "ProductID", "Description", and "Colour". In my inventory calculating query, I want the sales amount of item "001" "Widget" "Black" to be...

Hello All, Below is the code that I use for searching an existing record in a form after entering the "ProductNo": Private Sub ProductNo_BeforeUpdate(Cancel As Integer) Dim varX As Variant varX = DLookup("[ProductNo]", "tbLProducts", "[ProductNo] = '" & Forms!frmProducts.[ProductNo] & "'")...

Within my "Products" form, I have a "Transactions" subform whose records are categorized in five different type of inventory transactions - let's say "A", "B", "C", "D", and "E". I'm using linked queries (instead of DSum) to calculate the net inventory amount (A+B+C-D-E) per product - sort of...

Hi, I'm using the function found here http://support.microsoft.com/?kbid=210236to to repeat the values from the previous record automatically. It works fine for one single form but I keep getting "type mismatch" when applying it to a subform within another subform within a main form. Any...

While debugging my Orders report, which retrieves its data from a typical Order/OrderDetails form, I notice that Access iterates 5 detail records within a main record when it really contains only three! Any ideas as to how I can remedy this? Thanks, in advance, for responding. Tony

I'm trying to assign the images defined in a subform's detail records to image placeholders (controls) that are in the main form's report footer section and NOT in the detail section. I am using a classic Orders / Order Details database. Ultimately, when I print a record form the main form...

From an Orders / Order Details db, I'm trying to display images in a report whose record details have one or more image links. In other words, I want to assign the image from OrderDetail1 to ImageFrame1, OrderDetail2 to ImageFrame2, OrderDetail3 to ImageFrame3, and so on. I'm using the code...

From a classic Orders / Order Details db, I'm trying to display images in a report whose record details have one or more image links. In other words, I want to assign the image from OrderDetail1 to ImageFrame1, OrderDetail2 to ImageFrame2, OrderDetail3 to ImageFrame3, and so on. I'm using the...

All, I’m trying to insert a maximum of three images in a report via a linked path defined in a control that resides in the Details section of the report. I have successfully done so with one image using the code below: Private Sub Report_Activate() ' After selecting an image for the product...

Hi, I'm using the code below to check new product# input from a form called frmProducts that is bound to a table called tblProducts. Private Sub Prod__BeforeUpdate(Cancel As Integer) Dim varX As Variant varX = (DLookup([Prod#], "tblProducts", Forms!frmProducts.[Prod#])) If Not...

Hello All, I'm trying to create an Append Query that automatically executes after the closing of a form. However, I just want to append today's records and not all the form's records every time it is closed. So, I thought about using a DATE function inside an Append query to compare all the...