Search results for query: *

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!

When you create a form, parent form, you can create a subform in that form which then links parent to child(subform). I haven't tried to use the same subform in more than one form but it shouldn't be an issue........I don't think I quite get what you need......maybe more of an explanation is...

Looking for tables of information on City/State/Zip or Software that has all the Cities in any country along with Zip codes in order to make my database more efficient. Thanks for any and all your help in advance I can expect anything and everything of myself; But can only accept or reject what...

Come again? You are using a subform in more than one form? I am not sure what you need here...... I can expect anything and everything of myself; But can only accept or reject what you have to offer!

I have a printed screen try to email me the report and I will try to figure it out then send it back. I can expect anything and everything of myself; But can only accept or reject what you have to offer!

Do you have those tables set to a query? If not try setting them to a select query to make sure you have your one to many relationship and obtain the correct information, i.e. one company name and many phone numbers. Then connect that to the report and do the each value. I can expect anything...