This could do that.
Code:
=IIF(Isnull([Previous Start Date]or isnull([PrevAssnEnd],Null,[Previous Start Date] & " to " & [PrevAssnEnd])
Rozeanna Jerry
Last Activity: Jan 13 '11, 06:48 AM
Joined: Sep 22 '10
Location:
-
SO that means if one of the dates are blank then nothing should be shown:
This could do that.
-
Thanks..worked out for me..Leave a comment:
-
How to Add Hours and Minutes to current Time .
Hi every one..I am trying to add 8 hours 15 minutes to current time and show the new time on a text box. How would I do that.?
For example if the current time is 8:00am then adding 8 hours 15 minutes should show 4:15pm.
Please help.
Anna -
Hi TheSmileyOne, to your Question (POST#9), the subform is filtered by the StudentID, and the combo box in the subform select a record which is related to the Student, and therefore want to go to it. But Does not.
You understood me correctly:
Main form: Combobox select a student, and main form goes to that student.
Sub Form, Combobox 2 (within subform), select a timesheet (Date) and subform goes to that timesheet record....Leave a comment:
-
You have many fields that you wish to access thier records on a form for each. This might pose a problem. Try and uplaod the db.
The easiest way to proceed with uploading a new database would be to create a new one, and then import from the original database the relevant forms/tables, and then just check that its working before uploading that new database.Leave a comment:
-
Please upload the mdb file as zip and I'll have a look.Leave a comment:
-
Hi, am so sorry for the late reply. I was editing my existing db for confidentiality sake; do not what to publicise in forums like this. Anyway I came up with a similar db which is attached below. If you have spare time please have a look and reply.
**I was also thinking of just doing a search based on date entered on text box instead of combo but don know if that is possible.
A Bunch of Thanks!!
Ann...Leave a comment:
-
I do not really understand you properly but if am correct, try create a data sheet form, bound it to your table, in design view, create a text box and set its record source to the field of the table.
You can also create a query based on the table, select the desired field from the table. Now sort the field by ASC or DESC. Create a data-sheet form based on the query you created.In design view, create a text box and set its record source...Leave a comment:
-
If I understand correctly:
Main form: Combobox select a student, and main form goes to that student.
Sub Form, Combobox 2 (within subform), select a timesheet and subform goes to that timesheet record? Please confirm.
Hi, Thanks so much. What you presumed is 100% correct.
I could not upload the md file b'cause it's heavy..60MB. I'll try and delete some objects and send. AM so sorry for the late reply.
But...Leave a comment:
-
simply make the sub-form's controls unbound. Go to sub-form's properties-Data tab- and clear the record source. No data from subform will be written to table.
I'm just wondering why you do not want to save records to the table... ???Leave a comment:
-
Facts & Flash back: sub-form form is link to main form by studentID (Child and Parent keys).
Sub-form displays a filtered record based on a combo from Parent form. The problem arises on the second filter combo within the sub-form.
I was just thinking that filtering a filtered sub-form would pose that problem. Because if combo filtering is working in the sub-form's own window but not working within the parent-child form then...Leave a comment:
-
is ok/fine.Code:Msgbox "[TimeSheetId] = " & str(Nz(Me![Combo12], 0))"
However,AndCode:Me.RecordSet.FindFirst "[TimeSheetId] = " & str(Nz(Me![Combo12], 0))
Does not work in the Main/sub form but works perfectly in the sub-form in its own window. Any suggestion as to why this is happening? Obviously the sub-form doesn't...Code:If Me.Recordset.Nomatch Then msgbox "Record not found"
Leave a comment:
-
My code#2 in post #1 works when I open the sub-form in it's own window. But does not work when I open the form with MAin+Subform. SO I was thinking that I would have the combo in main form and clone the subform recorset to find the selected record from combo. something like.
...Code:Private Sub Combo12_AfterUpdate() ' Find the record that matches the control. Dim rs As Object [B] Set rs =[/]Leave a comment:
-
Any ideas would be appreciated. Anyway thanks for the link.Leave a comment:
-
Hi TheSmileyOne, Thanks for your assistance.
Replacing my code with your code gives this error message.
"Runtime Error 3464: Data mismatch in Criteria Expression"
...Code:Private Sub Combo12_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone [B][U] rs.FindFirst "[TimeSheetId] = '" & str(Nz(Me![Combo12], 0))[/][/]Leave a comment:
-
After Update Event does not work.
Hi Experts, am new to access. I juts created a form with sub form based on two tables having 1: many relationship.
The main form is from tblStudents and subform is from tble attendance.
First on main form I choose student name from a combo box and records for that student is displayed on the subform in form view.
1.*...Code:Private Sub Combo14_AfterUpdate() ' Find the record that matches the control.
No activity results to display
Leave a comment: