Search results

My assumption is that by removing one of the items in the list, the For Each statement gets confused. If the items in the list stay selected, but the one is gone, this I would think you could do the For Next code again (and again, and again) until there are no more items selected. I would...

That has to be done in the OnFormat and/or OnPrint event of the section that will be printing Field1 and Field2. Field3 will ALSO have to be defined in that same section, but as .Visible = False unless you really do want to print Field3

It looks like it can not be set programmatically. I have tried several different ways to make this work without being able to change the height of the subreport control, but all to no avail. What I tried was to create 3 subreports, one to do the first 1/3 of the name, the second the next 1/3...

The only way I know of to start an auto number field at 0 rather than 1 is to add the 0 record with an Append query. And, because it must be the highest number in the table if you want it to be the starting point for the next number, the table will have to be empty before starting.

There is a query that the wizard must have built for you to access the data from the table for the form. Open the form in Design view, open the properties window for the form (press the F4 key), select the Data tab. Record Source is the first property listed here for the Form. Select it and a...

If you look through the routine I posted, you will see that it is getting the start date for all these Mondays from the earliest date in your table. If that is not what you want, then all you need to do is provide, within that area of the code, the actual Monday that you want the weeks to start...

I don't understand any of what you are trying to explain as a problem with your "Firstly" explanation. Right now, in the sample you sent it takes 9 clicks to get to the last record because you have 9 companies in the Company table. At least the first 4 look identical from the glance I gave...

Ed, here is the further stuff you asked for in your email. I'm posting it here for others to learn from, and the answer will be in the next post.

The Last Contact field on your form gives you #Name? because you did not include this field from the table in your query. Add this field to the query to solve this problem. The CallBack date gives you #Error because the name of the text box on the form is "CallBack_Date" and the name of the...

Ed, I did a compact and repair on the database you sent to me, then put it into a Zip file, and have now attached it to this post so others can look at it if they desire to help also. I did not delete anything, it was just the compact and repair that took out all the "air" that Microsoft leaves...

If you notice, the first 10 bytes of the selected row have the start date of the week, and the last 10 bytes of the same row have the end date of the week. By just referencing the list box after you have selected a specific week, what Access returns to your reference is the whole row. So, by...

Create a new database, and from that database use the File menu, Get External Data option, browse to the "real" database, and then select the forms and tables necessary. Before sending the database, go through the tables and make sure there is no data in the table that you should not be sending...

If you need to sort the stuff in the list box, then the query that is the RowSource can identify those fields as sort fields. If you need access to that data as one of the columns in the list box, then include them as columns that are set to a width of 0" and you can still get to the column...

That means you need to name the module that you put the code into some other name. I would suggest you put "bas" in the front of the name that it already has. Therefore, it would be named "basWeeksToSelect" By the way, who is Ron K?

If you could post the two forms and the table(s) they are built on in a new database with just those objects, that would help. Table(s) do not need to have any data in it(them). I would offer suggestions on what the problem could be, but I can't think of any. Seeing the objects always helps.

Gannet, I went through your calendar form and put in the little calendar form I had sent for you to look at. I did some non-minor modifications to that sample calendar form so it would work. I was quite sure it would speed up the opening of the calendar selection form with all 12 months on it...

If you have the year in a field that is a Date field, then you can group on that field and specify you want to group by Year, then you can set the interval to 50. This is all found in the sorting and grouping for a report.

gemma-the-husky, I think you missed the idea behind the concatenation that I showed. Each column is cut off at a certain number of characters. There will be no running into the next column. But, some data sure might not been seen. And the way Access does a list box is that it truncates data...

rolaaus, Thank you for the idea. Rather than using tabs, which I'm thinking would not work. It's too logical, therefore Microsoft will not allow it.:( But, by defining the font for the list box to be Courier (where every character takes the same space), then blanks can be used to fill in the...

LadyDi, If you get any more errors, show us your code that produced the error along with the error message. Otherwise it is just a guess when trying to help you. Ryan (GolfProRM) is doing a great job for you here.