Recent content by fredpeters555

found it...thanks all Me.Parent.cmdAdd.SetFocus Just remember...they're only ones and zero's you're playing with. Fred

I have: a mainform called fScoutTrees a subform called qt2000Info subform7. When a subform field Text9 Gets Focus I want to auto-go to cmdAdd in fScoutrees Using DOCMD.gotocontrol, I cant get it to find the control!! Help Just remember...they're only ones and zero's you're playing with. Fred

hmmm...a little deep for me at this point, but thanks loads for the support. I'll start to learn that to get a medium range solution in place. Just remember...they're only ones and zero's you're playing with. Fred

Duane, Thanks for the reply. The query is the record source for a subform contained in the same form as the option boxes.I need it to requery when the change is made. It is also the source for a results report. Just remember...they're only ones and zero's you're playing with. Fred

I have a radio group 'frView' on a form that a user selects the conditon of a field he wishes to filter, displays the results in textfield 'txtViewName1' for the user to view. The query then calls the results of 'txtViewName1'. Codes for both the form and query follow. Although I get the...

GAK!!! if you are inserting a 600 DPI rez image in an email signature, you wasting bandwidth and probably annoying your recipients using dial-up. I suspect that you may be resizing the image once it is inserted into the signature thereby diminishing the quality. Might I suggest that you...

I have a radio group 'frView' on a form that a user selects the conditon of a field he wishes to filter, displays the results in textfield 'txtViewName1' for the user to view. The query then calls the results of 'txtViewName1'. Codes for both the form and query follow. Although I get the...

I'll give it a look. Thnaks for your help Fred

thanks for the quick response. I'll look closely at it I've gone to what seemed like a gazillion ASP pages which all stated that "w" returned weekday and "ww" returned weeks. For instance <% var1 = "5/01/2004" var2 = "6/01/2004" Response.Write("var1 to var2 is " &...

AAAAACKK" says Bill the cat! I need to get the balance of work days left in the current month but I can't even get the number of weekdays beween two hard coded dates. It just wants to return weeks. <% var1 = "5/10/2004" var2 = "5/12/2004" Response.Write("var1 to var2 is " &...

try using &quot;docmd.TransferSpreadsheet&quot; function. Go to the VBA help for this function to get arguments. The only downside is you have to know the name and or path of the xls book

Thanks for the help. It worked very well for me. I did search out help on the FORMAT before I posted but it muast have been just in Access as opposed to VBA. Thanks for the tip on the Expr1 rename. Sloppy practice I've had since starting. Fred

I have a data string inside a control that contains text as well as field data. I would like to format currency, % and dates within the string. It is as follows: =Sum([Expr1]) & &quot; or &quot; & ([text5]/[text6]) & &quot; % &quot; & &quot;of Inventory has not moved since &quot; &...

Ooops...found the problem. The original file was named on an old old machine in a different company branch with square brackets in the name. I never even noticed it but a colleague whom I was asking last week did when I show him the problem on my machine. Thanks For all the help guys Fred

HEY!!! I too just went back to it and tried it again and it worked fine. It must have had something to do with the renaming of the file. Do you want a copy of the original just to see?