Search results

Hey folks.... I am trying to convert one of my Forms over to a DAP making it easily accessible to other PC's across the region. I have several buttons on this form that use a macro for the event procedure. Is there a way or some type of program that can convert a form using macros to a DAP...

It seems that this would be easy, and it may be, but I cannot seem to find a way to only display certain text within a field. I have 5 fields that I am querying for and opening a report to display the results. I want to only show certain text out of one field due to all the garbage data within...

Well, I am back once again with another issue. I have 5 fields to describe each error that is logged. The first field is the location of the problem, 2nd is the error message that it creates, 3rd is the date, 4th is the start time, and the 5th is the end time. I have figured out a way to...

Having a bit of trouble once again. I have a few fields that I am querying and three of them have to do with time. Two fields are the start times and end times of an error that is being logged. The thrid column is a sum between the two start and end times. I need to calculate a sum of the...

Hey Folks, I am trying to filter out records throughout a 24 hour period using the times logged. The only problem is that all my records have a start and ending time. I probably could use just the start column since it will pull all the records within a time period. The major problem I am...

Is there a way to get a percentage based number off of information entered utilizing the yes/ no check boxes rather than a numerical input value. I have users entering audit information by checking a yes/no box, and would like to be able to run a report showing efficiency. The only way I would...

Hey folks, I have a table with several data fields in it, but the most important benig the cost for each seperate row. I am trying to compare that data with another table that holds my plan costs for the data fields in the first table. Does anyone know how to create a query or report that...

Hello, I having trouble deleting that pesky import errors tabel that is created when I import an excel worksheet. The import errors are due to Date information that is not in the right format, but I can't go in and change it in Excel due to the amount of imports that will be done. Is there a...

I am currently importing an Excel table into my database, but unfortunately Access does not like a part my imported data. Mostly the date due to it not being in text format. Due to the import errors, Access creates an import table to store the data it had an errors with. Is there a way...

Hey folks, I simply want to filter out data that equals $0.00. I seem to be having issues with this. I have several other filters going, but this one does not want to work properly. any help would be great. Thanks.

Hey folks, I have just about wrapped up my database, and I cannot figure out how to automate one bit of my DB. At the startup of my DB I have to import an Excel file that contains data that Access has a hard time transfering due to its nature. As we all have seen, it creates a...

I have a few hairs left to pull out, but I like the new Homer Simpson look. Could someone please help me out with this? I am kind of new to Access, but anxious to learn. I have a Like criteria that ask for the user to input a building name (i.e. Memphis), and it works great. A few people...

Hey folks, While working the night shift my company expects me to stay awake and develop a simple database for filtering data, but I have now achieved a brain block. I have a list of data that I need to search through and select only the numbers needed. For example, I need to filter and...

I am trying to create a database for an inventory that is continuously changing. I have created 12 tables that contain the inventory for each specific location. I would like to create a seperate spare parts inventory that would keep only the spare parts that have not been installed. The...

I am using the code: SELECT a.[Unload Device], a.[Scanner Position], a.[Serial #], a.[Model], a.[Tested By], a.[Test Date] FROM [Unload Inventory] AS a WHERE (((a.[Test Date])=(Select Max([Test Date]) from [Unload Inventory] where [Unload Device]=a.[Unload Device]))) ORDER BY a.[Unload Device]...

What I am doing is creating a database to keep track of our scanner inventory from 10 different conveyor lines with 10 different scanner positions. We change out a few scanners on each of these lines with new ones weekly. I have developed a table for each conveyor line, with a form pointing...