Recent content by Sdaddy

Mor information: I have built an access database that captures network outage ticket information. I am checking with multiple users and the problem only occurs in Windows 2000. However, some users with Windows 2000 are not having the problem. I am checking reference libraries and service...

I built a database in access 2000 for tracking network outage tickets.. works beautifully... but... The problem. When users that have Windows 2000 try and run a report.. they get a parameter box asking for Format... then one asking for date. Users in XP and NT have no problems. I use a...

VBA--- Thanks for your attempt. Unfortunately it didn't work. Guess I'll head back to the old drawing board. And people think the work we do is easy. LOL. Maybe I can pull the same thing off in a query if i think about it long enough. If anyone else cares to take a shot.. I'm game. The...

Thanks VBA, but that didn't quite work. See the problem is that I still need to click the ! refresh button on the pivot table itself. My users may not grasp this. I also need the excel spreadsheet to close and return to form view. Is there anyway to create a toolbar and make it bound to the...

I am using access 2000. Win NT. I am trying to write a sub that will on_click open an OLE(pivot table) and refresh the data without having the user navigate to the pivot table in excel and press the refresh button. I am working with users that have very limited knowledge in access and excel...

I would be very, very careful in regards to copyright infringement. However--- Display the slide you want to add the video to. On the Insert menu, point to Movies and Sounds. Do one of the following: To insert a video from the Clip Gallery, click Movie from Gallery, and then locate and...

Guess this one is a stumper

Help!!! I have built a pivot table form in access 2000. Basically, it is used to track network outages by state on a real time basis. Users input tickets and related information. Is there anyway to automatically refresh the pivot table form when users input new ticket information? I...

As a follow up.. Is there a way to create a toolbar on the form itself that would allow the user to hit the refresh button. I would want the toolbar to be bound to the form.

Help!!! I have built a pivot table form in access 2000. Basically, it is used to track network outages by state on a real time basis. Users input tickets and related information. Is there anyway to automatically refresh the pivot table form when users input new ticket information? I...

thank you for the tip... it was the tools database utility blah blah thing. lol. i have only worked in 2000 and 97 so i didn't know what wuz going on.. tyvm!!!

I have MS Office 2003.. but for some reason everytime i try and open a blank database it shows up in 2000 file format. Is this suppose to happen.. Puhleaze help

I am having a problem inserting a wma file into a powerpoint show. I need it to play on slides 2-??? but not on the first. I just can't figure this one out, because what makes sense isn't making any. I am using windows media 9 powerpoint 2000 on Windows 2000.. Please help

u is da man. Thanks.. I didn't think anyone would respond :) so I cheated and came up with this. LTrim(Left(datastring, 9)) I am going to use yours though because it will be much more efficient. Thanks!!!! [thumbsup2]

I am really tired and should know this.... but I need help getting an ID field on a text that is right justified to grab the up to 4 number id from right to left. PLEASE HELP!!! I'm stuck until i figure this out. Here's my function Option Compare Database Option Explicit Public Function...