Search results

So now I understand what you mean by run the report before any data is input. Thank you for clarifying that. Good questions all of them. Answers to them are as follows. I am not always the only person that will run these reports, and the other users might not always remember to run the...

June7 you are correct, I just haven't made a lot of reports, I am used to just using that term regarding things on forms and other areas. As I said though I am learning. I will adjust myself. I am uncertain of what you mean on this statement you said "If you want 31 rows regardless, run...

Oh that is working so nice, it meets more than one of my things I wanted to accomplish. If someone forgets to input a date then it is skipping a line as I needed it to. then if you go back to the form and input the missing date it is filling it in the correct spot on the report.

Nevermind I figured it out. I had moved the original date field to a portion of the report that was not the detail section, so it was limiting it.

Ok, I need to back up a step. So when I go into the report view after getting this working as I stated. The dates I put in the form are 1/1/25 and 1/2/25. However, when it is in print preview it only shows 1/1/25 for both entries as the date. I am confused as to why this is doing this.

Ok, I am taking this one step at a time, right now I am trying to get the date field to be empty. So I have put the IIF statement you made, and put it in the D_Date field. Renaming the [D] to txtDate as my field is named. It simply gives me #ERROR in that field. So i put a new text box in...

Well for what my date is set as I had to modify it a little for the date SELECT tbl_DailyRandoms.ID, Days.D_Date, tbl_DailyRandoms.[1A], tbl_DailyRandoms.[1B] FROM tbl_DailyRandoms RIGHT JOIN (SELECT DateSerial(Year(Date()), Month(Date()), [ID]) AS D_Date FROM tbl_DailyRandomsDummy) AS Days ON...

So from a query?

I saw that after I posted the DB to here. I have since corrected it. It was supposed to be 1 to 31, simple typos from my fat fingers.

I didn't realize I had 32 in there, I guess playing around with that number I left 32 in there by mistake. Putting 31 gives me the correct number of spaces/lines I need.

Oh I missed that last question, my apologies, I need there to be exactly 31 lines. One for every day of the longest month. If there is only 30 days then there should be 1 blank line at the end.

Should date be unique? The dates are all unique, there will never be a duplicate date. There will however be dates sometimes people forget to enter when the business is closed, like for Christmas and New years day, etc... So after the fact I usually go in there and input the missing days on...

Ok, I was able to finally get the boxes onto the report as I wanted. I am having 2 issues right now. The first of which is, I want each page of the report to be a different month. So basically if November was the first month of days entered I want that to be the first page, then December the...

I just tried to input that as the record source for the report and it wants to build it as a query.

its does some, but what is confusing me is this portion "then change the report's record source to:" Am I supposed to change the "field1, field2, etc. to my actual field names? I know I change the table names, but not sure about the rest. I know its because i am dense at times. But I am trying.

Ok, I am at this point now where I need to create these esthetic boxes on 3 separate report. I will need lots of help, so please bear with me. Right now I have created 1 table called DailyRandoms where the data is stored and a dummy table called DailyRandomsDummy with the same number of fields...

Ok, this works really well. It is doing what I need and I can see how I can add on to it. Thank you, saves me a whole lot of unnecessary code writing.

June7, I have multiple aisles, and each aisle has several sections below it. The initial code is from a different part of another form that I thought I could use for this part.

Okay, I have this working how I want, but the problem is I would have to write this 8 times, is there anyway to make this work without writing this code 8 times? Dim i As Integer If IsNull(Me.txtDate) Then For i = 1 To 3 Me("A" & i).Enabled = False Me("B" & i).Enabled = False...

Ok I am running into a bit of a problem on this. It works for single fields. However, I have 3 fields in each aisle that have to be enabled when both the txtDate and the Aisles fields are populated. My thinking is no so robust, all I can seem to come up with is 1 line of code for each field.