Search results

Hello All I don't know what this part of the form is called, if it has a name? In any case, it's VERY small. Can i enlarge it, or is there is simple way to replicate its funtionality with controls on the form? Including the search? Thanx Al

Hello Friends With the help of many of you here on the Accessworld forums I have created a VERY simple membership app for a local non-profit I volunteer for. (I know this sentence ends in a preposition, but I was afraid 'for which I volunteer' would sound a bit stodgy.) Grammar aside, I have a...

Hello form forum friends I created a very simple form using the blank form option on the ribbon. It has two buttons. One button with a macro opening a query to create a table I use for a mail merge. The second button has a macro calling the word mail merge wizard. This works fine, but the form...

Hello All I have a query that runs perfectly. When I copy the SQL code from it into the click event of a button I get a compile error. The SQL is a bit complex but as i said it runs fine in the query. SQL... SELECT Demo.PREFIX, Demo.FNAME, Demo.LNAME, Demo.PREFIX2, Demo.FNAME2, Demo.LNAME2...

Hello fellow keyboard pounders I'm not sure if the query or general form is the right place for this queston but you guys have been great so I'll start here. I'm trying to creat a Word mail merge from an access query. I can't get Word to find my query. I tried both initiating form Word and from...

Where can i find out how to close a thread and incate the it answered my question? Is there a place for housekeeping instructions? Thanx Al

Testing a simple report for a new page for each record. 'Force new page' is set to 'before section' in both Prefix and Detail headers? What else do i need to do? Thanx Al I

Hello Access Friends I have a simple membership applicaion. I have imported legacy data, and all is working well. Now I'm working on output,letters(from Access report) to members. My problem arises with the creation of the greeting in the correspondence. The membership record can hold the name...

Hello Access Friends I wrote a longish post for the query forum. I wrote it in google docs and it contains a snippet of a sheets spread sheet. When i tried to post it i received this message: What did I do wrong? How do i contact and Administrator? Thanx Al

Hello Access Friends I want to concatenate three fields in my table into a new field. When the first field in empty I do not get field2 + field3 Yeilds: I hoped to see the last+first without the prefix The sql looks like this: SELECT Demo.PREFIX, Demo.FNAME, Demo.LNAME, [prefix]+"...

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...

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...

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...

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...