What Is Best Control To Display Data In Grid Format?

Jun 30, 2006

I have a search page and would like to display the search results in a grid/table format. User will be able to select a row to go to a detail screen. What is the best component type to use for this?

View Replies


ADVERTISEMENT

Flex Grid Control In MS Access

May 31, 2005

Hi all,



Can I add a flex grid control on a MS ACCESS form.



IF yes, does MS access 2003 has a flex grid control, i cant find one in the toolbox.

MAy I know where can i find the control?

Thanks

View 2 Replies View Related

Reports :: Display Grid View Images On Report

Apr 2, 2015

How can I display multi images on 1 page as a grid view in access report...

View 5 Replies View Related

Queries :: Data To Display In Matrix Format

Feb 5, 2014

I am trying to get this data to display in a matrix format.How can I get it to display multiple entries in there, such as Fiona and Chloe in the FR box?

View 14 Replies View Related

Display Data In A Control

Dec 5, 2005

Hopefully a simple one that is eluding me at the moment.
I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will only display the answer if I go into another field on the form and make a modification to the data. It seems that the control will only calculate on an after update event but I need it to be visible at all times when the form is open. I have tried requery on open and on load with no effect.
Any thoughts out there?

Thanks

View 1 Replies View Related

Forms :: Textbox Control Source - Pull Data To Display On Summary Tab

Oct 16, 2014

I have a form, with a tab control on it. Each tab has a subform to display data. One tab is meant to be a summary tab of the rest, so I want to pull data from certain controls on each of the other tabs to display on the Summary tab.

If I set the ControlSource to Forms!subfrmLABOUR!txtTotalHours.Value the control just displays #Name?

I assume that means it can't reference the ControlSource. Is it just a syntax thing? I've tried various methods, but no luck.

View 6 Replies View Related

Forms :: Web Browser Control Inside A Tab Control Display

Jun 18, 2014

I have a form with a tab control, inside the tab control I placed an ActiveX control (Microsoft Web Browser). These are at the bottom of the form.

Everything displays fine if the entire form fit on the screen but if the form is too long and I scroll down the browser control is getting obscured by the tab control and getting chopped off (the contents are covered). It is as if the browser control is staying in space where it was and moving behind the tab control as I scroll.

This problem does not occur if I place the browser control directly on the form. Also I note that the browser control is sitting correctly within the tab control.

I have been through all the settings and properties of both controls and haven't been able to fix it. I searched all over the web but no one has previously stumbled across this one by the look of it.

See the attached image ...

View 3 Replies View Related

Display Date Format

May 21, 2006

Can someone help me?

is there a way about how to display date format inside on date field?
(but if user want to type the data then the date format automatically be deleted)

currently i just put the date format label below of the date field like this picture:

http://img62.imageshack.us/img62/4936/date6kq.jpg (http://imageshack.us)

please help me to solve it..

thank you:)

View 5 Replies View Related

Date Format Display

Mar 6, 2008

Can anyone quickly tell me how to display the date in a field in a form or report as


Year - Month - Day?

example 1999 - Feb - 03


Do I do this in the format function or should I use the input mask and... and how do I do this?

View 3 Replies View Related

How To Control Output Format

Aug 17, 2007

select salary, pct
from tally

I want salary to be in this format: $3211.00
pct in 23.00%

How can I do that?
Thanks

View 1 Replies View Related

Format Textbox To Display Currency And Percentage

May 22, 2006

Hi,

I have a query with 3 fields - PaymentAmount and PaymentTotal. The third field is a percentage of the two e.g:

PaymentAmount = 10000
PaymentTotal = 12000
PaymentPercentage = 83.333333333333

In my form I would like a text box to display the two combined i.e. £10.000.00 (83.33%).
At the moment it displays 10000 83.3333333333333. I can use £#,##0.00 to format the current half, but how can I then format the percentage to display 83.33%?

Thanks

View 1 Replies View Related

Tables :: Display Input Field Format

Apr 5, 2013

I have the following input mask for a certain field in an ACCESS 2010 table : 00-000-a-a-a;0;-

It works fine. That is when I tab down to it and if I know that the format is : xx-xxx-x-x-x

but if someone does not know the format , things can be out of position.how do I code the field such that the format (xx-xxx-x-x-x) is displayed in the input field awaiting the actual keying of the data?

View 2 Replies View Related

Control Format Of Autonumber When Database Is Replicated

Mar 29, 2007

I have created a design master of my database, i want to share it on more than one PC but add data from both whilst keep developing it.

I have noticed that after replication that the ID fields now use really long random numbers and am wondering whether anyone has been able to control the 'randomness' of the autonumber?

Reg...

View 1 Replies View Related

Forms :: Using Format Control In Auto Number

Mar 24, 2014

I need the auto number to be in specified format as ASI-23-0001. So I added the format "ASI-23-"0000 in the formats and I got it succesfully.The fueld name is "Part Number"

I have added the Part Number field to a form as combo and I was able to list the values in the drop down combo.

I wanted to use Dlookup command in the program to auto fill the next field in the form say "Description".

I am using the following code
Me.Text30 = DLookup("[Description]", "item_master", "[Part Number] = Form![Combo36]")

But now the data in the combo is treated as text because of the prefix "ASI-23" and I get data type mismatch error.

View 5 Replies View Related

Tables :: Format Control On Auto Numbers

Jul 4, 2014

I would like to expand on this questions. I would like to generate a number based on a reference I use, a format like "14/000" where I use "14" with the last 2 digits of the year. However i want the auto number to generate the the last 2 digit automatically when the year changes i.e. when 2015 comes the field generates "15/000" without any prompt from the user.

View 1 Replies View Related

Yes/No Feilds Display In Numeric Format When In Union Query

Jan 25, 2008

Hi all,

I have looked everywhere for a solution to this and found none. Its an annoying issue which I would like to get around.

Here is what happens.

I have a union query that gathers rows with different criteria together. The query works execept that the yes/no feild which is set to display as "Yes" or "No" is displayes as 0 for No and -1 for Yes.

I understand that the numeric values are the underlying values of yes/no feilds in access, however they are displayed as yes/no in all my queries and reports execept my union query.

I will include the union query here in case.

The following code is a function that I use to build the union query on the fly based on some parameters. If you are asking why I am doing it like this is becasue I need the rows that have a value for the feild schFeilds(0) to be on top of the final results followed by the rows that don't have any values for the above mentioned feild, and I want them sorted. I found this method to be the only one that gives me the result in the order I need.

' ----------------------------------------------------------

Public Function makeMainPanelQry()
On Error GoTo Err_makeMainPanelQry

Dim db As Database
Dim qd_window As QueryDef
Dim qd_nowindow As QueryDef
Dim strSQL As String, sql_window As String, sql_nowindow As String


Set db = CurrentDb
Set qd_window = db.QueryDefs("Q1")
Set qd_nowindow = db.QueryDefs("Q2")

strStatus = cmbStatus.Value
strReboot = cmbARStatus.Value

strFilter = makeHostFilter(strStatus, strReboot)

schFeilds = Split(getRSchechuleFeild(), ",")

sql_window = "SELECT " & pbl_ReleaseTable & ".Hostname, " & pbl_ReleaseTable & ".Status, " & pbl_ReleaseTable & ".Excluded, " & _
pbl_ReleaseTable & ".AutoReboot as Auto, " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & ", " & _
HEAT_PROFILE_NODECOM & "." & schFeilds(1) & _
", Technician.FirstName as Assigned, 1 as Priority FROM (" & pbl_ReleaseTable & " LEFT JOIN " & HEAT_PROFILE_NODECOM & " ON " & _
pbl_ReleaseTable & ".Hostname = " & HEAT_PROFILE_NODECOM & ".DeviceName) " & _
"LEFT JOIN Technician ON " & pbl_ReleaseTable & ".TechID = Technician.TechID " & _
"WHERE ((" & pbl_ReleaseTable & ".Excluded) = False) " & _
strFilter & "and " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & " Not Like """" "
'" ORDER BY " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & ", " & pbl_ReleaseTable & ".Status"

qd_window.sql = sql_window

sql_nowindow = "SELECT " & pbl_ReleaseTable & ".Hostname, " & pbl_ReleaseTable & ".Status, " & pbl_ReleaseTable & ".Excluded, " & _
pbl_ReleaseTable & ".AutoReboot as Auto, " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & ", " & _
HEAT_PROFILE_NODECOM & "." & schFeilds(1) & _
", Technician.FirstName as Assigned, 2 as Priority FROM (" & pbl_ReleaseTable & " LEFT JOIN " & HEAT_PROFILE_NODECOM & " ON " & _
pbl_ReleaseTable & ".Hostname = " & HEAT_PROFILE_NODECOM & ".DeviceName) " & _
"LEFT JOIN Technician ON " & pbl_ReleaseTable & ".TechID = Technician.TechID " & _
"WHERE ((" & pbl_ReleaseTable & ".Excluded) = False)" & _
strFilter & "and " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & " Like """" or " & _
HEAT_PROFILE_NODECOM & "." & schFeilds(0) & " is NULL"
'" ORDER BY Priority, " & HEAT_PROFILE_NODECOM & "." & schFeilds(0) & _
'", " & HEAT_PROFILE_NODECOM & ".Status;"

qd_nowindow.sql = sql_nowindow


strSQL = "SELECT * FROM Q1 " & _
"UNION ALL SELECT * FROM Q2 " & _
"order by Priority, " & schFeilds(0)


Set qd_window = Nothing
Set qd_nowindow = Nothing
Set db = Nothing

makeMainPanelQry = strSQL

Exit_makeMainPanelQry:
Exit Function

Err_makeMainPanelQry:
MsgBox Err.Description
Resume Exit_makeMainPanelQry

End Function

' ----------------------------------------------------------

I woudl really appreciate any assitance as its my last hope for a solution.

Thanks and regards
Sep

View 2 Replies View Related

Table With Multiple Like Fields That Need To Display Into Array-like Format

Jan 8, 2013

I have a table that contains the following;Company name, PositionID, Firstname1, Lastname1, title1, gender1, Firstname2, Lastname2, title2, gender2, Firstname3, Lastname3, title3, gender3 [...up to 50 names]

The data is uploaded to my table from a 3rd party database source via .csv file.I can capture up to 50 names, titles and gender per record. I would like to display this data in a table/array like format. I'm not too good at VBA but I can use expressions for unbound fields.I have attached a file that shows the data in a format I would like to see in Access displayed in a form.

View 2 Replies View Related

How To Format A Control In An ACCESS Form To Show Zeros

May 28, 2007

Hello,

I have a text box in an ACCESS form that is blank. How should I format it so that zeros are visible until a digit is entered into that field? This column is for ovetime figures (e.g. 1.35 hours) that will be entered later.

I would greatly appreciate any suggestions and help.

Regards,
Ligaya

View 2 Replies View Related

Tab Control Display Problem

Jun 22, 2007

I have a form that I have set up that uses a tab control. I have set the background color of the form to blue and have set the back style property of the tab control to transparent. On some users computer that tab control is transparent, but on some other users computer the tab control is the default gray. I don’t know of any settings on the users computers that could cause the tab control to loose it’s transparency.

Can anyone help me? Why would the tab control display differently on different computers, normal on some and transparent on others?

View 2 Replies View Related

Form Bound Control Display

Dec 5, 2012

I'm trying to change the display of a bound control on a form to a linked field in another table. Seems like it should be easy to do; I just can't figure it out.

The bound column is [StudentEnrollment]![AnnualClassNumberID] and is linked to a table called AnnualClassNumbers. The field I want to display is the ClassNumber from the is the AnnualClassNumbers table.

View 5 Replies View Related

Display Control Source OR Default Value In Textbox

Aug 31, 2005

Table1 has field (% Completed this Period) that may contain a value, or may be NULL for each entry, depending on how much work was performed that period. The records are sorted by date.

Form1 has a textbox that basically keeps a running tally of "% Completed to Date" by summing the "% Completed this Period" for the current period and all previous periods. So, my Control Source for the textbox is the DSum(...) function.

The problem is this: If I am looking at the first record and there is a 0 (null) value for "% Completed this Period," (i.e. No work was completed that period), I want to display 0 on Form1. However, Access just displays nothing - a blank textbox. I tried making a default value, but nothing will show up since I already have a Control Source set for that field. If I take the DSum function out of the Control Source, then the 0 will show up. But, obviously that defeats the whole purpose of the textbox. I guess I'm trying to figure out how to display the DSum value IF it is something other than 0, BUT IF IT IS 0, then I want 0 to be displayed. Any help would be appreciated.

View 1 Replies View Related

Need A Combo Box To Display Different Lists Depending On A Control

Dec 1, 2005

Hi, I'm not sure how to write something and would like assistance. The form is taken from a table and then there are two diffenterent forms displayed as datasheets within, on tab controls. I have a combo box taken from a query on each form and would like the combo box to display a certain list if the control on the form (the bit taken from the table) has a P in it, a different list if the control has an R in it or to display the whole list if the control has a B in it. Trouble is, I'm quite new to this and I'm not sure on how to write any code for if statements or whatever is needed. If you are able to assist I would appreciate it. Thanks

View 1 Replies View Related

Forms :: How To Control Display Of Fields In Form

Nov 20, 2013

How can I control the display of fields in a form? I see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.

I can't find how it was done, i see no difference in the fields' properties. Another question is how can i make a comboBox to display just the text without the ID number...

View 12 Replies View Related

Tables :: Setting Display Control To Check Box

May 17, 2014

I agree completely with everyone when it comes to not using lookup fields in tables.But does that extend to Display Control of yes/no tables? What are the problems with setting the Display Control to "Check Box"?

View 4 Replies View Related

Forms :: Display Value Of Control Within Popup Form

Jul 25, 2013

I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.

View 4 Replies View Related

Forms :: Display Only Selected Options In Multi-value Control

Mar 2, 2015

I have a form with about 30 controls. I organized it carefully so that all the controls show on a single page. It actually looks really good. However, several of the controls allow multiple values. These appear as a check box showing up beside each item in the list from which these controls take their information. When I run a Filter by Form process, the form flawlessly pulls the data from the table that I'm seeking, and the check boxes are visible, both the ones with checks and without. In a few cases, in order to fit everything onto one page, I have most of the related list hidden, and use scroll bars. This works really well for data entry and for editing individual records.

Where it DOESN'T work like I want it to is in situations where the checked item(s) in the multi-value control don't show up in the box on the form without scrolling. In the table where these multi-value fields actually live, what shows up is just the code for each option, a simple numeral, with commas separating any multiple values. Is there a way to make my form show only the selected codes like in the table? My suspicion is that I'm going to be told no, that the best way to do this is to use a report and query.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved