Microsoft Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems.

Click Here to Post a comment and start a new discussion!

SQL to insert PDF doc into table Link
Eric Michalek

Today 9:04 am

Did some research and still can't figure it out.
The goal:
A form where users drag and drop in scanned (PDF documents). So far I am using a bound object frame as it gives me the thumb nail view. Then they click a command button that fires off an insert into SQL statement. Read More...

Richard Rost
Today 9:06 am

Honestly, I've never done this before. I did spend a few days trying to figure out ANY way to do drag-and-drop with Access just using text boxes. Couldn't do it. Access doesn't support drag-and-drop without 3rd party add-ons, and I hate those. Personally, I'm against storing objects like PDF files INSIDE your database. That makes it big and bloated (and slow). I'd recommend storing them in a server folder and putting links to them in your database. I talk about this in my Imaging Seminar.

Add a Reply

Creating customer reference number Link
Sue Warrington

Today 7:42 am

Hi,

I have a table which stores all the information about a case study relating to specific projects i.e. one project can have many case studies. I would like to create a unique Case study refence number (via a form) which needs to be a combination of project number and sequential number. e.g. 14SIP091.01, 14SIP091.02; 14SIP092.01; 14SIP092.02. I've been trying to use Dmax and concatenate with the project number which doesn't work. Has anyone else managed this and point me to some sample code. Many thanks Sue

Richard Rost
Today 7:45 am

I just showed how to make a custom incrementing order number in this TechHelp video. The Extended Cut Member's Edition shows how to make the invoice numbers unique for each customer, which is almost exactly what you need (projects instead of customers).

Add a Reply

select customer with combo box Link
Fred Evans

Today 7:42 am

Hello Richard,
I have a table of customers
I have a combo box on the heading of a form. the idea is that the combobox will display a list of the customers following my entering of the first letters of the customer name and allow me to scroll down the list to find the required name. when I click the required name the customer record must display in the body of the form. Read More...

Richard Rost
Today 7:49 am

Sorting the combo box alphabetically is just something you set up when you create the combo box. The wizard gives you a sorting option. Run through the wizard again and recreate the box. As far as the search goes, Access Beginner 8, lesson 6 covers creating a Search Combo Box.

See... this is why I love the badges next to your names. I can see that you're a Beginner student and can answer your question accordingly. There is a better way to do this, but it requires programming. You'll get there. For now, this is the best solution for you.

Add a Reply

New TechHelp Videos Link
Richard Rost
Sun 8/9

Howdy Access Lovers. I just wanted to make a quick post to let all of you know about the new TechHelp videos I've posted in the past week or so.

I'll post this here as a digest maybe once a week or so. If you want to get notifications as soon as I release new videos, make sure you Subscribe to either my YouTube channel or the Computer Learning Zone News page. The TechHelp videos have become kind of like a daily video podcast for me. I love making them, answering questions, etc. Read More...

Add a Reply

Contact Form Link
Austin Ritner

Sat 8/8

When I select a customer to add a new contact in the subform, I select them from the combo box, type the message in the notes section, save and close.

I open the contactR and the name doesn't show up. I feel like something is linked wrong.

Alex Hedley

Sat 8/8

If you open the ContactT does the record exist?
If so what is its CustomerID (foreign key)?

Richard Rost
Sun 8/9

Make sure you Refresh the record before opening the report. If the little pencil is still showing in the record selector, the record is dirty which means it hasn't been saved to the table yet. The report won't see it. Refresh then Open Report.

Show 2 More Replies...

Add a Reply

Show Older Comments...
View in Table Format