Recent content by josephwalter

  1. J

    Linking-Internet

    Are you talking about using a web browser as your front end, or am I mis-understanding your question?
  2. J

    Field based on another field in a record

    If I understand right, you're working on a data entry form that is bound to the Budget table. If so, here's my suggestion: Say you have a form named frmBudget bound to Budget table, with textbox txtHardware bound to Hardware field and combo box cboComment bound to Comments field. Make the...
  3. J

    How can I auto populate related foreign keys with the primarykey autonumber?

    Put a hidden textbox on the Product form. Set the Control Source to VendorID (the foreign key field of the Product table). Then set the Default Value property to the VendorID textbox on the Vendor Form (i.e. =Forms!frmVendor!txtVendorID... your object names may be different, but I hope that...
  4. J

    Linked Tables

    I'm not sure exactly what you mean by "include some flags", but if you want to add fields to the table, you'll have to change the table as its source and then update the linked table. Alternatively, you could create a local table with a 1:1 (one-to-one) relationship with the linked table. Put...
  5. J

    Let the user chose the report grouping

    For simply including/excluding the page breaks, you could try something like this in the Report's On Open event: Private Sub Report_Open(Cancel As Integer) Const cNone As Integer = 0 Const cBeforeSection As Integer = 1 Const cAfterSection As Integer = 2 Const cBeforeAndAfter...
  6. J

    Stupid unwanted report parameter pop ups

    I don't entirely understand the steps you are taking to get prompted for the values. I put together an 'input form' form and a 'vertical' report. The below code is behind my 'input form' form. The Command2 button is what the user clicks after selecting the field name from the VENDOR list - it...
  7. J

    Linking Records in a Report

    Which field tells you to whom she was married? For example, if multiple men had a Marriage2Detail value of 12.12.1824, how would you know which men were and were not married to Jane Jones (who's Marriage1Detail is also 12.12.1824)? BTW, is 12.12.1824 a date?
  8. J

    Subreport on a new page

    One of the controls in the Toolbox is a Page Break. You could put one of those between each subreport object in the Detail section of your main report.
  9. J

    Visible code Run Time problem in report

    Could you post your VB code?
  10. J

    Printing labels in different positions

    Here's a knowledge base article that may help: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q95806
  11. J

    Printing alignment for report

    Have you tried playing with the Page Setup in your report, to include a top and bottom margin on your report?
Back
Top Bottom