Search results

OK, so i make a query with the two tables tblclients and clientcleaner and have the fields clientid from tblclients and clientid from clientcleaner and then for the criteria have =Null. This hasn't worked. Can I have simpler instructions please?

Yes, However some people can have a few preffered days like.. monday, tuesday and wednesday. So thats why I used the check boxes for each day.

I have a table (ClientCleaner) linking clients and cleaners together with id, clientid, and cleanerid. However, I want to have a query of this table to find out what clients do not have a cleaner.. and another query saying what cleaners do not have clients assigned ect. the clientid somes...

Hi yes, im looking to make some sort of query that will reccomend you assign cleaners to clients, depending on what days the cleaner is available and what days the client preffers? Also after I have done this it would be good if it could depend on other things like star rating, address which I...

I have a field (Text9) on a form and would like to have the code to be able to add the value of that field to a table once every month. The database wont be opened everyday so it would have to be nearest to a month if not exact? Any ideas? Thanks, Dan.

I would like to have a textbox on a form: That adds up the amount of money in query 'CurrentClients', Column 'And'. The data in this field is currency.

Thanks alot!!

1)I have a listbox (List51) and a Tab Control (TabCtl13) with two tabs: the first "Clients" and the second "All Info". I want to be able to change the tab from Clients to All Info when a record is selected on List51. 2)Another thing I would like is.. I have a button on another from with the...

It all works great.. Now I'm wondering how you can delete a client/cleaner relationship in a form with a control source to tblcleaners. I'd like a button saying "Delete client cleaner relationship" - Any Ideas?

It works great!!!

Thanks alot, really appreciate it :D

Select Case between two dates VBA I am trying to change the visibility of a label depending on a date in the Next_Payment_Due text box. I have used the select case method eg: Select Case Next_Payment_Due.Value Case Is >= Date - 25 PDS.Visible = True Case Is <= Date + 5 Case Else PDS.Visible =...

Thanks alot, and sorry for the snide remarks

Great Thanks!

I manually know how to export emails from ms outlook. However I do not have the code for this for ms access. Any Ideas?

Where do i put this vba code? Access?

So as Outlook and Outlook express are different email programs. Would Outlook import to access? Is outlook better for my situation?

And how would I do that?

Ahh ok then, Is it possible to sort the listbox in order of column 3, saying the ones that are <today (past dates) at top, then equal to today() in middle, and then the ones >today() (future dates) at bottom. That would be good?

Hi, I would like to have the code to import any email from a specific person say (dan_james11@me.com) and also (johnsmith@me.com) to a microsoft access table called tblEmailImport. I would have a table with To, From, CC, Subject, Body, Title.. ect. I've heared this can be done somehow...