|Microsoft Access Forum||how to increase a number by 1 by Michelle : hello everyone I am trying to fix up a database by rewriting it because something has gone wrong somewhere by the original writer my problem is I need to increase a number which displays on the form each time I add a new record currently it is using you auto number to do this
Hope to find someone out there who may be more...|
|Access Advanced 2 is Finished||Access Advanced 2 is Finished by Edward R: Always look forward to your newest lesson. Happy New Year!!|
|Microsoft Access Forum||Is it possible to use color indicators in Access by Masih O: Is it possible to use color indicators in Access? For example green light instead of Active checkbox or red light instead of Inactive and so on... Reply from Alex Hedley: You could have a textbox on the form and set the background colour based on the value of the textbox, toggle more...|
|Access Advanced DateTime Seminar||How can I default a Date time field to a PM time v by Jim Ogier: How can I default a Date/time field to a PM time value?
99 percent of the date time entries are a PM time and it would save much time to default to PM.
Jim O Reply from Alex Hedley: =Now()
Or =Date() + x amount of hours to make it into a PM value. |
|Microsoft Access Forum||Getting values from a Spreadsheet by Nicholas S: I have a stock database and two fields are stock number and quantity in stock.
The physical stock-taking is done on a spreadsheet and I would like to maintain a link between my exisitng database and the spreadsheet. So some how I need it to match the stock number and update the quantity in stock field. Any ideas more...|
|Microsoft Access Forum||DMax by Michelle : hello everyone is there a way of having an auto number and a number e.g. for your client which would increase by one each time you add a new record and show on the field at the moment when the database was started the auto number was assigned to the customer ID and I want to be able to changes as I do not have to worry about the auto number if I delete a record I fought more...|
|Access 2013 Runtime Released||Access 2013 Runtime Released by Lester G: How did i set up trusted files in runtime Reply from Alex Hedley: You could put the file in an already trusted location: %LocalAppData% |
|Microsoft Access Advanced 1||Microsoft Access Advanced 1 by Ngala Elvis F.: I really enjoyed the lessons i watch on youtube microsoft access 2013 tutorial level 1 part 00 to 12. and i wish to continue. Reply from Alex Hedley: You can Order more. |
|Microsoft Access Forum||How to autofill fields in 2 linked tables by Terry McKnight: I have a table with employees. Names, addresses, etc. I have a 2nd table with the 1100 phone numbers and extensions the company owns in it. An employee can have multiple phone numbers so it is a 1 to many. I need to be able to look up the phone table to assign numbers to an employee, but I more...|
|Microsoft Access Forum||Sharing Databases by Fran b: Hi
Once I've finished the course, I will be setting up a database that will be put on a shared drive for 3 members of the office to use. How do I ensure that the 'Security Warning' does not come up each time? Do I need to set up just one trusted folder on the network, or separate ones on each computer?
Thanks. Reply from Alex Hedley: Have more...|
|Microsoft Access Forum||LACCFB LOCKED IS IT A BUG by Jonathan S: I am using Access 10 on a LAN. Even though no other user is logged on the LACCDB stays locked meaning I cannot get in to edit the database. Is this a bug? Any ideas how to fix? Reply from Alex Hedley: You could delete the lock file. |
|Microsoft Access Forum||loan amortization template by Brendan: Was wondering if anyone had copy of the template here for 64 bit version of access? Reply from Alex Hedley: Is there a reason you have 64 bit installed?
See this blog post. |
|Microsoft Access Forum||Google Calendar Integration by Eddie P: Anyone done anything with API's for google calendar? Reply from Alex Hedley: You'd need an API key from Google first.
What are you wanting to do? |
|Access Database Security Seminar||Listbox by Dan Gettinger: Disregard my previous question. Figured it out. Needed to add the relationship between the StatusT and the ServiceT.|
|Microsoft Access Forum||Customer and Order by Teresa T: I built 2 forms. One customer and one table form. Both are pulling from respective tables. On the customer form I placed a command button that links to the order form for that contact. Customer ID is an auto # and relationship to both tables is one to many. My order form does not link to the customer. Does code need to be written to make this more...|
|Access Database Security Seminar||Listbox by Dan Gettinger: When I create the QUERY for the list box as you have done, I end up with a line for each status. Any idea why and what I need to change? Using Access 2013 if that matters. Reply from Alex Hedley: Why would there not be one for each Status? |
|Microsoft Access Forum||Numbers out of Large Integer range by Steven K: Happy New Year to all! I am going through the courses here on Access Learning Center as fast as time will allow me. However, I have a question which I am sure will be covered at some point, but I sort of need to figure it out now as I am starting to build my database with very simple reports to get me more...|
|Microsoft Access Forum||Automatic transaction number by Steven K: Hi Alex. Happy New Year! Thank you for the recommendation. I think the composite key will be very useful for me for some of the applications in the DB I am working on, but for the specific purpose of what I am trying to do, it will not work or at least I need to do some kind of hybrid perhaps between a composite and what I more...|
|Microsoft Access Forum||pivot chart by elena arsova: hello
i am trying to create a form that will have a subform with my pivot chart. now i make a combo box that will allow to my user to choose the data. when my user choose the data from combo box i want that my pivot chart also present the new data.
maybe somebody know how to do that?
thank you Reply from Alex Hedley: You could have an more...|
|Word 2007 Basic 2||Course by Amber Turner: How long will it take for me to get to start my courses? Reply from Alex Hedley: It should approve once the payment has gone through, you should get an email saying it's been approved and ready to watch.
Is it not in the Theater?
If not try Customer Service. |