Search results

response same error =Nz([myfield],"0") #Error

response I am using this formula in the control. In the query this report is based on has this field. what is nz()? thanks

I never use Access reports so I am struggling. I am trying to do this for a report field. =IIf(IsNull([field]),"n/a",[field]) I keep getting ERROR thanks cheers

response It was inherited and it will be 2 cubersome to re-design. My main form has one table behind it. When a user selects the vendor name from the list box, I need the vendor name and vendor number to be stored in 2 sep fields on my main table. The list box is created from a vendor table...

response My list box does populate the vendor name when the drop down is selected. Not sure how to populate 2 different fields at once this way. When the vendor is selected I would need the vendor name and # to be populated on these 2 sep fields on the table. thanks

I have a form with vendor name. I also have a second form with my vendor list and corresponding vendor number. Here is what I want to do. When a user selects vendor name from the drop down list (this is already in place), the form would match vendor name in this form to the vendor name in my...

Thanks Bob Cheers! :D

one more question thanks for your help but where does it fit in? I am clueless with VBA. Do you recommend any training sites also? here is my code ' test2 ' '------------------------------------------------------------ Function test2() On Error GoTo test2_Err DoCmd.Echo False, ""...

reply I am not good at all at VBA Right now my macro opens a union query and then transfers the results as the text file on my desktop. Can I run this VBA in my macro? thanks!

I have a macro which transfers a fixed width file to my desktop. The name is neppow.txt. Can I have this file land with the date dynamcially populated in the name? Example: neppow_20070308.txt today neppow_20070309.txt tomorrow thanks!

How do you copy a table and paste structure only to the same table name as the ony your are copying. Is there a delete table then rename tabel command? thanks

I don't know how to write code Can I delete the records and compact within DB using a macro?

response I am going to keep the autonumber field and create a new field for this purpose. Just not sure how to handle.

I have a cumlative DB that exports a file daily based on what was keyed daily.. Therfore, every day I am sending only new records from the DB to a vendor. I was using autonumber to assign the record number but they now want the record number to restart at 1 for a new days worth of data entry...

thanks thanks to all I am all set

answer I am tring to paste into a text field 8 bytes. The text box is formatted as yyyymmdd. I even formatted last change date to yyyymmdd and it still does not work.

Need more help To expand this: I want my last change date to be copied into my text date 8 bytes via a macro which I know how to do in my form. I formatted the text date in the form field as yyyymmdd but I keep getting an error stating that my field needs more bytes to accept the data? Even...

I capture last change date on a form using now(). When I export the file my vendor wants the date to be a text field and 8 bytes in length. It has to fill 8 bytes like this - YYYYMMDD Example in my form - 3/1/2007 8:11:55 AM I need to convert this to text - 20070301 when I export my file...

thanks there are so many fields that I was looking for a quicker and easier method, if possible

I have 3 tables which I export as 3 separate text files each having different fixed length records. Is there a way to append these three tables together? Union all does not work because they have different columns and field lengths. I really need to figure this out today. thanks!:confused: