This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 3351. |
Solve : Access 2016 Export to MariaDB ( WAMP installation )? |
|
Answer» Trying to figure out a way to migrate my Access 2016 database to MariaDB which is in a no-password WAMP installation. Its nice that after all these years Microsoft Access still doesnt have a easy export ( dump ) of database to something like alldatabases.sql for easy import to MySQL. |
|
| 3352. |
Solve : Excel and latest MS "upgrades"? |
|
Answer» Hi, after two overnight (non-optional) upgrades by MS earlier this week, I can no longer use Excel. I can't create new s/sheets. I can open and view existing s/sheets but can't make any changes; any attempt to change a cell (or to tab or use arrows to move between cells) results in (i) creation of a new version (copy) of the existing s/sheet, and (ii) closure of the XL programme. I'm using Windows 10 and Office XP. |
|
| 3353. |
Solve : Processor Fan not Work Proper? |
|
Answer» I am trying to open my COMPUTER and wash all dust from it and check my system FAN into another system its working but while i was try to ATTACH into my system its not workHuHH ? ?where are you hung up... trying to open your case, trying to 'wash' dust, trying to check it's working, or trying to attach?Google has a translator AVAILABLE to type in your native language and output it to English if you struggle with English. You can then state the issue in your language of choice and get the output in English to post here which might be easier for us to understand. Additionally a picture or a couple pictures of the issue can also point out where words MAY struggle to explain. |
|
| 3354. |
Solve : Looking for an old chat client? |
|
Answer» Hello, first time posting but I've been scouring the internet for an old chat client i used to have back in 2011 perhaps? It was called something like Global Network Chat or GNC or something like that for SHORT. The logo itself was a planet, blue/green, very old. I just simply can't find any trace of it. |
|
| 3355. |
Solve : Free Cell? |
|
Answer» When I changed to Windows 10 on my desktop, I had the address of freecell from my old program. I'll try it thanks Greenhorn. Clik Topic Solved...bottom of page... |
|
| 3356. |
Solve : Video Software won't respond.? |
|
Answer» A while ago I had bought this video software from NCH software. All was working fine for a while until when I boot this up the whole application doesn't seem to respond to any kind of input from me. Also seems like the damned thing isn't even there. Every time it the application will sit in the corner of the screen. The only way I can close the software is force closing it via the task manager. I have already attempted to uninstall and reinstall the software, reset my computer and contacted NCH. It seems like a SPECIFIC problem but hopefully, it can be solved. Judging from their website i'm sorry you spent money on it...it's just yet another GUI front end with ffmpeg in the background doing all the work. Why would anyone PAY for it when Handbrake is free?No idea... |
|
| 3357. |
Solve : I am trying to boost the framerate of a video and MEgui isn't working.? |
|
Answer» I am trying to double the framerate USING interpolation to MAKE a video look nice and smooth, and I am following this guide: (http://www.spirton.com/convert-videos-to-60fps/). |
|
| 3358. |
Solve : How to Get Firefox to Ask About Popups?? |
|
Answer» At one point when I was browsing, I accidentally clicked the option to not show me this notification about if I wanted a pop-up to open when I was trying to open a pop-up. Now, I can't find any way to turn the thing back on, and I'm having to manually add websites to pop-up exceptions in the settings, which is super annoying, because I don't even get a notification that a pop-up was blocked if a WEBSITE was supposed to serve me one that I needed. Run FFox with no addons...probably 1 of those actin up.This is some Firefox config that had the value changed. I don't have any add-ons that do anything to the UI or pop-ups. Quote from: BC_Programmer on June 16, 2018, 04:05:20 PM There is an "Exceptions" button to the right of the checkbox itself. Allowing pop-ups via the prompt/notification adds an exception there. I mentioned adding exceptions already, and there's nothing about restoring the notification there. The only thing I can see in the exceptions is the websites I now have to go all the way in there to add every time. Edit: Well I ended up finding it myself after getting an idea while thinking about it again. For anyone in the future who comes looking, if you go to about:config using the URL bar and then search for privacy.popups.showBrowserMessage, it will show up as false. Right-click that LINE and toggle it to true to restore the pop-up notifications.Well someone screwed around because the default is true...Quote from: patio on June 17, 2018, 06:17:07 PM Well someone screwed around because the default is true... If you had read the original post, you'd know how it got set to false... |
|
| 3359. |
Solve : XP it will say this disk needs checking for consistency? |
|
Answer» On startup of XP it will say this disk needs checking for CONSISTENCY hit any key WITHIN seconds USUALLY get this when you unplug machine from power is there or can it be done so one can disable this?1) Why are you unplugging it? You should not pull the plug while while in Windows (or even when it isn't until shutdown is complete). |
|
| 3360. |
Solve : Selective Syncing? |
|
Answer» I'd like to create a backup of a rather large directory - but NOT every subdirectory in it. And then I'd like to continue syncing the directories, continually OMITTING those same subdirectories (but copying over new subs as they get added to the original). |
|
| 3361. |
Solve : trying to perma change default folder icon? |
|
Answer» Every time I start a NEW folder I want that folder to ALWAYS have a specific folder icon that i made INSTEAD of the standard defaulted one without having to manually go in to properties and change it myself every time. How can I do that?You can't without changing it in Properties... You can't without changing it in Properties... i mean something so simple should be possible, its 2018 after allAnd next year it's gonna be 2019... Pretty simple task as it is now...Quote from: patio on June 27, 2018, 06:17:36 PM And next year it's gonna be 2019... um ok, do you mind explaining?You can change the IconPath Value in Computer\HKEY_CLASSES_ROOT\Folder\ShellNew in the registry to set the folder's icon for a new folder, I expect.Its not possible to change folder icon without change its property. SINCE you want to change folder icon as per you requirement, you can change it by folderico.com. |
|
| 3362. |
Solve : Fan stopped working? |
|
Answer» Suddenly whenever turning on my HP Pavilion 1000 laptop, a message appears that a fan stopped working but if I press Enter, I can go ONLINE. Why did the fan stop working? I never mistreated or dropped the unit. I notice it gets very hot. The PC is about 4 years old. Any advice?Replace the fan. You can buy them from various local retailers i many CITIES and online retailers. |
|
| 3363. |
Solve : I can't disable Fix connection problems button? |
|
Answer» Hi there! I'm Thierry. |
|
| 3364. |
Solve : Access 2016 - Cant Save Database - Database Already Open by myself? |
|
Answer» Curious if ANYONE has worked with Access 2016 and ran into this issue and know a solution for it. |
|
| 3365. |
Solve : Steam client service stop itself, Please help? |
|
Answer» The problem of steam won't start is steam client service, I tried starting it in Services but it stops itself, This is why steam is not starting at all, PLEASE can anyone help me? If you uninstall steam and then reboot computer and then download and install the latest version of steam then this problem should be resolved. I did but nothingSounds like the Windows install has issues then and I would back up all your data to external drive and perform a clean installation of Windows, then install Steam again.Quote from: DaveLembke on July 22, 2018, 11:02:38 AM Sounds like the Windows install has issues then and I would back up all your data to external drive and perform a clean installation of Windows, then install Steam again. I realized that the steam client service is stopped, and when I try to enable/start it, It says: 'steam client service started and then stopped some services stop automatically if they are not in use by other services or programs', Can you please help me with that?Has this system been DAMAGED by any malware or virus's? The fact that the service is failing to load and hold without failing means that Windows itself is damaged or infected since you downloaded and installed a new clean copy of steam. To find the exact cause as to why Windows is having issues with keeping the steam service running is like looking for a needle in a hay stack and you dont know what the needle looks like. So its easiest to perform an etch-a-sketch to the system ( wipe the hard drive and install clean ) and start from a clean OS state and clean Steam download and install and go from there. Have you run an up to date antivirus and checked your system over for an infection?He's infected...Quote from: DaveLembke on July 22, 2018, 02:56:45 PM Has this system been damaged by any malware or virus's? Well I tried scanning the system, but the problem still persists, Well I'm gonna now SCAN again the entire system and I'll keep you updatedDo you have the original installation media or if its a name brand computer you purchased preinstalled with Windows and software, does you system have system recovery options built into it with a recovery partition to perform a clean install of Windows if needed?Quote from: DaveLembke on July 23, 2018, 07:33:12 AM Do you have the original installation media or if its a name brand computer you purchased preinstalled with Windows and software, does you system have system recovery options built into it with a recovery partition to perform a clean install of Windows if needed? I don't know, How do I check these?What Make/Model is computer? Or is this one that was custom built and lacks a name brand like HP, Dell, IBM, etc1. Did you actually uninstall Steam and then reinstall it? reinstalling steam over top of the existing install does not do the same thing. 2. Uninstall and reinstalling steam reinstalls Steam itself, but does nothing if the issue is caused by corrupted data in your steam library itself. You would have to completely nuke your Steamapps directory (or temporarily rename it) and then reinstall steam and see if it works- if so something in your library was corrupted/broken. 3. If you run steam as admin, it will try to resolve any issues with the background service if it is misconfigured. It cannot do that under normal CIRCUMSTANCES due to permissions. 4. Is steam being blocked by your firewall or security software? If the Service is unable to connect it gives up and exits. Quote from: BC_Programmer on July 24, 2018, 02:34:17 AM 1. Did you actually uninstall Steam and then reinstall it? reinstalling steam over top of the existing install does not do the same thing. I tried these but nothing |
|
| 3366. |
Solve : Upgrade suggestions? |
|
Answer» Hello, |
|
| 3367. |
Solve : Pc gotten slow? |
|
Answer» How did it go? I'm having PROBLEM with PC being slow lately I'm planning to do a clean install but if the above solution works I will try it ALSO. Thanksbrav3 - please post your problem IN DETAIL in a separate threadQuote from: brav3 on JULY 28, 2018, 11:06:42 AM How did it go? I'm having problem with pc being slow lately I'm planning to do a clean install but if the above solution works I will try it also. Thanks My pc still seems to be pretty slow, still trying to find the solution**UPDATE** Pc specs: Intel(R) Core(TM) i5-4460 [emailprotected] 3.20GHz RAM: 8,00 GB System type: 64-bit operating system, x64-based processor GPU: NVIDIA Geforce 970 GTX So i've updated my driver, used msi afterburner (steady 50 degrees ingame both gpu and cpu), scanned my pc for everything, restored my pc, cleaned my pc, no background programs harming pc, optimized my drivers, and other stuff i dont remember. I've tried running on lower graphics in games, but it the lag still doesn't change. The weird part is that it's happening even though i have 90 fps, my friends SAY its my cpu thats not working correctly. |
|
| 3368. |
Solve : Software Developement Help? |
|
Answer» Hi All, |
|
| 3369. |
Solve : MS Access 2016 - SQL copy paste issue between 2 databases? |
|
Answer» So I have a final that I am working on and just about got it done. Went through to make sure that all was well with some forms and some fields in one of the forms shows that there is an issue now. Not sure how the issue happed as the tables and relationships haven't been altered in any way, but I have like 60 saves going back to the very beginning of my final project and the 5th save back doesn't have the issue. |
|
| 3370. |
Solve : Folders creation from a selection list? |
|
Answer» I am searching for a FREE program able to CREATE folders from a selection list . |
|
| 3371. |
Solve : How can I normalize levles of all MP3 in a folder?? |
|
Answer» I have an ALBUM of MP3 songs that have very low level. |
|
| 3372. |
Solve : Just discovered FFmpeg suite.? |
|
Answer» Just want everybody else to know. "Samson Trout" ? ?Did I say that? Quote from: patio on August 21, 2018, 07:29:33 PM "Samson Trout" ? ?Better not cut my hair sounds like a cool program, i'll check it out!Quote from: Salmon Trout on August 22, 2018, 12:32:46 AM Better not cut my hair Quote from: patio on August 22, 2018, 03:41:42 PM But first Delilah... |
|
| 3373. |
Solve : Unifont - how to force private characters displaying?? |
|
Answer» Hi! |
|
| 3374. |
Solve : How to find exact hidden document.? |
|
Answer» So I have a folder of pictures, about 5,000 to be exact and I saw that the "Show Hidden Items" box was not checked, so i clicked it, now it says i have 5,001 images, but i dont know which ONE it is, is the a WAY to find out? Cuz it'd be a real pain to check every line of pictures until i found it.In Details view, if you right-click one of the Columns, there is a 'More' Option; that will TAKE you to a list where you can select "Attributes" to be displayed as a column. |
|
| 3375. |
Solve : Enlarging Font size in incredimail.? |
|
Answer» When I TYPE a message with Incredimail the FONT is too small, I was advised to go to view, text size. HOWEVER, the text size is not there, any idea on how to GET over my problem? incred are no help, I am on windows 7 and GOOGLE chrome, thank's in advance.This might help: http://forums.incredimail.com/viewtopic.php?t=167024 |
|
| 3376. |
Solve : Which Spyware, Malware etc. Package? |
|
Answer» Hi everyone, Thanks very much for that Kpac. Not completely necessary. If you feel you need it then do, but if you're the type to scan regularly, then the free version will do you fine. |
|
| 3377. |
Solve : Free ware? |
|
Answer» Can someone please direct me to a safe website for freeware/shareware please? |
|
| 3378. |
Solve : Acronis, do I have to purchase yet another copy?? |
|
Answer» I have now purchased two copy's of ACRONIS true image. I REALLY like the software but I am reluctant to buy yet another copy that I need. I have purchased "True image 10 Home," for my windows Vista and just recently purchased "true image home 2009," for a laptop I bought. I have windows 7 RC now and want to make an image of all the things I have installed, just in-case anything goes wrong while I am testing it. I am dual booting it on the same computer that I have vista on and both windows are on SEPARATE harddrives. Now my question is, do I have to purchase this yet again to take an image of my windows 7 installs?No. No. Patio - Can I use one copy of Acronis on more than one computer, or do I have to purchase another copy? I am thinking that I have to purchase a new copy each TIME I have another computer. |
|
| 3379. |
Solve : GOM Player help? |
|
Answer» I got the FREE GOM Player and it should play MP3s and Wave Files and everything ELS and it did. |
|
| 3380. |
Solve : Problem while loging into Widows? |
|
Answer» I have looked through some of the FAQs but to no avail anyway. I updated somethingLike what?No its not that I updated anything sorry forgot what happened before this incident I did defrag with disckeeper deleted a bunch of file I dont use like movies and such nothing important I then restarted the comp witch I should have never done pritty much it I did change a crap load of stuff in my registry though I restarted several times Tuesday when I did that and nothing like this happened I got rid of file that where making my cnc 3 tw not allowing me to play the game that and stuff that same day to FIX my crappy COMBO drive to recognize blank media that didn't work actually though I restarted several times without a problem other than those things I have no clue as to whats doing it VIRUS scan came up nothing on the HD kinda annoyed I can always take the next whole week transferring data to this HD though their is a lot of other data I wont be able to put on this one or not sure if I can, though I would love a fix. Sorry if I ramble a bit or get of topic that and hope all that made sense sometimes I don't. Well, if you "I did change a crap load of stuff in my registry", then I have no idea how to help you. System Restore?Well I have tried system restore but the boot menu on here doesn't have those options just lets me choose what HD I can boot that and I cant figure out how to do it sing this HD.This is all unclear. How far can you boot in Normal/Safe Mode?Tell ya the truth I cant remember the last time I had to do boot to last known configuration or use safe mode all my problems have never needed either so I really don't know how to do either. In normal mode I cant get anything but task manager to pop up and even then altering anything crashes task manager.Time for a clean wipe and re-install of Windows...In Normal Mode, what happens, if you open Task Manager>New Task, and type in: explorer, click OK? To get to Safe Mode, restart computer, and keep tapping F8 key until menu appears.The thing is the menu does appear but it only asks what drive to boot up. Task manager just screws up it goes to looking like windows classic looking adn catn move it or anything kinda like it freezes left it for like 5 mins still nothing so no clue think clean install is all I got left got some of the important data on my large hd took me 2 hours to figure out how to find my bookmarks witch is one thing I needed. The only other option is Windows repair: http://www.geekstogo.com/forum/How-to-repair-Windows-XP-t138.html If that doesn't work, you're left with patio's advice - reinstall.Well I finally found my xp disc and well its cracked :O some jack off stacked books on top of the folder it was in *censored* so annoyed right now what do I do I still have the product key. Borrow a CD of the same version and Service Packs... |
|
| 3381. |
Solve : GMail Drive shell extension 1.0.13 installation. xp IE8? |
|
Answer» I am TRYING to install the above shell extension but it stops during installation and stays on "Windows is now setting up the following items : GMAIL DRIVE SHELL EXTENSION" |
|
| 3382. |
Solve : Playing a 3gpp file ?? |
|
Answer» I have a load of 3gpp files on my lapop that i want to save to disk and hard drive, but some of them just wont play, iv tried opening them in real player and quick time but they wont I'm not sure they are compatible with a computers media player. They are meant for mobile devices. http://www.apple.com/quicktime/technologies/3gpp/OK. Just wanted to be sure. Try the ONES that will not play in VLC media player. If they still don't work they could be corrupt. If they do then I suggest using VLC. It's very good with non standard codecs.Also, you can try getting the free software (it does good, I tried it) from below link and try converting your media to other media file types to see if the media will like it better than the original 3gp (or 3gpp, whatever that format's name is) format ... http://www.erightsoft.com/SUPER.html That has gotten some media files to play on my computer that way. The original file wasn't playing and the person who sent me the file said his computer was playing it with no problem with the original media type so... give that a shot too |
|
| 3383. |
Solve : Qosmio G20 - Tv tuner software? |
|
Answer» Hi |
|
| 3384. |
Solve : Why does my mp3 icon does not appear???? |
|
Answer» Ive recently remove some programs. Dont ask witch ones plz. THing is i have my mp3's but now windows shows my mp3's with an icon of windows media player and cant open them in the windows media player only. So I wanna know how can I return the mp3 icon file or its program or driver whatever. I wanna know what does it needs cause i know the windows media player works just fine.let me try be more clear if I click the icon of the mp3 it wont open it tells me it needs SOMETHING else. WHAT IS IT? The problem is my mp3 icon would still be missing. Is like my PC does not have the program or driver to make a shortcut . The icon am talking about is a music note colored blue saying mp3 right but what i have evrytime i download an mp3 is this. Depending on what program opens the file by default, the icon will change to that program's icon.That's it.THn k U guys ur the BEST!! We know .....just kidding Quote from: Broni on June 07, 2009, 10:08:19 AM That's it. Yes SIR, Lieutenant General Broni. Just "the great Broni" should be fine. |
|
| 3385. |
Solve : Hi about the error using an injector program..?? |
|
Answer» It is about x1nject injector, it's an injector for a game which injects a .dll file. I have 2 computers at home. One is vista ultimate while the second is vista home basic. The problem goes this way. When i run the program on the 1st computer it displays "x1nject has stopped working. A problem caused the program to stop working correctly...blah blah...and a button shows (Close Program) which can be pressed". |
|
| 3386. |
Solve : PS3 external hdd? |
|
Answer» I bought a 1 TB hdd for my ps3 and found how to convert it to fat 32 here : http://www.wikihow.com/Add-an-External-Hard-Drive-to-a-PlayStation-3 but while i'm on a vista pc the "Delete Partition" or "Delete Volume" |
|
| 3387. |
Solve : issue with word macros? |
|
Answer» Hi, The trouble is that the macro suddenly becomes something else ...Do you mean the procedure recorded in the macro actually change or that the menu icon you added as a shortcut to the macro changed?Thanks for your reply, Soybean. The answer is No. The bluetooth is not supposed to be part of the macro. For some reason, all the macros i have set up in the word template are replaced by these bluetooth connections. When i clicked on them, it said something like could not FIND the connection. Any help would be greatly appreciated. Thank you in advance |
|
| 3388. |
Solve : Filing emails by date from Outlok 2003? |
|
Answer» Hi, EVERY month I save my emails to a folder on my hard disk by copying and pasting to that folder. When they are pasted they file by subject line. I want to file them by date. At the moment if I want to do that I have to go into the subject line while they are still SITTING in Outlook and TYPE in the date then I can copy and paste them to the folder by date. Needless to say that is very time consuming. Is there another way I can file them to disk by date? Hope someone can help. Regards |
|
| 3389. |
Solve : Windows and the software are not compatable? |
|
Answer» God Blessings! konami, It would help to get a better responce if you provided more info. What is the operating system and what is the software you are having issues with? truenorth We are using Windows XP but the dictionary software is compatible with older versions. Is there any way to install it on XP? Thanks! Quote from: BRONI on June 08, 2009, 12:02:54 PM Did you try to install/run it in compatibility mode? Quote from: kpac on June 08, 2009, 12:42:58 PM If you can get your hands on a CD of the version of Windows needed to run the software, download, install, and run Microsoft Virtual PC 2007. Do you need more details about these two SUGGESTIONS? |
|
| 3390. |
Solve : Just reinstalled windows, think I did something wrong.? |
|
Answer» I just reinstalled windows on my computer and honestly it got to a part that I didn't really know what I was doing. It was talking about "partioning" which I dont think I want. Does that mean it PUT windows on half of my computer? Im not really sure what was going on. when i would go into computer it would have something extra next to the C: drive, and it had a red bar. Well anyway I re-installed in again and somehow I got rid of that, but now it says I have 72.4 GB. That can't be RIGHT, is it? I thought I had a lot more space before I re-installed. Now I feel stupid for doing that. Is there something I can do? |
|
| 3391. |
Solve : helppppp..? |
|
Answer» how can i CHANGE the my computer PROPERTIES logo? how can i put my picture on it? Assuming you mean the System Properties Logo see here |
|
| 3392. |
Solve : Netscape 7.2? |
|
Answer» My netscape e-mail has stopped downloading my mail from my Embarq site. |
|
| 3393. |
Solve : Need Correct Syntax for Using Microsoft Rich Copy 4.0 Utility? |
|
Answer» Does anyone know how to use Microsoft Rich Copy 4.0 Utility? What is the correct syntax structure for using this SOFTWARE. I need to copy a large volume of files and thought it would be easier to use since it's GUI, but I don't know the correct syntax to use it because I keep getting "The system cannot find the specified path" error. Any HELP would be greatly appreciated. I've read the help file and it does not have a section for dealing with errors. I've also searched the internet for more information to no avail. I've tried to use XCOPY and ROBOCOPY, but I was unsuccessful. I really don't know how to create a batch file. I'm using a Dell Precision 490 desktop with Windows XP. QUOTE "The system cannot find the specified path" The above error message is not generated by Rich Copy but by your Operating System (XP) when looking for either the Source or Destination path. The error could be that the Source or Destination folder does not exist or that there is (are) space(s) in the Foldername or Path to that folder. Can you post the entries you are making in the Source and Destination paths dialog boxes. Edit to strike-through previous response: Have done some digging and find that Rich Copy will open Destination folders which have spaces and will open Source paths with spaces, both without the need for double quote " ".. The only time I have generated Error CODE 3 is when the Source path\folder does not exist. Attached are a couple of screenshots showing the results when (1) the source path cannot be found and (2) when Source and Destination paths are acceptable. Note that the folder D:\temp\does not exist\ did not exist and was created by Rich Copy. Error codes displayed are due to (a) the file being in use and (b) the job being terminated by user intervention. [attachment deleted by admin]try using quotes in your command line, like this, for example: copy c:\sourceFOLDER\"large folder or file to be copied" c:\experimentFOLDER\destinationFOLDER If the folder or file you are copying has spaces in it's name, like this: Large Folder or File, you'll have to use quotes around it to tell the computer to recognize it as ONE object If there are folders inside the directory you wish to copy from, you will have to use the XCOPY command and add the /s switch to the end of the command line, like this: xcopy c:\sourceFolder\"large folder to be copied" c:\experimentFolder\destinationFolder /s If there are a LOT of files an folders to be copied, give it a few minutes to COMPLETE after you enter the command and press ENTER |
|
| 3394. |
Solve : help with Excel macro? |
|
Answer» I am designing a “basic” database in work and having trouble with some macros trying to get the post-production information from that worksheet to the correct row in the database worksheet i cannot doDoes that "correct row" vary each time you update the database? In other words, it could be row 500 one time and some other row the next time? Did you create the macro using the VB editor built-in to Excel? Can you post the code in the macro here?yes that row changes each time, ie the FIRST production run record would have reference 1, the second submit of production data would have ref 2 etc the below was created in VBA. the fist part finds the first empty cell and pastes the data from pre-production into the database spreadsheet for ease i have removed 95% of the coding to give chance to read all on one screen! i am looking at doing exactly the same function with the post-production details, without finding the next empty cell, instead pasting to a specific row as determined by the operator (ie post production form has "enter DB ref No here" cell which i would like the macro to select, find that value in column A, activate that cell, then take the values from post-production worksheet and paste using similiar coding below (offset) to paste into the correct row Sub test4temp() Application.ScreenUpdating = False ' test4temp Macro ' 'selects the last cell in column A and moves to the next cell Sheets("Database MkI").Select Range("A1").End(xlDown).Select ActiveCell.End(xlDown).Select ActiveCell.Offset(1, 0).Select 'adds +1 to the previous cells figure ActiveCell.FormulaR1C1 = "=R[-1]C+1" 'select, copy and pastes the Objective/Customer details Sheets("job card").Select Range("B5:e5").Select Selection.Copy Sheets("Database MkI").Select ActiveCell.Offset(0, 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False 'select, copy and pastes the PROJECT Number details Sheets("job card").Select Range("B3").Select Selection.Copy Sheets("Database MkI").Select ActiveCell.Offset(0, 1).Select ActiveSheet.Paste 'select, copy and pastes the details of who submitted the job Sheets("job card").Select Range("B30").Select Selection.Copy Sheets("Database MkI").Select ActiveCell.Offset(0, 1).Select ActiveSheet.Paste ......etc for many more variables End SubI'm not sure I'll be able to help you resolve this. Let's see whether someone else has some suggestions. And, I'm going to suggest you register http://www.excelforum.com/ and post your question there.ok thank you for your time Tooooo complex for MS Excel, tooooo problematic. You should start over using MS Access, there is where your project belongs. Quote from: alexK on June 10, 2009, 09:45:17 AM You should start over using MS Access, there is where your project belongs.Good point. I totally agree. Quote i have a worksheet with a pre production formWith Access, pre production data could be one table and post production data another table. The third part could be another table or query derived from the first two tables. Soybean, Right you are with those tables! Having worked with Mainframe IMS Data Bases (heavy duty stuff) for decades, MS Access has a short learning curve. MS Access has surprisingly infinite possibilities to solve complex problems. Ms Excel has limited scope, and is sometimes frustrating. It is not really designed to do that kind of stuff. Learn from me! thanks but i am simply following the instructions from my line manager......will consider it but no one in this team has any experience with access so not a favoured option |
|
| 3395. |
Solve : Help needed with Wise Disk Cleaner,Version-4!? |
|
Answer» HI Geeks! Iam getting intimidated with the No. of Junk Files this 'Wise Disk Cleaner Free'(Version 4) is able to SCOUR through my system! Its WHOPPING 615 MB of Files & this includes .dll files as well!? (All Recommended settings). Mind you, Iam a religious user of CCleaner & keep my system afresh! I haven't deleted anything as of yet, BUT has any one of you used it before..safely?! What's your take on the recommended Junk File Cleaning utility?!Personally i'd stay away from it..... Others may have different opinions...Patio! What's your favourite "Junk File Cleaning" Utility(FREEWARE)? Just a Quick Update! Here's what "Wise Disk Cleaner" Guys have to say!(Check out the attachment).These claim it to be absolute SAFE! [attachment deleted by admin]Have you compared what junk files are displayed between wise cleaner and ccleaner? dll files as junk? or are they unused or duplicates? No I don think that CCleaner ever displays .dll files as Junk! All I know is that Wise Disk Cleaner carries a SAFE Green Mark that INDICATES: "It is safe to delete the file"!? Nevertheless, I have got the assurance of Wise Cleaner itself & I have yet to be the JONNY Bravo to delete those files with their Product! I'll prefer CCleaner only! |
|
| 3396. |
Solve : Want an advice against 'Task Scheduler' Service!? |
|
Answer» Hi Guys!
You can safely disable the task scheduler. Read more >here<.Quote from: Rob Pomeroy on June 09, 2009, 05:53:32 AM I'm not sure why an HJT log is necessary? Some malware adds services called Task Scheduler, but with a different filename. Just asked to post one as it might not be the usual one.Quote I prefer manual updating of my AntivirusWhy?It gives me an assurance & moreover I can quickly Wrap-up the things for more important work on Internet rather than to HOG my Bandwidth with Automatic Updates running in the background making the Surfing experience slowed down! Its all the in the Mind!...You know! I don't know, what you use, but my Avast updates in a few seconds, and all I can see is a notice from Avast: Avast database has been updated. |
|
| 3397. |
Solve : How to lose a Program on Vista?? |
|
Answer» I have a Program Running on Vista that when I try to Uninstall it. It does nothing. { I Mean Nothing Moves } |
|
| 3398. |
Solve : MS Word embeds figure images in cross references!? |
|
Answer» Hello, |
|
| 3399. |
Solve : Security Alert - Certificates?? |
|
Answer» Recently one of my computers acted up, ran slow, took about 20 minutes for XP Home Edition to load, etc. The initial MB logo screen would sit there for quite a spell as would the following DOS type post screen.... then I would either receive a message that requested I insert a START up disk, sometimes a OS install disk, or the screen might simply bring up the XP intial screen and have that little sideways scroll window run endlessly. Eventually, after about a half hour or so, I could finally get XP to boot up. |
|
| 3400. |
Solve : ms office pro xp? |
|
Answer» recently my four year old computer crashed and I LOST all of my data and I had to re-INSTALL all my software. I had ms office pro xp upgrade and when I tried to install it, the computer would not take it and said that there was no qualifying program to use for the update. Is there anyway that I can install this software without having to purchase and install another ms office component? Right now all I have is Works.Sorry to jump in RW, but a similar THING happened to me on my XP Home Upgrade DISK. A shop fixed it for me, but l don't know how, so l'll tag along if you don't mind to see what replies there are. |
|