Search results for query: *

Perhaps on a Tuesday or Wednesday morning, I woulda made that leap, but never on a Monday :) Thank you very much. Its interesting that this worked... .Font.Bold = True .TypeText ScoreFollowup .Font.Bold = False

I am using Access to create a word document. It is something that I have done in the past, but this has a twist. Dim objWord As Object Set objWord = New Word.Application objWord.Documents.Add objWord.Visible = True With objWord.Selection ..... .Font.Size = 12 .TypeText "Please find the...

Got it up and running! Thank you. For some reason, I had to do step 3 of DigitalWebcast twice. I must have missed a file. (too bad Recovery Console doesnt recognize USB drives or I could have copied the lines from the web into a batch file) And - I didnt get asked what recovery session to...

Thank you - I will try once I can get my hands on a Home CD and report back.

I was recently looked at a laptop w/ XPHome (sp unknown) and I could not get it past a screen similair to a GUI log on screen. Its blue, has the yellow lines near the top and the bottom and the XP Logo off-set to the right. The mouse moves, but there is no where to click. Ctrl-Alt-Del does...

Thank you! Of course, I spent more time tinkering, searching, cursing Bill Gates than it took to actually (un)Group, but thats besides the point!

I have some forms that I need to group some controls together and others to ungroup, and altough it seems petty, I'm getting tired of going to the Forms pull-down menu and selecting Group or ungroup. But I cannot find them on any toolbar! I can MOVE an icon from the menu to a toolbar, but that...

Fantastic. Thank you. If I was confident that they were only going to ask me once, I'd do it by hand. But you know how management is... :)

I like where PHV's second response is going. Here is my actual code SELECT tbl_Complaint.* FROM tbl_Complaint WHERE (((tbl_Complaint.ComplaintID) In (SELECT TOP 5 tlkp_ComplaintCatagories.ComplaintID FROM tlkp_ComplaintCatagories WHERE tbl_Complaint.ComplaintType =...

I have a call-tracking database. Each call can be catagorized by 1 or 12 different ways (CallType) Sr Management wants to see a sampling of 5-10 calls per call-type. Unfortunately Topx doesn't work this way. Thoughts anyone?

Are the hours stored in date/time format or decimal?

Try impoting the spreadsheet into a temporary table then run an append query for the records that have no key field listed and an an update query to update the ones that have a key field. VBA is optional to automate the process and its simple docmd.openquery "qry_blahblahblah

is it Background Shading or Font color? To my knowledge there is no excel function that reads either. That is why the answer lies in VB.

I had to do this a few months back and of course can't find it now, but I wrote a macro to place a value (Selection.Interior.ColorIndex) representing the color in a temporary column. The phrase "sorting by color" is a little dubious. ie what is greater; Blue or Red. So by putting a the...

yes - but since I was having trouble with the query in your initial post, I took the IN (select...) into its own query for temporary purposes to get the proper syntax, etc.. before trying the main query again. But when I noticed that the query shown in the in(select) in my last post was...

Again Apologies (read some of my other posts, I'm not a complete newbie!) If we're using the same table twice, wouldnt the FROM Line contain both tables? I've seperated out the IN line to try and get a grasp of it and I get 7 records of the same (most recent) timestamp I know I didn't need...

Apolgies for a newbie question... By T1, T2 am I using the same root table twice? ie: T1=tbl_MachineUseage T2=tbl_MachineUseage_1 I think Enigma007 figured it out, but I dont have enough coffee available..

I have something similiar to thread701-871569 where I have a table storing the login times to the companies Access databases. I have the UserName, the computername, Timestamp, Database name & autonumber primary key. The purpose is to get a sense of who is logging on where. I am trying to find...

Fantastic code Mgolla. I have an access database used by supervisors that just has 1 form for monitoring. This code makes it simple enough that its almost impossible for them to do something wrong :)

ok - thank you. I had searched, but not for Filebrowe - tho I suspect that its an API call - in which I thank you for the nudge. -alan