|Microsoft Access Forum||Microsoft Access Forum by Susan W: Thank you.|
|Microsoft Access Forum||parameter query by Roderick K: beginner lesson 5 parameter query. Is the a way to enter two parameters. Like "NY" and "OH"? Reply from Alex Hedley: You could create two inputs [Input1] and [Input2] |
|Microsoft Access Forum||Exporting with format by Virginia M: thank you for your reply, but I found out the problem. Perhaps this was wrong to do but I created one Invoice and from that I copied to create Deposit Invoice and Grooming Invoice (of course I changed what needed to change) however there was a misspelling in one of the field names and as soon as I corrected the misspelling it is more...|
|Microsoft Access Developer 4||Microsoft Access Developer 4 by Kenny N: Thanks so much for the tip on the Dim statement! I never realized I was inadvertently dimming my variables as variants because I was not writing out my variable types individually. That explains some mysterious error messages I have been getting when trying to pass variables to subs and functions!|
|Microsoft Access Forum||LaunchCD function by Joni M: I am also having problems using this function ever since I switched to Office 365. Reply from Alex Hedley: What issue are you getting? |
|Access Imaging Seminar||LaunchCD VB by Joni M: I believe the last part should read "LaunchCD = Trim(... not rim|
|Microsoft Access 321||321 Sample by Kim Beaul: I can not download the sample files - the password I am using doesn't work. I am using the password from My Courses Page Access 321 Dynamic List Boxes, Multi-Select Reply from Alex Hedley: The download page states "The password is the same as the INSTALLATION PASSWORD for the more...|
|Microsoft Access 320||For access 2013 2016 and Office 365 which version by Gioia Heiser: For access 2013, 2016 and Office 365 which version DAO library should we use? Reply from Alex Hedley: Which versions do you have available? |
|Access Split Database Seminar||Access Split Database Seminar by Joya: I am also interested in this.[See below]
Currently I split a database and about 5 employees are using the one FE.accde file. We haven't had any issues, but let me know if you are aware of any. Did you ever make this seminar? That might work better for me. THANKS!
The mini seminar you mentioned here:[However, if you have the more...|
|Microsoft Access Forum||Microsoft Access mdb by FRED TARNELL: I am 75 yrs old. I have been semi retired
for over 10 yrs. I want to get up to date
on Access 16. I have a .mdb that I can email someone. I tried opening and converting according to MS. No luck. I want to pay someone to open and convert to MS Access 16. Reply from Alex Hedley: Try creating a blank new db in 2016 so an more...|
|Microsoft Access Forum||Convention by Dennis O: I am not sure if I have a cartesian query which is joining 3 items per attendee, one for each year? However, I did notice that I have a "copy of MemberF" I no longer use this one but I added more to this page that I am using. If I delete this copy could that be the answer to the multiple entries? If the member was at the 2016, 2017, 2018 convention it is listed more...|
|Microsoft Access Forum||Convention by Dennis O: This is what I found out. The new entry is in the "MemberT". The new entry is also listed on the "MemberListF". The Record Source is "MemberSortedQ". When I open the Master Roster (Main Menu)and select the new entry, it opens to a blank form with a (New) Member ID.If I fill this form again, it will set up a new ID. Will list it on the Main Menu Master List but more...|
|Microsoft Access Forum||Random Seed value by Richard S: In Expert 26 on the Random number lesson, is there any reason to not use the RND() function as the seed ?
Something like Rnd(rnd()) ?
San Antonio, TX|
|Back in the Saddle||Data Replication by Adonis B: Yes, offline usage is necessary due to the amount of queries that run within the application to access the data. Some forms-reports take longer than a minute in running all the queries before actually displaying something if all the tables are online (ODBC SQL server). Because of the number of queries on the database, user will have to work with this more...|
|Back in the Saddle||Developer 4 by Mac W: Waiting on Developer 4 Reply from Alex Hedley: It's been released. See the outline. |
|Microsoft Access Forum||Microsoft Access Forum by Susan W: I just realized my second question was similar to my first.The reason I was getting that message (?NAME)was because the field EmployeeID had an extra space in the Employee Form which was not in the Employee Table.
d Reply from Alex Hedley: Have you added a space in the Field name i.e. "Employee ID" not "EmployeeID". Try not to more...|
|Microsoft Access Forum||Combo box Search by Naser A: I put the combo box on the page header of the Form. It appears only on design mode but does not show up in Form View or Layout mode. Reply from Alex Hedley: Put it in the FORM header not the PAGE header. |
|Microsoft Access Forum||Convention by Dennis O: I'm not sure. Can you refresh my memory. Where can I go to find out how to write a Cartesian query? I may not because you mention one for every year. Reply from Alex Hedley: Access 223 |
|Back in the Saddle||Back in the Saddle by Ray W: I thought Richard was back in the Saddle? Reply from Alex Hedley: D4 has just been released, D5 is in production. |
|Microsoft Access Forum||Microsoft Access Forum by Susan W: I did not have the all the necessary fields listed in my table. I do have another question, though. I have an employee form and a customer form, both with EmployeeID fields. However, one is working correctly with the ID # showing, but the other has #Name? in the EmployeeID field instead of the number. Both seem to be set-up the same more...|