Search results

cover your bets I've been married 21 years. One thing I have learned is to cover my bets. Buy whatever you think she will like for lingerie...assume she may not like it and have a backup. Usually something in a diamond like a diamond necklace, ear ring, etc. . Good luck.

subform Are you sure your subform wasn't originally a single form? I see now where the subform you are using is a continuous form.

Combo Box Why Not just create a combo box on your form that displays those 4 fields? When the user starts to type in the lastname the combo box displays it immediately. The user will know if the consultant is already in the database.

db to db Check this beast out http://support.microsoft.com/kb/298174

Access Per your comment :Please don't use very complicated software language is this is possible as I don't understand a lot of the computer design jargon. If I may, I think before you proceed any further you should buy a beginner's Access book to become familiar with tables, queries, forms...

A query You can not use the format in the table to do this. I created a query for you Golf Club Data Query that does what you need. Open the query and scroll all the way over to the right. You wil see the wtwo fields in proper case.

lines Don't see the new report. No vertical lines in the db you zipped. By the way, you have a line in the page footer. Delete that, and then on the right side of your report in design view adjust the width so that it is snug to the right side of your right most tex box. That's why you are...

lines Place the following code after the Next statement Me.Line (900, 400)-(900, 16000) Me.Line (3500, 400)-(3500, 16000) You should see this now.

lines Can you post your db?

lines Put this in instead and you should see it. Me.Line (1000, 1)-(1000, 4000), , B

lines rem out the me.print statement If you don't want to use a loop for the vertical lines do the following: To create some vertical lines just put a few lines of code after the Next statement like me.line (0,whateveryvalueyouwanttostartat)-(0,whateveryvalueyouwanttoendat),,B me.line...

column heads To my knowledge this is not possible but I've been wrong before. Why not just use a label instead at the top of the listbox and set to bold?

assumptions I made the assumption (yep, I know what that means) that you were entering your data through a form. So, in the afterupdate event of that field you could place the above code.

text Use vbpropercase. me.MyString = StrConv(me.MyString, vbProperCase)

focus Try putting this in the gotfocus event of that field Me.ActiveControl.SelStart=0

report Create a new report in design view. Use your table as your record source. In the page header place your column labels. Place text boxes in your detail section of the report and set the data source to the fields in your table.

lines in report Place the following code in the On Page property of your report. It will print 25 lines down the report no matter how many records you have. You will have to make a few adjustments. Let me know if this gets you in the right direction. If you play with the x,y coordinates and...

No mouse wheel May I ask why you don't want users scrolling through records using the mouse wheel? Just curious. Thanks

Continuous forms I don't believe it does..atleast not like Access.Try this link. It may help. http://groups.google.com/group/microsoft.public.access.forms/browse_thread/thread/4894ac45e7226b24/8d0a63483fbdb4a6%238d0a63483fbdb4a6

I have a dream Very impressive!! Looks like a lot of time, effort, and talented programming went into this project.