Search results

...edit... Wow...I started typing out the problem/question and ended up typing a novel! I can be a bit wordy sometimes.... So, here it goes.:) I'm working on an Access file to use w/ an on-line training record system. The on-line system exports XML files, which I then save & re-name as...

I ran into this problem, too. I needed to TransferSpreadsheet multiple files w/ Access 2007, but couldn't find a way to do it w/o FileSearch....Until I came across this. I don't know if this will help the original issue, but it works fine. The code was listed here. Dim strPathFile As String...

Got it! I just created a new query based on the table w/ a date criteria of Now()-365 and used that for the DCount. Now I can identify repeat/recuring discrepancies based on tail number and system code, and then call an aircraft systems discrepancy history. Works like a champ! Thanks for the...

Works like a champ! Thanks, wazz! Now...I need to restrict the DCount search to the last six months. If you have some help for this, that'd be great. In the meantime, I'm gonna be doing some more research.

I've been doing a bit of looking around for some DCount/DLookup stuff to help w/ some auto-magic stuff on a new database. After the using enters a new record, I need to check for duplication of criteria. If so, I need to have it capture some info from the form and open a report. The code I...

There are two queries in the database that are used to count and calculate percentages. One (Percentage Query) draws its dates from inputs to a form: >=CDate([Forms]![Request Percent Report Form]![Start Date]) And <DateAdd("d",1,CDate([Forms]![Request Percent Report Form]![End Date])) The...

Well, I checked out the "mousehook" file, but I don't think it's gonna really help out. The problem isn't so much trapping them in the record, it's forcing the user to save/undo changes only once, as opposed for each section of the form. I know that you can change the value of a field (bound...

That's kinda what I was afraid of....I haven't quite given up on it yet, though. (I'm kinda stubborn that way.) I'm hoping that I can find a way to use a field value (whether from a bound or unbound field) as a flag to perform essentially the same as the mousetrap. It might turn out to be a...

Like many on this board I've used the mousetrap by GHudson. However, I have two subforms in the main form. This has created a lot of saving. There are three diferent areas to save in now. One thing I did to reduce the number of times a user has to save his/her records is to incorporate a...

I agree. After one of the users told me that "it was fixed", I went ahead and had all the users print something to make sure their printers were all set up properly. The database is not split...yet. The original db file was used in another 'company' all together. That copy has relatively...

Well...as it turns out... One of the computer's users who was having this problem told me today, "It fixed itself." ??? I didn't change anything. It never ceases to amaze me that software written by a single company can't talk to its sister-software....Goofy stuff. Oh, well. Chalk this one...

Well...here's the deal. Four computers were replaced in our office and now three of them are having problems with the database. The database is written in Access2003 and all computers (the old ones and the four new ones) are running on WindowsXP Professional w/ Office 2003. The problems that...

That looks like it'll return the error number and description to a table. That's not quite what I'm looking for. The update database I made uses a LOT of delete/import lines: DoCmd.DeleteObject acQuery, "NameOfQuery1" DoCmd.DeleteObject acQuery, "NameOfQuery2" DoCmd.DeleteObject acQuery...

I've been working on some update utilities which I've figured out pretty well, but I'd like some better error trapping. These utilities are being e-mailed out to the various locations (not connected by a common LAN & not web-based) and I'd like to create a table listing any errors received...

Thanks for the responses. It helps to be able to make a little sense out of what was happening. Of course, I'll still get those complaints..."What'd you do to the database?":eek: C'est la vie.:cool: At least I know I haven't messed anything up...yet.:rolleyes:

Well...after all that babbling, the IIf statement works. Problem solved. Also, that means that I avoided this from potentially happening at the other sites. =IIf([txtGroupTotals]="N/A","0",(([txtGroupTotals]*100)-[DeductPoints])/100) Thanks for the responses. Sometimes (like this time)...

I kinda figured it was something to do w/ automatic updates. Is there an effective way of managing these? It goes way beyond a pain in the @#!. It essentially voids the usefulness of the db. I'm sure you can imagine the "fun" you'd have if a component of your db quit working for no apparent...

Here's how it all works. I have them go to File|Get External Data|Import and import a browsing module and a form that has all the update code in it. Then I have them open that form, click the 'Browse' button to find the update-utility db. After that, the code runs and deletes the old objects...

Alright...Our database was benchmarked by several other units. They're completely separate, i.e. independant data collection, no shared networks, different bosses. At any rate, I made some changes to the db and created a "utility update" db for these other units to use to automatically get...

I've run into a problem in my database. It's actually happened several times, but it's basically the same problem. We've been using this database since January and on at least five different occasions a function in the database (be it VBA, query, report, or what-have-you) all of a sudden...