The code below always displays opens form even when field being tested is null.
Private Sub Assign_Classes_Click()
On Error GoTo Err_Assign_Classes_Click
Dim stDocName As String
Dim msgboxstring As String
Dim stLinkCriteria As String
Me.name_found.Requery
[code]....
I have a subform with continuous records. One of the fields in the recordset of the subform is a field named "Remarks". This field does not need to be visible on the continuous subform as it is rare that this field will have any entries.
I plan to apply conditional formatting on another field (IDcardNo) in the record line of the continuous subform so that when field "Remarks" contains any data it will show as a different format on the field IDcardNo.
I would like to make a small form appear when one points to the IDcardNo field with the different format, so that the data in the field "Remarks" pops up when one points to the field IDcardNo with altered format, showing that there is data in the field "Remarks".
One of my forms in the database is not showing some records in a particular field. Although those records are entered through the same form and are shown in the table, yet some of them are not visible in the form.
This is happening only in a particular field, and in that field, some records are shown , and some are not shown.
I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text?
for example:
txtDate is 1/1/1000
if txtDate = 1/1/1000 then display = "*"
but the query still runs on 1/1/1000
I am asking this because I am trying to run a between statement for a date range and the only way I can do the entire range of dates on my table is to use the highest and lowest date possible (1/1/1000 and 1/1/3000) but I only want the users to see "*" so they are not confused.
I am trying to show a certain subform based on whether or not a field is blank or null. This database is not owned by me--it's what we use to run queries and reports on the data on a centralized server for the library. It's not even in the same city--so changing the tables is not an option for me.
So, I have a subform (subform1) that is linked to the main form based on 2 fields (BibID and Item_Enum). The trouble is that the second field (Item_Enum) is sometimes blank, so the subform will not display. So I created another subform (subform2), which is a duplicate of the first one, but this time only linked on the first field (BibID). So, if that second field (Item_Enum) is blank, I want subform2 to display and subform1 to be hidden. If the second field (Item_Enum) is not blank, I want subform1 to display, and subform2 to be hidden.
I've tried putting the VBA code on different events for the form, but I can't get it to work consistently.
There are two problems, one of which I think I have fixed--but I would prefer a better solution. The VBA code doesn't run unless the form is newly loaded. I've tried placing the VBA code on different form events, but nothing works. I want the code to activate whenever a new record is displayed. The work around is that the form IS newly loaded every time the user scans a barcode for a new book. That works now, but if I need to change the way the user looks up new records, this might not work anymore.
The second problem is that the VBA code doesn't display subform1 when Item_Enum is blank. It doesn't display subform2 either, but that's the desired result.
Private Sub Form_Load()
If Me.ITEM_ENUM = "*" Then
Me.subform2.Visible = False
Me.subform1.Visible = True
Else
Me.subform2.Visible = True
Me.subform1.Visible = False
End If
End Sub
I've tried changing the condition to Me.Item_Enum = null, and changing the false/true results accordingly, but that didn't work either. In that case, only subform2 is visible, whether it should be or not.
Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the query is [Forms]![Search_frm]![txtClosed]. If they type a date in here it opens the form and shows the user all the closed records. The problem is they want to see all the records that have no value or Null. I've tried eveything to make this work. I'm ready to jump!! Just kidding. Is there a way to do this with out creating another query. Thanks a bunch!!!
View 2 Replies View RelatedI am relatively new to Access 2007, I am having an issue with a sub form not showing all the data from a table.
Basically I have 2 tables: Headers and Line Details, they are linked via an order number. The headers will only ever have 1 record per order number but there can be multiple records on the line details table.
I have imported the data into both tables. When I open my main form, all the data from the header file is all visable and all correct for all records. However when I look at the data in the sub form, it is only showing data for some of the records.
I have checked and the data is correctly linked, and if I change the "source object" to point directly at the table in the sub form it shows the record is there. When I point it back to my sub form it is blank.
We have a recent issue on client PC. After application running for a while, all the sudden the calculated field on the form not showing the details, though there is data on the control. After restart the PC, the calculated field display correctly. We guess this may be due to the theme we use.
View 3 Replies View RelatedI have a form called PAF_Assignment and on this form there are many textboxes for editing. After all fields are entered, the user clicks on a button and this button populates the PAF_Issued_Date field with the actual date.
Then I want to disable (enable=False) all fields on this form once there is a date on PAF_Issued_Date as I don't want any user to make any changes after submitting it, although the user would still be able to read the information submitted.
I have tried the following...
PAF_Assignment Form AfterUpdate Event
If Me.PAF_Issued_Date=Not null Then
Me.FieldName1.Enabled=False
Me.FieldName2.Enabled=False
Me.FieldName3.Enabled=False
[Code] ......
However this is not working, there is no error message or anything but the fields remain enabled with the date...
I've been trying to populate a field in a form with information, but only if the field is blank.
What I am trying to do is this.
I have a continuous form displaying all of our principals, however when our principals are on leave I want to populate the field with the "acting principal". I have set it up so the field grabs the acting principal first but it is blank for several schools. For these schools where there there is no "acting principal" I want it to grab the substantive principal automatically and populate the field.
I have tried Is Null, Is Not Null, NZ, IF, Where and Then statements but to no avail.
What is wrong with this query?
=IIf(IsNull([OffPeakDay],IIf(IsNull([OffPeakHour],Sum([Import]-[Export]),0)))
What I want is to sum the field (Import minus Export which are numeric) on the form if the OffPeakDay AND OffPeakHour fields are null.
When editing a record in Access 2003, the status bar would show the value of each field's description from the table design grid. Is there a way to get Access 2010 to do the same?
View 1 Replies View RelatedI have two forms. The first form has individual data to include the person's Social Security Number (SSN). I have another form (subform) that has other data to include the person's SSN. I added the subform to the form (linked the SSN). Unfortunately, only the SSN field appears in the subform. None of the other data in the subform appears in the subform.
View 6 Replies View RelatedI have a subform on a form which I load up after the user enters a value in the main form by using the sourceobject property of the subform, the problem i have is that after reloading the main form and the user entering another value, the textbox.value of a control on the subform will sometimes not show the correct value. I am aware that textbox.value doesn't change until the after update event, however this particular textbox is just showing information that has just been queried from the database.
View 1 Replies View RelatedI have a Subform that is inside a Subform that its only purpose is to display some calculations but for some reason it is blank. Here is a screenshot of what I am dealing with:
See that area under "Pump Calc" that is blank...it should have data in it:
Here is the query that drives that data:
And here is a copy of that subform running in form view:
What am I missing?
I have a chart that shows the amount of complaints every month in the last year of a selected costumer. The goal is to see if the amount of complaints from this costumer is decreasing or increasing.
The problem is that some smaller costumers have months without complaints (in real life that isn’t that bad). But my graph only displays a dot for the months were the amount of complaints is not null. This makes that the graph line doesn’t show the complete picture.
I know that I should be able to solve this with an ISNULL expression. I have tried the following SQL code as Row Source of the graph:
SELECT (Format([Complaintdate],"MMM 'YY")), ISNULL(Count([Complaintnumber])),0 AS [CountOfComplaintnumber] FROM [Complaints] WHERE [Complaintdate] > (Date() -365) AND [Costumername] = Forms!Report_complaintscostumer!Combocustumername GROUP BY (Year([Complaintdate])*12 + Month([Complaintdate])-1),(Format([Complaintdate],"MMM 'YY"));
The result of this is that all the months with complaints now get a 0 value and still the months without complaints aren’t shown.
What am I doing wrong? Could someone help me solve this problem? Any help is greatly appreciated!
I have a list of departments, 1-17, where each needs a SUM of their price for each end of day.
At first I was going to make 17 queries, and place each into a new sub-report, but there must be a way to list all 17, even if they haven't had a sale put through.
I've tried linking using "show all values in tblDept and only those that match in tblOrder" - but I cam across a very obvious issue.
The items are grouped by Z1 Number, a unique number for the end of day sales. If there is no department linked to a Z1 number, then it won't show it. For example, if there were no sales in dept01, then there is no record under tblOrder to show a Z1 number for dept01 - so there is nothing to link to in the report.
I was then thinking of creating false data at the end of day so the Z1 number mentioned each department at least once, but that would get messy and not 'normal'
I'm thinking of a type of loop to generate the report so a 17 row report is generated,
I have a table called welding, I want to create a user friendly form for input. The database ultimately wants to go on share point so I am building it in the web database option.
One of the fields is called location, if the location is 'Field' I want 10 more fields to appear for data entry such as weld reason, rail temperature etc . If the location is 'Depot' I want these fields to be hidden as they aren't relevant.how would I do this?
I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)
I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.
I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.
I have an Option Group I created (simple Yes-No) in a form that links to a Yes-No field in a table. I have the default set for this field to "Yes" in the form. The option button works when the form is first opened. If I cange the option to "No", that works. Here's the tricky part that is giving me eye twitches...
If I change the option back to "Yes", the radial button doesn't reflect the change...but it does change the table data! Why do the radial buttons stop changing? Even when I close the form and open it again, the data in the table is no longer reflected with the buttons in the form.
I have 64-bit, Access 2010.
I am trying to show the Current Repair Estimate total in currency form on my report. The attachment shows my criteria, which works on the query, but does not show in the report. The second attachment shows what pops up when I try to view the report. What can I do to get this current rep estimate to show correctly in currency form on the report?
View 8 Replies View RelatedI have a question about reports in Access. Is there a way for report fields to be omitted from the report if the database value is null?
For example:
Name: Joe
Last Name: Smith
Company: (Is Null)
website: something.com
would become.....
Name: Joe
Last Name: Smith
Website: something.com
thanks!
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
I think the title pretty much sums it up....
I have a query where data is first sorted by user input; first field's criteria: [fieldname], then by another field's criteria: Is Null.
I know there are records containing null values in the second field, as I have run a select query with the criteria: Like "*", to make sure they are null, and not zero-length-strings.
The query is refusing to return any results...
Any ideas?
I am using workdays to calculate time passed between two dates. I also have a table for Holidays that I don't want counted as work days. This is working well, but I would like my queries to show a null value instead of showing #Error when a date field is empty. Here is my coding in my Module.
Option Compare Database
Option Explicit
Public Function Workdays(ByRef startDate As Date, _
ByRef endDate As Date, _
Optional ByVal strHolidays As String = "Holidays" _
) As Integer
[code]....
Trying to run a query using criteria to populate the query by looking at information from a field on a form, if from is closed I need that criteria to look at the table and return all date in table.
View 14 Replies View Related