Search results for query: *

Hello everyone, I've run into a strange problem that I can't seem to resolve. I recently purchased a Compaq Presario with Windows 7 Home, then I upgraded to Professional to use it here at work. Thirty days after purchase the hard drive failed. HP recently sent me a new hard drive and the...

I'm currently working on a report that's pulling all of my data from a query that's main function is using the "group by" command. For example, if I have 5 purchase order numbers of the same value I only need to see that value once. Due to the desired report format I have to use a...

I'm currently working on code so the end user will have an open form in Excel then upon execution of a command button the user will be able to browse their pc for Word files needed to update the current Excel document/form. Once the Word document is opened I want to automate the process of...

Hello, I'm building a form with an active clock that tracks the current time via a text box. This works like a charm. It's constantly running unless the user stops the clock with a button. When the command button is selected it copies and pastes the "paused" time into another field so this...

Hello, My objective is to link an Outlook folder to an Access database in order to extract specific fields from Outlook that aren't included in Microsoft's clunky Import/Export Wizard for Outlook. I'm currently using Office 2002. I've followed these steps in an attempt to link the two...

I've been down every road at this point. I've read through the FAQ, I've researched prior posts, the whole nine yards and I still can't seem to figure out how to properly use Dmax. I need to make a custom control number. Example ST30549, ST30550, ST30551. This number has to sequentially...

I'm working with barcode software from Loftware and Access all at once. My objective is to enter information via a form in Access, but to click on a print button on this form that will print through Loftware which inturn will produce a series of barcodes, etc. on a label/form. Everthing in...

I'm working with barcode software from Loftware and Access all at once. My objective is to enter information via a form in Access, but to click on a print button on this form that will print through Loftware which inturn will produce a series of barcodes, etc. on a label/form. Everthing in...

Hello, First of all I know there are a million BETTER ways to do this, but I've managed to get the first half of this to work in my database so I'm running with it. I'm trying to nest several Iif functions together in one query field but I'm having some problems. The first portion of the Iif...

Hello, I picked up some great pointers on here about using both the INT and MOD functions in Excel. But now I'm trying to find a work around solution to a problem i'm having in a program that isn't as powerful as Excel when it comes to preset formulas. The program doesn't offer the INT or...

Hello, First let me explain the application I am trying to sort out and then perhaps someone can suggest a better way of doing this bcuz I think I'm going down the wrong track. I'm working with numbers in a production environment where the number of items ordered is constantly changing for...

Hello, I'm working with a database that is designed to track sales information of specific part numbers, when the units were sold, how much each specific order was invoiced for, etc etc. I'm having problems filtering one report in this project. I'm sure there is an easy solution, but I...

Hello, bear with me through this I'm obviously an Access newbie. I've installed Calendar Control 10.0 into a form that I'm working on. The purpose of the form is to select products, quantity, and due dates in order to create a daily/weekly production schedule. The problem I'm running into is...

I'm trying to build a production time expression for a report. My end goal is to obtain a production time number in hours. Everyone knows how much fun it is to work with time and dates in Access. Anyways what I have so far is this =[quantity]*[pages]/(7000)*(60) It's currently taking a...

Ok guys, bear with me...I'm new to the world of Access and these are really trivial questions, but I need a helping hand. I'm using the conditional formatting wizard in Access. I know how to use the formatting options, they're really basic my problem stems from the expression I'm trying to...

I'm trying to build a production time expression for a report. My end goal is to obtain a production time number in hours. Everyone knows how much fun it is to work with time and dates in Access. Anyways what I have so far is this =[quantity]*[pages]/(7000)*(60) It's currently taking a...