Search results

I have 6 small tables with 2 to 3 fields that are related occurrence-types in each table (they have quite a few point criteria). What would you guys recommend for the primary key? This is where I get a bit confused. I'll need to link all of these tables in the event that they want reports ran on...

You guys sold me on it! I'm scrapping the calendar format and utilizing the "date of occurrence" method. My experience with relationships and joining relies heavily on already created tables and queries so I'm sure that I will have questions on that subject. :confused: Thank you both for your...

Hi Paul, Would you be able to elaborate on that? I would like to do this in the most efficient manner. Otherwise, I was planning on a separate query for each employee with 365 records for each calendar date. In each record/row there would be the option of inputting a 1 representing the point...

Hi everyone! I am back with another question! The new database that I am building will be used as a point system based on attendance. This means that I will have a main form that a few users will utilize to look up an employee's score. So far, I have a combobox (cmbEmployeeDropDown) that lists...

I decided to create the calendar in a spreadsheet within Excel and then import it as a table into Access. It was easier to drag the autofill down and allow Excel to do the work.

Hi everyone! I wanted to know if anyone has implemented the LoadCalendar procedure in Access 2013. I need to create a table for each employee and these tables must include all calendar dates for the year 2014. The LoadCalendar procedure will do this for me, unfortunately I do not know how to...

It worked! That was hopefully the last question that I had for this thread! :-) Thank you all for your help and understanding! :D

Not sure if this is Access 2013 specific or not, but will "Long Text" suffice for Data Type in the table? There is no option for "Memo", I believe "Long Text" replaced it.

I need to have a text box on another form that will accept more characters, at least a large paragraph size.

Rainlover, awesome! Thank you for the document! I wanted to mention that one of the reasons for the unconventional names is that non-Access/SQL users will be using this as simply a knowledgebase. At the request of the management I had to keep the names on a familiar basis. However, you are...

Semantics aside :p Why doesn't the intCount function the same way as it used to? It no longer provides a message box if the queries return 0. Instead one query, the same query every time, opens completely empty. This same query opens empty after every query even if another query returns 1. Not...

That was the explanation that I was looking for, thank you! It helped me to get another form & table working. For some reason, now that the Usage Log is being updated, the intcount is causing one of the queries to always pop up regardless of whether or not the text in the search field is in the...

This worked!! There was a reason for the date and time listed as a string but now I can't remember. It had something to do with the function. Regardless, this is much better! Thank you for all of your help! I'm attempting to do something similar in another form. I'll probably have questions...

Unfortunately, it would not translate to .mdb so it was saved at .accdb. I cut all of the fat out and left only the necessary code. It is pretty self explanatory. The form is "Start Here" and the necessary tables are there. I also took out all of the butchered code that I had and provided you...

Cronk, Contractor is right, the code that he had posted is the code that I provided, he was just modifying it. I want to thank you all for your interest in helping me learn and succeed. This certainly has been a labor-intensive, long thread. Paul, I will attempt to get a stripped version...

I have the table Usage Log that includes NTID (I took the space out), loginDate, loginTime. The UL Query then references these fields. I have attached an image of the Design View of the the append query, UL Query. Do I need to change anything here?

The cmdFind button is set to [Event Procedure]. This hasn't changed.

This is definitely progress. After the button is clicked, the search for the queries are ran, and a box comes up asking to add a record and then a blank record is added to the Usage Log table. I get 3 Enter Parameter Value boxes that ask for UL Query.NTID, UL Query.loginDate, UL Query.loginTime...

That's how I have it. The cmdFind_Click() is placed in the Form code while the function GetNetworkUserName is located in a module.

Hi Contractor, I created the module, added the code, and now I'm struggling to get the button click to work.