Search results

After a bit of rework, I have a working model which addresses most of my earlier concerns. Using the idea of flags mentioned by billyr and lagbolt and with some modifications to the db linked earlier, I created some index tables which include unique records from the source tables. I have a...

Ok, I have figured out the last part, at least initially. I still need to add/modify the code for the optional variables. It might be better to make them required. The modified portion is highlighted. Sub TransferAllItems(strSourceControl As String, strTargetControl As String, Optional...

Oops, sorry. Both strForm and strControl are called in the function: Option Explicit Global vdr As Variant Public strControl As String Public strForm As String Function OpenMSelect(Optional strCtl As String) On Error Resume Next strForm = Screen.ActiveForm.Name strControl =...

I have a question related to my first follow-up question "fill the listbox on the main form with the items chosen on the subform frmMSelect. I'll need a way to pull any values on the parent form listbox into the list 2 on the sub." The original form uses a sub to move items from one list box...

That sounds interesting, but I don't think I'll be able to go this route with my project. The purpose of this whole thing is to allow the users to specify a query's criteria with as much flexibility as they need. In this case, there are 5 sets of criteria which benefit from allowing multiple...

Aha. I have resolved the first issue. I removed the code in the function related to the strsubform variable and removed it from the command button. Function OpenMSelect(strControl As String) On Error Resume Next DoCmd.OpenForm "frmMSelect", , , , , , strControl and...

Sorry if that bit is confusing. Form with a few list boxes, named "lstfares", "lstzone", etc. A button is assigned which calls the function with an argument. This argument is the control name, ie "lstfares". The form frmMSelect on Form_Open uses the argument to choose and create the...

Anyone? I have tried to modify this code with the openargs property of the target form, but I cannot make it work with the select statement, even with a test debug message. I have bypassed the module and put a direct command button with the argument listed and it doesn't open the form...

Ok, I have a current project to work through and I've hit a few rough spots. I am trying to create a list box which is called by a function and references the target control to populate the list boxes. I have used the example here to create the list box and it works fine. This is the code...

We have to separate the inventory count up into Lot and Part because some of the parts were mislabeled with a bad Lot#. What we want is a way to count parts using either method, depending on whether the Lot # is correct. In a bin, you might see an odd amount of parts loose, and a few bags...

This is what I have now. When I run it with a large range over dates, I get ODBC call failed. If I leave off the Between [enter flight_date] And [enter end flight_date] from the criteria, then it returns a divide by zero error. If I enter get a single date or a small range, it works, but...

Thank you. I will give that a shot.

Hi. I have searched the forums for an answer, but I may not be on the right track. What I have is a db linking to SQL. The query pulls information related to quantity usage of an item per day. I would like to add a daily total and usage percentage for each day in a range. User specifies...