Recent content by sfatz

Forgive me if I state something obvious, but don't forget to 'record' that the archive has been executed so that it doesn't execute again for that month.

Amy, If each customer issue has a unique identifier, then why not create a separate table for the update notes. Each record of the note update table would have fields for Customer Issue ID, Date (and time if necessary), ID/Name of who entered the update, and of course, the Note itself. To...

I tried RuralGuy's (aka RG) suggestion and imported everything to a new dB. That seems to have worked. What ever was broken is no longer there. Thanks for all the help

PHV, Guess what, there really are no macros. I double checked to make sure that show hidden was checked, and it was. For grins, I even checked to show system objects, but only see what I would expect in the table section. RG, I'll give your route a try. I've done that before, but was kinda...

In this case, I left the Switchboard Manager create the switchboard. I then modified the code to suit my needs. Technically, the switchboards contain code in modules, not macros, but that may be just semantics. I don't think that it is the switchboard code, because I can run the switchboard...

PHV, Sorry, but no macros at all. I prefer VBA. The properties for the dB are set to start up with the Switchboard form if that helps. Later,

missinglinq I thought that as well. But after I do a "shifted" start I am able to launch the Switchboard without the error. In fact, everything appears to run fine. I'm beginning to think that it must be due to code that compiles during the startup, but is then no longer needed. I just don't...

I have an access database (Access 2003) running on an XP laptop. When I double click the shortcut to launch the database I get the security dialog. No problem since I have my security set to ask if I want to run macros. But if I enable macros, after a bit of time I get a dialog that tells me...

Also, in case it isn't obvious from the previous 2 posts, watch how you declare the array. Use Dim myArry() and not Dim myArry(1,3)

You may still have cases where the simple doesn't work as expected. I've seen in other posting where people concatenated "" to the field to avoid null problems. Your simple query would then look like this: = IIf((""&[FamilyName])="", [FamilyName], ([Title]&" " &[LastName])) just my 2¢

Since you say you almost no VB experience, then it might be easier to create a batch file. Using a text editor, enter the following: MKDIR WBT MKDIR WBT\Administration MKDIR WBT\Administration\Review MKDIR WBT\Development MKDIR WBT\Development\Audio MKDIR WBT\Development\Assessments MKDIR...

Could it be that the slowdown is in the query 'qryStorageCommodities" and not the code? Just a thought.

You can try this. Test it on a copy of the spreadsheet since it has not error checking etc. Make sure that the cell after your data has nothing in it. To run, make sure that the first row is selected. Sub Test() Dim strN As String Do While Len(ActiveCell.Value) <> 0 'if the value...

Thanks Golom, Late last night I had more time to search the net and found even more help on this. It's amazing what well chosen search words will turn up ;-) we'll give the code you referenced a try. Thanks again.

I would like to create an applet (or script) that moves a file from a selected directory to a standard directory. Then, in place of the file, create a shortcut to the file's new location. Has anyone done this before that would be willing to share the code? Is anyone aware of anything out...