Search results

I have a listbox (list14) that displays 3 columns. The row source is SELECT QryPaymentsDue.FullName, QryPaymentsDue.[And], QryPaymentsDue.[Next Payment Due] FROM QryPaymentsDue; I want an if statement to say that if column 3 (Next Payment Due) is <Todays Date then the row colour to flash red...

Hi, I have used this idea and integrated it with my database. I have had trouble with one of the forms as it says an error code and does not work, wheras the client form does. I will attach my database to this (.zip), and if it is possible for you to change one of the forms to work (the one...

OK so create a new table called tblClientCleanerJunction and then add those field names, in the design view? I would like to do this, but unsure on how to link the cleaner with more than one client as they can clean for loads? and how to get in the tblpersondata cleaner name to have the...

Eventhough the checkbox situation would be easier, our company needs to have all cancelled people in a certain table because it causes more problems for other code in the database, if it is a YES/NO field. I am sure it is possible and would owrk if you could copy data into another table...

Hi, I have two tables [tblPersonData] and [tblStaff]. When I go on a form to add a client (tblPersonData) there is a cleaner textbox with a dropdown list with cleaner names. I'd like it if when you select a cleaner and save the record for the database to copy the client name from...

I need a button on a form, that when clicked on copys the selected record from table [tblPersonData] to [CancelledClients] and when this is successfull to delete the record from [tblPersonData]. There is a dropdown list on the form where you select a name from [tblPersonData] the details come...

Yes, it would be easy if you added instructions as not everyone is going to know how yuo have done it. Also I know the line of code and did not ask you for an essay of how you'r amazing but what to type in for the word template, as when I add something, say "C:\Desktop\TFY.doc" it says an error...

I am unsure of what you, mean. There are no templates to click OK for and when I click "Add New Template" what shall I enter in the box, ect.. ?? Is it the address of a file or something - can you explain more simply as I'm new to mail-merge with MS Access? Thanks, Dan.

I'm unsure about the template most of all... like shall I do C:\Desktop or something like that in there.. and what word file do I put in there??

OK, I have that form downloaded but now I need to change all of the code to documents for the word, and the tables ect.. ?

Right I have changed the design to Mon, Tues, Wed, Thurs, Fri, Sat with Yes/No boxes. Now I need to say on a querie: If clientnames perffered = Mon And Cleanernames Day Working = Not Mon Then Reccomend. If you get what I mean.. So I need a list of client names next to cleaner names that do...

Hi, could I please have the actual mail merge VBA code for one button, "Mail-Merge this Client" and another "Mail Merge All Clients". I have a table with each letter in one column and the address on disk of letter in the other. I have a list box with all of the letter names and I'd like the...

Ahh right and then what about the criteria, so if Mon = True and Tues = True and Wed = True then show cleaner with Mon= False or/And Tues = False or/And Wed = False something like that isi?

Ok thanks mate, I used the Sub Form option and its working fine.

Ahh right, can it be bound to two tables or queries?

Heres a basic Access file Of what I'd Like.. Theres 2 tables for clients and cleaners. One query showing client names, preffered days ( what days theyd like a cleaner), cleaner names and Working days ( what days the Cleaner is working at the moment). So really its if there a day the client...

I have a table for clients and a field preffered days , with data like "mon, tues, thurs" for example and I have a table for cleaners and a field working days, with data like "thurs, wed, fri" For example. would like the query to display Cleaners that have 1 or more of the same day as the...

I have a database and a form with the field-records of the table "tblPersonData", I have a button saying "MailMerge this Client" where on click I'd like a word file come up with this clients details. And also another button saying "Mail-Merge All Clients" and it would mail merge all clients...

Wait, I don't have a drop down menu and don't want one. I just want for when the form loads the value of Text14 to say the value of Query1 For Example. As Query1 adds up all of the data and I need the value to go in the text box. Any Ideas? Thanks, Dan.

Ok, I've made the query summing up the amounts. And then in control source I have put = [Quarterly Pay]![Quarterly]. But it doesn't show the value but says name! So what contol source for the text box shall i put? Thanks, Dan