Access 2007-2013
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

Forums     

Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Access 2010 by Mike Y @ 3/13/2017
I am a novice to Access.  I have a database with two tables, one for the patients table, name address, and the other for recording visits table.  I want the visits form to be populated from the patients with their name and address so eliminating having to type the name and address every time.  I would like to use a combo box to select the name I need.  I have set up a form from the visitors table and a combo box and used a macro Me.txtfirstName.Value=Me.CboPat.Column(2)for each field, but it does not work.  Do I need to link the two databases together using an ID and relationship the two?  this is where I lack the knowledge.  Is there a course I could download to follow my problem?


Reply from Alex Hedley:

Get the chosen value from the Combo and display it on the next form.
/tips/access/forms-formname-field-notation/
You should have a Foreign Key in your Visits table of PatientID, just set this value to the combo.
You can then use the column Property of the Combo to display the name.
Show Just This Thread        Post Reply
Read Using Access 2010 Runtime by Ken @ 10/13/2016
I have completed the Beginner s videos of Access 2010. What I now would like to do is to launch a sample database that I have created using Access 2010 Runtime. This will be on a computer that does not have any version of Access installed. Eventually, I would like to have a user be able to add new records through the forms I have created and to publish reports (also already created) without having to have the full version of Access installed.
I have downloaded and installed Access 2010 Runtime on a clean computer. However, the Access database file will not open.
What are the specific steps necessary to open and use an Access database with Runtime?
Regards, Ken


Reply from Alex Hedley:

Create and accde file in the Save As.
I think you can then change the extension to accdr.
Show Just This Thread        Post Reply
Read Access 2010 in Windows 10 by Ray M @ 8/10/2016
I recently indicated that Windows 10 was preventing my use of the tool bar to access the header/footer controls.  This remains the case in that this control is not enabled.  
I have determined that by right clicking on the form, I am able to complete the function I thought was otherwise missing.
Problem solved
Show Just This Thread        Post Reply
Read Access 2010 in Windows 10 by Ray M @ 8/8/2016
I am using Access 2010 in Windows 10. I am attempting to use the lessons from Access 2003, and find that all of the controls do not work as I anticipated.  Particularly the header footer control is not enabled, and therefore does not work.
I no longer have Access 2003 installed on my computer, and only have Access 2010.  
Is there a way to have control over the tool bar, and over the header footer control, or is this something that Windows 10 took away from me?
Let me know how this can be handled.

Thank you


Reply from Alex Hedley:

It's likely to be a contextual ribbon, and only show up when you are editing a Header/Footer?
Show Just This Thread        Post Reply
Read Tracking Student Attendance in Access 2010 by Keri N @ 6/27/2016
In the video about Tracking student attendance, there are several references for which I would like more information.

How can I sort the list by homeroom using a combo box? I've tried several things with no luck.

How do I advance the date by one?

And, finally, is it possible to clear or reset all of the yes/no boxes once the "go" macro has been run? Again, tried all the tricks I thought would work.

Thanks in advance...I'm so glad I came upon this tutorial as it will save me TONS of time!


Reply from Alex Hedley:

You want to pick a value from a combobox to sort the form?

Do you want a button on the form that you click and add 1 to the date?
DateAdd

Checkboxes

Dim chk As CheckBox
Dim Ctl As Control

For Each Ctl In Me.Controls
  If Ctl.Properties("ControlType") = acCheckBox Then Ctl = False
Next Ctl

Show Just This Thread        Post Reply
Read Tracking Student Attendance in Access 2010 by Keri N @ 6/27/2016
I stumbled on the solution by accident and not where I expected! Thanks :)
Show Just This Thread        Post Reply
Read Access 2010 hangs if used with o 365 by leo polla psemara @ 6/26/2016
I tried to install access 2016 runtime but system doesen't allow it. It says that we have to uninstall o365 first ??!
Anyway , i will post the exact text
Show Just This Thread        Post Reply
Read Access 2010 hangs if used with o 365 by leo polla psemara @ 6/26/2016
Well, the oficce 365 package does NOT include access, access 2016 is incredible expensive. We decided to keep on access 2010 and this is the reason we didn't upgrade access.

I have in my future plans to take some seminars from your valuable and second to none training site however I cannot afford it money and time wise right now.
I don't think that email seminar will help in this office 2016 and access 2010 malfunction


Reply from Alex Hedley:

Ah I didn't know that, we've got it at work so I assumed it came with it.
The Email Seminar covers sending email via SMTP so by passes SendObject.
Show Just This Thread        Post Reply
Read Tracking Student Attendance in Access 2010 by Keri N @ 6/23/2016
I'm thrilled to find this specific attendance tutorial as it is the exact solution I need for my application. HOWEVER, when I try to edit the Visual Basic (11:28 in the video) my Convert Macros to Visual Basic option is disabled and I can't make the necessary changes. Help?


Reply from Alex Hedley:

Is this an embedded macro?
If it's a macro in the navigation pane the option should be available.
Show Just This Thread        Post Reply
Read Access 2010 hangs if used with o 365 by Leo Polla Psemata @ 6/22/2016
Hi
I am using an Access 2010. Recently we installed office 365.
Unfortunately  the DoCmd.SendObject method hangs Access 2010 if we have to use the Outlook 2016

Is there any way we can work around this problem ?

In our office Access was giving the working pace and make a our emails easy to make in uniform with a very descriptive subject.
Now we have to type emails manual, disaster ...


Reply from Alex Hedley:

Is there a reason you upgraded Outlook and not the rest of office?

Might be worth using the Email Seminar

Other forums suggest:
"Your best bet is to use the 2016 Runtime."
Microsoft Access 2016 Runtime


Show Just This Thread        Post Reply
Read Library Systern using Access 2010 by Peter Songe @ 3/28/2016
The whole purpose of this db is for loaning out books to students.
Show Just This Thread        Post Reply
Read Library Systern using Access 2010 by Peter Songe @ 3/7/2016
Function of this db should allow students to borrow books from the school library. I having difficulty here trying to figure out how the tables should be related as there can be more copies of one Title of a book. And when a book (copy) is borrowed, automatically the system should show one less in the remaining stock in the library and when the book is returned it should show that a copy is added to the remaining stock. Please try and help given a bit more detailed explanation.


Reply from Alex Hedley:

You could use a Recordset, see the Developer level series for Stock Control courses
Show Just This Thread        Post Reply
Read Library Systern using Access 2010 by Peter Songe @ 3/5/2016
I would like to know the names of tables and how the relationship would look like if I want to design a School Library system using access 2010.


Reply from Alex Hedley:

What functions do you want the db to have?
Show Just This Thread        Post Reply
Read Shockwave Flash Object missing in Access 2010 by Jozef Lehotsky @ 12/22/2014
I want to imbed flash video in my form, but active x for flash is missing. Does have anybody an idea how to go about it?


Reply from Alex Hedley:

You'll probably need a product like flash player installed on your machine for it to be available.
I'd advise using something like handbrake to convert it from flash and play it using another program.
Show Just This Thread        Post Reply
Read Access 2010 and the Calendar Training by Joe-Paul R @ 10/1/2014
Hello...
First..your samples won't open for Access 2010...is there anything newer?  And when I follow the course..it gets to setting up different days on the form... in the listbox rowsource, it says to use DateTime >= Forms!DatePickerF!StartDate ... this is does....but then when I added " < Forms!DatePickerF!StartDate + 1 the query won't run...it says that it is too complicated or has a misspelling in it...Not!...:0)...So I did a  "DateAdd("d",1,Forms!DatePickerF!startdate) and it works... then tried to build the date boxes with =Forms!DatePickerF!StartDate and the first box was ok, but when I did that "+ 1", I get an error in the box "#Type!" ??  Tried that "DateAdd ... function again...and that does not work...any help?  Thanks


Reply from Alexander Hedley:

Hi Joe,
What error are you getting when you try and open the Sample File?
Are you getting the 'missing or broken reference to the file 'MSCAL.OCX' version 7.0'?
Show Just This Thread        Post Reply
Read Images in Access 2010 by william c @ 6/9/2014
I have the same problem with Access 2010and the seminar was based on Access 2007
Show Just This Thread        Post Reply
Read Printing Postcards in Access 2010 by Lanie @ 6/4/2014
Printing postcards 4 on a page.
The detail of each postcard contains date, part # and description.  The problem is there are a different number of records on each postcard.  Some have 1 line and others have 2 or 3 or 4 lines.  That prints fine.  The problem is in the footer section, right below the detail section.  I have the customers address and the address information is moving up and down depending upon the number of detail records.  Would love to know how to keep the footer section in the same place no matter how many detail line items there are?


Reply from Richard Rost:

Set the DETAIL SECTION's CAN SHRINK property to FALSE.
Show Just This Thread        Post Reply
Read Images in Access 2010 by Mk @ 6/3/2014
This is the tutorial I am following right now to build a very simple db for my work. Access Tip: How to Use Images and OLE Objects in your Database .It involves many images. When I write the vb code you suggested ( I don't know vb at all), it gives me Run Time Error 2220 - file can't be found. I have checked the file path I provided - what can i do? really stuck - and this is sue tomorrow! help!
Show Just This Thread        Post Reply
Read Access 2010 Forms by Stuart @ 4/3/2014
How do I create a combo box that is based upon the information entered in the prior combo box on a form? The "sub-combo box" should be gray unless activated by the response in the "parent combo box."  Thanks


Reply from Richard Rost:

You need cascading combo boxes.
Show Just This Thread        Post Reply
Read Access 2010 Grid display ON but not showing by Ettienne K @ 2/17/2014
I noticed that my GRID display in Access 2010 design view is not showing even if the GRID view is ON when i right click on the form. Ruler is ON and working but not GRID. Can anyone help as to what can be the problem?
Show Just This Thread        Post Reply
Read Microsoft Access 2010 Subforms Go to next record by Pamela F @ 1/30/2014
Microsoft Access 2010- Subforms- Go to next record. I am trying to figure out how I would go to the next record in a subform that has several entries per account number. EX. I want to go from record one to record 2 without filtering through all the records in the first record. Hope I explained this appropriately. Thanks
Show Just This Thread        Post Reply
Read Ms Access 2010 by Alex Hedley @ 11/3/2013
Which version of MS Office did you get?
Home & Student, Professional, 365?

What programs were actually installed?

Not all versions have Access.

Office Home & Student 2013
Word
Excel
Powerpoint
OneNote

Office Professional 2013
Word
Excel
Powerpoint
OneNote
Outlook
Publisher
Access

Alex
Show Just This Thread        Post Reply
Read Ms Access 2010 by Robert Racho @ 10/29/2013
I have Ms Office tools 2010 but I don't have the Ms Access, during installation we didn't not accept it, is there any chance on how to go back and install ms access or re-install again to buy new Ms Office tools
Show Just This Thread        Post Reply
Read Printing Image in Access 2010 Report by Richard O @ 7/6/2013
Good Day Fellow Access Users.
I have a report which includes the company logo as a BMP image in the Header.  It is visible in Report view and Print preview but when it goes to the printer the image fails to print.
However, when I export the report to a PDF file, I can then print it out perfectly.
Has anyone a suggestion on how I can get Access 2010 to print the report including the image correctly?
Richard in Melbourne Australia.


Reply from Richard Rost:

That's very interesting. I've never seen that happen before. Perhaps try changing it to a different format like GIF or JPG? Maybe your print driver is having an issue with BMP images. Perhaps the image is too large (MB wise) and is overrunning your print buffer? Could be a million things.
Show Just This Thread        Post Reply
Read Access 2013 and Access 2010 by Ariana @ 5/22/2013
I am currrently using the Access 2013 version.  Is there a significant difference between 2010 and 2013 I should be aware of when I'm watching your Access 2010 videos?
Thank you!


Reply from Richard Rost:

There is very little difference between 2010 and 2013.
Show Just This Thread        Post Reply
Read access 2010 on win 7 64 by sady @ 5/17/2013
Is there anyone using access 2010 on win 7 64 bit?


Reply from Richard Rost:

I was for a while, but I recently switched to 2013 on Windows 8, 64-bit.
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by eddy geijselaers @ 4/6/2013
Many thankx Rick,

Seems to work. I don't know realy what happend. The debugger came up with a problem that I didn't recognise. On one form I had button removed and later build in again (from the Imaging seminar). But I forgot to remove the code.

Even the Access Debugger got confused: it asked to Dim a Private Sub routine.

Will test the accde version later this week, for now I am glad it is converted.

eddy
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by eddy geijselaers @ 4/4/2013
Hello again,

What about the Form Property "Has Module" set to yes?
This is the standard setting I guess. When can it be set to No?

Thanks,
eddy


Reply from Richard Rost:

When you're sure there won't be any code in your form. I've never needed to change that setting before.
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by eddy geijselaers @ 4/4/2013
Thanks Rick,

It is the 32 bit version od Access 2010. Using the 2007 setting.

the Database has 23 tables, 30 forms, 12 reports, 24 queries, 1 macro and 4 modules. And a handfull of SQL statements in the forms and classes/modules.

So this cannot be the problem, I think.

No more then 5 forms at a time are open.

Could it be because it is a relational database? All tables have an ID, the main table about 20 ID's. Don't know what I could have done wrong (except using a MS product). But your teachings are so great I couldn't resist.

Thankx,
eddy


Reply from Richard Rost:

Maybe there's a bug in your VBA code somewhere. That sometimes causes issues when the database tries to compile. Open up your VBA editor from any form, and go to Debug > Compile Database. That will show you if there are any syntax errors in your code.
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by eddy geijselaers @ 4/3/2013
Hi Rick,

I tried to run the 2007 Developer Extentions but it doesn't run without Access 2007. That question answered.

I already had the 2010 version installed at my PC.

I tried to make a runtime version of my WineCellar database but did run into a couple of messages:
First: Microsoft Access was unable to create the .accde, .mde, or .ade file
Second: This error is usually associated with compiling a large database into an MDE file.  Because of the method used to compile the database, a considerable number of TableID references are created for each table.  The Access database engine can only create a maximum of 2048 open TableIDs at one time.  Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.  However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.

Next I tried the LoanAmortizer
A small Database we created in the Access 2003 classes.
No messages this time, but guess what: running the accde file I am able to open the tables and even make changes in them.
Not good I suppose, could it be this is caused because there is no menu?

Could it be that I installed Access 2010 in 64 bit mode, using XP? But MS would have seen that while installing, wouldnt it? I cant remember and since there is no uninstall I can find re-installing seems not possible either.

Either way, I am out of options, can you help me out?

Thankx,
Eddy



Reply from Richard Rost:

I've built some pretty complex databases and I've NEVER come close to exceeding the 2048 table limit. I think the biggest database I ever built had 200 tables in it. This one is easy: consolidate, split, or use SQL Server.

Creating an ACCDE file does NOT lock the tables or queries. It only encrypts the forms, reports, macros, and your module code.

I don't believe you can install 64-bit under Windows XP. You can find out which version of you have under File > Help > About Access.


Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by Mike Everts @ 3/30/2013
Thanks Rich. Just the answer I was looking for!
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by eddy geijselaers @ 3/29/2013
Hello again,

What is wisdom, Access 2010 can be set to 2007. Which runtime to use, 2007 or 2010?
Can they run both on the same programm?

thanks,
eddy


Reply from Richard Rost:

I'm honestly not sure. Anybody research this?
Show Just This Thread        Post Reply
Read Access 2010 Runtime Record Navigator by Mike Everts @ 3/25/2013
I plan to distribute my Access 2010 application as a "Runtime" version. Does the built in record navigator ship with the runtime or do you have to program them with form controls?


Reply from Richard Rost:

If by the "record navigator" you mean the navigation buttons on the bottom of a form, then NO, you do not need to build your own controls for that. Those are a basic part of form design.
Show Just This Thread        Post Reply
Read Access 2010 counter by eddy geijselaers @ 3/14/2013
Thanks Rick,

Catched your pun.
I am almost finished with this Database, shared this for the info to others. Did find a solution, so it's all right with me.

Have to work around my other question (listbox) and then I think it is ready.

Is there a lesson or seminar on how to convert the batabase to an .exe file?

eddy




Reply from Richard Rost:

You don't really make an EXE file, but you can distribute it with the Access Runtime edition. It basically makes an encrypted version of your database so others can't modify it, and gives them a royalty-free (FREE) copy of Access they can use to just RUN/use your database. See this blog post.
Show Just This Thread        Post Reply
Read Access 2010 counter by eddy geijselaers @ 3/13/2013
Hello everyone,

I kind of run in to a unusual problem.
in one of my Databases I've have forms with listboxes. Of course I added a counter on each onde of them. But ....

Access 2010 has a problem with more than one counter even if they are not in the same form. I've had an error message that wasn't very helpful. It referred to an expected macro in the on-open event, which I don't have in this Database. Searching some more in the "macro" button in the ribbon it called on a unrelated Database from years ago in Access XP.

Curious why in another form the counter worked properly I found out it was named counter 2. So I renamed the problem counters "counter3; counter4 etc" and the problem seems to be solved.

Hope someone can use thi sinformation.

eddy


Reply from Richard Rost:

I've never enCOUNTERed this before (catch my pun there? LOL)

I can't picture what's going on. I'd probably have to see your database to tell you for sure.
Show Just This Thread        Post Reply
Read Timesheet in Access 2010 by Yvonne @ 3/12/2013
Thanks Greg and T-Bone. I have created my Timesheet DB which is to be completed by staff and tracks their clocking in and out times, their total hours worked as well as whatc project they were working on during that time and the name of the customer they were doing the work for so that they can be billed for it. Just doing some user testing and setting up queries and reports before l roll  it out.  I am not really experienced in Access so it's been very interesting! And only possible because of Richard's excellent tutorials.
Show Just This Thread        Post Reply
Read Timesheet in Access 2010 by T-Bone @ 3/7/2013
I too have created a database to keep track of time. My employees start a timer on each job then end their time when they are finished with that particular job and it totals their time at the end of the pay period and creates the paychecks all for me. I got the breakdown for the payroll from my state and the other tables from my local county as to what had to be deducted and it has worked just fine so far. So, it can be done; I just have to check the websites for updated information on the payroll tables and I do that about once every three months.
Show Just This Thread        Post Reply
Read Timesheet in Access 2010 by Greg @ 3/4/2013
Yvonne, I have created a payroll database which pulls together timesheet information for about 100 employees. At this point we have to manually input the hours (such as 7am to 2pm on 3/2/2013). I use separate fields for start time, end time, and date. It all works very well. I have 7 or 8 people in there on payroll day inputting and printing data. It does all of the calculations and prints all of the master timesheets. We are preparing soon to have it export the data in a format which can be directly uploaded to our payroll processing company. So yes, I would say Access is great for this, if you know enough to program it for this.
Show Just This Thread        Post Reply
Read Timesheet in Access 2010 by Yvonne F @ 3/3/2013
Has anyone used Access to track data from staff timesheets? Would Access be a good application to do this?
Show Just This Thread        Post Reply
Read how to custom sort in access 2010 by Greg Davis @ 2/23/2013
If it's just in the table where you want to sort just select the table properties and enter your sort order on the "order by" line
Show Just This Thread        Post Reply
Read how to custom sort in access 2010 by HT @ 2/21/2013
How can I create a custom sort in access 2010, eg the day field which holds the days of the week value sorted as monday, tuesday, wednesday etc? I need to use a lookup table for my entries. New to access 2010 so any help is most appreciated!


Reply from Richard Rost:

I don't understand your question. Can you show me an example?
Show Just This Thread        Post Reply
Read Access 2010 Dimension Datatype by Alex Hedley @ 2/16/2013
Has it actually failed for you or was it just the note you spotted?
Are they connecting to a SQL Server?

I found the following MS Article
[http://blogs.office.com/b/microsoft-access/archive/2012/03/19/access-2010-how-to-write-expressions-for-web-queries-forms-and-reports.aspx]

It might Server related.
Scroll 1/3 of the way down.

Strict Type Coercion

One of the most difficult changes for traditional Access users to get used to is likely to be the addition of strict type coercion on the server. Access client will allow you to compare values stored in mismatching data types. For example, users can create a query that compares the value of a date/time column to the string �2009-10-02� and they will receive results from the query appropriate to the comparison. However, the same query will fail on the server because the user is attempting to compare a string and a date value. The only exception to strict type coercion is between dates and numbers, mainly because they are both stored internally as numeric values. For all other data types, implicit coercion is blocked on the server.

Because of this restriction, there are two common design considerations you should keep in mind when working with different data types.

When you work with Boolean values, always use the constants True and False instead of the numeric values 0, -1 or 1.
When you compare strings to numeric or date/time values use FormatNumber(), FormatPercent(), FormatCurrency() or FormatDateTime() functions to convert the field value to a string in order for the comparison to work on the server.

Alex
Show Just This Thread        Post Reply
Read Access 2010 Dimension Datatype by David S @ 2/15/2013
No the second Dim statement is within a comment.
Show Just This Thread        Post Reply
Read Access 2010 Dimension Datatype by MUBEEZI M @ 2/14/2013
Dear David,

From what i see below,
Dim MyTimeSlotDuration As Double 'the duration of each time slot
'Dim MyTimeSlotDuration As Date 'this fails in 2010 which can't do coercion with times!

It seems that the same variable [MyTimeSlotDuration] is dimmed twice within the same sub, first as Double and then as a Date.

Please try and change the second variable name from MyTimeSlotDuration to say MyTimeSlotDate.

Good luck!

MICAH
Show Just This Thread        Post Reply
Read Access 2010 Dimension Datatype by David S @ 2/12/2013
Someone has added the following remarks in a database in Access 2010.
Dim MyDisplayStartTime As Date 'the top most time slot
Dim MyTimeSlotDuration As Double 'the duration of each time slot
'Dim MyTimeSlotDuration As Date 'this fails in 2010 which can't do coercion with times! That's progress for ya !?
Is that true?  If it is, does it also apply in 2013?
David
Show Just This Thread        Post Reply
Read Access 2010 Expert 1 by Richard R @ 2/5/2013
Yep. Access 2010 Expert 1 is ready. Come and get it. :)
Show Just This Thread        Post Reply
Read Installing Access 2010 and 2003 on the same comput by Rupert @ 12/19/2012
Hi Richard,
I have been using Access 2003 these past years, but have now been given Access 2010 to use(just a bit late, I think). From you experience, can these two versions "peacefully coexist" on the same computer, or do I need to uninstall 2003? Thanks for your advice.
Rupert


Reply from Richard Rost:

Sure. Just make sure you install 2010 to a different folder.
Show Just This Thread        Post Reply
Read User level permissions in MS Access 2010 by Sruthi @ 8/29/2012
I created a database in MS Access 2010 and I need to give different permissions for different users who are going to use  it. But, i don't find user-level security in Access 2010. Can anyone tell me how to go about it?


Reply from Richard Rost:

Microsoft removed User-Level Security from Access 2010. This is why I created my Access Security Seminar, to teach you how to secure your database WITHOUT it.
Show Just This Thread        Post Reply
Read Does Access 2010 have a latency problem by David S @ 8/24/2012
This gremlin, however, was a programming error.  In the vba code I did not change AccountT to AccountQ, so my RecordSource was not the source upon which the form was based.  I believe that entirely explains the problem.
Human Error only.


Reply from Richard Rost:

That would explain it. :)
Show Just This Thread        Post Reply
Read Does Access 2010 have a latency problem by David S @ 8/24/2012
I have run into a problem with vba code sometimes not working.
I had a perfectly good Access Database (or so it seemed to me) until one day the vba code on the double click event to open a form to edit details in another form, stopped working.
I could not resolve the problem, until I remembered the last change I had made to the form.  I opened it with the RecordSource as AccountQ (which was ordered in a descending order) instead of AccountT (upon which Account Q was based).
I changed it back to AccountT and everything worked again.
I later, (after having closed and reopened the database, but without having turned my computer off), changed it back to AccountQ and again everything worked!!!
I can only assume therefore that somehow or other the vba code was remembered during the period the database was shut.
Would I be right?
David


Reply from Richard Rost:

I've never experienced this before, but I have had weird problems that you futz with for hours and then all of the sudden just inexplicably fix themselves. I don't know of any latency problem as you suggest, but I do know that Gremlins are real, and they sometimes live inside your database.
Show Just This Thread        Post Reply
Read Access 2010 Web databases by RonH @ 7/24/2012
thanks, Richard
I agree with you.
Show Just This Thread        Post Reply
Read Access 2010 Web databases by RonH @ 7/23/2012
Anyone have good/bad experiences with Access 2010 web databases? I am starting and I find that a lot of Access functions are not available, e.g., VBA.


Reply from Richard Rost:

Ron, you pretty much can't use VBA at all when making Web Databases, which is one of the reasons I don't like them. You have to learn the new Embedded Macros to do anything on the Web. Yes, I'll be doing a course on Web Databases a bit later, but I also have to say I'm not terribly impressed with them. They have a very "version 1.0" feel right now. Sure, in 5 years they might be wonderful, but they have to mature before I'll like them.
Show Just This Thread        Post Reply
Read Access 2010 subform by Greg Davis @ 7/16/2012
Richard --- that's what I'm working on now. Any suggestions would be appreciated.
I started trying an SQL statement that was suggested from another site; the INSERT INTO statement. So far errors keep popping up. Will have to keep trying


Reply from Richard Rost:

Yes, that's the easiest way to do it. A command button with a DoCmd.RunSQL statement. INSERT INTO is the SQL equivalent of an Append Query. It's too much to explain in detail here. That's one of the things I teach in my SQL Seminar Series, however. Part 2 is all about modifying the data in your tables. Lessons 5 and 6 are exactly what you need.
Show Just This Thread        Post Reply
Read Access 2010 subform by Greg Davis @ 7/15/2012
Richard I appreciate your help. The subform which I described adds data to the table, which in this case is the name of the individual who logged in along with the date and time. Once a table is designed it can get all it's data from a form and that's what I want to happen in this case. As I had mentioned the main form comes from a two table query. I'm pulling some of the data from theses tables to use on this form for identification purposes; such as name, department, picture, etc.
So when a barcode is entered or a name is selected the appropriate data fills the form. With the Id of the main form linked to the Volunteer_Id of the subform the Correct name appears there along with the data and time of entry.
All of this works exactely as designed but for what ever readon the name and date/time are not saved to the table "Project_Participation" where it needs to be stored for later reports and safety concerns. I've tried writing code to get it to save but nothing works
I look forward to your reply.


Reply from Richard Rost:

It sounds to me like you're just using an unbound form, or some unbound controls which aren't saving their data anywhere... which is why you should use BOUND controls. Otherwise you have to write VBA code to manually insert the data into the table using either SQL code or something like a recordset which is MUCH more advanced.
Show Just This Thread        Post Reply
Read Access 2010 subform by Greg Davis @ 7/15/2012
Richard the comments you made are exactly what I said. The main form based on a two table query display the data on the form and the data on the subform comes from the link between the two forms. The table on the sub form contains no data. It is mean't to store the data from the sub form.


Reply from Richard Rost:

Greg, let's get on the same page with the terminology since I'm not understanding what you're trying to explain. You have two tables linked together with a join in a query. That query provides the data for your main form (master/parent form).

Now you say "the data on the subform comes from the link between the two forms." This doesn't make any sense. The subform has to get its data from a TABLE or QUERY. Is it the same query you're using for the main form? You can specify a link between a main form and its subform, but that doesn't define where it gets its data from - only which fields link the main form and sub form together to filter/limit the records. For example, if your main form had customers and the subform showed orders, you would link them together with a CustomerID field.

Your last sentence doesn't make any sense. Are you saying that the subform is bound to a table that doesn't have any records in it? If so, put some sample records in it and see what it displays. It's always easiest to work with tables that have sample data in them.

I strongly recommend you watch my free tutorial on forms and subforms to better understand the terminology, and how to set something like this up.
Show Just This Thread        Post Reply
Read Access 2010 subform by Greg Davis @ 7/13/2012
I have form base on a two table query with a sub form base on another table.
When a barcode is entered or a name selected everything works fine, and the correct data appears on the sub form. My problem is saving the data on the sub form to the table. Everything I've tried fails. Starting to get a little frustrating.


Reply from Richard Rost:

Greg, your subform should be automatically saving data to the table. Forms are generally BOUND to tables, so if you can see data in there, you're seeing the data FROM THE TABLE. Forms and queries themselves don't hold any data. They just DISPLAY it from a table. Without seeing your database, it's impossible for me to see what's wrong.
Show Just This Thread        Post Reply
Read Menus in Access 2010 by Abid D @ 6/24/2012
can anyone help me install Arrange/Format menu in Access 2010 as they are not on the menu bar .I am trying to obtain a grid view to work on forms >Sorry just a begineer doing lesson 2 so dont be harsh with me


Reply from Richard Rost:

I'll be covering creating Menu Forms very soon. I covered them in the original Access 103, and will be going over them very soon in the Access 2010 lessons.
Show Just This Thread        Post Reply
Read Access 2010 Navigation Tab by Mike @ 6/17/2012
Would anyone know how to password protect individual access 2010 navigation tabs?

Thanks


Reply from Richard Rost:

Personally I don't use navigation tabs. I prefer creating my own menus using forms and command buttons. Those are easy to password protect. I cover it in Access 306, 322, and of course in my Access Security Seminar. All it takes is an InputBox and a couple of lines of code.
Show Just This Thread        Post Reply
Read Access 2010 help by Mubeezi Micah @ 5/20/2012
Thank you Alex,

I suppose you meant drag a textbox not a label.
If the spaces still persist to appear, follow the insructions given by Alex and add TRIM function. So it would look like;
= TRIM(firstname & " " & lastname)

You could also watch this short access tip by Richard.
http://599cd.com/tips/access/string-concatenation/

MICAH
Show Just This Thread        Post Reply
Read Access 2010 help by Mubeezi Micah @ 5/20/2012
Thank you Alex,

I suppose you meant drag a textbox not a label.
If the spaces still persist to appear, follow the insructions given by Alex and add TRIM function. So it would look like;
= TRIM(firstname & " " & lastname)

You could also watch this short access tip by Richard.

MICAH
Show Just This Thread        Post Reply
Read Access 2010 help by Alex Hedley @ 5/19/2012
Just drag a label and change its control source to
= firstname & " " & lastname. (substitute your field names)
Or add this as a new field in a query and drag that onto the form/report.
Show Just This Thread        Post Reply
Read Access 2010 help by Cindi @ 5/19/2012
I need to remove spaces on a report between two fields.  Ex:
John Lee Robinson - Full Name Field

When I use first and last name (2 fields), I need the first name to end, leave one space and add the last name.  Not Megan        Smith, but Megan Smith.

Thanks.
Show Just This Thread        Post Reply
Read Signature Capture in Access 2010 Through IPAD by John Morgan @ 4/10/2012
I haven't purchased any hardware yet, so I'm open to using an android platform. I do use iPhones now, so I would like to stay with IOS if possible. DO you know of anything in android? I have searched the apple app store for a solution, nothing found yet. Thanks for the suggestion on the VNC. I'll check it out


Reply from Richard Rost:

I've never personally had the need to capture signatures... but I'd be REAL surprised if there wasn't an app available for this. Check the Android Market (sorry, the Google Play Store now) and see what you can find. If you see something interesting, let me know and I'll try it out for you, since you don't have an Android phone. Maybe later when I get some free time I'll poke around for you.
Show Just This Thread        Post Reply
Read Signature Capture in Access 2010 Through IPAD by John Morgan @ 4/10/2012
I have recently started working on getting my database to sharepoint services through office 365. I'm getting the tables converted to web, but it is a slow process. Many web comp problems. So I would like to connect to my desktop via gotomypc in the interim. My major problem would be getting the signature from an iPad to the corrosponding service order. I would like to get that up and running as soon as possible. Thanks for your help.


Reply from Richard Rost:

Personally I don't have an iPad. I use an Android tablet myself. Have you searched for any apps that provide that functionality? You could just capture the signatures in a different program and then pull them up later if needed. As far as GoToMyPC goes, I recommend a VNC solution. It's just software you install and there's no monthly fee! If you have a static IP address, it works great. I use TightVNC and RealVNC.
Show Just This Thread        Post Reply
Read Signature Capture in Access 2010 Through IPAD by John Morgan @ 4/8/2012
I have a very nice servicemanagement system I devloped in Access. I am currently using pendragon software to sync HTML 5 on an iphone. it works, but not all the time. So what I would like to do is log on to a desktop in the office through a browser. Fill all required fields for the service order. Lastly, I need to be able to capture a customers signature that can be stored in the database, and printed on service orders sent to customers. I currently use dbpix 2. plese help


Reply from Richard Rost:

I've never worked with Pendragon software before, but you could certainly build this as a web-based solution, storing your data in a back-end Access or SQL Server database. I'm not sure about the best way to handle customer signature captures, but I'm sure we could figure something out with a little research. Have you looked into a Sharepoint solution?
Show Just This Thread        Post Reply
Read Access 2010 Unhide windows by Ben Chua @ 1/30/2012
Thank you as soon as I get back I will try.
Show Just This Thread        Post Reply
Read Access 2010 Unhide windows by Alex Hedley @ 1/29/2012
Hiding and Displaying Objects
To hide an object in Access 2007/2010, do the following:

Right-click the object in the Navigation Pane.
Choose Table Object | View Properties. (The qualifiers are different for each object.)
Check the Hidden option.
Click OK.

Hiding objects is still easy.
Unhiding an object is less intuitive in the accdb versions. You might browse the application options (via the Object button or the File tab — that seems the most likely spot. It’s actually easy to find, but you have to know where to start:

Right-click the Navigation Pane’s title bar.
Choose Navigation Options.
In the Display Options section, check the Show Hidden Objects option.
Click OK.
Show Just This Thread        Post Reply
Read Access 2010 Unhide windows by Phil @ 1/27/2012
F11 key should get you there.
Show Just This Thread        Post Reply
Read Access 2010 Unhide windows by George @ 1/27/2012
The F11 function key will act as a toggle between hiding and unhiding the database pane
Show Just This Thread        Post Reply
Read Access 2010 Unhide windows by Ben Chua @ 1/26/2012
Can someone show me how to unhide the database?  In access 2003, we click Window, Unhide.
Show Just This Thread        Post Reply
Read Access 2010 install by Kevin @ 1/25/2012
I bought a single license of access 2010 and will be using it in a multi user environment using run time libraries and a server-workstation environment. I need to be able to program from my workstation.  Do I install access on the server or my workstation? Or do I need to do both and buy another copy?  
Show Just This Thread        Post Reply
Read Embedded Macros in Access 2010 by Greg Beben @ 12/12/2011
Richard, the recent question about macros prompted me to ask. In earlier versions of Access, when I let the command button wizard create procedures for me, it created VBA code. In the 2010 version (and maybe 2007, don't remember) it creates macros. I'm hoping that this is not a move away from VBA on Microsoft's part? Do you still recommend using VBA over macros? Is there a place to use macros for experienced developers?


Reply from Richard Rost:

Yes, I still do recommend VBA over macros. The wizard now creates something called an EMBEDDED MACRO, which is stored right in your form. The benefit of an embedded macro is that they're GUARANTEED TO BE SAFE. This way malicious coders can't hide something potentially dangerous in the code behind a form and send it out. You run it, and all of the sudden your hard drive is erased (which is possible with VBA). You can open a database you get from someone else and the code behind the forms and reports will still work even if you don't click the "enable" button when you get the security warning upon opening.

PLUS, embedded macros FOR THE MOST PART work if you're going to upload your database to a Sharepoint server for use on the web. There are a few features that don't work, but pretty much all of the popular functions do.

Now, macros have come a long way since earlier versions of Access, and I'll be spending some time on them in the Advanced level classes. They have their place. Obviously if you're building a database you plan on sharing with the world online OR you're planning on porting your database up to Sharepoint, you want to use embedded macros whenever possible.

For the rest of us who are building old-school databases for in-house use (on a LAN) where all of the users trust us, and you're NOT going to put the database online, I prefer VBA myself.

Hope this answers your question. :)
Show Just This Thread        Post Reply
Read Access 2010 by Gerald Walker @ 8/23/2011
Just checking on the status of Access 2010 training videos.


Reply from Richard Rost:

Finishing up the videos for Excel Level 10 today and tomorrow. I've been working on the Access 2010 outline for the past two weeks now, on and off. I expect to start recording later this week.
Show Just This Thread        Post Reply
Read Access 2010 by Gerald Walker @ 5/27/2011
Any idea when training on 2010 will be available?


Reply from Richard Rost:

Coming very soon. I have a couple more Excel 2010 Expert lessons to finish up, then I'm moving right to Access 2010. I'm hoping to start next week.
Show Just This Thread        Post Reply
Read Old database tables and Access 2010 by Greg Beben @ 5/2/2011
I have a customer who is using HP lab equipment from about 1995.  (Very expensive, so can't replace.)  The equipment produces files which are apparently in an old Access database format, like Access 2.0 maybe.  I could link to these tables with Access 2007, but 2010 is refusing to link to them.  Do you know of any program which will convert old Access files to a new format?  I can do it manually, but they have hundreds of these, and produce more all the time, so they need an automated method.  I only need the tables, no code, forms, reports, etc.


Reply from Richard Rost:

I'm VERY surprised that Access 2010 won't import Access 2.0 tables. Honestly, I haven't used Access 2.0 since the 90s myself, so it's not something I've come across. I just Google'd "access 2.0 convert" and I see there are different conversion methods to bring Access 2.0 databases up to the 2000 or 2003 format, but most of these appear to be plug-ins for those older versions of Access. Perhaps with a little more searching you can find a stand-alone app. If not, let me know and I'll try looking some more.
Show Just This Thread        Post Reply
Read Access 2007 and Access 2010 by Alan Hill @ 10/11/2010
Hi Richard
I keep reading that there is little difference between Access 2007 and Access 2010, but you stated that you love 2010. Could you please give me/us some idea about the changes please in your forums.
Best wishes Alan Hill
Show Just This Thread        Post Reply

Collapse All Topics

 

Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
 
If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 4+3:
  
  Notify me when the this forum is updated
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

You may want to read these articles from the 599CD News:

6/7/2017Microsoft Access Developer 1
6/6/2017Access Developer 1 is Finished
5/18/2017Microsoft Access Advanced 6
5/17/2017Access Advanced 6 is Online
4/9/2017Microsoft Access Advanced 5
4/9/2017Microsoft Access Advanced 4
4/4/2017Microsoft Drops Access Web Apps
4/3/2017Access Advanced 5 is finished
3/26/2017Access Advanced 4 is Finished and Online
3/19/2017Microsoft Access Advanced 3
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP