Search results

  1. A

    Report open without data

    It seems the do.cmd maximize is actually the culprit here. I tried a couple different things, but using the same original codes, I took out maximize, and it run fine. I moved docmd.maximize to the on click event. It created a fragmented report. http://imgur.com/oq9Z0 Harmankardon: I do not...
  2. A

    Report open without data

    Rank_Am: It seems that me.refresh does not work in 2010 like it had in previous versions. It needs to be dialog because I have it setup to open on the users 2nd monitor. As they still need to reference the form while evaluating the report that opens. vbaInet: Yes is it a pop-up report. My...
  3. A

    Report open without data

    Opening my report from form: DoCmd.OpenReport "rptcurrent_openings", acViewReport, , , acDialog Then on the report itself: Private Sub Report_Load() DoCmd.MoveSize 28000 DoCmd.Maximize End Sub When the report loads, no data is there. If I scroll over, then everything appears. Otherwise...
  4. A

    Filter Report

    I have report 1, which gives basic information about job openings, sorted by position, then it lists the employer, # of openings etc. On report 2 I have the requirements that the employer has sent us. User would start on report 1, then click button which loads report 2, filtered based on...
  5. A

    Creating a template

    So I have always done this the long way. Lets say I have a theme for my reports/forms. Green header, certain font, etc. I have always just set the properties of each individually every time I make a new form/report. Something tells me there has to be an eaiser way, so that when the report or...
  6. A

    Display fields if not null

    I was sure I was getting an error when I tried that... Works now though!
  7. A

    Display fields if not null

    Yes it is.
  8. A

    Display fields if not null

    I have about 25 fields on a form all locked. If any of the fields are null, I do not want that field to display. I was able to create this on one field by attaching it to the on load event, however, I am not sure how to add the other fields. Thanks! Private Sub Form_Load() If...
  9. A

    E-mail Selective Report

    Thanks. I think I was having one of those days that for some reason, NOTHING makes sense. Here is my final working code, in case someone runs across this: Private Sub Earnings_Warning_Click() On Error GoTo Err_WarningEmail strempwarnemail = "badams2@uwlax.edu" Dim vbRst As New...
  10. A

    E-mail Selective Report

    So I have done things like this, but never this exact scenario and cannot figure out how to design it. I have a report that is displaying a department, and a list of students who meet X criteria in that department. What I want to do is this: E-mail the report to the department where students...
  11. A

    Selection

    On my table I have 12 different locations, each location have 5-20 providers. I need to assign a provider to a client (one to many). On the form what I would like to do is first select a location, then have only the providers at that location populate in the provider box. Then when the location...
  12. A

    Question Separating Bio Data Into Separate DB

    3 different programs run on the same set of biographical data. These programs perform surveys and track participants progress. Ideally I wanted to create three separate front ends so that each program could be customized to fit the specific needs. However, the front ends want to be able to come...
  13. A

    Splitting The Database

    So here is what I am thinking about doing, I just want to know if a) it is feasible b) anyone has done it that can tell me whether I'm going down the wrong path So I have one set of demographic data. However, for many of these people they are involved in 3 programs (A,B,C). Sometimes one...
  14. A

    Open In Design Mode

    So I know that someone can hold shift to open in design mode. What I am wondering is if there is a way to always open access databases in design mode. Thanks
  15. A

    Save Button On Form

    Should have dug a little deeper before posting. For anyone else who is wondering, here is the code that should be before the open report do command DoCmd.RunCommand acCmdSaveRecord
  16. A

    Save Button On Form

    So what I am wondering is if I can just add "DoCmd.Save" before the DoCmd that opens the report. Is this possible, and would I have to do anything other than simply putting DoCmd.Save? Here is what I have right now for the receipt button Private Sub Open_Receipt_Click() On Error GoTo...
  17. A

    Save Button On Form

    Form is used to "check" out customers from an auction. Field "payment method" is selected on form, and report "receipt" is printed. For some reason payment method does not update instantly after selection, and requires me to basically go from one customer and then back and then when I click...
  18. A

    Data Type In Calculated Field

    Thanks LagBot... Didn't know it was that easy! :) Tried setting the format property to currency still would not return in currency data type. Thanks for the quick reply though!
  19. A

    Data Type In Calculated Field

    Select query pulls in two fields from same table, both are currency type fields. Then I have a calculated field in the query finding the difference between the two, but the output is not currency. Is there some way to make the calculated field a currency data type?
  20. A

    Lookup Source

    Yes I know a lot of people find them evil but in this specific instance it would suite me well. Beyond that: Am I not going to run into the same problem when I create the combo on the form. How can I have the box lookup the name of the contact and the name of the dept when they are in two...
Back
Top Bottom