Search results for query: *

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

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...

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")...

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...

That's what I was looking for! Thanks.

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...

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

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...

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...

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

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...

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

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...

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

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...

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...

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...

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...

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...

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...