i have a subform which displays data depending on the criteria selected on the main form. I want to be able to double-click on the row in the datasheet view to pop up a form and display the selected row contents. is it possible? if so then what event do i have to code it in?
View RepliesHi all, I have a query to recall all the events related to a certain employee by running a query and inserting the staff number, I then have a form showing the details of all employees; what I need is to add a button on the form that runs the mentioned query without having to insert the staff number again as the form is already showing that employee.
Thanks
Marco
Hi,
Does anyone know how I can set up the following?
I have a form with a list box in it which is populated by the data from a query.
What I would like is that when a user clicks on one line of data so that the line goes black and the text goes white, I would like the code that when double clicked, will take you to a form with the record displaying the same data as the one that was in the list box.
E.g. The list box would be a work queue of outstanding post items to action and when a record is double clicked on, it takes you to another form but shows all of the data for that record as opposed to just the data in the list box query result.
Many thanks
I am new to access and all of this and trying to create a database to record livestock (budgerigars) I have put in the reletive informnation for 2 generations but would like to beable to click on a record in forms view and for the grandparents to be automatically inserted. Something like a family tree.
Also I would like to be able to double click on a entry which shows as a parent in a form view, and for the database to go directly to that entry and bring it up onto the form.
I hope someone can help and that I'm making so sense
(anyone know a good book that would help me understand all of this)
Thanks
Norma
When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.
View 4 Replies View RelatedSee title :)
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up from. I want to achieve the same behaviour in Access.I started to think towards a VBA coda, that could be initiated from the form's double click event. It should go to datasheet view with the prpoer filter criterias.
View 1 Replies View RelatedI have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries. When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field. I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process.
Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option.
My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field (not the plan query). Would like to double click a plan within the plan query and have that description populated into the form's plan field.
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.
If u kno how i could resolve this please offer ur help
thanks
I have a list of incidents in my Incidents Management Database. It comes up as a grid view when users open the database.
This is what it looks loke (paste the following into address bar of your browser. lh5.google.com.au/snehal.dabhi/R8oc22J_RfI/AAAAAAAABz0/bbIkCzg5whk/image001.png
I want particular incident to open in a form when users double click on any particular incident from the list above.
For example double clicking on the first incident (dated 1/03/2008 in the list above) should open the form below with THAT PERTICULAR incident. And double clicking on 22nd incident should open the following form with 22nd incident loaded, so users can edit that incident
please Paste the following into your browser to see the image.
lh6.google.com.au/snehal.dabhi/R8oc3GJ_RgI/AAAAAAAABz8/vGSjfr5rZ10/image003.png?imgmax=640
Any detailed help is much appreciated. – I am too new to understand macros and vba.
Thanks!
I have a form "IntUnderwriterSearchByName" which is based on the query "Search by Name". This form opens with a parameter (please enter name of broker) and is set out like a datasheet with the following fields- "Broker Name", "Domicile", "Broker Code" and a couple of others. I'd like to be able to click on a record and open the form "IntUnderwriterPopUp" so that the details of that specified record are displayed.
Broker Code is what I'd like the form to look for and this Broker Code is unique for every one of the 900 or so records. This code can be numerical e.g. 01233 but also can be a mixture of both e.g. EU2885. It is also worth noting that this code is not the primary key- i have an autonumber (called ID) that does this- but this field does not appear on the form.
when you select the Data sheet View you display error messages in the Accounts Sub reports fields.
The database has been included as a reference:
Forms- Double click Accounts Form By Discipline -data sheet view
Under Current balance,Spent, and Encumbered Columns you get error message instead of the actuall totals.
Please tell me how to correct this prolsdms
Is it possible to switch the view of a subform to datasheet when a command button on the mainform is selected?
I know it is something involving acFormDS...but I cant figure out the rest of the code! I appreciate your help in advance!
(P.S. I know you can right click the form and select datasheet. Unfortunately there are not many people here that are familiar with MS Access and I dont trust that they will know this)
I am reviewing a program that in datasheet view has '+' signs in the left-hand column -- it displays rows of companies. When I select a '+' another 'sub-datasheet view' of employees of that company appears, partially covering the original datasheet view of companies.
Is this the way sub-forms look in datasheet view or is something else involved?
Thanks
Hi. I am trying to create subform in datasheet view with one column (total 3)as drop down list. Is this doable? Thanks.
View 3 Replies View RelatedIs it possible to do a query of the datasheet view of a subform? If so, how does one go about it.
Thanks.
eileen
hi
i have created subforms and set the Default View to Datasheet
Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW.
Any Clue?
Thanks
I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.
I would like a column to be hidden for a certain group of users and have tried the following.
On the subform opening event i have
if vlevel = "engineer" then
me.Hours.columnhidden = True
Else
me.Hours.columnhidden = False
End If
And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True
But neither worked.
Can any suggest something.
Can anyone tell me how to manipulate a single cell in a datasheet view, or if it is even possible?
View 3 Replies View RelatedI have two Access files. One is just forms which I use as a front end app. The other is the database that I store all my tables/data/etc...
I want to run a query to display data from these tables and display it in like a datasheet view. I know how to do this if it was all the same Access file, but not how to do it with two separate files.
Thanks,
JMH
I am trying to get rid of the row header (the little square next to a record) when in datasheet view.
View 1 Replies View RelatedI created some forms in datasheet view. Now I want to change the datasheet properties (background color, text color...): the problem is that the forms I create with the new properties are displayed as I want, but the old forms are displayed with the old properties.
Does it exist a command to open the old forms/subforms with the new properties or do I have to re-create all the old forms?
I'm using access 2003 sp2 with all the current updates. I've got several tables linked to a sql server 2000 DB. We use it for an app called Altiris. Most of the queries i've written from these various tables work fine. However, a couple of them for no apparent reason, do not display the correct data in the data sheet view when the query is ran.
for example, I have a simple query with two tables linked. The first field is asking for the "name" column of one of the tables. In the criteria of that column, I put something in to limit the names of the programs i'm looking for. Lets say I use LIKE '%adobe acrobat 7.0%' When I run the query, it returns a certain number of records, but in the name column, it has all wrong info. I just ran it and it came up with 4 records: "webcast....", "abacast client", "Ibm websphere", and something else. Nothing even close to "adobe...."
So then I export the query to an excel spreadsheet and then open. Guess what? It has the correct info. Four records of adobe acrobat. The other column I have is from the other table and is just listing pc names. They displayed properly in both datasheet and excel file.
does anyone have any ideas what could cause this? I've deleted the table and linked to it several times. I've used this table for many other queries and it works most of the time. I just have no idea what is causing it to do this for only a few queries.
Thanks in advance for any help.
fisk
In my db I am tracking different stages for an event. I have a subform that is in datasheet view. The last field (current) is a yes/no check box that says that this entry is the current stage of the process. In one of the fields I have a afterupdate event that says me.current = true. But what I need is to change the previous entry to show that stage's current to be false.Does that make sense?Date Event Location Current02/01/07 Drying Dryer X (when next event added this =false)02/05/07 Bagged Warehouse XUp until I enter the 02/05 entry the 02/01 entry was the current stage and I want a check in the current box. But when I enter the 02/05 entry that now becomes my current stage so on the 02/01 event then current = false and on the 02/05 event current = True. I can get the 02/05 event to show current = True but how do I make the 02/01 current =False?Thanks,Rick
View 4 Replies View RelatedHello,
I am trying to find out how to view the field names for variables while in datasheet view in Access. Or, alternatively, I would like to know how to toggle between datasheet and design view for a particular variable. Basically, I have a huge database and I need to be able to find the field name for a variable that I have identified in datasheet view, but right now all I know to do is go into design view and guess which field name it is, click on it, see if the caption matches what I see in datasheet view, and keep doing this until I find the match. I did not create this database which is why I am not familiar enough to know what goes with what.
Thanks in advance!
I have a table that I was in the process of cleaning up when I got the following errors: "type mismatch in expression" and "microsoft office access can't open the table in Datasheet view." What does this mean, and how can I get rid of these errors? Thanks.
View 1 Replies View Related