Search results

rick, After some thought, I would put your text in a table. This table doesn't need to be related to the others. When you want it in a report then use the following code. DLookup("[MemoField]","Table") If this is the only field/record in the table then no WHERE clause is needed. This will also...

Mihail, nanscombe please don't hijack this post. I find it very rude. If you have a question use this post as a reference. Thank you, Dale

I think I have the idea. Let's step back a little and break it down a little further. We have a cover sheet. I assume you are not having any problems with that. Do you have the reports created? Let's start with cat 1. What is need for that only. I asked about variables and fields. Can you clear...

Function removeFilter(source As String, combo As ComboBox) 'source is the field being filtered and combo is the current 'value of the combobox With Forms("PART_QUERY") .Filter = "[" & source & "] = " & Chr(34) & combo & Chr(34) .FilterOn = False End With Your Combo...

Place a label close to the text box and use it to display Weeks. Dale

Why? Do you get errors? Just doesn't work? Wrong data returned? Dale

If it is the same for all reports AND has Bold and Italics. I would look at putting in the code behind the report. Format it just once and call it when you need it. If you put it in the table with the other data you are storing lots of data you don't need to. You can format it. put it in a...

Welcome to the forum. Dale

What situations? Please, 1 post 1 question. You will get better answers. Please explain Issue 1 completely as to what you have and what you want to do. Do you have variables or fields? Variables are for code and fields are for records(data). Dale

Try YourCombo Box.Requery Dale

Docmd.OpenReport "YourReportName",acViewPreview,YourQuery,,AcWindowNormal Dale

Memo field, set to can grow. Set Text Format to Text Rich to get the Bold and Italics. Dale

Not sure I understand you completely. First a form with more than 5 pages. You need to explain further what you have so far. Sound like you may be having table problems if you need over 5 pages of a single form. Can you copy and paste your tables from relationship/design. Dale

What application are we talking about? Excel, Word or Access? Dale

your database and your table. Dale

I stopped in/joined my first Access forum about a year ago. I had questions and needed answers. I had no real knowledge of how or where to look up answers. I ended up joining 3 forums and try to give answers to others having problems. Just answering the questions has taught me as much about...

I was working on query not the Dlookup(). All wrong. MORE COFFEE IS NEEDED. Dale

requery the form. Dale

Under FILE/OPTIONS/CURRENT DATABASE/Document Window Options. Dale

Sorry, Got all backwards. Thanks Paul. Dale