Search results

Thank you Namliam for your response. TimeIn, BeginTime and EndTime are date/time fields. Since I've tested the [DayTypeID] part of the DLookup and know that it works, I've kept it the same. Changes have been made based on your other suggestions. My DLookup now looks like this...

DLookup with 3 criteria. I have a aPointsRate table such as shown below: DayTypeID____BeginTime_____EndTime____MultiplyBy 2____________00:00am______8:59am____2.0 2____________9:00am_______5:59pm____1.0 2____________6:00pm_______11:59pm___1.5 3____________00:00am______8:59am____2.0...

Hi David, Try this: 1. Select the text. 2. Properties --> Other (tab) 3. Vertical: Yes The text will be displayed vertically. ie, from top to bottom. To read the text, you'll need to tilt your head to the right. :)

I'd like to know whether it is possible to achieve the following: Have a form that periodically checks for certain condition in a table, when the condition is satisfied, the application automatically dials Sales colleague's telephone number, once the colleague picks up the phone, Access...

Great! Thank you for highlighting Raskew. I shall be using your solution for my application.

Thank you everyone for contributing. Since there can be many solutions for a problem, I've also come up with another solution: Assuming the field is a text field. The query that is created to do summation on the text field containing hh:mm format is as follows: Expr1...

Hi, I would like to know how I can use query to do summation on a text field which has hh:mm format (in hours and minutes. eg. 10:30, 11:00, ...). Which string manipulation function should I use? Thanks in advance for helping.

Thanks Hi There.

Thank you ghudson for the AuditTrail demo. It works great!

Once an Access application has been upsized to SQL Server, should I continue to use Access' mdw security file or should I use SQL Server's security? I'm new to SQL Server, where should I begin to learn about authentication in SQL Server? Thanks...

I've recently completed an Access application (App A), had the application split into 'be' and 'fe'. Users are satisfied with the application and is now requesting for another application to be developed (App B). The plan is to redevelop disparate databases currently maintained in different...

The correct website is: http://www.smartaccessnewsletter.com/ Thanks Steve.

I'd like to know whether it is possible to use Access to let me login to a POP3 email account to retrieve emails. For eg: Customer sends a helpdesk request to helpdesk@mycompany.com My Access application periodically login to the POP3 mail server as 'helpdesk' user to retrieve email(s) and...

Thank you Kevin for your sharing.

I've two questions: 1. If I upsize my application to MS SQL Server, is there any limitation to the total number of users running MS Access application accessing the same database concurrently? 2. Has anyone tried using MySQL instead of MS SQL Server as the 'be' database? Thanks...

Thank you Autoeng.

Securing the be My be database is located in a file server which some colleagues have access to, if anyone of them have a full MS Access software, they can just double-click on the be to open it with full permission. Though the fe application has been protected now, how can I protect the be...

I'd like to know how should I configure my application to allow users the ability to change login password. Should I create a customised menu? Thanks...

Awesome! It Works! Thank you Jon K.

Other collegues in my office are having problem running Visio after I installed my Access application on their PCs. Each time when launching Visio, it immediately shows installation of Access Runtime, then once the installation is completed, Visio hangs. IT Support suspects the problem could...