Recent content by ROSEK

Not sure it will really matter for my application, thought I am not sure what the difference is

Minty, Not sure what was going on. It is now working. Crazy Monday morning issues

I am looking to add the current week number to the header of a report. I know =Date() will return today's date but I am looking to convert that to a week number I tried =DatePart("ww",Date()) in a text box on the report but it is not working. Any suggestions?

perfect thanks

Arnelgp, Here is the database I started but still having an issue with the partial copy of a record in the same table. I know there is a pre made command function to easily copy the entire record but I would prefer if we only copied some information. Then went directly to the form for that new...

Thanks Arnelgp. Maybe this is not the right code for what I am trying to do. We do mostly of one off mechanical builds for our customer but sometime get a repeat job. In those case we would want to copy an existing record but not all fields as the PO #, start date and end date would be...

I am trying something similar to this but having an issue. I am trying to copy a record within the same table but only want to coping 7 fields. I tried the following code but get a compile error (Invalid use of property) every time. The debugger highlights the rs =CurrentDb. I am using...