Recent content by robk5787

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

Thanks, I will give this a try.

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

Thanks, That is exactly what I needed. Funny how it all makes sense now. I recall something like that being in the help! I guess being awake at 3:00 AM can do things like that. Graveyard shift! I appreciate the help!!

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

Thanks for the help. I will gve this a try.

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

Everytime I try to run this module I get a "Type Mismatch" error message with the "Current DB" part. I tried to play with it, but I do not to delet any part of my other DB components. I hate ask for more help, but I am new to VB code. I appreciate the help.

I appreciate your response to my question, and have tried to use this with my DB. As a somehwat beginner I haven't had the chance to really try any of the module development yet, and was hoping you could tell me how to input this in to my DB! I tried to create a module and type this code in...

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 thanks for the help everyone. I soon found the answer after I posted this earlier today. It seems as though the last post before this one had what was I looking for! <>0 was right on the money. Thanks again.