Search results

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...

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...

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...

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...

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...

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...

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...

Hi, I am having a difficult time figuring out how to have a table add a new record that includes the Windows username of the user that clicks the button on my form. The function is in place that pulls the Windows username: Public Function getWinUser() As String getWinUser =...

Hi, I have successfully put together some VBA code that will accept a user's input into a textbox on a form. A cmdFindprinter button is clicked and the query is ran. The user is asked via an inputbox for their login ID so that the query is exported to a text file on the desktop. The query then...

Hi, I hope that this is the correct place to post this. My VBA knowledge is expanding, however, this is way over my head in terms of technical know-how. I have 3 queries that provide the same printer information. Each one is queried by a different field: IP address, asset tag, and serial...

Hi all! I was wondering if there is a way to take the selected OptionValue from an option group on a form and have that value check a box in different fields on the bound table instead of just placing a value in one single field. For example, I have a form that users will use to report...

Hi all, I am attempting to create a form (Access 2013) that will include buttons to open the hyperlink menu to add a hyperlink into a table. It works if you click "Ok" without issue, however, if you click "Cancel" or click on the "X" I get a "Run-time error '2501' - The RunCommand action was...

Hi, I am not sure where to start or go about creating message box that would display "No results found" if my queries return no results. My search of the forums hasn't been fruitful. :confused: I have created one form that has a text box and a button that works as a search function to run...

Hi, I am creating a "knowledgebase" for my company. Each table will contain records with hyperlinks that point to a PDF or other file. Currently, I have 1 search field on a form that also contains 5 combo boxes and 16 hyperlink buttons. My question is regarding the search field. I have it set...

Hi, I am a Systems Analyst for a large company in Pittsburgh, PA. I'm familiar with Access, however, there is much to learn! Please bare with me if I have some ignorant questions. :banghead: Nate