Over 1 million tech questions and answers.

Solved: Access 03 - Call Modules/Procedures

Q: Solved: Access 03 - Call Modules/Procedures

I have this procedure:
Private Sub Form_BeforeUpdate(Cancel As Integer)

This searches for empty fields and displays a message if any are
found.

I need this procedure to run when certain other buttons are
clicked. I know I don't have to cut and paste this every time. I
thought I could "call" the procedure...didn't work. So I cut and
pasted it into a Module and named it "ReqFields" with the same
procedure name...didn't work. I can't find good examples on the
Net. Can anyone help me! I don't know much in this area.
THANKS!!!

RELEVANCY SCORE 200
Preferred Solution: Solved: Access 03 - Call Modules/Procedures

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Access 03 - Call Modules/Procedures

ddw, I am not sure what you named "ReqFields", was it the Module or the Sub?
If it was the module then I would suggest it would be better to call the Sub either the same or something just as meaningful, do not use a Form's Event for it's name as it might confuse Access.
If you re-name your Sub as ReqFields then use
Call ReqFields

to call it.

Read other 2 answers
RELEVANCY SCORE 67.2

I am running Windows7, 64-bit operating system. In trying to run Windows Office Access 2003 on this operating system and an Access data base (which runs fine in Windows XP), I get the following error message when I try to execute an Even Procedure. This problem only occurs when running on the Windows7 platform with 64-bit, and not on Windows XP with a 32-bit system:

"File not found"

The following in Blue is the event procedure I am trying to run which upon clicking, is suppose to grab the contents of the "Bates" record (which is the name of a TIF image) and feed the TIF image name to an external image viewer: "i_view32.exe", so that the viewer then displays the image.

Private Sub Command13_Click()
On Error GoTo Err_Command13_Click

Dim stAppName As String
Dim txthold As String

txthold = "C:\Docs\" & Bates & ".tif"

stAppName = "C:\Program Files(x86)\IrfanView\i_view32.exe" & txthold

Call Shell(stAppName, 1)

Exit_Command13_Click:
Exit Sub

Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click

End Sub

Your help would be greatly appreciated.
 

Read other answers
RELEVANCY SCORE 59.6

I have a form with an option group. One of the options is to “Return to Claims”. When this option is selected, I would like for a text box to pop up so that information can be entered into the text box. If this option is not chosen, then I would like for the text box to remain hidden.

I am aware that I will need to set up an event. However, I am not familiar with this. Can anyone help me with what I need to do and how to do it? I will especially need help writing the code.

Thanks.
 

A:Access Help: Events/Procedures

Read other 10 answers
RELEVANCY SCORE 58.8

I have a form that I added The Microsoft TreeView Control to. I have my tree and I want to add the "NodeClick" event procedure but everytime I try to add it (in code) I get errors on ALL my event procedures.

I am guessing that I am missing a step and cannot just add the code directly like this:

Code:
Private Sub MyTree_NodeClick(Node as Node)
End Sub
When I add other events to this control using the properties box they work fine.

Can someone tell me what I am doing wrong?

Thanks,
Guy
 

A:Access 2000: Event Procedures

Read other 8 answers
RELEVANCY SCORE 53.6

Hi there

I was wondering if anyone out there knows how the Modules in Access 97 works. Is there any websites that can explains how it works of how to use it.

Thanks for your help
Manny007
 

A:Using Modules in Access 97

A module is basically a piece of code you use over and over again in an application. If you have multiple formes that use the same code you can create a module and call it from the form without having to manually code each form.
 

Read other 2 answers
RELEVANCY SCORE 53.2

I can't seem to get Message Analyzer to capture network data. After clicking on "Start Local Trace"  I just get a bunch of "Windows_Kernel_Trace". And I get an error at the top that says "Modules Loaded: Errors or warnings
were found when loading modules". I'm not sure what the cause is, and what I need to do to fix this.  And this is what I get when I click on the show log button (I couldn't paste everything because it's too long, and this website won't take
it all)

6/1/2016 2:54:36 PM Information Cannot generate enum for map TCPIP_SLOW_PATH_REASON_ValueMap because it have different fields with same name
6/1/2016 2:54:36 PM Information Cannot generate enum for map TCPIP_SLOW_PATH_REASON_ValueMap because it have different fields with same name
6/1/2016 2:54:38 PM Progress Loaded cached module 'Windows_Kernel_Trace_ProcessTracking_2cc3d1b85397939c45061ef9388fb58e_4_0_7948_0.mdb'
6/1/2016 2:54:38 PM Information Module cache file doesn't exist: C:\Users\N5227\AppData\Local\Microsoft\MessageAnalyzer\CompilationCache\ExtendTCPIP_66747ecf79d16b47eac835c67c1f284b_4_0_7948_0.mdb
6/1/2016 2:54:38 PM Information Module cache file doesn't exist: C:\Users\N5227\AppData\Local\Microsoft\MessageAnalyzer\CompilationCache\ExtendTCPIP_66747ecf79d16b47eac835c67c1f284b_4_0_7948_0.mdb
6/1/2016 2:54:39 PM Error C:\Users\N5227\AppData\Local\Microsoft\MessageAnalyzer\OPNAndConfiguration\OpnForEtw\OpnForEtwProcess\TCPIPComponentExt.opn(173... Read more

Read other answers
RELEVANCY SCORE 53.2

Good morning (my time) all.
I need to build a simple access database (access 2010) I looked at the ready made templates and they don't quite meet my needs as you would expect, some however I have found some form/table that I can use like customer details and others.
In order for me to cheat a little can i pick the various tables and forms already made in other templates and import them into my database? or would i be wasting my time and just build from scratch?

Thanks
 

Read other answers
RELEVANCY SCORE 53.2

Please, is there a way to run access Modules from Macro? Basically I am trying to run the module at certain time of the day via Windows Task Scheduler. All my Access queries are defined in a Module.

Thanks so much
 

A:Access 2000 Modules

1. Your code in the module needs to be a Function rather than a Sub.
2. Name your macro AutoExec.
3. The first line of your macro should be RunCode and use the expression builder or type your function name in the Function Name argument for RunCode.

AutoExec will run when your scheduled task opens your database. It, in turn, will run your function.
 

Read other 1 answers
RELEVANCY SCORE 53.2

I want to upgrade the ram in my HP Notebook - 15-ac121dx, and maybe the hard drive, but I cannot figure out how to access the ram. There is no access panel, and unlike some other models, it doesnt have a simple lever in battery bay to pull off the cover. 











Solved!
View Solution.

A:How to access the ram modules on a 15-ac121dx

OK, I figured out how to get the bottom on the laptop off.  After watching some youtube videos I came across another HP laptop that had screws under the rubber feet and of course there are also screws under the rear two rubber feet, can't believe I didn't think of looking under them.   So to get the bottom you need to:Take out all the screws on the bottom.  (Should be 12 total)Pull out the DVD drive (Yes it does come out).Finally, carefully pull apart the case around the side.After that you should have complete access to the hard drive and RAM slots.

Read other 4 answers
RELEVANCY SCORE 52.8

I have just bought a new computer and I am not sure how to handle the Home Network set-up. Here are the facts:

Old Home Network:

Gateway Select 1200 (Me) Main Identity (Windows Me)
Compaq Presario 2440 (Wife) (Windows 98)

Uses Wireles Linksys adapters on both with Linksys cable modem works great with no problems.

New Home Network

Compaq Presario 6300US (Me) Main Identity(Windows XP)
Gateway Select 1200 Wife) (Windows Me)

Same adapters and modem

Do I have to delete the old home network? - or just use new names on the new home network - am slightly confused about just what procedures apply. I will be setting up the new Compaq computer and leaving the old Gateway basically alone. Anyone out there that can guide me? I need all the help I can get.

Thanks !

P.S. When I set up the new computer at what point do I set up the Network? I am kinda confused - lol!
 

A:Solved: New Home Network Procedures

Read other 6 answers
RELEVANCY SCORE 50.8

I'm trying to look at stored procedures in a database to make sure there are no crossserver or cross database joins so we can upgrade to SQL Server 2005 from SQL 2000

Can anyone tell me a script i could use to see all procedure scripts at once?

Or do you have any other idea?

Thanks
 

Read other answers
RELEVANCY SCORE 50.8

I'm pretty much 100% sure a trojan has infected my computer. I had one a while ago (about a month) and although Kaspersky said it had neutralized it, judging by my computer's behaviour now there's something seriously wrong. I'm guessing it might have come from some custom content for Sims 2 that I downloaded, it seems the most high risk anyway. I don't know much about computers, so I'm not sure about the technical jargon, but I know this much:

Something consistently tries to delete startup modules, particularly when I try to connect to the internet. I think it might be writing itself into my hkey modules/files? It's often the files called hkey that try to delete the list of startup modules (sometimes it comes from the System 32 file or similar files) and Kaspersky intercepts it. Me, being stupid and before I realised it must be a virus, once allowed it to, and then, of course, the next time I booted up my computer, it wouldn't boot. I managed to reverse it after some frustration thankfully, but I still have no idea how to get rid of a virus once it's infected my computer. Kaspersky won't identify it, nor does Windows Defender (no surprise there). Other than those programs the only other defensive program I have is PC Tools Spyware Doctor which naturally doesn't detect anything. I'm afraid to download any other programs which might help. I don't want to make things worse.

Also, the internet browsers won't work ... Read more

A:Virus? Tries to Delete Startup Modules And Prevents Internet Access

Hi Fozzypeg and welcome to BC While we have an active internet connection, please follow the procedure below.Please download Malwarebytes Anti-Malware and save it to your desktop.alternate download link 1alternate download link 2Make sure you are connected to the Internet.Double-click on mbam-setup.exe to install the application.When the installation begins, follow the prompts and do not make any changes to default settings.When installation has finished, make sure you leave both of these checked:Update Malwarebytes' Anti-MalwareLaunch Malwarebytes' Anti-MalwareThen click Finish.MBAM will automatically start and you will be asked to update the program before performing a scan.If an update is found, the program will automatically update itself.Press the OK button to close that box and continue.If you encounter any problems while downloading the updates, manually download them from here and just double-click on mbam-rules.exe to install.On the Scanner tab:Make sure the "Perform Quick Scan" option is selected.Then click on the Scan button.If asked to select the drives to scan, leave all the drives selected and click on the Start Scan button. The scan will begin and "Scan in progress" will show at the top. It may take some time to complete so please be patient.When the scan is finished, a message box will say "The scan completed successfully. Click 'Show Results' to display all objects found".Click OK to close the message box and co... Read more

Read other 7 answers
RELEVANCY SCORE 47.2

Hi everybody! I have a little question. I have Dell Dimension E521. I have four slots for RAM modules. I filled it with 4 x 512 MB RAM modules. Now I heard that there is ONE (1) module size of 1 gigabyte.
First question, is that true?
Second question, where can I sell my old modules?
And a final question, what is the name (if there are modules like that) and where do they sell them for the cheapest price possible, those 1 gigabyte RAM modules?
 

A:Solved: RAM modules

Read other 16 answers
RELEVANCY SCORE 46.8

I have a Micron Millennia GS 933. Bus is 133. I am having a hard time adding 256 SDRAM. I have 3 slots. I have 2 256 and 1 68(68 came with puter). I have put 4 different 256 SDRAM pc 133 in. None have worked. I need a 168 pin, PC 133, VC SDRAM, Non-ECC(64 bit) 3.3V with total max of 768. I can't change the position they are in, or one doesn't show up. I have the Micron 68 in the middle. Should I assume that the only ram stick compatible would be another Micron stick? I have tired kingston, pny, other known brands. My computer is past 3 years old. I am trying to beef it up. I have a radeon 8500 graphics card, I play games and would love the extra ram.

Next question. Is it common for a DVD ROM disk drive to burn out after 3 1/2 years? Mine started to run loud and is now heating up. Been using the other(non-DVD) disk drive for games.

What is the life expectency of a computer? I also have one fan that is starting to rattle when I first turn the computer on. Should I start saving for a new one and stop spending money on this one? Thanks
 

A:(Solved) New Ram modules not working

Read other 15 answers
RELEVANCY SCORE 46.8

When I log into my computer three small windows pop up saying:

Error loading C:/WINDOWS/system32/jvdmycvx.dll

The specified module could not be found.

and same with

C:/WINDOWS/system32/hiooqild.dll

C:/WINDOWS/system32/bbdwxylf.dll

I dont know what happened or what I can do to fix it. I dont know if it has any effect on my computer. But is it anything I can do to fix this, or should I just ignore it?

Thanks
 

A:Solved: Modules missing

Read other 9 answers
RELEVANCY SCORE 46.4

I was playing CoDUO one day and tried to play a map which would not load because the game was reading the wrong files. I decided it was a great itea(at the time) to just go and delete all of my call of CoD/CoDUO files without uninstalling either first. After deleteing all files(or what I thought was all files) I tried to reinstall both games. When I insert the CD, the main title screen opens and gives me the options to play in single/multiplayer, or uninstall. if I click on uninstall, the uninstall wizard starts to open, then goes away with no affect. I found a post here on how to possible delete Cod and CoDUO from my computer, that post is here: http://forums.techguy.org/games/472741-uninstall-call-duty-help.html . I have followed the steps given by colmaca but to no success. I have tried searching in all hidden/non-hidden and all indexed/non-indexed places on all my drives to find anything related to Call of Duty, and get nothing. Is there anything else I should try? Please help, I would like to get back to my 'clan' on CoDUO
 

A:Solved: Removing Call of Duty & Call of Duty United Offensive

Read other 8 answers
RELEVANCY SCORE 46.4

I have an ECS K7S5A motherboard w/a SIS 735 chipset, AMD Athlon XP chip. I was running 2 256k memory modules in my system, Accubyte brand. One went bad so I'm now down to one 256k module. I've tried installing two different 1 GB modules in my board and neither worked. (One generic industry standard and one Samsung module.) Both times the system went thru the bootup routine fine, checked memory and hd's etc, but then when it got to the point it should boot into Windows, it just sits there.

The memory module specs: PC2100 (64x8) 16C 266Mhz DDR 184Pin DIMM. The 256k module, the one that works in my machine, is made by Accubyte, but I can't find that anywhere on the internet.

The manual for the mb says it will take 1 GB of memory, so that's not the problem.

Any suggestions would be much appreciated. I am sick of running on only 256k!

Thanks,
Harold
 

A:Solved: New Memory Modules Not Working!

Read other 16 answers
RELEVANCY SCORE 46.4

In MS Access you can write VBA code that allows you to manipulate the existing VBA code in standard and class modules by using the Modules collection of the application object.

In Access VBA, the Application.Modules collection contains only open modules

I am trying to do a similar same thing in Excel but with no luck.

There appears to be an undocumented Modules collection in Excel but the Modules.Count always comes back as zero. If this works the same way as in Access VBA, then none of the modules are officially "open" (including the one I'm executing).

Anyone have any experience doing this sort of thing in MS Excel VBA?

I just want to write some quick and dirty code to do some rudimentary analysis of an Excel application that was dropped on my desk. I want to do things like counting lines of code, and identifying the entry points and global declarations.

Yes, I can cut and paste all of the code into a text file and analyze that but I was looking for a more elegant solution.
 

A:Solved: How to get to Excel VBA code modules using VBA?

Read other 7 answers
RELEVANCY SCORE 46.4

Hi,

I have two RAM modules
# 512 DDR1 400 Mhz (Hynix semiconductors)
# 256 DDR1 333 Mhz or less frequency I believe. (Simtronics semiconductos)
My motherboard make is Intel 865 GFB a quite older model.
I would like to know is it possible to make the computer to work properly by installing both of these RAM modules which are with different frequency or will it harm my computer hardware!

Replies and suggestions are much appreciated!
 

A:Solved: Doubt about installing RAM modules

Read other 10 answers
RELEVANCY SCORE 46.4

I have been upgrading my cables for LAN and Sat TV. I am almost ready to "clean up" the wiring. I was looking at rj45 modules, coax modules, and wall plates. Before I get myself into trouble, will someone please answer a few questions for me?
1.) Are "keystone" and "leviton" modules and plates interchangeable or do I have to stay with one or the other.
2.) Are all rj45 modules the same? Some seem to say Cat 5 others Cat5e and others Cat 6. I ran Cat5e cable for my expansion and update and want to be sure I get the right modules. I purchased bulk cable and a crimp tool and successfully made up my own cables, so I feel pretty comfortable that I will be OK "punching down" the cable to the module. Also saw some modules that did not require a punch down tool.

Basically I just want to end up with several two or three port wall plates with modules for TV (f connector), LAN (rj45 module) and regular telephone.

Any insight would be appreciated.
 

A:Solved: Modules and Wall Plates

You should stick with one brand. I use the Leviton ones here, and they've worked out fine for me. The only difference between them might be the CAT6, some CAT6 cable (but not all) is 23ga instead of 24ga like CAT5/5e. If you have CAT5e, CAT5 connectors and jacks are compatible, they're the same thing. The Leviton ones I used recently have a plastic cover that presses the wires into the block, no tool required.
 

Read other 3 answers
RELEVANCY SCORE 46.4

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit. XP = Version 2002
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 6566 MB; D: Total - 36294 MB, Free - 8670 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi
I use the VBA code for a program I wrote quite often and keep adding to it to improve, since last year I find on opening the code window that the modules for the vbacode in a smaller size, then I have to move it and drag the size to fit the window. It always fitted the space on the righthand side. Did I do something wrong for it to happen, and can it be fixed?

Find attached file just to show what it looks like

Please help

Thanks
Rusty
 

A:Solved: vba code modules sizes

Read other 10 answers
RELEVANCY SCORE 46.4

I am thinking of upgrading memory in my 64 bit computer running vista 32bit OS and want to make sure it will work or not.
This is the memory...
240-Pin DDR2 SDRAM ECC DDR2 533 KVR533D2E4/1G
Will it work on my AMD Athlon 64?
I only have one gig now and would like to have four.
Thanks
 

A:Solved: Will memory modules work in both 32 and 64 bit?

Read other 15 answers
RELEVANCY SCORE 46.4

Hi All,

Having some trouble exporting modules from code. Not sure why. Any help would be appreciated. I am getting Run-time error '50012' Method 'Export' of object '_VBComponent' failed. I am using an .xls workbook in Excel 2007.

My code is below, but the export breaks even when I do this:
Code:
strPath = "C:\ReplaceTaxCode"
ActiveWorkbook.VBProject.VBComponents("ToolsA").Export "\" & strPath
Full Code Here:

Code:
Public Sub ReplaceCode()

Dim wkbCode, wkbReplace As Workbook
Dim strPath
Dim VBAEditor As VBIDE.VBE
Dim objProject As VBIDE.VBProject
Dim objComponent As VBIDE.VBComponent

Set wkbCode = ThisWorkbook
Set VBAEditor = Application.VBE
Set objProject = VBAEditor.ActiveVBProject

strPath = "C:\ReplaceTaxCode"

For Each objComponent In objProject.VBComponents
objProject.VBComponents(objComponent.Name).Export "\" & strPath
Next

End Sub

 

A:Solved: Excel VBA Exporting Modules

Read other 7 answers
RELEVANCY SCORE 46

I have an access 2003 database that calls a VB6 module. The module starts and then I get a run-time error 75 path/file access error. I can execute the vb module outside of access but I have to run as administrator for it to work correctly. What can I fix so that the call from access will execute? I believe the issue is with comctl32.ocx and the status bar control inside the vb module.

Read other answers
RELEVANCY SCORE 45.6

When using the Call statement in Access VBA, is there a way to use a dynamic value for the Sub or Function name. For instance,

Dim MyVariableFunction as String
MyVariableFunction = "Func1"
Call MyVariableFunction

Where "Func1" is the name of a function. The above code obviously doesn't work. A string is not a valid argument for the Call statement, only a Sub or Function name is allowed.

I want to run different subroutines based on the value of a variable. I prefer not to build an If..Then..Else or Select Case with all the possible values but that is what I'm facing unless someone can help.

Thanks.
 

A:Access VBA - Using Call Statement

There is indeed a hierarchy you can set to call specific procedures in specific modules.

I've been programming in Access for over 5 years, I've never once used it.

While it might sound practical, it is actually only useful if you are actually creating modules on the fly (if I understand your situation, you're not, you just want to call them on the fly), which you would be doing only in the rarest of cases.

If you think about it, it's about the worst documenting situation you can think of. All good code--and I do mean all, and I do mean good--should be immediately readable to a competent developer, because you may some day be hit by a train, but your app needs to keep going. Procedure calls are not variables; variables are variables.

I'd recommend doing the work to use if then or select case.
 

Read other 1 answers
RELEVANCY SCORE 45.2

hi my motherboard is epox ep-4Sgm8i.in the manual it say it will accept 2x1gb memory but has to be 1gb dimm modules using 512mb techology.

i have 2x512mb 333/400 mhz in now,but they are 184pin ddr sdram cards.

which ones are fine to install in and do i look for 333/400 etc and will they still be 1gb each even though they are using 512mb techology.

thankyou
 

Read other answers
RELEVANCY SCORE 45.2

I hope someone can give me some advice. I've a friend with a G550 running Windows 7 32 with only 2 GB of RAM, and it's woefully slow. I suggested he update to 4 GB (his system is obviously only capable of addressing 4 GB) and, as I recently updated my G560 to 8 GB (I'm running 64 bit Windows) I wondered whether I could give him one of my two old 2 GB modules (1 original, one added Crucial), or replace both, to upgrade his system? On paper, the memory seems to be similar to my untutored eye - am I missing some incompatibility between the two systems? Thanks for any help you can give.





IainLenovo G560 - Windows 7 Home Premium x64

A:Compatibility of RAM modules between G550 & G560 laptop's - SOLVED

G550:2GB, 3GB, or 4GB std / 4GB max / PC3-8500 1066MHz DDR3, non-parity,dual-channel capable, two 204-pin SO-DIMM sockets;Italics: standard memory in both sockets; no sockets available;Non-italics: standard memory in one socket; 1 socket available G560:2GB or 4GB std / 8GB max / PC3-8500 1066MHz DDR3, non-parity,dual-channel capable, two 204-pin SO-DIMM sockets;Italics: standard memory in both sockets; no sockets available;Non-italics: standard memory in one socket; 1 socket available Both machines have same memory spec.

Read other 3 answers
RELEVANCY SCORE 45.2

Hi there

I'm working with Excel 2000. Is there a way to change the names of the Modules in the project explorer window. The names that show up are generic in nature (module1, module2 etc.). I want to make the names of the modules more meaningful to me.

Thanks

Mario
 

A:Solved: Changing the names of the modules in Project Explorer

Do you see the Properties Window on the left side of your screen when you select a module? If not, do the following....

1. Click "View"
2. Click "Properties Window"

Once you have the properties window displaying, you can select the module. In the properties window you will see a field like "(Name)". Out to the right, enter the name of the module you would like to see.
 

Read other 3 answers
RELEVANCY SCORE 45.2

I am using a linksys befw11s4v2 (4 port) dsl router with 3 PC's all running windows xp home. My isp is bellsouth and the router connects to a westell wirespeed ethernet dsl modem. Bellsouth uses the pppoe connection type which I have chosen in the router. All 3 PC's have access to the internet and everything works fine until a vioce call comes into the house. Once the voice call is answered any PC connected to the internet is now stuck...it can not access any new web sites. If I power cycle the router everything starts to work. Before I call bellsouth support, I thought I would ask you for any ideas you might have on this issue.
 

A:dsl access hangs with voice call

Find the appropriate forum and post there.

http://www.dslreports.com/forums/9
 

Read other 1 answers
RELEVANCY SCORE 45.2

Ok, here's the breakdown: Computer OS is NT4 SP6a, Office 97 full install, MDAC 6.1 SP1, and I have checked the components w/ ComCheck to see if they were Ok and they were. The problem is: Whenever trying to access part of the the database it comes up with 'ODBC--call failed' and then does not proceed any further w/ the database. I have reinstalled Acces, installed the newest MDAC (which is 6.1 SP1) and re-applied the service pack. No application errors in the event log even pertain to the error. See if you can crack this one. Thanks.

Joe Dyer
 

A:Access 97 + ODBC call failed

Read other 6 answers
RELEVANCY SCORE 44.8

Am I hijacked? Eudora not responding correctly to "Close" command, got error msg trying to access Trend Micro House Call. Scans by Trend Micro/Adaware/Spybot all say nothing's wrong. Can someone look atmy log to see if I have a problem?Logfile of HijackThis v1.99.1Scan saved at 4:42:17 PM, on 7/22/2006Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Running processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\WINDOWS\SYSTEM32\SVCHOST.EXEC:\WINDOWS\SYSTEM32\SPOOLSV.EXEC:\WINDOWS\system32\netdde.exeC:\WINDOWS\system32\clipsrv.exeC:\Program Files\Common Files\LightScribe\LSSrvc.exeC:\PROGRA~1\TRENDM~1\INTERN~2\PCCTLCOM.EXEC:\WINDOWS\System32\svchost.exeC:\PROGRA~1\TRENDM~1\INTERN~2\Tmntsrv.exeC:\PROGRA~1\TRENDM~1\INTERN~2\TMPFW.EXEC:\WINDOWS\Explorer.EXEC:\Program Files\HP\hpcoretech\hpcmpmgr.exeC:\WINDOWS\SM1BG.EXEC:\WINDOWS\BCMSMMSG.exeC:\Program Files\Adobe\Photoshop Album Starter Edition\3.0\Apps\apdproxy.exeC:\Program Files\Roxio\Easy Media Creator 7\Drag to Disc\DrgToDsc.exeC:\... Read more

A:Can't Access Tm House Call, My Bank Acct, Etc.

Download the trial version of Ewido Security Suite http://www.ewido.net/en/download/ (W2K/XP Only)? Install ewido.? Run the application? Click on scanner? Click Complete System Scan and the scan will begin.? When the scan is finished, Set all items to delete? Apply all actions? look at the bottom of the screen and click the Save report button.? Save the report to your C: DriveThis will take some time to run!RE-BootPost that log and a new HiJack log

Read other 1 answers
RELEVANCY SCORE 44.8

You guessed it I am trying to get your attention. Until recently I have done quite well solving business problem using Excel, However my next project is to replace a paper based quality control system with a software solution that I can run off a Palm Pilot or similar device. Let me explain:

1) the receiver has to receive ingredients and log vital statistics on a form, - how much, what it was, the lot number, the carrier, etc

2) the formulator has to select certain ingredients and make a product, here again a paper record tracks, lot numbers, ingredient names, etc

3) the QC person has to check the product during manufacture and record vitals such a lot Number, temperature, colour. Texture, etc
4) if something does wrong and we have to recall a product we need to know - what was produced, where it went to, quantities, how many products are impacted, etc.

I want to build a database with the appropriate forms, report generation capability and product traceability (product recall) capability.

I am told Excel is not the product to use and the name MySQL and Access has been mentioned. Problem is, at this time I do not want to use the web; I simply want an internal system that is fast, effective and reliable.

Maybe you understand the essence of my application (food quality control) and can offer some ideas.
 

Read other answers
RELEVANCY SCORE 44.8

ALREADY SOLVED

In an Access routine, how can I call an Excel subroutine.

I'm rewriting a very messy Excel application that should've been done as an Access database in the first place, except that it has some intense VBA calculations embedded in it and the users expect to see output in Excel sheets and graphs.

I don't have time to move all of the code to Access (especially since it would mean rewriting tons of references to named ranges). Instead, I'm going to make all of the data files that exist in separate data tables into Access tables, and I'm going to create some Access entry forms.

But there are a handful of buttons in the main Excel spreadsheet that kick off a series of calculations. I want to have a button on my Access form kick off the calculations.
EDITED: Okay, you can ignore this question. I was using ObjExcel.Run and it wasn't working because my procedure was on a sheet and not in a module. When I moved it to a module, it started working.
Chuck
 

Read other answers
RELEVANCY SCORE 44.8

Hi, I'm looking for some advice regarding my girlfriends laptop.
 
Yesterday her brother took a call from somebody claiming to be from TalkTalk, and unfortunately they were able to take control of the laptop after claiming to have noticed problems and needing remote access to solve the issues. He was instructed to download TeamViewer. My girlfriend returned home during this call and took over after becoming suspicious with the nature of the call and after some questioning the caller quickly hung up. An attempt to withdraw a substantial amount from a bank account was denied shortly after or during the call. 
 
I've since uninstalled TeamViewer.
 
My question really is, would there potentially be anything malicious left behind after this attack? And what is the best course of action to take now?
 
Many thanks 
 
Sam.

A:Scam call, remote access gained, what to do now?

Yes!  You will need to scour the hard-drive with several anti-virus and anti-malware programs, both online and downloadable/installable.  Do you have current external image backups of the OS and the Data partitions?  If yes, you can choose to simply restore right over the entire laptop.  The regular BC malware team should be along shortly.  Let them know what external usb and/or dvd boot material you have on hand.

Read other 1 answers
RELEVANCY SCORE 44.8

Hey Guys,

I'm still fairly new in vba coding and need some help!!

Situation:
I have two buttons on my form - SAVE and CLOSE. I have added certain validations on SAVE button and want that whenever someone Clicks on CLOSE, it calls the SAVE button first and then close the form only if all validations are satisfied. When I use the below mentioned code, it calls the SAVE button perfectly and gives pop-ups wherever validations are not met. However, it does not stop there and still closes the form. And yes, every validation in SAVE button already has "Exit Sub" added to it.

Code:

Private Sub Command61_Click()

Call Command41_Click

DoCmd.Close acForm, "QAWorkflow", acSaveYes
DoCmd.OpenForm "WelcomeForm", acNormal

Thanks in Advance!
 

A:Call Button not working properly in MS Access

You need to set a Public Variable that can pass it's value back to the Command61_Click() sub.
Then you would have a line of code after the Call line with something like

If dontcloseform = 1 then exit sub.

the variable dontcloseform would be set to zero before the Call line
ie
dontcloseform = 0

then in the Command41_Click sub instead of just exit sub you would have
dontcloseform = 1
exit sub
Thus when the code comes back from the Command41_Click sub the new line would trigger an exit code before the form is closed.

ps I assume that you are aware that Access automatically saves any new records or edited records and that if you do not want the data saved you have to "undo" the record.
 

Read other 1 answers
RELEVANCY SCORE 44

Step 1 -
Avast Call Blocker for iOS - Request Beta Access

Avoid annoying spam and unwanted conversations with our advanced call-screening technology.

Don?t let spam catch you off-guard

Stop picking up for telemarketers ? Avast Call Blocker can either warn you about spam before you answer, or block calls automatically.

Block any number you like

Not all irritating calls are spam. Avast Call Blocker helps you avoid any unwanted conversations (or people) o you can keep your phone a happy place.

Keep your private data to yourself

Stay protected with our easy, noninvasive technology and ever-growing database of spam numbers.
Step 2 -
Detect and block spam phone calls with third-party apps - Apple Support

Set up a third-party app on your iOS device to help you detect and block spam phone calls.

Step 3 -
Avast Mobile Products - Forum Support
 

A:Avast Call Blocker - iOS - Request Beta Access

interesting. is it something like truecaller?

anyway you can already block numbers from your iphone , without apps.
 

Read other 4 answers
RELEVANCY SCORE 44

Hi,

I need some help. I have created a database of personnel information and I am working on the search criteria using Visual Basic. The options are to choose a project year (cboProjectyear) and/or a Discipline (cboDiscipline) and/or inspector's name (cboInspectors) I have 4 disciplines to choose from. I have part of my searches working fine if just a Discipline is selected. I need to be able to do a search if someone selects:

a particular discipline and a year
a particular inspector and a year
just a year.
My inspector table does has discipline in it so if an Inspector is selected the appropriate Discipline can be called. I am adding in my code for just the discipline. Can someone help please! Do I use an sfilter? If so how to write it properly to call multiple options.

If cboDiscipline.Value = "2" Then
DoCmd.OpenReport "AArptname", acViewPreview
Else
If cboDiscipline.Value = "3" Then
DoCmd.OpenReport "SArptname", acViewPreview
Else
If cboDiscipline.Value = "4" Then
DoCmd.OpenReport "EErptname", acViewPreview
Else
If cboDiscipline.Value = "5" Then
DoCmd.OpenReport "MErptname", acViewPreview
Else
MsgBox "Please select a Discipline"
End If
End If
End If
End If
 

A:Trying to use multiple filters to call reports in Access 2007

Read other 10 answers
RELEVANCY SCORE 43.6

I have a access database with about 17000 contacts.

I email reports to customers through access which then goes through outlook.

Recently this has stopped working and i am receiving the error
-2147418107 (80010005) It is illegal to call out while inside message filter. The database is about 400MB is size so i tried using the compact and repair database option but had no luck.

Sometimes i will receive this error and other times it will just hang

The error happens on other computers at the workplace as well so its not isolated to a single computer

A:Access 2007 automation error - it is illegal to call out while inside

Not sure if anything here might help:
PRB: VB5.0 OLE Automation Error --2147418107 (80010005)

Read other 2 answers
RELEVANCY SCORE 43.2

This is our first post.
Background info: Dell Laptop Latitude D820
Windows XP Professional SP 3
Using Cingular/ATT GT Max card for internet/email

We use weather.com radar maps for scientific research and watch the weather avidly. We put in the city, state and at the bottom of that page there is an interactive map using virtual earth that shows the weather radar and you can zoom in and so on. Last week it quit working. It's the only thing that isn't working and it's a major pain. Normally when you click on the map to make it larger and animate it, it goes to a new window and starts the radar moving. Now it show a blank square, everything else comes up, ads, so on, just not the radar. There is an error code that pops up at the bottom of the screen with a yellow triangle and an exclamation point. When I click on it this is what it says " CHAR 6660 ....unexpected call to property or method access"

I have checked windows for any further updates, ran virus check, spybot, updated Java...updated adobe player, flash player. Nothing changes. the radar map still doesn't work.

Any help would be appreciated.

A:Internet Explorer Error Unexpected Call To Property Or Method Access

Hello saddleman,

It sounds like a scripting problem on the website itself. Can you post a link to the site in question?

Read other 3 answers
RELEVANCY SCORE 43.2

Simple question. I'm looking for documentation to describe the difference between "logoff userid" and "restart". What are the differences to the system.

Any insight or direction will be greatly appreciated.
 

A:Shutdown procedures

As far as i am aware ..

Logoff will unload all programs in use and log off the person logged on.

Restart will do that al well as clear memory.

In short, logoff is just a faster way to switch users.
 

Read other 1 answers
RELEVANCY SCORE 43.2

Need WinMovMkr "Step-by-Step" Procedure(s)

You will need to put on a pot of coffee before beginning to read this novel. Sorry, but I wanted to offer as much info as someone might need.

My objective is to receive a 'step-by-step' procedure, from one of you experienced experts, to produce a ".wmv" (Windows Movie) file which will play on someone else's PC with their version of Windows Media Player, their monitor (which is probably not wide screen), AND not lose the aspect ratio of the movie I created. Neither should it distort the Sound, as Windows Media Player does.

When I playback my .wmv files from my computer's hard drive with VLC Media Player -- they play perfectly, both video and audio. Windows Media Player never plays them properly.

I do not want to buy new software or hardware. I know my system is truly outdated, but it still works.

Here's what I'm working with:
* Windows XP Home Editon (SP2). I do not want to update SP2 to SP3, for reasons of my own! Please, don't suggest it.
* 2GB's system RAM.
* Monitor: Acer model H233H (23" wide, High Definition), running at 1280pix x 768pix, 32-bit color.
* Windows Media Player ver 11.0.5721.5268.
* Windows Profile Editor.
* Windows Media Encoder ver 9.00.00.2980
* FRAPS 3.4.1 Build 13142
* VLC Media Player ver 1.1.11
* WavePad "Master's Edition" Sound Editor (registered, paid/licensed user) vers 4.46.
* MixPad Audio Mixer (registered, paid/license... Read more

A:Need WinMovMkr Procedures

Read other 8 answers
RELEVANCY SCORE 43.2

Getting ready to install Win 7 Pro on my XP installation machine. Put in new Motherboard/CPU/Memory but my XP Pro installation will not boot ?

Same Sata hard drive being used with unchanged XP installation.

Have done many motherboard/cpu upgrades in past without issues. I'm wondering if the XP "Genuine Advantage" stuff is causing the no-boot ?

I have not done anything with Win 7 yet...still waiting for UPS delivery !

Hoping I do not have to remove all the new hardware and replace the old and then boot again and THEN call Microsoft ? ( Have licensed/registered XP Pro box & disks here )

The error screen I am getting is something like " Sorry...Windows wouldn't load...maybe new hardware/software/compatibility issues"...I have a bunch of loading options including safe mode and last good configurations...but all options lead to a reboot and the same screen ?

Win XP loading screen does appear for a second...but then system reboots ?

Any Ideas on what the issues might be and how to fix it will be greatly appreciated !!

Tim

A:Procedures for adding new MB/CPU to Win XP Pro

Unless you replace the hardware with the same items you will have to wipe your hard drive and reinstall Windows. The OS marries itself to be compatible with the hardware it is connected to with drivers that is why it does not want to cooperate with your new motherboard. CPU/Memory should not matter but different MB's will use different drivers.

Read other 5 answers
RELEVANCY SCORE 43.2

Before I uopgrade to Win 10.....

I have 2 Win 7 Pro installations. On The 32bit machine...I want to move the MD from the 64bit machine to the 32bit machine.

Have read many post but I seem to get more confused the more I read.. Will I have to call Microsoft after move motherboard in box A to box B and replacing in the A box with a new MB/CPU combo ?

If not...what's the best way to proceed if I can avoid calling MS ( although I did previously with one of this systems when reinstalling) ? Both are licensed registered (with MS) copies of Windows Pro with serial number pockets in-tact.

Some posts say Acronis...some say Paragon(?) free product...some say (sysprep ?) I have Acronis 2013 and create 'clones' fairly regularly stored on external USB drive(s)

We have the licensed installation DVD for both OS's on the two machines

Thanks...TiminAz

A:Procedures for moving MB from one PC to another

Could you supply some more info. Are you planning just to move the MB from A to B & still use the 32 bit drive in B. If you want to have B with a 64 bit drive you will have to reinstall Windows in the old 32 bit drive.

Or, you could move the MB from A to B as planned & change the A hard drive to B as well. That should be fairly easy. That will leave you with a 32 bit hard drive that is of no use, unless you can use it for something else.

Do you want to do a fresh install of Windows 10 or just do an upgrade. If you want to do a W 10 upgrade on A after the hardware change, you will have to have a copy of Windows 7 on the hard drive & this could be a problem if you want the 64 bit version of W 10 & you have moved that hard drive to B.

The problem seems that you might end up with 2 installations of the same Windows 7 Pro 64 which is a breach of the license.

Read other 9 answers
RELEVANCY SCORE 43.2

I am using SQL on an enterprise database/server and feeding the data back to a client browser using html and asp.

I need to create a sub procedure that totals the values in a colume Sum(values) as Total. I also need get a distinct Employer name so it only shows once and I need to know how many rows from the table were used to acquire this data.

I can get the count keyword function to work or aI can get the sum keyword function to work. Both have worked with the select distinct employer from ....

How do I get them to work all together?
 

A:SQL and Stored Procedures

Something like this:

Select Employer, Sum(Values) As Total, Count(Employer) As NumberOfRecords From MyTable Group By Employer
 

Read other 1 answers
RELEVANCY SCORE 42.8

I HAVE JUST ACQUIRED MY FIRST P.C.,AND INTEND TO SHOP ALOT USING MY DEBIT CARD.WHAT ARE THE NECCESSARY SAFETY PROCEDURES I SHOULD USE TO SAFEGUARD AGAINST MY DEBIT CARD NUMBER FALLING INTO THE WRONG HANDS.?
THANK YOU FOR YOUR TIME...MIKE.
 

A:what security procedures are needed?

Good Morning kmbrmc.....
Welcome to TSG !

The first thing I would highly suggest to you is DO NOT use a debit card on the internet. It is much too risky if this is taken directly out of your banking account.
Get yourself a regular credit card. You are usually only responsible for the first $50 dollars if something should happen.

When purchasing on any site, be sure that it is secure. On IE you will have a lock icon at the bottom of the window. The address will begin with https://, instead of http://.

Hope this helps.

Debe
 

Read other 2 answers
RELEVANCY SCORE 42.8

I'm trying to use the Win7 Backup Program and have a couple of questions:

I did a backup of my C-drive to my external harddrive and it backup up ok. But, it did not put the back in a Folder on the E-drive, just put the backup file on the drive under the name of the C-drive. Question, I normally retain 2-3 backups in other backup programs, but don't know if I can backup again with Win7 Backup and it will retain the previous one and not overwrite it - so, I can maintain a number of backups?

Second, I tested the Restore File function, but restoring a backed up file to a different folder on the backed up drive, and it put it there but deleted the file from the original location? It there a way to tell it to not delete the previous file when restoring the backup file to a different location?

Thanks for any insights/suggestions.

Gumboman

A:Win7 Backup Procedures?

"so, I can maintain a number of backups?"=>yes no problem at all. Just try it.
" but restoring a backed up file to a different folder on the backed up drive, and it put it there but deleted the file from the original location?" => it doesn't delete anything at all! It only supersedes the file if it's already there.

Read other 7 answers