Search results

Update: I found a work around, instead of the information displaying in a query, it will be displayed in a subreport/subform that can convert the strings back into hyperlinks after selecting Is hyperlink: Yes in the properties. Now I am running into the same issue with dropdown boxes. If I do...

I am in the process of building a new database in SQL to replace my MS Access database. However, I will continue to use the Access forms, queries, and reports. The new tables will house much of the same data. In multiple tables I have hyperlinks that were created and added in the original Access...

Thank you, saved me a ton of time! :D

Hi everyone, In the Access Table, how does one Find and Replace part of the hyperlink if the Text to display is different? Example of Hyperlink Editor: Example of Find and Replace In other words, I'd like to find \\\FAKESERVER\ and replace it with C:\Users\ in all 1000 records. Is there...

Ok, so I assume that I would use something like: Between Time() And Time()-#3:00:00 AM# This would need to be without the "AM/PM", it would need to be based on hours not time. I would need to add in criteria based on another field, "Status". If that field has the number "3" then the "End...

Thanks for the quick reply, Paul! I would like to display all records other than those that have "3" in the Status field that are older than 3 hours. In other words, after someone changes the Status field to "3" and types in the time in the End Time field(from a form) the query will not display...

Hi everyone, Can anyone guide me on how to build a query in Access 2010/13 that will not display any records that are older than 3 hours? See below for more specifics. The criteria would be based on a field that houses the time (End Time) and also a field that houses a number (Status). So...

Hi everyone! I wanted to know if it is possible to set a rolling year based on the first recorded date for an individual. In other words, my table is updated every time an employee receives a point. The record includes the employee's name (empName), the date (dateOfOccurrence), and the point...

I ended up going a slightly different route. This database needs to be as simplified as possible considering the 2 or 3 users that will be using it have very little experience with Access. I was able to retain each separate menu. Each menu auto selects the amount of points based on the...

I would still like to have separate forms for each grouping of occurrences. In other words, I want the user to be able to click on the "Late" button and have that lead right to the Late Occurrence form.

This is very helpful! Any advice on how to modify my forms to work with these new tables?

I was advised to do just the opposite by someone else on here. He recommended that each infraction group have it's own table. I'm interested in using your method. Would you be able to elaborate a bit more on the structure of each table? In the first table, do you mean that each type of...

Hi, I have created a database that will be used as a point system, kind of like keeping attendance. A person would get 1 point for calling off from work, or a half point for being late. This will help management when the employee's annual review comes. There is a table with employee details and...

Once again, you nailed it! It was bound to the ID field. I set it to 2 and it works perfectly now! Thanks again, Paul!

You nailed it! I set the form to be unbound and deleted the control source for each combobox and the text boxes. Thank you for your help!

Hi, I have a form that has a few combo boxes that I use as drop down lists that the user can choose from. After the form is completed, the user clicks "Submit" and the query/table is updated. However, 2 records are added instead of 1. The first record leaves the first field blank and every...

I have a form that utilizes a combo box with 2 options: 0 & 0.5. If I select 0.5 on the combo box the field in the table records it as 2. Why doesn't it reflect as 0.5? And how do I fix it? This is the general info that I have for the field properties: Field Size - Double Decimal Places - 1...

Haha! I like that!

David, First, thank you for your assistance as I work this out. I have gone ahead and created a second form that will open upon clicking a button next to the employee name combo box in the main form. This second form opens to the Employee Occurrence Form and the first text box on the this...

Hi David, Thank you for that info! This point system won't be implemented until 1/1/14 so the date range will be easy to start off. :-) How should I setup the form for the user to input the data? In other words, would you suggest the textboxes and comboboxes be tied directly to the tables or...