Search results

Thanx GP I put the referential integrity late in my efforts, thought it might help. Made no diffrence. I DO want to place the gift type NOT the key(id) into the payments table. Again Thanx

I have a very simple Membership application. only Three tables, Demographics, Payments, and a gift_type table to supply the list of gift types to the gift_type field in Payments No matter how I set the Bound Property in the listbox the list box returns column 1 (the id) Columns are set to 2...

Quite a bit of interesting ideas, but did not solve my problem. Thanx Al

Hello New to Access & having a problem Executing a Word mail merge from an Access button. I have a Word Doc that I have successfully merged with an Access Query. Google's AI provoded the following: To run a Word mail merge from an Access macro, you would use the "DoCmd.TransferDatabase"...

Thanx

Hello again, I have a query and a word mail mege doc. I can manually go through the mail merge steps to generate the merge. What do I need to know/do in order to launch the mail merge from an Access control (probably from a switchboard)? Thanx Al

Sorry Doc & Others I looked for my earlier post on formatting & didn't see it. I thought I must not have posted properly & reposted. I didn't intent to repost. Again, sorry Al I started a new thread as the forum wouldn't allow me to reply to the thread

I have a database built on imported external files. The phone numbers in these files were stored with formatting. That is the number is stored as 999-999-9999. I know that best practice is to store raw data & format it for display however, if i start to do that now I will have the numbers stored...

I have created an access database by importing external data. The data i have imported has the phone field stored with its format ie 999-999-9999. I know this is not best practice but if i store my new data raw I will have the data store in differnt ways. I'm thinking this will cause future...

Thank you Access community... You have given me a few things to look into. I think I was having layout problems. Again thanx, it's good to have friends.

MajP, the question was more general. I'm not trying to solve a problem with a particular form. More, should I be using the form wizard or is there a better technique that would still be suitable for a newbie.

No problem using the form, i had problems trying to edit the form after it was created with the form wizard.

Hello Acces Brother & Sisters I'm new to access and have a question about how I should think about creating subforms. I did a few experiments with the subform wizard and was happy with the results except for the fact that the form was difficult to edit after it was created. In my previous life...

Thanx Doc… I’m 75. My 4 year old grandson, who is good with numbers informed me that when he’s my age I’ll be 154. Hmmm.

I'm old. There, I said it. I did quite a bit of database work in Ashton Tate dBase, Foxbase & then Microsoft Foxpro & Visual Fox. That being said, I have a foundation in database theory & practice. I've been out of the loop for 30 years, but have recently volunteered to help a non-profit with...