Search results

Do you have SQL or a query name as the Object Source for the form and subform? Or does it not matter?

Paul, I'm really getting my game back, so I'm really looking forward to you getting all the way over the hill to my area. How was the Ridge? I love the course, but it eats me alive each time I've played it. So, why do I like it???? :) pablotx A batch process would be where you write one...

The new calendar form that I supplied as a sample uses labels rather than text boxes, so the switch was from the original calendar to the form I supplied as a sample. The choice was to use the sample form rather than make changes to the original calendar form to incorporate the ideas shown in...

Looks like you have 42 labels to change into 42 text boxes. If you did not know this, you can right click on a label, then select "Change To", then choose Text Box. I have not found any way to do multiple labels at once.

Each individual's database on their own laptop would have to know who is using the database, and have a specific code for that person to be included in each record created while in the field. No matter what table has new records created, each record would carry the users code. I would also be...

WhatsInTheLabel = me.LabelName.Caption

If you have not used your two free support calls to microsoft, I would suggest using one of them of this. After two or three days I normally give up and call microsoft. It's quicker and less painful than continuing to not have the thing fixed.

What I don't understand is how do you want to use this check box and calculation within a form.

Look up the Format function in Access help, and in Access VBA help (from the VBA editor). This: format(Now(), "dd-mmm-yy hh:nn") gives: 22-Feb-08 09:57 and this: format(Now(), "dd-mm-yy hh:nn") gives: 22-02-08 09:57

1. Import into Access 2. Create query to read columns 1 and 2 (CompanyName, Employee) and append this into to your table. 3. Create query to read columns 1 and 3 and append this into your table. Then do columns 1 and 4, then 1 and 5, etc. Be sure to not append a record if the Employee X...

This is one of my favorite things to hate. But, Microsoft is in the business to protect us from ourselves. But, here is the Microsoft Knowledge Base artical that explains how to fix this: http://support.microsoft.com/kb/303650

Are you, per chance, using the same query for both the subform and the main form? If so, changing the query for the subform would of course change that query for when the main form uses it.

Within Access you would have to parse the html yourself, but then you would have the problem of having to use a rich text box to display what html can. The other idea, which I like better, would be to write the html code in the message to a temp folder and file with a suffix of .html. Then you...

Rolaaus, If you do a two pass thing, the second pass should be from the high end down to the low end. If you delete item 3, then you have lost all the items numbers above that. Because once you delete item 3, then item 4 becomes 3, 5 becomes 4, etc. But if you start at the high end, the only...

This appears to be a great link that needs to be read before posting questions. It might help get an answer much quicker. It's title is: How to Ask Questions The Smart Way. This is the official link for this forum.

This is the part that makes no sense whatsoever, at least until we know what is really meant by it. Until these words I "knew" what was being asked.

Use the Sorting and Grouping dialog box. You get to that dialog box while the report is in Design view, then use the View Menu, and the Sorting and Grouping option is about 1/2 the way down. In the Field/Expression column, select StudentID. In the area at the bottom of this dialog box, change...

If you want to print the value of three records (three different services) on one line of a report, you will need to do that within the footer of the BusinessName, or at least whatever the three services would be tied to. Because the 3 services records would be processed (but need not be...

No idea what you are trying to say. Please reword, then think about what is written to see if someone who has no idea what you are doing could understand what you want.

OldestDate = DateAdd("yyyy", -1, Date())