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...
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...
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...
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...
Thank you both for your suggestions. Being human (lazy), I was hoping for a quick and easy solution for moving the forms and reports to the VB app. Moving the code is not really a problem.
I will look into both suggestions.
We have a pretty extensive Access front end to the company Sql Server back end database. This includes a myriad of reports and forms. For a variety of reasons, we would like to convert this from Access to a Visual Basic application.
Can anyone offer a suggestion or two on the most most...
I use a laptop, that when in the docking station, is hooked to a second monitor (I have to work with CAD drawings as part of the job). I occasionally undock the laptop for meetings around the office (we're wireless). When I re-dock, I have to re-extend the desktop to the second monitor. To do...
kjv1611: Yes this is in Access, and I suppose that I could create a query, and then use that where necessary. However, this is for a very large (complex?) application that has both Access and SQL back ends. At the risk of aging myself, a long time ago I found that working directly with SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.