Search results for query: *

I have a spreadsheet in which I keep track of student's performances in several evaluation points. Row 1 of the spreadsheet is dates (beginning with column C), column A of all subsequent rows describes the evaluation point. The remaining cells in the worksheet is where I enter values (1...

EBee, If I remember correctly, Access does not allow you to set the focus to the textbox that has the focus. If you have another textbox on the form, set the Exit event of the textbox1 to send the focus to textbox2. Then on the GotFocus event of textbox2, send the focus back to textbox1. If...

Thanks to all who have responded. You've all given me something to think about and play with. I'll continue to mess around with the styles as, again, this is something I have not used before. Thanks again!!

GeoCan, Thanks for the response. I'll try what I'm attempting to accomplish with textboxes. If you read my response to Doroth you can see that if the textbox won't "autoexpand" this may not work well for this particular application as I fill in textboxes with sometimes relatively lengthy...

Doroth What you suggested is exactly what I want: text to remain dynamicly where I place them. My current purpose for this is in filling out a form in Word with several textboxes within it to be completed by myself, much like a contract. I have created a template for this and I would like...

Gerry, I do see now what you mean by PAGE setup and how my desires were conflicting. Is there any way of accomplishing what I'm wanting without placing paragraph marks (pushing the enter key some number of times) to force the proper placement? Something like text boxes or something in VBA...

Aaron, Copy the contents of the calculated cell by highlighting it. Then click in the cell in which you want to paste the value of the calculated cell. Click Edit on the menu bar and select Paste Special. In the dialog box that opens select Value under the paste section. Make sure None is...

I am trying to vary the verticle alignment of text on the same page of a Word 2002 document. I have attempted to do this by inserting continuous breaks at the end of each section and then setting the verticle alignment on the page setup tab to the appropriate alignment. However, it doesn't...

Not sure if this will work, but what about applying a filter? Create a query (query1) to include botht the room and the container fields. In the criteria for the room enter [forms]![formname]![roomfieldname]. Then in the LostFocus event of the room field on the form do the following: dim...

This may be what BNPMike is talking about, but I believe if relationships have been established between the tables and referential integrity is applied, a record must exist on the one side of a one-to-many relationship. I had a similar problem before and I couldn't enter a record on the many...

Prufrock, Not sure if this will work, but in code, immediately after the query is opened or the SQL is run, couldn't you use the SelectObject command? DoCmd.SelectObject acQuery, "queryname" Not sure if this will work if you are talking about a true switchboard, but if you are talking about...

Craig, Regarding adding a new record: there are a host of ways in which you could do this. One is with the wizard. Create a command button as you did before by clicking on the Command Button button in the Toolbox toolbar, then clicking in the design grid where you want the button to appear...

Craig, I just noticed your response to BNPMike. I think I've answered most of your questions except for your first question. Personally, I don't think basing a form on a query is any better than basing one on a table. When you base a form on a query, you actually are basing your form on a...

In the database window, click on Forms under the Objects heading on the left of the database window. Then double-click "Create form in Design View". A new form will open up. Double click the dot in the upper left corner of the form near where the word "Detail" appears. This will open the...

Gary, Thanks for the idea. I obviously hadn't thought of that. I'll give it a try!! Thanks much!!

I have a command button on a form (form1) whose OnClick event is to launch another form (form2) for the user to enter a parameter for a query. After entering a name in a textbox on form2, clicking a command button on form2 displays a report. In the report header, I have a textbox whose value...

I have a text box on a form which can contain multiple lines of text from the result of a query. I have set the CanGrow property of the text box to Yes which allows the text to wrap as desired. I would like to space the lines of the text a little more from one another. If I set the Line...

Ken and J, Thanks for the response. J, I'll try your idea, but in the meantime, Ken, if you wouldn't mind, I'd like more information on how to perform your suggestion. I'd like to see an example of the user defined function, not only just to learn more, but I've got repetitive components of...

I have a subreport which is based on a query. This query has a "calculated" field which is as follows: Readdress: [Street]&" "&[City]&", "&[State]&" "&[Zip] The Street, City, State, and Zip fields are within the same query. This combines the above...

Thank you all! The formatting works exactly how I needed it to. This is a helpful reminder of the custom formatting that is available in Access. Thanks again!