Search results for query: *

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...

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...

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...

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...

I appologize - I've tried to sort this myself but I just can't. I've tried the expression builder and the webpage on mvps.org. In any case. Form (frmMain) on which I have Tab Control (TabCtl0) on which I have Tab Roasts (Roasts) on which I have Form2 (frmRoasts) one which I have Form3...

This is less complicated then it appears - a question of if it can be done relatively easily. The form is basically ... Tab control with a Form On that From a subform Form is linked to table subform is linked to subtable RoastID is the common link to create the subdatasheet All works fine...

Hello all - Thanks for your assistance, my query building is a bit weak. I have: tblRoasts with fields comp1, comp2 comp3 tblInvTrans with fields TransDesc, ProductID My intent is to build a query that will provide the following information. Comp1 - 3 all equal a unique entry in tblInvTrans...

Ok gents - I've spent enough hours banging my head ... I have a main form (frmMain) and a subform (frmReports) from which the user can select different reports to fire from a combo box (cboRptPicker) that sits on the subform. When the button for generating the reports fires (also on the...

I am trying to distribute an Access Solution that uses the Microsoft Data grid control to a Windows 2003 server. I had believed that is was part of an MDAC package however I am unable to find the original source. I am aware that I can try and copy the components and register manually - but I...

Does anyone know of a single device that would serve the function of both an external (warehouse) line ringer as well as a paging device or an ICS system? Thanks

I'm trying to have a form close and openen another form to indicate there are no records yet in the table. I'm trying on the form's Form_Load : If IsNull(DSum("[Units Received]", "Inventory Transactions")) Then DoCmd.OpenForm ("frmNoInventory") DoCmd.Close End If ... however this returns...

I have the following query: SELECT [Inventory Transactions].TransactionDescription, Products.ProductName, [Inventory Transactions].UnitsReceived, [UnitsReceived]-[Qty] AS QtyAvail, qryCompOut.Qty FROM Products INNER JOIN (qryCompOut RIGHT JOIN [Inventory Transactions] ON qryCompOut.comp =...

I'll try my best to describe... I have a report based on a table (tblReportData) which always has 6 lines of entries. This report uses the last entry to produce fields in the report. Within the report, I have a subreport (~daylisting) that lists these 6 lines of data. The report produces...

Sorry all - I just can't remember I am trying to have the content on tabs start with their visibile setting to false but I can't remember the coding. I'm trying Forms!frmMenu.TabCtl0.Pages(2)!Label49.Visible = False however this fails. Would someone please kick start my memory. Thanks

Sorry for this one - just can't remember. I need to detect which of 3 tabls is current the active tab - Can someone kick start my memory please. For example - If Me.TabCtl0.Pages(1).setfocus = True But this doesn't work - as I knew it wouldn't Thanks.

I'm read many of the threads on Excel not closing - and just can't get it to sort my coding... Public Function dataExcel(Item As String, Topic As String) Dim oExcel As Excel.Application Dim objActiveWkb As Excel.Workbook Dim objActiveSht As String Set oExcel =...

OK - I know this is harder stuff but... I have 3 lines of code that work in Excel channelNumber = Application.DDEInitiate("CQGPC", Topic) returnList = Application.DDERequest(channelNumber, Item) Application.DDETerminate channelNumber but fails in Access It connects to a program "CQGPC"...

I can use a bit of help with the following: I am trying to pull the linked filename from: Dim dbs As Database, stPath As String Set dbs = CurrentDb() On Error Resume Next stPath = dbs.TableDefs(strTable).Connect If stPath = "" Then fGetLinkPath = vbNullString Else...