Search results

The text box displays an id value when the results are shown. I am trying to get it to show a lookup value. Please see attached screen shot. Issue is SIC 1 field is a combo box in the Entry Data Section. In the results when bound to SIC1 it just displays the ID, where I would like for it...

I have a search form that has a text box that needs to be bound to [SIC1] but show a lookup value. Anyone know how to do this with out making it a combo box? I tried setting the control source to DLookup, but it appears as though the text box doesnt know what value to bind to the box and gives...

Fear I maybe confusing the situation. I attached a screenshot of the form. In the Entry Data portion. The SIC1 field is a combo box that gets its values from table [CodesSic]. When selected and "ran" the Results section displays the right records, but the SIC1 field displays the ID or hidden...

Maybe a better way to ask is I need to bind a text box to [SIC1] and show a lookup value of =DLookup("Code", "CodesSIC", "[ID]") All numeric.

Hello Gina......Thank you for the reply and review. I think the issue I am having is the field that displays a look up value (That i am assigning DLOOKUP too) is not specific to the form. It is based on search results. So when I write it as Me![SIC1] it just shows up blank. Ill try all...

Struggling here. Have a table (Customers) which has lookup fields for codes. This is expanded to a query (customers extended). The query displays the lookup value just fine. I have a form which is split and is used to search for customers based on a number of things including the codes. Unless...

Report Code '-----------------------------Create SQL String--------------- Dim FindLast As String, Findthis As String Findthis = ",'" & Forms![FmComparable]![txtBeginMonth] & "_" & Forms![FmComparable]![txtYear] & " ' " For counter = 2 To Forms![FmComparable]![txtEndMonth] Findthis = Findthis...

Form Code Dim txtYear As String Dim txtBeginMonth As String Dim txtEndMonth As String Dim PrinName As String If Nz(Me.cboPrincipal, "") <> "" Then PrinName = "([PrinName] = """ & Me.cboPrincipal & """)" End If If Nz(Me.txtBeginMonth, "") <> "" Then txtBeginMonth =...

Struggling with omitting entire rows when no orders exist for customers. I have a crosstab that pulls & groups suppliers orders per customer based on months. I then pull that info to a report which provides a comparision of sales in specified year verses prior year and next year when...

Geezzzzzzzzzz believe my brain is null. Thank you for that. Also thank you for the second one. I actually found that I was Summing Employee which killed the code.......GOT THAT FIXED AND YEA it works@@@@!!!!!!!!! WHOO HOO!!!!!!!!!!!! drinking heavy tonight@@!!!!!!!!!!!!!!! Not sure if I can do...

Can someone please help review this code. I have been working on this for months now and at a loss. Have a multi list box/combo box form that should open a form on preview command. I have run into multiple issues which I had in other topics. After reviewing help files and chnaging code, form and...

Link was exactly what I needed. Thanks!

Hello Jdraw Its giving Run-time error 3071 The code is for the orginal thread, where I am looking to know if it is possible to have a report that that generates based on a form where the form passes varibles to the report. Guidance is requested on if I am headed in the right direction in...

If anyone would be so kind to share if I am atleast headed in the right direction? Form Option Compare Database Option Explicit Enum SalesPeriod1Enum ByMonth = 1 ByQuarter = 2 ByYear = 3 End Enum Sub PrintReports(ReportView As AcView) ' This procedure used in...

I am struggling with marrying forms to reports based on my selections. It would be very nice if I could be pointed to a reference or helpfull info. I am limited in Access, but feel as though I can grasp conpects once I see them. I have the following Tables Employees Customers Principals...

That was some great stuff, thanks Hi-Tech. I am on to new issues now................

Thank you for the pointer. Hard at work, hence the delay. Turns out I was calling for Email address from a table that created the issue. All is well, with that issue atleast. Thanks

I am about to loose it...... For weeks on end I have worked on adapting parts of northwind to an old existing database. After spending months trying to import an excel spreadsheet, removing invoice, inventory and other worthless parts; I am now struggling to just enter a freaking order. This...

Thank you for any help in advance. I have adapted parts of Northwinds along with an old DB. I believe I have included Class Objects, Modules, and class modules in order to do so. My issue is: I have designed a Sales Report Dialog form much like Northwinds and adapted code for varrious...