Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dapotter

    Changing Rectangle Width (per record) On A Report

    Thanks Remou! That was a lot easier than I expected, which probably means I should have worked harder to find it myself. But I greatly appreciate your help. Don
  2. dapotter

    Changing Rectangle Width (per record) On A Report

    I want to create a report on which a rectangle will be drawn for each record. The length of the record should be based on a numeric field from that record. Specifically, I would like two rectangles, one to serve as a border and one as a fill. They would work together as a chart. For...
  3. dapotter

    Importing Import/Export Specs

    Jerry, I tried using the schema.ini file (as was recommended in the thread Greg pointed me to). I used the following code that I found on a Microsoft website. Function LinkSchema() Dim db As DATABASE, tbl As TableDef Set db = CurrentDb() Set tbl = db.CreateTableDef("Linked Text")...
  4. dapotter

    Importing Import/Export Specs

    I have an Access database that I use to generate reports on data in a text-based company database. I extract data from the company database into a .csv file, which I link to in Access. Several other people have copies of my database, each with some of their own queries/reports defined. I...
  5. dapotter

    Finding Page Breaks in Excel

    That's what I was looking for! Thanks.
  6. dapotter

    Finding Page Breaks in Excel

    Thanks Skip, The Page Break Preview did come to mind, but I'm trying to avoid manual intervention. As Peter recommended, I'll probably split the sections (as detected by my VBA code) into different worksheets, use a page m of n header on each sheet, then print the whole workbook. I just...
  7. dapotter

    Finding Page Breaks in Excel

    Thanks Pete, I had considered this and will probably go that direction, but thought if there was an easy way to find the soft page breaks, someone on this forum would know the answer. Thanks, Don
  8. dapotter

    Finding Page Breaks in Excel

    I have an Excel spreadsheet that contains a budget report. This report is divided into sections of varying length that will be handed out to the individuals responsible for those sections. Using VBA, I have set page breaks to divide each section. What I would like to have is a page count for...
  9. dapotter

    Changing a Reports Recordsource

    cmmrfrds, I wasn't creating the SQL in the OnOpen event, but in the Click event of a push button. I've tried so many different things that I can't remember what I've done and when. I'm trying to duplicate some of them now in the few minutes before I have to leave for work. To the best of my...
  10. dapotter

    Changing a Reports Recordsource

    I tried your suggestion, but since my database is currently modeled for ADODB, it didn't work well. Is there a method that would allow me to do this without having to convert to DAO? Don
  11. dapotter

    Changing a Reports Recordsource

    I have a form with a pushbutton which, when clicked, is to launch a report. I am using the DoCmd.OpenReport method to open the report. What I want to do is change the report's record source based on data contained in the form. My preference is to set the report's record source property...
  12. dapotter

    DTPicker.Value Read-Only?

    Yes. That is almost exactly what I was doing. The only difference is I was using the Form.Open event. When I tried it again using the Form.Load event, the current date loaded just fine. Do you know why the Form.Open event doesn't work? Thanks, Don
  13. dapotter

    DTPicker.Value Read-Only?

    I am trying to set the value of a DTPicker control to a specific date, such as today's date. According to the object browser, the Value property "Returns/sets the current date." When I try to assign to the value in my VBA code, I get a message saying the property is read-only. I can set the...
  14. dapotter

    Defaulting fields for new records enterd in a subform.

    PHV, I'm not sure what the difference between last night and tonight is, but I was able to code the subform to get the behavior I need. Thanks so much for your time. Don
  15. dapotter

    Defaulting fields for new records enterd in a subform.

    I will have to refresh my memory on exactly what was happening. I abandoned my efforts to add code to the subform relatively early last night. I am currently at work, but the project I started this thread for is an at-home project. I'll try to find time tonight to remember what sort of errors...
  16. dapotter

    Defaulting fields for new records enterd in a subform.

    PHV, I do use the Customer and Date fields to limit the set of data that appears in the subform, but I don't include those fields in the subform (which I display in the datasheet view). I don't want the user to see those fields, since they appear to be included in the main form. I guess I...
  17. dapotter

    Defaulting fields for new records enterd in a subform.

    I am creating a form to enter data into a table. I want to be able to enter several records where certain fields are identical without having to re-enter those fields every time. I've added unbound edit boxes for the user to enter the data that may not change for several records (e.g. Customer...
  18. dapotter

    Locking out the kids

    Sorry if this is not the correct forum to post to. The kids are getting a new PC for Christmas. All four are under seven and tend to click everywhere. I would like to set the computer up so they're limited to some subset of tasks that I define (which wouldn't include using Explorer or even...
  19. dapotter

    Marking a linked table as read only

    I have an access database whose primary purpose is to allow viewing of data exported from a different database management system. The other system is cumbersome to use, so the Access database allows querying and reporting in a more familiar manner. Because the Access database is intended to...
  20. dapotter

    Exporting an Import/Export Specification To Another Database

    Thanks MoLaker, I have imported many types of objects, but I never looked at the options dialog before. That makes the job a whole lot easier. I had actually considered doing just what you recommended (splitting the db into front end and data dbs), but didn't want to get into that just yet...

Part and Inventory Search

Back
Top