Search results

Ok its all resolved now. It was a problem with the Binding Column. Access makes it difficult.

I think I am close to figure this out. I deleted the column and re-added using Combo box. Now I have the drop down choices. However when I make a choice in the Combo box, it changes all of them for all records to the same. How do I fix this?

I might add my Form is configured for SPLIT VIEW, so I can't get the DROP DOWN TO ACTED AS A DROP Down COMBO BOX IN SPLIT VIEW under Form. I hope this makes sense and someone can help.

In the main Table design view, in the Look Up Tab under field properties, there is a setting for Text, Combo, List etc... But that didn't fix it.

Hi, I have no where to turn to except the best place I know where to get the answer :) I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine. I have a form that opens and displays these Fields in a Data Sheet view...

Thanks. Yea I don't know what it means. I downloaded an access db template for meeting notes. You would think by just adding a new field using the same syntax would work,but I think I am missing a , or " or ) is all.

Anyone out there?

Hi, I have a Form, user presses a button to launch Outlook and populate an email. The subject currently has =Replace(Replace("Issue |1: |2","|1",Nz([ID],"")),"|2",Nz([Title],"")) I need to add another field to this called Status. But simply adding the last bit of code bolded there, I get an...

Great response! Thanks for the help, I will test this code out

Thanks again.

1) can someone tell me what this says? If Me.Formfieldname <> Me.FormfieldName Then What does the <> do? Is this equals or greater/than??

The fiscal year starts in July. I did discover DateDiff which could do the calculation but I think a look up would be much easier. The fiscal month/week look up table would be static, I have a weekNum and I could use that to look up the fiscal month. How would I start the look up given that...

This would not work actually. What I need to do is populate the table with the Fiscal Months/Weeks based on a DLOOKUP , can anyone offere assistance? Thanks,

Thanks, some of my months are 4 weeks and some are 5 weeks. Would this still work?

If I want the button to update without adding in the Table Name, since it will be the same table each time, how can I just make it run without entering in the table name? mytable = InputBox("enter the table name") Thanks,

Ok thanks much, I see that it returns the month number and that should work, although name would be a bit better. But I see how it updates the table and thats what I needed. Thanks AGAIN!!

Here it is. Thanks again.

So does access automatically define the TO CC BCC in that order when using the docmd.

I just made a simple form. Date field and a Month field. Thanks a bunch!!

that didn't work. This should be simple like excel , take a date and turn it into a month. Sometimes I hate access... Not sure even how to start coding this up in VB. I am sure its simple but not knowing much makes it hard.