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, you can watch Access Beginner Level 1 for free, and then purchase Level 2 for just $1.00 here. 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.

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

Drop Query or Table onto Form Link
Timothy Smith

Today 1:51 pm

Have you seen an issue with the new Access where in form design it will not let you drop a query or table on to the form? I am having this problem and I cannot seem to be able to figure this out.

Richard Rost

Today 1:54 pm

I've never seen that before, but that's not something I ever do. I never put tables or queries directly into form. I always make subforms first and use those. I just did a quick check in a sample database and it's working OK for me.

Anyone else having this issue?

Add a Reply

Recent Files Link
NORMAND CARON

Sat 7/11

When i select File/option/Recent Files. The options are grayed out. Why?

Richard Rost

Today 3:48 pm

Where exactly are you? Do you mean File > OPEN > Recent Files?

Add a Reply

Fill In Fields Link
Richard Gioia

Sat 7/11

Which course will explain how to create a combo box to fill in fields? I created this box, but I dont want to enter an employee number first. I want to use first name or last name to find the record, then select it and have all the fields filled in. Every time I do it, it fails. Its like it cant use text as the look up. Help!. Where do I find the answer to this?

Richard Rost

Sat 7/11

I would need to know more about what you're trying to do in order to answer this question properly. Are you just dealing with one table, or are you trying to pick an employee and fill in their information in some other table, like a time sheet? Sounds to me like its the latter. If that's the case, you need to learn about relationships. I start covering that in the Expert series. I do a little bit of using a combo box to select a value from another table in Access Beginner 8, but you really want Access Expert 1 for all the details. I see you've only completed up to Access Beginner 3, so I would say just keep learning. We'll get there.

Richard Gioia

Today 6:15 am

Hi all! I am a new student. Above was actually my question. I am trying to use this for. To track employees that call out the day of their schedules work day. I use the comp box to search the data base with all employee records. I want to search be first name, instead of employee number. I then need the records to populate in this form with First Name, last name, employee number, department, etc.

Show 1 More Reply...

Add a Reply

Does Your Web Site Use Access? Link
Timothy Smith

Sat 7/11

I have a question. Is your web site using Access?

Richard Rost

Sat 7/11

I used to use Access MDB files for storing data on the web server, but I upgraded to SQL Server as a back-end about a year ago. I outgrew Access which is just fine for small sites. but I've got over 40,000 customers now, and I could have 100 people active at any given time. Too much for Access to handle.

Timothy Smith

Sat 7/11

Was the active users the only problem, or was there a limit on the amount of data which could be housed?

Show 8 More Replies...

Richard Rost

Sat 7/11

Active users. An Access Database can store up to 2 GB of data, and even then you can use multiple MDB or ACCDB files, so number of records isn't usually the problem. Number of concurrent active users is. When you get even a moderately sized database (10,000 records or so) and a few dozen or more users hitting the database at once, Access starts to slow down A LOT. Like I always say, it's a great small to mid-sized business database, but if you get more than 10 or so users, you need to upgrade your back-end. You can still keep Access as a front-end (forms and such) but SQL Server is definitely needed for high-VOLUME databases.

Richard Rost

Sat 7/11

Plus a database SERVER speeds things up a lot as far as processing goes. If you want a list of your customers, sorted by email address, with orders between January 2019 and now, Access would have to pull ALL of that data through the wire, sort it, filter it, etc. A database server can crunch the numbers on the server side and only send the relevant data down the wire. So for networked databases on a LAN, a server makes sense.

Richard Rost

Sat 7/11

On a web server, only the relevant records are shown in the browser, but the way an Access database is handled in the background is completely different than the way SQL Server (or MySQL or any other server program) deals with the data. It's much more efficient. Access files have record-locking issues and don't deal with many concurrent users that well. So if I have 100 people on the web site and they're all trying to view their Course Listing, it can slow down. I used to have the Theater database in an MDB file, which I thought would be fine because there's only a couple hundred classes. But if I got 200 concurrent users, the site would crawl.

Richard Rost

Sat 7/11

Now that I've got the site running on SQL Server it's much faster. Almost every page you see is pulled from my database. I built a "blog engine" where I can edit pages in my web browser and post them and they look like real pages. Everything is stored in a database, backed up by the minute to my off-site database by a routine I run in-house (another Access database LOL). Plus GoDaddy (my ISP) backs up everything too. I've had enough crashes in the past where I'm very skeptical now. I back up EVERYTHING.

Garry Smith

Sat 7/11

Do you have a course that shows how to have an access database online such as a google site?

Timothy Smith

Sat 7/11

I think I am over building my Access database. I have one table with 17K records in it already. I haven't seen the problems yet which I have seen before. Hopefully I will get it all built correctly. The information you have provided has been very interesting and I already know I will need to switch the back end to MySQL. I have been very afraid to mess with it as I have tried in the past and cannot seem to get it to work. My boss will definitely like it better when I switch to MySQL and give him some web pages to use to use the database on his Mac.

Richard Rost

Today 3:52 pm

Garry: I have a couple of lessons where I show you how to load web sites from Access using the WebBrowser ActiveX Control including Access Expert 24 and the Web Data Sync Seminar. However in Access 2019, Microsoft has a new Browser object that is native to Access and part of the normal Control Box. I'm going to cover how to use this soon. PLUS, you can also use XMLHTTP in your VBA code to pull data from a web page without using any form controls. Real cool stuff, and that's coming up soon.

Richard Rost

Today 4:01 pm

Timothy: any reason for MySQL and not SQL Server?

Add a Reply

Record Monthly Pricing Link
Stephen Egan

Thu 7/9

I have setup a list of investments, must like the Customer list in your Access Training. When you select an investment you get a detail form for that investment. There is sub form for updating the price of that investment. Im trying to create an append query that will add the list of investments to the table so I can use one form to add the new price for each investment each month. Looking for ideas

Richard Rost

Thu 7/9

See if this Student Attendance tip gives you some ideas.

Add a Reply

Show Older Posts