Recent content by Namsha

Awesome!! Worked......Sometimes the simplest answers are right in front of your face but you don't see them for the forest is in the way. I can expect anything and everything of myself; But can only accept or reject what you have to offer!

I am trying to create an envelope that when there is no street or no PO Box it trims it out completely and doesn't leave a blank line where a street or PO Box would be. Thanks for your help. I know to use If ISNULL but from there kinda lost. I can expect anything and everything of myself; But...

I think I figured it out in the query. I made up an Expr: [PO_BOX]& [STREET] and set the criteria to is not null. Thank you anyways I think your way would work also. Just looking for easier envelopes. Nina I can expect anything and everything of myself; But can only accept or reject what you...

I am trying to print some records (envelopes) but don't want them to print if the po box and street are null. I have the following code: If IsNull(me.PO_BOX AND Me.STREET) THEN This is where I am not sure what to put in because if they both are null I don't want to print that particular...

You could always hard code it in vb or behind the report but most of the time you can change a control, setup your page, fix the control then resave the report. Access is funny like that you have to have change in order to be saved. I think your best bet is hardcode behind the report! I can...

I have used headers but that puts it on two different lines.....what about IIF functions? I can expect anything and everything of myself; But can only accept or reject what you have to offer!

I would respond but you know well enough what you wrote..... I can expect anything and everything of myself; But can only accept or reject what you have to offer!

When are you using this form? How is it disappearing? And I think I need more information before I can answer this. I can expect anything and everything of myself; But can only accept or reject what you have to offer!

Question!!! Can't I just fire up the appendme query and on vbyes = true fire the delete query? I can expect anything and everything of myself; But can only accept or reject what you have to offer!

Let me be more specific.....On click, a command that fires an append query if my client chooses to append the records to the table and it is successful then I want to delete the records in the previous table. I think what I need is a function that fires, and yes I did learn VB.....took less...

I need a function to append the data to another table then pop up with a message box that requires a yes or no answer and if yes deletes data from original table.... I can expect anything and everything of myself; But can only accept or reject what you have to offer!

YOU ROCK!!! I can expect anything and everything of myself; But can only accept or reject what you have to offer!

I am trying to create a label with the & such as: Markets & Food How do I create that as a literal character without the program thinking it is a concatenated field? Nina ;cl I can expect anything and everything of myself; But can only accept or reject what you have to offer!

I am trying to create a label with the & such as: Markets & Food How do I create that as a literal character without the program thinking it is a concatenated field? Nina ;cl I can expect anything and everything of myself; But can only accept or reject what you have to offer!

How can I merge one company name and many records attached into Word? Is there a way to do it with the merge functions? I can expect anything and everything of myself; But can only accept or reject what you have to offer!