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.
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.
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
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.
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.
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.
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.
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.
Anyway, 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. ;)
I 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?
In 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.
Hi 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
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)?
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.
I'm using a datasheet that can be filtered for certain fields. I have a macro that opens a form to the record that was selected (aka "current") in the datasheet. It filters this opened form to "1 of 1" which makes sense. How would I go about filtering that form for all of the records left (after filtering) in the datasheet?
I hate macros, but I'm doing client-specific work. The primary key is a field (autonumber) called "ListingNumber".
I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page.Think like the search results of Google, you get a huge number of results, but only so many are displayed per page.
