how can i control a field to show/not show at the query level?
let's say i have a query (from a table) like this
[regularPrice] [isOnSale] [onSalePrice]
where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing.
i've tried to put "[isOnSale]=Yes" in the Criteria, the query will filter out only those records that's on sale, which i don't want...
please help :confused:
I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.
I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.
I have added form controls for modified fields in the past so I am confused about why this is happening.
I have a form with various controls that reflect dollar amounts.
One of those controls, despite deleting and replacing it, despite deleting the field whose value it displays, despite changing it to 'general number', saving, then changing back, despite comparing its properties with that of numerous normal-behaving controls, refuses to show a dollar sign, nor zero cents values. I've compressed and repaired in between deleting fields and controls, too, to no avail.
Otherwise it is working correctly in that calculations based on it work fine and it shows the number of dollars it's supposed to. Just no dollar sign and refuses to show zero cents...
Can anyone suggest to me what's up with this thing?
I'm trying to use the Access 2010 web browser control to dynamically show a PDF.
The base file path is a constant (R:MS_ACCESS_PROJECTSSAFETYIMAGESMSDS SHEETS)
and the dynamic part is two fields from the selected record:
me.txtMsdsID & "." & me.txtVersion
what is the simplest way to "bind" this so that when a record changes it automatically refreshes this control? I've tried setting it with VBA, but it's not working consistently.
I know the issues isn't the file path, as it works fine if I paste it in windows explorer.
Is it possible to have the header of a list box show the value of another control?
View 2 Replies View RelatedI have a form where the records are propulated by ane xpression, which checks and sums database values.
Sometimes, the control boxes are empty as there is no data to sum for a particular record. Is there a way to get the control box to show the value 0 ?
I've tried default's, etc. but that doesn't seem to work...probably because the expression returns a NULL value.
I know it can be done using IIf but that will complicate the formulas even further.
Is there perhaps a way to do it using code instead ?
I have some tab controls, which for some reason show up white.
I have set their back style to transparent but it doesn't seem to show the grey Windows colour of the background form.
Any ideas why ?
AT the moment I'm having to put grey rectangles in various places to cover this up, which is obviously not ideal.
I have a text box [txtTrafficValue] that is a calculated field of two short times. I want an image to be visible if the value is >= 0.0104 (15 minutes). I have in the after update of the field:
if me.txtTrafficValue >= 0.0104 Then
Me.imgWarning.visible = true
Else
Me.imgWarning.visible = false
End if
but when the field does the calculation and updates the image is not appearing.
My 'print' icon prints whatever is on the page as soon as it is clicked.
I'd like it to show the print dialog detailing which page / how many copies / which printer and so on.
how to do this?
I tried to customize the toolbar by adding the print icon from the File toolbar , but this is the same 'straight-to-print' as I already have.
I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.
i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..
Is it possible to convert fields listed down to show across.
IDNo Code Position
AAA B01 1
AAA C01 2
AAA D01 3
AAA E01 4
I want to show it as
IDNo Code Code Code Code
AAA B01 C01 D01 E01
Is this possible using Access 2003?
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
Is it possible to have the control tip show related records from another table?
I've been looking around the internet, and I've seen many examples for showing concatenated fields on current record, but had no luck with what I'm trying to do.
For example.
I have a continuous form, and on it shows top line data. Where a record in this form shows as "Split" it means I have more data related to this record on another table.
Is it possible to show however many fields are related to this record, when I control tip, or mouseover?
I've been playing with
Code:
Me.textbox.ControlTipText = Me.textbox
but was wondering, if this is possible, how I'd reference the other table,
If said column of continuous form is "split"...
lookup related table by ID number
show however many columns of data..
I have a report called "orders" and on this is records for orders of the day inputted.
On this report I have a control called "urgent" and a picture called "UrgentPicture" with the picture set to visible.false?
If any of the controls for Urgent is True then this will show my image, but this is not happening?
I am using this in the current event on the report
If Me.Urgent = True Then
Me.UrgentPicture.Visible = True
Else
Me.UrgentPicture.Visible = False
End If
I have a form based on a query in datasheet view. What i would like is to show only those records that fulfill the truepart of iif statment, and do not show the ones that fulfill the false part.
I have the following fileds in the query
month
currency 1 checkbox
currency 2 checkbox
sum
In the form, the control named month contains the following code:
control source: =IIf([checkbox1]=no;[month];0)
So this gives the appropriate months, but also shows the all other records with a 0 in the month field. I would like to get only the records shown that are correct with the truepart of the statement.
I wondered if someone could help.
I have 3 columns of data within a table and from a select query am trying to seperate certain groups.
Table 1
yr period valuehome
2006 0 100
2006 0 10
2006 1 1000
2006 1 800
2006 2 60
2006 2 50
2006 3 40
2006 3 10
2006 3 5
2006 3 70
2006 4 50
2006 4 5
I wish to show both results for period 0 and an accumulative total for periods 1-4
so results would be
year period Total sum
2006 0 110
2006 1-4 2090
Can anyone help?
thanks
Paul
I have a set of cascading combo boxes. When a value is selected in Cat 1 ID, it narrows down the selections in Cat 2 ID which narrows down the selections in Cat 3 ID.
However, the values don't show up for columns Cat 2 ID or Cat 3 ID until I enter the row. Then I have it set to requery the fields because the underlying data isn't populated. But then when I leave the row, the values go away.
Why doesn't it show the underlying value from the table? Each column is bound to a field in a table - I would assume that the recorded value would show up. Did I miss something easy?
I've attached a picture of exactly what I mean.
I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company.
For some strange reason, 2 of my reports requery with no problem, and 2 of them give me a message that the report can't be found. Here is the code:
Code:
Private Sub cboCompanyName_AfterUpdate()
On Error GoTo cboCompanyName_AfterUpdate_Err
' DoCmd.SearchForRecord , "", acFirst, "[CompanyID] = " & str(Nz(Screen.ActiveControl, 0))
' After selecting a company, requery the subreports to display the appropriate data
' These 2 work
Forms!frmCompanyHistory!RptCompany_Projects_Brief.Requery
Forms!frmCompanyHistory!RptEmployeesSpecificCompany.Requery
'These 2 Fail
Forms!frmCompanyHistory!SubRptCompany_Payback.Requery
Forms!frmCompanyHistory!SubRptCompany_Revenue.Requery
'Other things I've tried
'Forms!frmCompanyHistory!TabCtl66!SubRptCompany_Payback.Requery
'Me.TabCtl66!SubRptCompany_Revenue.Requery
As a side note, if I chose the company, say "ok" to the error, and then go run the queries that these reports are based on, I get the correct records. Also, if I chose the company and run the 2 failing reports standalone, they work fine, so I know the problem isn't the reports or the queries themselves.
I have also checked and rechecked for any spelling mistakes and have found none. I should mention that the error message is "Programs cannot find the field 'SubrptCompany_Payback' referred to in your expression".
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Right now, my code looks like this for On_Click:
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
I have tab controls, each of which holds a report. If the report is longer than the tab control the report is stuck there. no slide bars, no overflow. I have set scroll bars but they dont seem to take or work. I need to find a way to add verticle scroll bars to the reports within the tab controls so that you can view the entire report. I have included a screen print of what I mean.
View 1 Replies View RelatedI have two tables, one for categories and one for records. I have sorted out the active records. But I only want to see each category once. Right now I see the category for each active records.
What I am looking for is a list of categories that have active records in them.
I have Part Numbers and Events. Each Part Number should have 4 different
Event Numbers.
10
20
40
80
I would like to have a query that would show me which of these part numbers
that do not have Event 10, 20, 40 or 80 with it and for it to show which
of these four numbers it does not have.
This hard to explain.
Can anyone tell how to do this?
I have a query made up of a number of other querries. the query works fine and I am able to get the results to go into a form, (I have been advised that calculations, which is what the results are should not be put into a table, so I havent). The query is set up to show results even if some of the origonal querries produce no results, again it works fine. My problem is that when I show the results in a form I want anything that produced no results to show "0". At the present time it just leaves the textbox blank. I need it show "0" in order that furthur calculations can be carried out! Make sense, I hope so!
View 1 Replies View RelatedI have a query that displays tow number fields. Feild1 and feild 2.
I only want to show the feilds that dosent match. If feild one has 50 and feild 2 has 60 then it would show. if feild one has 50 and feild two has 50 then it wouldnt show, only the values would show if they dont match
Example much help needed thanks
i searched for similar combobox features, nut didn't find any that helped.
i have 2 unbound combos that get heir values from different tables
first combo1 gets its values from a query
SELECT [tbl_music].[MID], [tbl_music].[Artist], [tbl_music].[Song], [tbl_music].[CID] FROM tbl_music;
combo2 gets values from
SELECT [tbl_category].[CID], [tbl_category].[Category] FROM tbl_category;
IDs are autonumber and primary
The CID fields in the tables are in a 1..* relationship
Both are constructed with the wizard and the ID columns are hidden.
What i need is:
when selecting something from combo1, the combo 2 should show the right category for that song.
Hope i explained clearly enough.
I tried to use the dlookup function, but i get error 94, invalid use of null.
i'm using the afterupdate event.
I can update a textbox text, but can't do so with the combobox value.
Any ideas what i'm donig wrong :confused: :confused: :confused:
I'm trying to view the last two valuations for each property so that they can be compared. I can pull out the last valuation for each property and can pull out the top two records but not for each property, just shows me the top 2 of all records.
Any suggestions?