Search results

Hi all! I have an Access Database that I am using to track the difference in product codes between two different external databases. I export the codes from both and import to their own table. I then run two queries, one to show what is missing from one and another to show what is missing...

Hello all! I have a filter on a subform based on a value from the main form. Code for this filter is: Private Sub Product_Type_AfterUpdate() Me.Central_Structure_Product_List.Requery Dim strType As String Dim strFilter As String If Not IsNull(Me.[Product Product Type]) Then strType = "='"...

Hi All, I am trying to add an additional filter criteria to the below. This is a selection drop-down to filter on [Product Product Type]. I want it to also filter the main form to show only those records where [ActionCmb] is null. I have gone round and round and just cannot get it to work...

I am using the below code to filter a subform based on the main form field of [Product Product Type]. The subform will filter based on the field [Product Type]. If I manually change the dropdown on the main form it will filter the subform. I do not want the user to have to do this as they...

:confused: Hello everyone! I have the below code on a subform. The search works fine IF the item is on the list. However, if the item is not on the list, it gives a 2185 error. WHY?! And how do I fix it? When I debug it highlights the Me.Searchbox.SelStart = Len(strSearch) line. TIA...

I am going nuts with this. No errors and it filters perfectly on the Product Group but it will not filter on Product Type. Help! :banghead: The goal is to filter a subform [Central Structure Product List] based on given values for Product Group and Product Type. I have another code on both...

This is mainly a formating question: I have the following wordy, messy code in a database. Code works great but I know there is a better way to write it. Can anyone offer some shortcuts for this code? Thanks! Private Sub Form_Close() Dim SQLA1 As String Dim SQLA2 As String Dim SQLA3 As...

I am trying to set up an alternative for the default Not In List Message. What I would like is for the item typed into the [Item Name] field of the Purchase Order Detail to be added to the [Inventory List] Form (in the [Item Name] field) and then for the [Inventory List] to be opened to that...

I am creating a database to centralize the supply orders for an animal hospital. Currently I am working on the order list itself. Employees will be able to add items to the order list (the Item Name field is controlled via a separate Items table). Once an item is put on a purchase order the...

I am setting up a supply ordering db. Employees will be able to enter items into the order list and then when the items are entered onto a purchase order (separate set of tables) the item is deleted off the order list (I figured this out already). I am trying to come up with a way to use a...

I had this working and then messed with it and for the life of me can't figure out what is wrong... Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec Me.FamilyID = [Form]![Family Directory]![FamilyID] End Sub Family Directory is a form but it is seeing it as a field. Can someone tell...

I have a db for our accounts receivables (clients that owe us money). The parent table holds the clients info (address, phone, etc.). One of the child tables [Contact Notes] holds all the contact info...relationship is set up as one-to-many. I am just getting started with VB and am creating a...

I have a db that holds all the pertinent info on revenue for a business. The revenue budget is the average daily income for the same month from last year...so this month's budget is the average revenue for May 2009. I have the following: 1. A table with each day's revenue 2. A table with the...

I am having some issues with a database...I realize that is kinda of dumb...if I didn't have any issues why would I be here?? :) Anyway, I am working on a database to track staff training. I have a list of skills (with a trainer level code for each) and a list of trainers (also with trainer...