Search results

Use a form linked to the text boxes on the report to change the text and then open the report using that information. View this thread http://www.access-programmers.co.uk/forums/showthread.php?t=91468

Thanks for the insight and the help!

I have a a table that changes monthly, and each month I need to find the records from the old table that are not in the new table and visa versa. I made the entire row in the table the key. and wrote two find unmatched queries. However, the queries are not finding all the information that is no...

Thanks Pat!! your the best Thanks Pat!! your the best

Sorry Pat my mistake I am using a linked table and just copied part of it in! See above problem this DB shows the error. thanks

Pat anyone can you tell me what I am doing wrong?? attached is a sample. attached is a sample can you tell me why the form will not populate the text box for the report (or the lables)??

I have a an employee table and am setting it up to print labels for different distribution lists. however sometimes the labels need to be marked "Confidential" or 'Conflicts" etc. Is there a way to have a pop up box open on report open with a pull down menu to pick the heading of the labels???

OK I got it must of had a brain fart I used an append query and made the four fields my key. thanks anyway...

I have a table of 50,000 reccords. The table has 8 fields of theses eight fields I want to remove duplicates based on 4 of the fields in a query. Is there a way I can do this and keep the uniqe identifyer so that after the duplicates are removed from those 4 fields I can match them back up with...

I have a button that runs a macro to insert NOW() into a text box. This is how it is coded; Private Sub Start_transferred_job_button_Click() On Error GoTo Err_Start_transferred_job_button_Click Dim stDocName As String stDocName = "Start transfered job" DoCmd.RunMacro stDocName...

here is a start This is a start to get you linked to your email system

forgot the attachment!!! The buton runs a macro

I have a burron to run a query that auto populates 'start time' with NOW(). It has worked for 3 years and now I get an error message see attached. The only thing I did was change the program fromm 2000 to 2002. any and all suggestions welcome. Thanks

thanks for all the help but now that I am totally confused. If this is my SQL query: SELECT [Attorney Profiles].[Client Name], [Job Log in].[Client Number], [Job Log in].[Matter Number], [Job Log in].[Completed on Time], [Work Type].[Work Type], [Job Log in].[Number of Pages], [Job Log...

thanks but I have one more stupid question. What do I put in (your date) ??

I have a table with a "NOW()" field I need to change the now() to a Date() in a query so I can pull information by date values. Because of the time in the now() field it pulls incorrectly. I have tried this: cdate(int([job log in]![time qc totally complete])) this will give me what appears to...

all I did was change the program from 2000 to 2002

Always willing to learn more

I am pulling data from tables into a query and running a form off of this. The form contains a macro on a button the when pushed places NOW() in to the start time field. it use to work but now it will not work on the form or query however, I can still update it in the table. I recieve an error...

Thank You very much much appriciated just sorry I wasted so much of your time while I was sitting here having a brain fart..