I'm working With Access 2002, and have a form with 2-subforms. SubForm-1 is a datasheet which shows a list of records. SubForm-2 shows a list of records in a different table, which are linked to the record selected in SubForm-1. The question is how can I Highlite the entire row in Subform-1 when I click on any field in the row. Is there a way to do this?
Any help would be greatly appreciated.
Thanks
MBeaston
Hello everyone,
I have a query that runs from the main form when the command button is clicked. It displays the results in datasheet view. I want the user to double click a specific record and jump to that specific record in the main form. How do I do this? Sorry, if this is a dumb question. Please help, my boss is breathing down my neck. :eek: The main form is called Contracts. Each record has a unique ID.
Thanks,
Jason
When viewing in 'continuous' / datasheet mode - is it possible to highlight the whole row instread of just the cell the user has clicked in?
View 1 Replies View RelatedHi,
I'm not even sure if this is possible to do (I havn't found anything on the Net yet), but I have a Form displaying Customer information, and the vending machines that customer has.
The main form (frmAccount) has 2 SubForms:
1) AddressSubForm (is a Datasheet), listing the many addresses the one account has.
2) VendingMachineSubForm (is a Continuous Form) and displays the machines related to the account.
What I want to do is select an address in the datasheet, and have the MachineSubForm populate with what machines are located at that address. Can this be done?
The Machines and Addresses link by AddressID. Both subforms are built on queries.
Thanks for any help/insight!
Mike
The table has PK and city column can be one of several. I need to create a filtered datasheet view (few columns only).
Since there are quite a few cities, I need to select one to display all the records in that city. My questions
Since it is a datasheet view I cannot use Combo Box. What to do then ?
If I use subform with a combo box, and bind the query in the subform with the selected combo text, it does not work.
here is the subform query
SELECT tblClient.ClientName, tblClient.HqCity FROM tblClient WHERE (((tblClient.HqCity)=[Forms]![frmSearchCity]![cboCity]));
I get nothing.....
I'm new to this.
Is there a way to make a Form Datasheet (including calculated cells) update the corresponding Table Datasheet?
Hi,
There is a requirement for
1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented?
2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet.
Pls let me know.
Thanks,
Savita
hello,
I'm working on someone elses database, and I'm not too familiar with access.
He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.
The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update:
However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.
Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.
Any help would be greatly appreciated.
Thanks
Hi
I have a datasheet subform on an unbound form. but the data on the subform will not sort in ascending order.
I have used the ORDER BY in the table and form but it still will not do it??
Thanks
way to have auto summing of datasheet view of a field of a form back on the same datasheet at the bottom of the field. I do not want to use a calculated control.
View 1 Replies View Relatedhello,
I also posted this in the report section, but it doesen't seem like the readers over there have any answers. I'm hoping maybe query people will.
I'm working on someone elses database, and I'm not too familiar with access.
He's got this form called Customer_Select, and when you click on a check box for a customer, it's option value is recorded in a field called Product, which then corresponds to the product/customer id located in a table called CustomerCharacteristics.
The problem is that I just realized that this Product field existed. When I view the form as a datasheet, I see the fields: Product, Lot_Nr, Version:, and Last Update:
However, when i look at the field list for the same form in Design view, I get: DateTime, VersionDisplay, and Description.
Does anyone know what's going on here? I need to reference the Product field in a query I'm modifying, but the expression builder can only 'see' the fields that are visible in design view.
Any help would be greatly appreciated.
Thanks
In one of my forms (which is a datasheet) I want to create a hyperlink or a command button (in each row), which enables the user to jump to another form (determined by the cell contents).
I have achieved that by replacing my datasheet with a continuous form and adding a command button. But I would much rather keep my datasheet format.
I tried to put a command button into the datasheet, but it won't display it.
Is it possible to achieve my objective here ? I am not having much joy with HELP.
NoVoiceLeft
I have a datasheet form that is used to update existing data in a table. One of the fields that can be udpated is Department. On the table I'd like to update, the DepartmentID is stored. The DepartmentName is stored in a seperate table.
I would like to use a combo box so users can select from a list of Department Names, then update the DepartmentID field in the main table. However, it appears the combo box can not be "bound" to the DepartmentName field in the Department table - every time the combo box is changed it tries to update the Department table. If I make the combo box unbound, no data appears in the combo box so users can't determine what the current Department is.
Using the Form View I could set a default value for the combo box based on the current record, but that doesn't seem possible in the Datasheet View. Is there a way around this?
Okay this i definately need help with. I want my form to behave in the same manner as a datasheet in that it just displays rows of data. I want to create this how do i do that.
View 3 Replies View RelatedI have a form that displays inventory using a datasheet format..
is there a way that i can make it so that if that record has a sales order number (because it is sold) then highlight that record...
I have a form designed in DS mode. If I open it directly (double click on it on the Panel), it works fine
When opening it programmatically (from a button in another form) it shows just ONE record, in spite of having room enough for several records.
May I get some help to check what am I doing wrong?
thanks
I have been fighting a problem with sorting the data in a subform that is in a datasheet. It is sorting the data automatically so the entries are not in the original order. Is there a way to disable the feature so that when I put data into the datasheet it will appear in the same order that it was originally.
View 2 Replies View RelatedAnyway, I have a form that opens in datasheet view. It displays company names that exist on a client table based on a "Like" criteria the user typed into a text box. They type the word "network" in the text box, click search and a datasheet opens that has all companies that have "network" somewhere in the title. That's it. Works perfectly. We'll call this datasheet view form result "Test Query Form."
I have a second form that currently allows users to select a company from a drop down box and then populates the rest of the form with data from a table for that company. Again, works perfectly. We'll call this form "Existing Info."
I want to make a change to this second form. Rather than allow a drop down combo box for selection of the company, I want the "Test Query Form" to open the "Existing Info" form and automatically populate the form based on the company that the user double clicks on in the "Test Query Form." For instance, if I type in "network" and clicked search and got three companies with the word "network" in the company name, I want the user to double click on the second company name and have the "Existing Info" form open up with that second company on it and all the info populated for that second company.
I know this needs to be VBA code on the dblClick command for the company name cell on the "Test Query Form" but I can't quite get it to push the company name through to the "Existing Info" form.
I am new to access web databases (access 2010). I have a "web datasheet form" that shows a query of all the projects in my database (fields are ProjectID, ProjectName, Assignedto)
The assignedTo field has been populated with the sharepoint user name.I now want to automatically filter this form to only show the projects for the currentwebUser? ie. I don't want the user to have to select their name from a dropdown.Do I do it on the query or on the from that loads.?
I have a form that shows details of a record. I have a command button to open associated records in another form in DS view. My code will open the DS and show all records or filtered to specific record.
What I would like to do is use code on command button to open DS view and simply highlight (find) the record that was being viewed in the first form.
Main Form = frmBroachBase
DS Form = frmBroachBaseDS
Associated fields on both forms are - [AutoID], [BroachID] - that can be used to link the two forms.
Well, I couldn't find this using the search, so here it goes:I have a form in which I enter data to create a new client. Within that form I have a subform in datasheetview which is based on a query which holds/retrieves certain (important) fields from a table that holds case info. So in that one view the client data is displayed on the form and all cases and the most important data from those cases is displayed nicely in one screen.Now, when a client calls I navigate to that client and see all previous and all current cases that are open and/or closed for this customer. So the customer says case this and that number is the case I need to discuss with you. Now, what I would like is to be able to click or double click anywhere on the line that, for instance, says case nr 55, so that the form(s) belonging to case nr 55 pop up and all info concerning that case is displayed and can be edited as needed. My problem is: I'm still a newbie and if it was a simple thing like using the on_click event to open the form that's needed, I would not have to post this question. But that can't be done (as far as I know) since the subform is based on a query which is displayed in dataview.Am I overlooking a very simple solution to this problem or is it really going to be as difficult as I think it's going to be?For clarification of the idea I have included a screenshot of the form in question. I assume there are tons of databases out there which use such a layout or idea as this one. Please, never mind the buttons etc. It is still a work in progress. ;)
View 12 Replies View RelatedI want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view.However, the problem is that they want to also see on the same form Contact details (Name & Tel.no). This is a one to many relationship with the underlying query so I cannot build this data into that query as it then makes it un-updateable.I had thought of putting the contact details into a subform and then putting that onto the continuous form but Access does not allow that.I am currently trying to get it work using an Unbound listbox and then using either a query or DLOOKUP but so far I cant get it to work.It seems to be something to do with it being on a continuous form.Any ideas please?
View 7 Replies View RelatedIn Filemaker, when you open a table in datasheet view and then select a record you can then open the form relating to this record. Can you do this in Access - I can't get it to work.
View 2 Replies View RelatedHi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute
I was hoping that my subform viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)
Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU
I have read you can do this quiet easy in access 2007 but was wondering if possible in 97
Thanks heaps for your help
Thanks
I have a continuous form that I need to appear as a datasheet (one record per row). The data fields are "locked" to the left edge of the form. How do I free them for realignment inot a row (instead of a stack)?
View 4 Replies View Related(MS Access 2010)
I'm trying to find some code to allow a datasheet form to link to a csv file.I'd like the link to the data to be dynamic so it connects when the form loads as the access database will be run from a network share by multiple people at the same time.
The CSV file will be different for each user and reside on their local PCs in their profile folders.
I've been trying variations of this snippet of code I found which is called On Form Load:
Code:
Public Sub getData(path As String, fileName As String)
Dim cN As ADODB.Connection
Dim RS As ADODB.Recordset
Set c N = New ADODB.Connection
Set RS = New ADODB.Recordset
[code]...
setting up and connecting ADO data sources to a form.