Search results for query: *

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

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

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

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

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

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

I am developing/maintaining a database that is being used by multiple users. Due to the nature of the database (and my lack of experience) we have decided that each user will have their own copy (which will have the same structure but different data). I am working on a change that will require...

Is it possible, using VBA, to modify the definition of a query that exists on the Queries tab of the main database window? Thanks.

I have two tables with matching primary keys. The second table is simply a place to collect notes on the records in the first table. Not all records from the first table will have notes, so the second table will likely have fewer records than the first table. I have a query that combines...

I have a Microsoft Excel worksheet that I would like to export to a text file using a non-standard field delimiter ('^' for example). I know Excel will let you choose the delimiter for a file being imported, but I can't seem to find the corresponding operation for exporting. I am not averse to...

I use Internet Explorer as my primary browser. If I have a browser open when I launch an Internet shortcut, instead of opening a new browser window, an existing window is used. Is there a way to force the shortcut to open a new window?

I have a form with a subform that is based on a table. One of the fields in the table has a default value. I would like to change the default value based on the current value in an edit box on the form. My intent is to autopopulate a field that is not visible in the subform when a new record...

I have a db with several identically designed tables. I am trying to build a form with a subform to show the contents of one of those tables based on the users selection from a list box. It is simple to create a form for each table then create a master form with a subform tied to one of those...