Search results for query: *

Only getting this error if the number of lines I need pasted is less than 2. Otherwise it works like a charm. Here's my code: Range("AT2").Select ActiveCell.Formula = "=('RF Engineer Only'!$M$1)" Range("AT2").Select 'Debug.Print "Cell: AT" & RFTabCnt + 1...

I'm exporting a query to excel from access and I'm running into the problem if Excel auto-formatting the appended records that I am exporting to an excel file. Basically it's reformating "General" formatted fields to "Time/Date". So when I want to see the number 1, or 94 - Excel creates a...

Hi Trying to write a function to return only biz days from a given date (M-F). I want 4 biz days ago (backwards) from a given date, usually Today's date. I need it to work longer than a period of one week because I need the code to check 4th biz day for the past month or so (backwards)...

Quick Q for you guys. I've had this problem in the past, and I got it to work then, however I don't remember how. Trying to make a macro run from command prompt. I'm trying to run a macro that runs a piece of code that exports an excel file, then closes the database Trying to schedule this...

Having a small problem that I cannot seem to figure out. I'm calling a function whose variables are all optional, and when I don't feed it the first variable, it thinks that I've actually fed it the variable. So my IsMissing() statements are returning false when they should be true! Let me...

Hey guys... I was reluctant to post this on Tek-Tips just yet due to the fact that a simple string method is stumping me. Since I've self-taught myself VBA, I skipped a lot of the basics. Anyways, I've got a quesiton. I'm working on a MapPoint database again and I'm gettin a small...

Hey everyone, I'm runnin Win2k Pro. I'm not loging into a server, I use it for my home pc. There are computers connected to it via a router, but thats just my local area network to share my cable modem connection. So I logoff Windows 2000 last night to go to bed, everything was...

Seems like Ben Ohara and I are both in a jam today... Read on! ;-) There's a personal note to all of you at the bottom if you finish reading my question... Okay - with time I've found that Access comes with it's fair share of head-aches. AC97 is giving me a HUGE head-ache this week. I've...

Hey, I don't know if any of you ever hop over to the Access: Other Topics forum, but if you get a chance, I've got a query question in this thread that's plaguing me. ;-) Multiple Query Criteria ... kind of ... thread181-332977 -Josh ------------------ -JPeters [COLOR=red]Got a helpful tip...

Hey all, I've been doing some searching and I can't find this because I can't really word it correctly in the search box in advanced search... I'm trying to run a complicated query... but I can't figure out how to do it. Maybe someone can point me in the right direction .... I've got these...

Anyone ever used the Chart Export database that lets you export your charts to jpeg files? Well, I use it's code quite a bit in my applications and I've run into some snags. I've edited my code to be in a central database that I reference all the databases that use this export feature to. So...

Man, this problem is driving me bonkers. ThornMstr has been helping me out bit by bit, but I don't like bothring him he's a busy man - besides I'd rather bother you guys. ;-) Ok .. here's the deal. I got this database from http://www.mp2kmag.com/articles.asp?ArticleID=74 It uses MapPoint...

Getting the error message, "There is no object in this control." I'm trying to use the Map Point 2002 Control, and it's not working - rather frustrating. I have MP2k referenced ... I've got the control registered ... and I have the Map Point ACtiveX Box sitting in my Access form...

Hi all, I seldom post in the VB forum since I spend most of my time designing Access Databases and using VBA. But I've got an interesting request - sort of a rareity, I've found. Not a lot of people use MapPoint 2002 in VBA, usually it's just used in VB, or .Net. Since VB is so similar to...

Most of you guys are pretty good at VBA coding... I know that some of you don't get a chance to read all the Access forums, but if any of you have ever used the MapPoint 2002 object library with Access, could you take a look at thread181-319893 and maybe post me a reply or drop me an e-mail...

Hey all, I've got a few questions for any of you out there that are decent at using the MP2002 Object Libarary. I broke down and bought MP2k for dummies, and (although it's a great tool) it isn't exactly what I was looking for. The book doesn't really explain how to maximize the use of...

Okay Brains, here's one that I am sick of searching for. I dreamt this up, but it won't work - obviously, maybe one of you can tweak it for me. This code below tells me that there is no Current Record ... well duh! I want it to add one if the record doesn't exist, and if it already does - I...

Does anyone know a clever trick to set the focus on alternate programs that are loaded using outlook? I want to multitask from Access over to Outlook's Inbox window when they push a button. Just curious if anyone knows how to do this. I've done some pretty hefty browsing in books, on this...

I got this link from the Microsoft Office Forums... A Visual Basic-Based Active Messaging Inbox Agent (Q173915) http://support.microsoft.com/default.aspx?scid=kb;EN-US;q173915 It's a pretty nifty little program. Basically all that it does is launch a program based on a rule in outlook. Anyone...

Hey, I'm using Microsoft Access 97 and Outlook 98. I've got some code that imports the MailItems in the inbox to a table in my Access Database. What I'm trying to do is import a ReportItem (udeliverable reciept reports) into this database so I can flag e-mails that need to be resent to...