Datasheet Expand, Help Please!
Jan 27, 2006
HI
i never needed help this much.
i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird.
I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell.
This works fine in 2003. De datasheet is displayed, and when you click on the plus, the other datasheet opens in the maindatasheet.
But in 2000, you dont see the plusjes.
It is a major issue that i fix that! can some help me to solve this?
Joost
View Replies
ADVERTISEMENT
May 2, 2005
I want to make a table (1 row, 3 columns) on Form like we create the table in Microsoft Word. When I type the data in the first row more than one line. The other rows will then automatically expand. All the data will be saved in the same table.
I try to combine 3 textboxs but do not know how to solve the problem.
Thank you very much.
View 3 Replies
View Related
Apr 19, 2006
I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.
Any clues would be much appreciated.
Fozi
View 1 Replies
View Related
Jul 27, 2006
On my main screen I have a button that I press and it pulls up a
pop up box...in the box you type in one item and hit ok then
the query goes and gets the results.
My quesion:
how do it make it so when I click the button the pop up box
has lets say four areas where I can enter different items and
then it goes and gets all four...or three or whatever I need ?
thanks...
View 1 Replies
View Related
Sep 22, 2005
Any ideas why combo boxes that all have their "auto expand" option set to YES are not auto expanding as I type-in text? They were working last week and I have no idea why they're not working now. Strangely, if I type in any of the entries present in the combobox list (text such as "St. Louis City") exactly as it appears in the combobox list, and then press enter, I get an error message telling me the value is invalid. Then, if I use the drop-down list to find and select "St. Louis City", it allows me to enter this value.
View 1 Replies
View Related
Jan 13, 2005
Hi
I have a report with a column of data. It contains a variable amount of data according to the demand of the user (criteria entered in a parameter query). The problem I have is that the data is short string of 3 letters but there are generaly lots of entries so the report runs over several pages. I would like to be able to creat columns side by side. A bit like with the "Can grow" option" but that a new column appears...
I am not sure I am clear...
Many thanx for your help
View 4 Replies
View Related
Jul 30, 2014
OFC without "+" Now I have something like this in double click event in one of my field
Code:
If Me.SubdatasheetExpanded = False Then
Me.SubdatasheetExpanded = True
Else
Me.SubdatasheetExpanded = False
End If
But this code expand all of my items:/
View 1 Replies
View Related
Aug 22, 2014
I have a report that needs to show about 20 different fields from 24 records. I have it set up in landscape view, with one record per line (running horizontally). It allows me to show about 15 of the fields, spanning two pages (wide). I don't know how to add a third page to show the remaining fields.There are no Groupings.
Also, is there a way to "wrap" text in the column header?
View 11 Replies
View Related
Oct 28, 2004
Is there a code for event procedure OnEnter() that allows me to expand my list box so that i can see a list that's larger than the size of it. I was hoping to multiple select from the list and do it at a glance because my list is very long.
View 1 Replies
View Related
Sep 17, 2014
the login is working perfectly, once It logs in there is a button to expand all that is based in JS. I can't seem to work out how to get it to click the button to expand the whole menu, latest code is below:
Code:
Option Explicit
Function Checkpage()
Dim IE As Object
Dim lform As Object
Dim Document As Object
Dim item As Object
[code]...
View 3 Replies
View Related
Jun 30, 2015
MS ACCESS 2010
AutoExpand Property Set to Yes
I have a bound combo box that has a query as a row source, The query has 3 fields called from tblMasterItems, The ItemID , ItemDesc and ItemSupplier(related to the PK of tblSupplier).
Column Count = 3
Column Width = 0";1";0"
If I do not put a criteria under ItemSupplier, the combo box behaves just fine. The problem happens when I set the criteria under ItemSupplier, the criteria being the supplier ID, the combo box no longer expands and searches as you type, but the items in the combo box have been filtered and are there.
Summary:
When the row source qry ItemSupplier Field does not have a criteria, cbo works just fine.
When the row source qry ItemSupplier has a criteria, cbo no longer expands and searches as you type, but has the filtered data showing if you hit the expand button (that arrow pointing down in the cbo)
View 6 Replies
View Related
Dec 13, 2013
Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another.
View 4 Replies
View Related
Sep 1, 2007
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
View 2 Replies
View Related
Oct 4, 2004
I'm new to this.
Is there a way to make a Form Datasheet (including calculated cells) update the corresponding Table Datasheet?
View 1 Replies
View Related
Jun 5, 2014
I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.
What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.
The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.
(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading
Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!
View 4 Replies
View Related
Dec 26, 2006
I have an access 2000 db. My users open the DB and I have it launch a simple “startup” form with various buttons for the most used features. I have one button that launches another form. The default view of the form is supposed to be in ‘datasheet’ view. However when I click the button it opens in ‘single form’ view.
What can I change on this vb code to allow it to launch in datasheet view instead of single form?
Private Sub cmd_su_checkpaid_Click()
On Error GoTo Err_cmd_su_checkpaid_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_ACCOUNTING_BILLING_VER"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmd_su_checkpaid_Click:
Exit Sub
Err_cmd_su_checkpaid_Click:
MsgBox Err.Description
Resume Exit_cmd_su_checkpaid_Click
End Sub
View 2 Replies
View Related
May 11, 2005
Hey guys.
Well this is a new on for me, the idea is this.
By using a datasheet view in a subform and a custom popup menu I can allow users to filter down to the records they wish to view, in whatever order they want, and then allow them to open/edit said records with a Double-Click Event.
Fact is there are so many ways that different departments wish to filter this works in theory and in a sample I have created. A search or filter form would be huge. This seems simpler.
Ok, all good in theory, I can restrict “new” and “edit” etc, but I can just see users resizing the datasheet view to something only brain dead users could do or hiding columns. <SHUDDER>
So my question is, can or is there some why that I can use the OnOpen or OnLoad event to re-size the datasheet to a default size? (Well the fields in the datasheet mainly) This would allow you average bi-polar user to mess and re-size until their coffee mugs run out and the next user doesn’t get left a mess. (Which would then force them to ring me!) <SHUDDER>
I hope this makes sense, I really hope someone can point me in the right direction.
Have a look at the sample database attached to get a better idea of what I mean.
Thanks :)
View 1 Replies
View Related
Jul 22, 2005
Exporting datasheet to word, how is this possible using vb. Actually, I do have a thread in Form forum. But, I think not a lot of people visit that place. Anyways, I have created bookmarked and used datavariable to export the data (by ansentry's help). But the only thing that it exports is just one selection on that datasheet, instead of all the chosen rows.
I am exhausted now after searching everywhere, and not finding a clue. How to resolve that situation. If there is an example that I can use, that would be gr8.
Thanks In Adv.
View 2 Replies
View Related
Oct 26, 2005
I have subforms that are datasheet view, if the user rearranges the coloumns, or resizes etc , I would like to save what they have done so it is as they left it next time they open up the screen.
This works fine with an mdb (all my forms are set to close acsaveNo).
However in an mde this doesn't work.
Can I get this to happen in and mde.
(A button that saves a layout change would be fine for my purpose)
Thanks
Paul
View 1 Replies
View Related
Mar 16, 2008
Is there any way you can specify the size of a datasheet?
Say the datasheet opens up with 600x800 size?
or 10cm x 15cm?
View 5 Replies
View Related
May 15, 2006
Hi,
Is there a way to set the background color of a datasheet? I don't mean the color of the cells, but the datasheet itself outside of the rows/columns as shown below (dark grey color):
http://img.photobucket.com/albums/v368/flemmo/datasheet.gif
Thanks
View 1 Replies
View Related
Jul 11, 2006
I have a form and a datasheet subform in Access. A form has person info and datasheet subform has 4 fields: QuestionID, QuestionNumber, QuestionName and Answer fields. The Answer field is a dropdown field and has 3 items: Yes, No and N/A. If QuestionNumber from 3 to 6 the answer was Yes or No then lock the Answer field in Question 7. Any idea how to do it?
View 1 Replies
View Related
Nov 3, 2006
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
View 1 Replies
View Related
Dec 27, 2006
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
View 7 Replies
View Related
Aug 20, 2004
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)
View 1 Replies
View Related
Jun 18, 2007
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
View 4 Replies
View Related
