Search results for query: *

Hello everyone. I need help in removing the characters out of a cell that also has numbers in it. I have this report that I want to modify but some of the cells contains numbers and letters. I want to remove the letters in one shot. Ex. Weight 69,972.00 lbs 5,023.00 lbs...

Before I go out and buy a new hard drive, I'd like to ask you guys for solutions. I can not get to ME. It say's "Insert Disk, Failure to Boot" befor ME loads up. I've used a start up disk that I created with ME when it was running fine. It did not solve the problem. I decided to...

I'm having trouble understanding vlookup and Hlookup. Would someone be kind enough to explain how it works? Also, can someone send me an example at vigorous1@yahoo.com. Thanks, RookieDBO

I would really appreciate it if someone could tell me where I can find a a generic network card driver. However, I do not know what my network card brand is. I just bought a "used" pc as is. I formatted it and installed ME and everything works well except for the network card. I...

Please help with DGET function. I cannot get it to work. It works well with LOTUS123. I got the following formula from Lotus. @DGET(<<U:\REF\Dep-desc.123>>$ZZ,&quot;DMM_Code&quot;,DEP=C4) @DGET(<<U:\REF\Dep-desc.123>>$ZZ,&quot;DMM&quot;,DEP=C4) How do I translate this into Excel? Would...

I just recently changed company but with similar job description. However, my new company does not use ACCESS but instead uses APPROACH. Which by the way &quot;SUCKS&quot;. I've heard some good news but don't really understand it. There's talk about using ACCESS &quot;RUNTIME&quot;. Is this...

I need help on modifying a date criteria that I have. I've got a column in a table that contains number of weeks. Week_Num 49 50 51 52 I have a query that would only extract the past previous 8 weeks. I run this query every week. I would like to automate this query. I manually...

How do you unhide a module? I had made my modules hidden. I need to know how to make them appear again. Thanks, RookieDBO

I need help in making this calculated field work. I'm trying to format the result of this calculation to show with one decimal. Help would be greatly appreciated. WEEK OH QTY: Format(Sum([Yogurt Report]![BILL OH QTY]/[Yogurt Report]![FCST QTY]&quot;0.0&quot;)) Thanks, RookieDBO

I need to know if there's a way to protect my pc after office hours. I have these daily automated process that runs overnight using Task Scheduler. They are production reports created from MS Access and emailed automatically by MS Outlook. I tried using Screen Saver password but it interfere's...

Could someone or everyone help me in creating a module that is similar to the &quot;SendObject&quot; macro? I've created a database that extracts and manipulate data for my inventory managers. I then use the SendObject Macro to distribute the final table in an Excel format. This is a daily...

Would someone please help me take off the decimal of my expression result. I tried adding &quot;Int&quot; but could not get it to work. I've got a text to display if it's being divided by zero else go ahead with the calculation. However the results are showing with decimal. Don't want that...

I build an expression that does a division calculation. Now I need to format the output with 0 decimal. Please help. OH QTY: Sum([Yogurt Report]![BILL OH QTY]/[Yogurt Report]![CURR FCST QTY]) Thanks, RookieDBO

Is it possible to schedule Outlook to email an attachment daily? I need to email an Excel file daily that is produced by Access using macro export. Thanks, Joe

How do I make a macro that would email a table in an Excel format??? Is this possible with Access '97. I created a macro that exports to an Excel format, but I need to find a way to auto email it. This would be a daily process. I want to automate it. Thanks, RookieDBO

How do you create a SAS table using proc report? I want to create a table specifying the order of variables. I was told this is the best way to do it. Is this true? I also tried &quot;Drop&quot; and &quot;Attrib&quot; option but couldn't get it to work. What's the fast and efficient way to...

Everytime I launch my internet explorer in ME from turning on my pc, it freezes up. I usually have to shut the program down using ctrl, alt and delete then launch it again. Is there a fix for this besides re-formating my hard drive? Thanks, RookieDBO

When using the &quot;Transfer Spreadsheet&quot; macro in Access 97, is it possible to format the spreadsheet as well? For example, set up the print format and bold the column headings, etc... I'm trying to avoid having to do it daily in Excel 97. Thanks, RookieDBO

I just realized that my hard drive in my PC at work was set in &quot;shared&quot;. I usually have it on all day and night due to my daily process that I have scheduled to run every night. I tried to restart today and got a message that says &quot;2 other users are connected to my...

I'm a junior data analyst in my company. I use Access as my primary tool. I need some advise on what type of reports I can develop in MS Access to impress my employers. I virtually have access to all kinds of information at our oracle database. From wholesale, distribution and retail sales...