Thanks alot, it is working fine for me now. Thanks for all your help. it was conflicting with one of my Replace Function. Have a great Day ... From:...
Hi John, Sorry for the transposition of words in the title of the upload. I repsonded and then I uploaded and called it something else. Did you get a chance to...
Hi all, Is there any code to stop an Event or Procedure immediately? I have set up a form to check the real time connection to Data Server on its Timer Event....
Hi Crystal, I read the paper a couple of weeks ago and found it very interesting as well. Anytime I come across anything by Luke Chung, President and founder...
Shan Roy- To "cancel" the Timer event, set the TimerInterval to 0. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
The database is essentially a dictionary and can be visualized as such. One table has two datafields for the letter groupings and their descriptions: "A" "The...
SELECT Field1, Field2, "" As Field3, "" As Field4 FROM Table1 UNION ALL SELECT Field1, Field2, Field3, Field4 FROM Table2 ORDER BY Field1 .. where "Field1" is...
Question: If the Division number changes in 1 table, it is suppose to automatically change in the other tables. If it don't change, what is the problem? ...
Hi Pat, great link, thanks! Looking forward to making time to read 'Playing WAV Files (API)' by Gavin Burgess ... several other things caught my eye too...
Tyrone A child row would be a record in a table that has a foreign key to another table. For instance, Customers is a table with the primary key CustID. Orders...
Hi Crystal If you read *all* the posts here you would have seen one for playing WAV files. <g> Bill ... read 'Playing WAV Files (API)' by Gavin Burgess ......
Hi Tyrone, "My professors response to my database problem/question: It will if you have the relationship created correctly, turn on referential integrity,...
Hi Bill, I'm gonna have to set aside at least a few days once I start looking at the WAV stuff because I have some coding in mind ... <smile> yes, I do...
Hello, Access 2003 I have used the following code to open a PDF file - it works: Application.FollowHyperlink "D:\My Documents\databases\poss_fe\possManual.pdf"...
Hi John Viescas, I had done it already. It works fine only if the connection is successful. ie it never stops until it finishes the entire procedure which...
Peter- You're not passing the same value in each case. Application.FollowHyperlink "D:\My Documents\databases\poss_fe\possManual.pdf" .. passes the value: ...
Shan Roy- The FIRST line of code in your On Timer event procedure should be: Me.TimerInterval = 0 That shuts off the timer, and your code can take as long as...
John, Of course you are right! I thought I needed the quotes. Now it works well. nobody should ever tell I would not go the extra (complicating) mile :) thanks...
Hi All I have an access 2007 database that is split. I needed to move the database to a new server, which I have done. When I tried to manage the linked tables...
If it's only one table, the simplest thing to do is delete the linked table and relink it. John Viescas, author Microsoft Office Access 2007 Inside Out ...
Chanell- Yes, I've looked at your spreadsheet a couple of times. First rule of thumb should be that ONLY data entered by the user should end up a fields in...
Hi John, I only created fields in my table where the user has to input data...None of the calculated fields are a part of my table. The only information that...
Jonus I can think of a couple things: 1. The name of the table is misspelled in the front end. 2. The table does not exist in the back end. But don't beat...
Hi Clive, thank you I put 49146 in the search box and got your post below, not the post with that number what was the date/time of the post? I can find...
Hi Crystal The code is at msg#67300 Bill ... looking at the WAV stuff because I have some coding in mind ... <smile> ... search for it when the time comes --...
Hi Crystal, I am glad you found something you like. There is so much on the site I am going to start a new Thread to post some of what is available to ...
Hi All, Some of us have been checking out the great wealth of free presentations and downloads graciously made available to the public from the UK AUG...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
