Search results

Thanks! I think it is along the right path; the report now comes up, but it is blank and shows no data... Can I change it to pull from the form the PositionTitle, Activity and also the option for "Any" in the Activity box rather than using the Activity2 box? Private Sub PreviewReport_Click()...

I have an application supply file database that will pull a single application list of multiple applicants for a certain job and certain office. The problem is this report has to pull data from a single table, but several things are playing out in it. I created a form with the following...

I created a report database that rely's on both default data and user entered data. Unfortunately the default data is going to be different for each office and needs to be easily updated as needed. So I created a "default data table" and named it DefaultData_tbl; and has these field names in...

I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such: The initial is 30 days after supervision started or annual performance report completed The midterm is 120 after supervision started or...

As soon as I changed it from "text box" to a "label" as you said...it worked! Thanks again everyone for helping me do this!

I think I got the string error fixed, I did have it set to Date/Time; changed it to number and it works. But, it says the object does not support this property or method: .MoveFirst strCurYear = !CurYear If strCurYear = strTstYear Then Me!lblCounter.Caption...

This is great; how would I phrase it to send as Snap Shot Format with the email address list and subject automatically put in it? Email: first.last@mody.mil Subject: Taskers

Now I am getting a Run-time error '3421': Data type conversion error on the red part... Else .Edit !CurYear = strTstYear !Counter = 1 .Update Me!lblCounter.Caption = 1

Sorry; column name is "Number" not "Cnt."

First, I sincerly appreciate the help with this! I am learning a lot by playing around with this and I appreciate your assistance! Now let me say "Duh; what a yo-yo!" I put the End Function at the end; can't believe I missed that; thanks! I changed to column names to "Yr" and "Cnt." I...

Great help! Got me off to a wonderful start; thanks! Here is what I got: Table named "tbl Count" with 2 columns..."Year" and "Count" (nothing else). The format for the "Count" column is "0000" and is formating the numbers correctly as 0001 automatically. However, the report is acting stupid...

I am working on a report that gets printed once or twice a week. The manager would like this report to print the year and the increment number (for that year) on the report. For instance, when the first one for 2007 is printed the increment number will look something like 2007001 and the...

There are 5 total options for them to choose from for "status." I thought about this option, but how would I ensure that numbers 4 & 5 are intermingled together and not separated when I assign these numbers in the table? The problem came in when 4 & 5 were also separated into their prospective...

I created a report that lists names in alphabetical order according to their status. The status choices are MSP, THP, VET, NAF and OTH. These are chosen from a dropdown menu in the form which pulls this list from a status table. In the report I must list them in the order above but without...