Search results

I am seeking advice on a database with currently over 40,000 records, which was pulled off the internet from NOAA for weather related records. The spreadsheet that they were using looks like this: GridNumber | Year | IntervalNumber | Index Value Each grid has history back to 1948 and each...

Please help with this error I downloaded this example and converted it to 2003. As is, stand alone form, this works great!!! Many thanks to the author and to U-82 for posting it. However, I have a Program Setup form that hosts several subforms - though use of a command button and source...

Solution for those looking... Problem : I needed to keep track of what has/has not been printed. I had a Printed field in my table and used an update query to make this work. The user however wanted the choice of which records to print - instead of being locked into a date mode, which I had...

I am having trouble wraping my head around this am am seeking help (I have done a search and have made select box print labels and get the general idea) But this is a different format. I have 3 tables running through a query supplying info for the report. The report is filtered using a date...

Error that I am getting OK...Update! I got this working with the following exception When FE first opens it asks to link BE. On 2nd open it does not open the open file window as long as the FE and BE are in the same directory. When I change the BE to a different directory it opens the open...

Credit goes to FoFa for posting this code on this form. Attached you will find code to relink tables. I manage I am doing to wrong, and need help in order for it to execute correctly. I would appreciate direction. What I am doing: Copying the modules over to my unsplit database. Creating a...

Fyi after spending all day searching and messing with code i know have the answer: This may not be "correct" in form but it works for me:) Private Sub NonMPCI_Exit(Cancel As Integer) If NonMPCI = True And [Forms]![PolicyEntry]![CompanyName] = "4" Then CommissionRate = CommissionRate * 0.5...

After much searching and reading Maybe I shouldn't put if statements on checkbox instead putting them on CommissionRate Field. But I can not seem to grasp this. Anyone?

I have searched the forums for an answer, either there is not one or I missed keyword somehow. I have a form (frmA) with a combo box to choose company (cboCompanyName). In this form there is a subform (frmA subform) ->Everything works great... Within the subform I have another combobox...

Dont know if this really what your looking for, I have a command button on click event procedure is: DoCmd.ShowAllRecords Someone else may have a better answer:)

Finally found it...

*EDIT* - Mod - sorry for multiple threads, internet froze up, as I was posting. I have a print dialog form with a combo box (cboCompanyName). When a choice is given (i.e Company 1) I would like Company 1's logo and mailing address to be visible, if the choice is Company 2 then Company 1's...

Thanks for your help on the combo button. Thank you for kind words - I am trying, and am proud of what I have:) . As for a newbie question - what is twips? for the calculator. And, is I got to thinking is there a way I can place the amount shown in the calculator into the premium column on my...

I forgot to mention - using the binderdate as what's being filtered by year.

I would like to use it on the form it is currently located. (PolicyEntry) OT: I am not asking you to redo my database, and I know it's not very pretty as far naming fields(i.e cbo, tbl, frm etc) but, am I on the right track? I got about 120 hrs of building and research in whole thing, and I...

Oops, sorry for that. here ya go

This is the one I play and experiment with. That way I dont mess up the one I am working with. So it's not very pretty...:) You'll notice a combo box, down by the calculator on initial opened form (policyentry) , then under queries (policyentryfilter) the expression you given me.

Alastair - Thanks for reply. I got this to work from the query. However, it does not work from my combo box on my form. I am having trouble understanding the "on click" event handler.

Hello, I have been working on my database for sometime - searching this forum for answers, thanks to all the experienced people for their sharing of knowledge. My question is this: My database will be over several years of data, on my splash screen (switchboard) I would like to have a combo box...

Since I am pretty new myself, someone may correct me. But, I think you can create a Macro that will printout "x" number for copies and attach that macro to the button your using to print.