Search results
Results from the Tech24 Deals Content Network
The first (and maybe the simplest) idea that comes to mind is to create a new record for the client when a change is made. I assume that the client ID won’t change, so you might have to split a client table into two tables: ConstantClient and ChangeableClient …. Author of The Ten Commandments Of VBA For Microsoft Access Newbies ...
Ms Access Login form and User Level. I am trying to make Login Form Using DCount and LookUp functions. My table has the following field LoginID, UserName, Password, Level and Description. Form has: Combobox Named: "txtUser" bound column is 1 (LoginID) and I hide it by sitting Column Widths by 0. TextBox Named "txtPass".
Notification of works starting (need to log start proposed date, contractor). This notification document will very often contain multiple items of work. Works completed (need to log proposed end date) Works checked/verified (need to log date of check, approved/rejected, person doing the checking) If an item is rejected, it will need to return ...
The Employee/Course table should look like this: EmployeeCourseID (PK Autonumber) EmployeeID (FK) CourseID (FK) DateTaken. Cost. You should not be repeating the employee names in that table, nor the course names. And yes, you do need a record for each employee and each course.
CustomerID. CallDate. CallDetails. etc etc. Create a small form based on that table, and either (a) embed it in the Customer form as a Subform or (b) open it on a Button click as needed. If you use the button click method, be sure to pass in the CustomerID to that form so the record can be properly associated with the Customer.
Maybe the simplest is: Design the form. Right-click on the square in the upper-left corner and select Properties. The Form's Properties form appears. In the Events tab, select AfterUpdate (the ... button) Now you're in the VBA editor and you can write code. > one explanation told me to open the form in visual basic.
The blog shows you how to just create a login form. If you don't want to use the Access level feature to control access once logged in you don't have to. I prefer to use a Combobox (as illustrated in the blog) to let the user select their user name. This eliminates the step of having to verify that they typed in the user name correctly.
In reply to Tom van Stiphout's post on September 6, 2014. Sure. When the File Open dialog comes up to pick a file, in the File name field type: *.log. You will then be browsing for log files. Okay, great I can now pull up the files.
I need to find a way of closing Access applications when the user is inactive for a period of time ...
1. Choose the reason you need your password reset, and then click Next. 2. Enter the email address you used when you made your Microsoft account (This could be any email address, or an email ending in a Microsoft domain like hotmail.com or outlook.com).