Search results for query: *

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...

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...

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...

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...

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

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...

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...

I need to write a function that will count commas inside a memo box. I.E. I have a memo field inside a record that users paste an array of 6 digit numbers all seperated by a comma. I need to count how many 6 digit number sets are inside that memo box and populate it into the same record in...

I need to link data on an existing weekly report. My problem is that the data crosses over 2 weeks. This dataset is measured from Wednesday to Tuesday. However, I need to link all the data with the Saturday in between the Wednesday and Tuesday. Any Suggestions... please help.

I have an interactive form/database being used by about 10 users. Suddenly after months of working correctly users are now receiving an error dialog box popping up after they begin working. The messsage is "disk or network error". That is followed by SQL errors(I don't know much SQL)...

I have a report embedded inside another report, which is acting "somewhat" as a Summary Page for the beginning of the "main" report. Each report works off of the same query. Both reports have date range parameters. When separated, the reports work fine. My problem...

This makes no sense to me. Since I have embedded a report into another, every time i run the report I have to input the parameters 3 times(as opposed to twice if they are stand alone's- 1 each), but when I attempt to export it into a snapshot, it again asks me for the parameters another 3...

I need to complete this function Function WeekOfMonth(ByVal datDate As Date) As String WeekOfMonth = "Week " & DatePart("ww", datDate) - _ DatePart("ww", Month(datDate) & _ "/1/" & Year(datDate)) + 1...

I am trying to write a function that will return the week number of a month. For instance Week 1, Week 2...I have tried writing an if statement, but I get a funky date in return. This is for a week over week view in MS Access on a report. I need the function or expression or conditional macro...