Search results

yes and i think the variable's are wrong somewhere.. getting nowhere with this

I have a list of folders in a source folder as follows Source Drive John Doe Sub1 Sub2 Joe Bloggs Sub1 Sub2 and a folder list as follows Destination Drive John Doe Joe Bloggs The names are determined by a subform with a list of names so the database knows the assignee name...

Worked a treat thanks

Button to run the code.. The mainform fields create the Mainfolder and subfolder. I need to then create assignee folders in the subfolder based on assignee values ion the subform/query.. E:G Mainfolder subfolder John Doe Harry Trueman the Here is the code i currently use to make...

I am looking to create a list of folders based on the Assignee field in a query. so if i have 30 records, i would like 30 folders created with the value of the Assignee field in the query. I can do this for a single record but not multiple record but not multiple. Can you Help?

I have a button a form which is a file picker. 1. click the button it opens an explorer window. 2. choose the file, which then records the file chosen in an unbound field in the form called Text3403 3. looks at text3403 and moves the file to another location renaming it to datetimesecond...

Genius!!! so looking a the string we have first condition, second condition, first result, second result, else Would that be right?

Yes this would be the case until terminated date is populated. then it would be Unclassified.. Registered_Date and no Terminated_Date = Classified Registered_Date and Terminated_Date = Unclassified Why i need 2 conditions for Classified or i endup with UNCLASSIFIEDCLASSIFIED

Thanks Guys.. working on it.

Need help with this one guys. I have a calculated field called Classification: when date is null it calculates the word "UNCLASSIFIED" pretty straight forward but i cant quite get the syntax for 2 conditions.. Like if [Registered_date] is not null and [terminated_date] is null then calculate...

The tickbox is a field on the table. before this was a manual tick but i am trying to get the code to tick it for me based on the condition of the date field. i was going to discard the tick box completely and have a calculated field on the query showing result but thought i would accommodate...

I have a date field on a form and VBA after update event if the date field is null it ticks a box, if it is not null it unticks the box.. code works but when i close form it gives me a write conflict.. someone else has changed the record. I have also tried adding me.dirty=false at the start and...

Solved this one. basically used a combobox as a filter on the subform and only shows the records i need. Thanks for all your input.

yeh ive done that already but how do i get the listbox to go directly to that record? do i need additional

I have a listbox on mainform that goes to a specific applicant when clicked.. ="[Applicant_ID] = " & Str(Nz([Screen].[ActiveControl],0)) the issue i have is the applicant has a subform with more than one record, how can i filter the form to goto the specific record on the subform reported on...

Minty your solution worked.

Here is my code but i would like it to report Medium Date Medium Date.. the actual field and table format is medium date. Code: between the" & " " &DateAdd("m", -1, Forms![TRHA]![Medical_Due_Subform].Form![Medical_Due]) & " " & "and" & " " &...

Cant really send you that. the date fields are Medium Date format and are actual fields in the table. if i take out the + 30 it works

Still the same. regardless of what date i put in.. it shows the button.

If [Last_date] < ([Due_Date_Field] +30) Then Me.Update_DD_Button.Visible = True End If