Grid on a Form

I am a retired Visual FoxPro programmer. I have been asked to create a membership application using MSAccess. I would like to replicate a form which I found very useful in VFP. It consists of a grid containing name and address of a member with detail fields below. The user scrolls through the list of names and addresses to identify an individual then clicks on their record. The detail fields are then populated with data held on that individual. I cannot find how to do it in the books I have read, they all seem to concentrate on the master/detail scenario. I would be grateful for any help, even if it is only 'can't be done'.

Sponsored Links:

Related Topics

Substitute for Excel grid in access
We are changing an official form from excel to access. The old form had a grid with 14 rows X 3 columns. Access reports do not need to "print" a grid at all but we want to keep the OLD LOOK.

How can I fiddle with the access report to make a permanent grid with 14 rows in which only a few of them have data?


form positioning
does anyone know how you can adjust the position of a form when it loads?

I assumed it could be done using the 'grid x' and 'grid y' property however no matter what value I input the form always opens up in the same place.

Maybe I have a contradicting property selected somewhere which is preventing the grid reference property from taking effect


Drawing a grid on a Report
I have a report based on a Crosstab query. Both the Query and the Report work just fine. They have 2 row headers on the left side of the table and a variable number of PivotField headers.

I've been asked to have the Report's table in a grid when printed. Normally I would just use line segments to draw this grid. BUT, the number of PivotFields varies from Report to Report, so I'm having difficulty getting the grid to work. My supervisor wants the grid to end with the LAST COLUMN. I'd like to know:

a) What is the best way to compute how many Pivotfields a Query will have?

b) How should I approach the drawing of the grid?

I'm not experienced enough at coding to know how to handle this properly.


How to remove the grid from the form design view ?
In the form design view,I click at the design tab, the grid line section was disabled.

How can I enable it so that I can remove the grid from my form design view ?


Form background grid size
Access 2007: On a form, in design mode, the background grid dot spacing is too large. How do I change it to a smaller dot pattern?


Manipulating data and the data grid
Working with the data grid: When you have a large quantity of data to input, the data grid is not a bad way to go. You normally won't use this technique for day-to-day operations - we will create forms for that - but it is useful at startup.


Using filtered form data as record source for report
I have a split form in an Access 2007 database where the data grid shows the records from a query. The user can filter any combination of fields from the the drop down headers. I have a command button above the data grid that opens a report with the same query as its record source. I'm trying to figure out how to pass the filtered data to the report so it will show only those records that the user is seeing in the data grid of the split form.


Grouping of controls in form to perform common operations
Let us say I have 9 text boxes on a form ( grid of 3 x 3).

Can I assign say textbox3 to 3 different groups
Row as the 1st group to which it belongs ,
Column as the 2nd group to which it belongs ,
The entire grid as the third group to which it belongs

to allow based on value of text box 3,
operations to be performed
on either
the entire row group
or
the entire column group
or
the entire grid.

Hope have put across my query properly


Form delay
I am struggling with a slight form delay. When it opens on the OnOpen event, I am populating a grid. This takes about 3 to 5 seconds but, the it also takes the form the same time to open. What I need to do is get the form to open then populate the grid.

Can I make the form open first then populate?


Grid control? Where are all the comtrols in 2007?
I have not used access since 97 I am having a harder time of it than I expected.

I am using a Listbox for a grid. It would be Ok if I could increase the height of the row.


Pre populate rows in sub form
development and I need to work on a issue.
We have a form with product details and a subform in the form of a grid where we need to enter some cash values. The sub-form has 3 columns in the grid.
I want that when a new product record is shown the subform is shown with 30 rows with the first column having values 1-30 and the corresponding columns blank which can be edited later.

Attached is a screenshot of what my form looks like


Overtype values and create new record
please bear with me.

I want to create a grid, in appearance like a spreadsheet, that is populated with values held in a table. Not all grid squares will be populated but it is important that current values from the table are displayed. I then want to be able to type in a value into an empty grid square, which would then create a new record. The values of the displayed records will be used to calculate a total.

On the face of it a spreadsheet would seem to be the answer but I want to create a history of values entered in the grid.

There is a bit more to it than the above but I reckon if I can crack the above problem then I can probably sort out the rest.

Will be away for a few days so may not respond immediately.


Finding value from one table using criteria from another table
I have 2 tables, Table 1 and Table 2, they both have about 1000 GRID values: Table 1 contains anywhere from 1-20 records (I.e., rows) per GRID value containing unique “spc_ID” and “name”values, while Table 2 has 365 unique “cum_GDD” and “doy” values within each GRID value (“cum_GDD” is a running sum of something, calculated as a function of “GRID” and “doy”).

I’d like to create a table that contains the fields “GRID” and “name” from Table 1, but which also has the field “doy” (from Table 2) where “doy” corresponds to the record in Table 2 (as a function of GRID) for the first occurrence of “cum_GDD” is = or > “min_GDD” from Table 1 (order matters and so I sort both tables at the beginning of the module).


How to change background color in a grid?
I want to change background color in a control in a form grid depending on the value in another control in the same grid.


Pre populate rows in sub form
I am new to access development and I need to work on a issue. We have a form with product details and a subform in the form of a grid where we need to enter some cash values. The sub-form has 3 columns in the grid.
I want that when a new product record is shown the subform is shown with 30 rows with the first column having values 1-30 and the corresponding columns blank which can be edited later.


Add Excel-style comments to controls grid
We have an existing tool in Excel where users can set 'states' of criteria by changing cell colors and adding comments (this is used for evaluating employees). We are looking to move that over to Access.

Besides the issue of creating the actual grid (trying for something better than a grid of labels, but that's another problem), is there a way to imitate Excel's comment feature?


BMP image add to form, grid appears on it
When I look at the attached image in photoshop as a bmp, its perfect. When I add it to an Access form, it has a grid on it. Is this usual or unusual for a bmp? I have added it by an image control.


Looking for Grid Control
Could someone point to a decent Grid control I can use in my Access 2010 projects? It would be great if it is a free one or one from Microsoft (I have MSDN).


Add Excel-style comments to controls grid
We have an existing tool in Excel where users can set 'states' of criteria by changing cell colors and adding comments (this is used for evaluating employees). We are looking to move that over to Access.

Besides the issue of creating the actual grid (trying for something better than a grid of labels, but that's another problem), is there a way to imitate Excel's comment feature?

Want to make sure we're not heading down a dead-end path.


Snap to Grid
I cannot move a field to make room for spacing. I tried to turn off Snap Grid and it still will not work My fields are fixed in place. How could I change this