Hi, Is it possible to assign a value to a text control on a report during the report_open stage, I know I can assign the value to a label but it doesn't...

Hi, I am generating a report that have several values. What I want is the summation of these values into one textbox (like calculating the total). I have...

Hi all, this is statement in a print event txtWholeComment = mstrWholeComments txtWholeComment is control on group section, mstrWholeComments is string,...

I have a drop-down box which is populated at form load by a query from a look-up table in the database (the query captures a number and the corresponding...

Hi all, Is it possible to assign special null to a var in VBE. clara thank you so much for your help

Hi, In my report, I have several negative number. I want to highlight the negative number to Red by using the following code. Private Sub...

I need some ideas on how to solve a problem. Excuse me for the length of the post; I’ll be as concise as opssible. I need to create a report in which weekly...

I have a Access 2003 front-end with DB/2 Back-end containing two tables. Primary table name is TST_FR_CASE_RECORDS. This table has Primary key of two joined...

I am looking for assistance using the Concatenate function by Duane Hookom to display data in the details area of my report horizontally. I am using Access...

I have a drop down list and want those items in the drop down to be associated with certain values. How can I achieve this? For example: drop down = walk to...

Greetings**** Why the associated label will not grow/shrink stimulatingly as the text does? I have several text boxes that grow/shrink based on the amount of...

Ok, this may sound like a stupid question, but I was working on a report & I'm not sure what I did but now I've lost field associations/control source. I am...

I have made a report that takes its parameters from a form. What code should I write for the OK button so that when a person presses enter on the keyboard, it...

how to set a print button on report? when i preview the report after that i can click the print button to print. -- Message posted via...

I am using Duane Hookum's At Your Survey to analyze the results of a research survey. I need to be able to generate a report similar to the Statistics...

Attach a label to a database I am trying to attach my labels, in an access report, to a data table that has the field defined. Ex: CY = 2009 PY = 2008 So...

I have an unbound text box on a report that shows the date from data typed in an unbound text box on the form (menu) from which the report is opened. The info...

In my database, I've given the enduser the ability to upload files to a network drive and I record the file name, path, and RecordID in a new table. I haven't...

I've attached jpeg files to my table. The problem is that the attached pictures are not as clear as the original pictures. How do I clean up the images in...

i have managed to create a button which will create a pdf of a report of a single record and attach it to an e-mail ready to be sent, but doing so does not...