tdw
Last Activity: Feb 14 '09, 03:05 PM
Joined: Mar 29 '07
Location: Woodbridge, Virginia
-
Yes that is a good way of describing it. That someone has encountered this before and happens to see the question is all I can hope for. I think I've Googled it all I can at this point. -
I was afraid that would be the case. I've looked at all of those basic security and other settings that I can think of.
I apologize about the question being open ended, but the problem, so far as I can tell, is probably something just that simple. Just can't find it.
However, I also wondered if it's some kind of reference library problem. I looked at all that and it looks fine too.
Just at a loss.Leave a comment:
-
I have the email thing working fine on my computer. However on another computer (my boss's) it just doesn't work. No error message or anything, it just doesn't open a new email message at all. Outlook is installed on his computer, and it is set as his default email program.
Any ideas what might be different on his computer than on mine?Leave a comment:
-
A corrupted database is what caused me to start learning Access.
So far, just self-taught, but may go to school to learn more soon.
No corrupted databases since then....yet.... I hope I didn't just jinx myself.
When the Messiah comes, won't the anti-christ be killed?? Without Bill Gates, what would you need with a Microsoft database anyway? So much for Him resurrecting the file.Leave a comment:
-
Wow. I am curious as to the answer to this as well. Can Access do random number generation?
You could always create code that assigns a number to each button on the keyboard, runs some sort of calculation on a text field entry, and have a cat walk across your keyboard.Leave a comment:
-
First you'll want to split the database into a "Front End / Back End". This is important to avoid the database becoming corrupted, especially if you are intending this to be a multi-user program.
Then you save the back-end into a location on the server where it won't accidentally be moved or deleted by some other user.
Then copy the front-end onto each user's computer. The front end will contain all of the forms,...Leave a comment:
-
Probably a dumb idea, but could you give software support a dummy asset ID number, like zero?Leave a comment:
-
Not sure, personally, since I really don't use subforms (no need for them yet). But the first thing that came to my mind was to check your Tab Order on the form (or subform). It may be that something near the bottom of your form (or subform) is at the top of the Tab Order list.Leave a comment:
-
Have you tried using a form instead of a report? It seems to me that you would benefit by having a series of forms that are filtered by whatever command buttons and combo boxes you set up. Then if you need an actual "report" based on the info currently displayed on your screen, create a "print report" or "view report" button on the form.
The only reason that I can think of that you'd even desire to do this...Leave a comment:
-
I am also looking to accomplish this. I will check out the link below, but wanted to respond to this comment.
I have thought the same thing (using the pdf printer), but then I don't know how to programatically name the pdf and save it in the correct location. Currently I save the report in .rtf format, but it loses the look of the layout of the report that way. The .rtf file does programatically name itself and save in the correct folder,...Leave a comment:
-
Ok, that all sounds good. I will try it.
Thanks!Leave a comment:
-
Not yet. I will as soon as time allows.Leave a comment:
-
Updating a table from TXT file
Hi all,
I have several ideas on how to do this, but am having difficulty putting the ideas together and figuring out the most efficient way to do this.
I have a database of survey coordinate points. These records are imported from a txt file, and never manually entered. Currently there are no forms at all.
The first problem is that the txt file continually gets updated by a CAD program.
The second problem... -
Quick question on this.
I have been reading through the link you gave me, FishVal. I have a switchboard that is always open on the front end, which of course uses a table as it's record source. Isn't that already a persistent recordset connection? If so, it looks like I'll need to do the suggestions further down in the thread.Leave a comment:
-
Looks promising to me too. I'll let you know how it works out when I get a chance to try it. Thanks!Leave a comment:
-
Makes sense. I think in this case a procedure within the form's module would be most appropriate. I'll give it a try.Leave a comment:
-
Thanks for the advise. I will do that as soon as I have time. If and when I get results, bad or good, I'll post again here.Leave a comment:
-
Yes, but the $$$ is the problem. My boss wouldn't understand the usefulness of it, since he is really just a basic user, and not the one who has to improve it's functionality or performance.
That link you provided, is that also for creating an installer so that I could, say, put the database on a disk and distribute it to other people to install on their machines and servers (minus the actual data, of course)?Leave a comment:
-
Yes, there is a lot of configuring. I ended up using it because the only batch file I know how to do would copy the front end every time instead of just when there was an update. I'm sure there was a batch file solution to that too but I didn't know how to do it, so I didn't. But, once set up, the FE Updater is great....Leave a comment:
-
In looking for a solution for automatically pushing updated front ends to individual computers for my database I found a shareware solution.
It's a utility that you launch from the server on each computer. It copies the front end file from the server to the computer, and from then on every time the user opens their front end (using the desktop icon it creates) it checks to see if the copy on the server has been updated (by looking at the "modified"...Leave a comment:
No activity results to display
Leave a comment: