Search results for query: *

Good morning, My MIS guy can’t find a solution so I am asking my Tek-Tips friends. GENERAL INFORMATION My manager and I use Microsoft OneNote and collaborate on a regular basis throughout the day every day at work. In an effort to be more mobile my company has replaced our PCs with a laptops...

Good morning, Question: Is it possible to get my sql statements from old Crystal Report files that I have on my PC? The problem (short version): Many years ago my company bought me Crystal Reports XI. My company paid for my training to use CR XI. My PC crashed and my MIS department decided...

Good Morning, I am trying to set a Validation based on the Assigned To field. I am not sure if it is possible or at least what I have tried so far has not worked. I am hoping that someone can correct my formula so this will work. Overview We are using Share Point 2007 to assign tasks which flow...

Good morning, PROBLEM I am having trouble systematically removing a hidden character or space from part numbers. DETAILS 1. Table is linked to an excel sheet where the hidden character problem starts. 2. Each excel sheet is different in size. 3. Not every part number has the hidden character...

Hello, I am trying to name a formula and I can't figure out how to do this. I am working on a list in SharePoint and I have a calculated field with a formula. I would like to have the field display a name rather than the formula. Below is the formula...

Good morning, This is what I am trying to do but it is not working. **If Required Date is less than todays date then flash. I have not used VBA but a few times so I am having trouble figuring out what I am doing wrong. The background is not flashing. Below is my code: Private Sub...

Good morning, I have a text field in a query that contains 3 sets if data that I am trying to pull out. I have tried using the Switch function and the IIF but when I combine more than one statement it does not work. I am using ACCESS 2003 and do not know VBA. Below is not code but just a...

Hello, I have a report that I built in Crystal Reports 11. I have been asked to RE-BUILD as a query in Access 2003 for another user that uses Access 2003. In the query there is a field that is called "STATUS" which consists of numbers or letters that most users do not know the meaning of. In...

Hello, I work in our Supply Chain Group at work and build many of the reports that are used by our department. I have Oracle SQL Developer on my PC and have taught myself how to build basic queries using SQL. I currently also use Crystal Reports and Access 2003 in building many of the reports...

Good morning, I have a user that has a problem with Excel (2003 & 2007) email attachments. All his emails that contain an Excel attachment will only open in read-only mode. The problem is that if the sender requires him to make changes to the Excel attachment, he is forced to take extra...

Good morning, I have a Crystal Report that works great but my management has requested that I create the same query in Access 2003 for multiple users. I have created the query in Access 2003 but I can't figure out how to re-write the formula in the Expression Builder. I have used the...

Good afternoon and Merry Christmas, Is it possible to exclude a specific week or dates with-in an existing date range? We will be off work next week so I do not want to populate that week on my report. My report is ran every Monday morning with the date range of 20 weeks. The purpose of the...

Good afternoon, I have a report that I need to only pull records that are within plus or minus 7 days of current date. This is what I have: First, I have to choose between the need date or the promise date. (which works fine) Formula: IF {@PROMISE DATE} = 'NULL' THEN...

Good Morning, Summary of what I want to achieve: From my main form I would like three combo boxes to auto populate my main data table. Database Details: I am using one form and two tables Cage_Code_tbl is used only for the purpose of auto populating three combo boxes on my form. PBOM_tbl is my...

Hi, I have been working on a access data base for the last couple of days. I don't know how I did it but I managed to delete my most important form. Does anyone know how I can recover the form with out installing software. This is my work PC so I am blocked from installing software. Clay

Good afternoon, Question: Can I set up MS Outlook to send reminder emails until a reply is recieved? How I handle this currently: I send a email to our company in France requesting them to correct the engineering for a bad part number in their database. Most of the time I do not get a reply for...

Good Morning, -Goal: To determine "months of stock on hand" -Problem: I have fields that are empty with no data or a qty of zero. That is causing me to get an error message "Division by Zero" so the report will not run My formula: {TS.AVAILABLE} / {TS.AVG_MONTHLY_USAGE} Does anyone have any...

Hello, Subject: ad keeps popping up (ad.doubleclick.net) and will not stop. current virus software used: Webroot - does not detect any problems. I have followed the suggestion on yahoo and added 127.0.0.1ad.doubleclick.net in the last line of my host file. That did not work. I have...

Happy Thanksgiving to all, I was messing with the display settings on a pc which would only use 16 bit color and 640 x 480. Everything on my screen was huge. Not sure what I did but now there is nothing on my display at all. Is there a way that I can reverse this through the bios or anyother...

I have tried to find this by searching but I just don't understand. I have a form using access 2003 that I need to be able to drag n drop emails and excel files into and be able to open from a record. Example; I have a list of part numbers that are emailed to me. I want to be able to attach...