Search results

Hello, Does anyone know of the existence of a script that does the following? Google is not my friend today and I don't have time to reinvent the wheel, unfortunately. A script that traverses the entire local network, logging the names of all files present on each user's desktop folder in each...

I found this function online at gist.github.com/1371323 It was written for PL/SQL. I'm wondering if it can be adapted to work in MS SQL. I've tried a bunch of stuff, but I just can't get the validator to 'like' it. Any ideas? function ups1z(p_tracking_number varchar2) return boolean is trk...

I have the following code on a report. When the report opens, I would like to set the recordsource to that of the ADODB query, however I am encountering the error: "This feature is not available in an MDB." I understand why the error is appearing, but I also know there has to be a way around it...

I've been out of the loop for a while so I can't remember the best course of action here. I have a table with a list of Orders that need to be worked by a team in our company. I also have a form that Administrators use to select a batch of those orders to work. The options they select are...

Quick questoin for all you server admins. I am setting up a new box running Windows Server 2003 R2. This is going to function mainly as a test server for SQL but will also function as my home media server, ftp and http server. I have 380GB total to spare. I was thinking about partitioning...

Well, I'm going for it. Starting school in January and I'm going for a BS majoring in Database Management. I know Access and VBA like the back of my hand and I'm a fast learner, but I don't know everything I need to. There will definately be instruction on complex SQL queries, Oracle and DB2...

Do you find it typical to include a field called something like "IsVisible" to most of the tables in any given database, then create a corresponding query for each of the tables which includes all fields where IsVisible = true, then for anything you create in the future, you base it off the...

I'm building a crosstab query to show different totals and counts for monitoring scores. The query that the crosstab is based on has a date parameter where the user enters a start and end date (always a 7 day range) but in the results, I also need to see the average score for the previous week...

Writer's Block - Training Tracking DB I have created a db that tracks training courses, classes and attendees. A course can have many classes and a class can have many attendees. The database also stores links to course documents and class notes. I think there is a lot more I can do with this...

I have this code on a form that is usually displayed through a subform control of another form. Private Sub Form_Delete(Cancel As Integer) If MsgBox("Are you sure you want to delete this note?", vbYesNo, "Confirm Delete") = vbNo Then Cancel = True End If End Sub When the form...

I've noticed yeseterday and today, on both my computer at work and at home; When I log in to this site, I am usually taken to my User CP page automatically, but instead it redirects me to the login page again. Once there, If I click on "Access World Forums" in the upper left hand area, I am...

I know you can make a form application modal, but can you make it system modal like you can with a msgbox?

Hello, I have an interesting solution to a problem I've had for a looong time now. I have reports in an Access database that I have to run manually every day because the data source of the reports is a DSN connection to an iSeries server. I have to run these manually because no matter what...

Yes, that's it. I would like to thank everyone on this forum for giving your time away to help our members. Two years ago, I created a job for myself developing and managing the database we use in our call center. It was originally created in Access '97 and only recently did we upgrade the...

In the picture attached, there are two fields we're working with; Address1 and DepartmentID The picture shows two different queries that return the same results. If you wanted to run this query where; Address1 = "123 Fake St." and DepartmentID = 28 or 29 Which method would be more...

I have a database that I do not own, but I need to run a report on. One of the columns is called TransactionNote and contains text like this; "Order XXX released from PAY TYPE" and "Order XXXXX released from PRODUCT INFORMAT" What I need to do is split out the text in caps. Then we would have...

I am currently trying to apply conditional formatting to a continuous form that typically has thousands of records. Unfortunately it is a lot more complicated than you may think and requires a little background before I can address my real problem. I'll do my best! My idea is very similar to...

If you wanted a database to do any one thing (regardless of price, resources and time) what would you want? ...and yes, I AM fishing for ideas here. All ideas welcome, including ridiculous ones. :) Thanks,

If I use Trim(Nz([Service State],"")) as the Update To value in an update query then: If the value of [Service State] = "Ca " then it will return "Ca" or if the value of [Service State] is null then it will return a zls.. right? Am I correct to assume this?

Hello everyone. It's been a while! I've managed to hold my own due to everything I learned right here on the forum, but alas I've run into a road-block. I have this code to generate an email with plain-text It takes a bunch of fields from a single-form (we'll call it "Deliveries") and sticks...