Search results

There is no button, but i did find out that there was a requery macro tied to an event, i took that out and it seems to fix the problem. Thanks for replying

My form with the subdatasheet is doing strange things with i view the data. It is not always consistent when this happens which makes it harder for me to figure out what the problem is. I hope someone can help me. Here is the problem; when i click on the plus sign to view the subdatasheet...

The Me stays, dont replace it. It referrs to the open form or report(instead of typing the real name of the form Access will assume you are referring to the current form). The only thing you replace is the field name.

I agree that it is stupid to only work with an input mask, does yours have one? Mind is very simple, i just put 999, all that is going in each field is a 3 digit number. Should i be putting something else as the input mask? Thanks for your help!

Pat i tried your suggestion but it still doesn't work, i checked out the help for this feature and it mentions using an input mask, so i added one and it still doesnt work, what could i be doing wrong?

You need to put the following code in the "On Click" event; Me.[fieldname].Selstart = 0

Is it possible to have a form go to the next field after update without tabbing? i.e. i have 4 text fields that will always have 3 characters in each; if i type the first three i want it to fill in the first text field and then if i type the next three i want it to fill in the next text field...

Thanks for replying back so fast! It works great!

I have a City/States table and i have an Address table. When a user selects a City in the form the user then fills in the State field. I would like to automate the State information so i tried to add the following code in the "after update" event of the city field. set...

I know i have done this before but my mind is drawing a blank.... I have two fields, City and State; i would like the State to automaticly fill in after the city is selected from a combo box. I tried the set value in a macro and in code in the After update event of the City field, but nothing...

Actually it is working fine now. I dont know why but i closed out and went back in later today and it works fine.

I tried to create a new field in a query using the IIF function but didn't get the results i wanted. The same IIf function works fine in my report but when i tried to do it in a query it wouldn't. Here is my iif function: IIf([Payee]="Beneficiary",[FullName],[Payee]). If the payee is a...

never mind i got it, Thanks for your help

Thanks Pat, however when i went to the Knowledge base to look it up i got this message "Content that matches your query is not available at this time. However, Microsoft adds new documents regularly, and may provide information similar to what you are looking for in the future. " Is there...

I understand how to concatanate fields but the problem is it isn't 3 fields its 3 records. ie, i have a table called contracts and another table called people. For every one contract there are many people tied to it. I have a mainform with a subform showing this info. After the names have...

Can you write code in an unbound control that would merge data in a field from several records. ie. a subform has a field named "Owner", the subform has 3 records. I would like to put all 3 owners in one text box separated by a comma. Is this possible?

I dont know if this is possible, but i need to build a query (probably more than one) for a mail merge doc in Word. My word document a basic contract. In the contract there needs to be a merge field for multiple names, ie. firstperson, second person, etc. Depending on each contract some will...

Change the code on your Switchboard button to just open the report, then add the following code to the field in the report: =[Forms]![My_Switchboard]![Combo8] That should work.

Thanks everyone for your help, i did get it to work using Harry second suggestion. Works great! I will take alook at the solutions db on the web site. Thanks again to everyone for your help.

Here is what i did: The following code is tied to a command button on the first form DoCmd.OpenForm "SecondForm", acNormal Forms![SecondForm]![CountyID] = Forms![FirstForm]![CountyID] Works great! Hope this helps