Search results for query: *

Thanks for bringing to my attention , I was not clear. I have started creating the Report in Access, where I imported the data from a excel spreadsheet. I did try changing the margins but get error message. I have snapshot of the old layout instructions . Cards are continuous feed with...

Hello My client needs to print time cards Name, Location , Hours, Location2 on perforated form for time cards. Existing Printer (the Driver) was not installed when new computer was given to office and no one can find the software. I have written a report in Access with the above Data. I...

Hi David This project keeps stopping and re-starting, wish it would be more consistent . Now that I have the green light again I will try your suggestion. All I have is a VB book ):<

dhookoom Thank you so very much . I brought the work home, and I am happy that i was on the right track. Thanks again for your knowlege and support

Thanks for the input. I know very little VB, I will figure something out. again Thanks

History information is in a separate table Tbl_MeHistory.. has everything that is in the Employee Table, I just added item Previous Status and Datemodified

Good Morning Dave, Please bear with me... Self taught with Access When I build this event. Will I do this at the properties of Status for the Employee Table and in the main form. This what I keyed in on the property of Previous Status and it came back with syntax errors Private Sub Change...

i will certainly give this\a try

Hello My task for creating an append query was put on hold.. Now a month later I am attempting it again. It is possible for someone to just give me some sample code on: the task at hand. I have it where information will be entered on Form Subform shows History I need to Update the "Status"...

Hello My task for creating an append query was put on hold.. Now a month later I am attempting it again. It is possible for someone to just give me some sample code on: the task at hand. I need to Update the "Status" in the History Table if Status changed in the Employee Table; and move...

That is IT !!Thanks so much... Thoughts were faster than my typing and phones ringing off the hook. Thanks again

Good Morning I'm sure this is simple, How do you reformat the Report Header.. I need Title of Report second Line on the Title I tried to add a text box 'unbound' and now nothing will print.

Happy Monday !!! Duane I want to do this by way of Form , Once User updates Current table, Update is done in History. Now, my question is , Will I do this on the form properties and on each field property ? thanks

Need to append to this my last reply. Would it really be an Append Action?? If any changes on the record in the Master table , I need that change to update in the History table. We want to keep a tracking report on what changed and I want to add a timestamp . Thanks again to anyone who...

Thanks dhookom, I was just giving a quick example,, NO !! none of the fields are just titled name ):>, It is Lastname, Firstname etc. Thanks again

Hi All Getting into more Access applications , I have a table Current and will duplicate it as History . fields = name hiredate status etc. Once any field has changed I need to update the History table , Data is being entered or change in a form. Not sure how to handle this, but know...

THANK YOU SO VERY MUCH GOLOM Mission Accomplished !!!

Thanks for the FYI On this weekend, I tried that and I was trying to put a dummy date of 99/99/9999 and it returned all with a weird date od 12/30/1899 Field is defined as date/time mm/dd/yyyy here is the SQL code I used UPDATE Tbl_MeEval SET Tbl_MeEval.[Last Eval] = 99/99/9999...

Good Morning All I have 2 (datetime) fields and 284 records are null. I need to have a value in these blank fields. I'm reading about the NZ function, does this only apply to queries. Would I need to make a validation rule in the table if null report 0 , is yes HOW Thanks in advance

Thanks so much.. I'm getting there.. JonFer in the last sql is that saying what is the dateserial is that a redefine of year and then take "Year" in Eval Due and add 3 years ? I'm somewhat a entry level with SQL Right now 80% of records are Last Eval = Eval Due which is wrong; My...