Search results for query: *

Very similar to my issue - of which I'm struggling http://www.tek-tips.com/viewthread.cfm?qid=1233417&page=1

Sorry if this is a bit basic - my first VB / SQL app. SQL 2005 with: dbo.Employee EmployeeID (int,PK) LastName (nvarchar50) dbo.Purchase Orders PurchaseOrderID (int,PK) EmployeeID (FK, int) On Form1 I have a bound combo box: DataSource: EmployeesBindingSource DisplayMember: LastName...

I am running across this same concept / concern. Has anyway come up with a clever solution to date?

You bet snyperx - long hours of coding - sometimes the basics just slip me... But thanks all.

Sorry Gents - EXACTLY what I was looking for! Thank you both.

Hi Lars, thanks for yours. Unfortunately a combo box doesn't suit the purpose. The need to select mulitple choices exists. Additionally the large scrolling would still be evident. Hi fneily, thanks for yours. Unfortunately I need all choices always active. In fact as they are "used" we have...

Long days, long nights ... sorry gents - the problem is it wasn't a value of zero - it was a string of "0".

Hi Gents- THe problem here is - the data is in a subreport's detail of the main report's detail field. By using the above methods I either get a circular reference error - or it makes all listings either visible or not.

Thanks Snyper.. You know I tried this, but when I did I used "" instead of a space and received an error, and never stopped to think why. Sad.

Gents - I have a report which in the detail area at times has one field with a value that is occasionally zero. During such listings, I'd rather hide that zero value. All other times I'd like it to appear. Any thoughts?

I have a huge multiselect list box that has choices by a unique identifier in the form of #-###-#### ex. 3-411-2323 There are thousands of these records and it takes a fair bit of scrolling for the user to get to the records he needs. To that end - I was wondering if I could create a "move...

PHV you are the best, thanks. Works perfectly.

Gents - I have the specific problem as outlined here: http://www.tek-tips.com/viewthread.cfm?qid=1102402 I am able to filter a report based on a SQL building loop, however when too many records are indicated it fails with the Filter Is Too Long error. On the referenced archived thread the...

Gents I've looked at some of the archived threads but am having the following difficulty. I have a HUGE Excel file link. Query1 pulls the info and is the source for the report "LOT / LOB Breakdown". The report genereates without issue on the entire query. I have a form with 2 subforms. The...

Hi PHV - I'm not sure if part of your response was missed. It starts with "anyway ..." and refers to some brocketting I may have goofed. Any help would be appreciated.

Gents I am trying to use an unbound to filter a subform. It works rather well. I need, however to move from a single SQL condition (1 column on the multiselect) to a 2 column match on the multiselect. The difficulty lies in my ability to pull the proper condition from the multiselect and pull...

SDK Thank you much - you certainly have sorted the method. Much appreciated.

It is actually 1 Form (main) with a tab control One one page of the tab control then a form and subform I think it is this tab control throwing the wrench in the works...

Same result - no good. Additionally this will not pull that first "comp" value. I do appreciate your efforts.

Hi PHV - Actually, perhaps the problem is caused otherwise. There is a subform with a frmRoastComp in Datasheet view so it has multiple entries all child records from frmRoast. (They are the different coffees by origin in any given coffee roast.) I'm trying to ensure that there is at least...