Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating records via VBA in bound continuous form
You sir, are a star! Thank you. That did the trick wonderfully. ---------------------------------------- Knowing is not enough, we must apply. Willing is not enough, we must do. --Bruce Lee- DrDan1
- Post #8
- Forum: Microsoft: Access Forms
-
Updating records via VBA in bound continuous form
I currently have the form properties set to allow edits, although I want it set to no. But if I set it to no then I can't alter any of the combo or text boxes. As I said, I'm an access newbie, so maybe I'm going around this in completely the wrong way. ----------------------------------------...- DrDan1
- Post #6
- Forum: Microsoft: Access Forms
-
Updating records via VBA in bound continuous form
Thanks Aceman. I tried that already but got the same alert. I'm pretty new to Access but I was wondering if it would be possible to show the results in an unbound form. That way I can ensure that updating an individual record will only be done by the code...- DrDan1
- Post #4
- Forum: Microsoft: Access Forms
-
Updating records via VBA in bound continuous form
FYI: The code I have to do the updates to the 2 tables is as follows: Private Sub Command31_Click() Dim sqlQuery As String Dim sqlQuery2 As String Dim SiteID As Integer Dim UpgradeId As Integer Dim EngineerID As Integer Dim EnvironmentID As Integer Dim DoneTime...- DrDan1
- Post #2
- Forum: Microsoft: Access Forms
-
Updating records via VBA in bound continuous form
Hi. I'm using Access 2010 and I'm stuck! I'm essentially putting together a system for booking jobs. I have a form for booking them (done and dusted) and a form for confirming a job as complete. when updating the job as completed, it needs to update TWO tables, including the jobs table. Each...- DrDan1
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
-
Keeping files seperate to virtual domain path
I've managed to more or less do what I wa intending using mod rewrite, however of course this doesn't remove the actual variable folder that contains the "userX." I was wondering if there was an Alias equivilent to vhost_dbd out there, but scouring the net, there doesn't seem to be. Pity...- DrDan1
- Post #3
- Forum: Linux (server)
-
Keeping files seperate to virtual domain path
Ah! Never mind. I just found out about Alias! It does exactly what I need. Well, almost. If anybody knows of a way to generate a dynamic Alias path, then please let me know. For example user1 will have an images folder that points to: htdocs\shared\user1\images And user 2 would have one...- DrDan1
- Post #2
- Forum: Linux (server)
-
Keeping files seperate to virtual domain path
Maybe I'm over complicating things here, but here goes. I'd like to have a system where a user can have theri own website by selecting a website template. Lets say a user select template1 stored at: \htdocs\templates\template1\ He will also need to be able to store his own files, such as...- DrDan1
- Thread
- Replies: 2
- Forum: Linux (server)
-
2 Col layout, But SEO friendly
I have been suitably chastised. I will be more observant next time. Thanks to you and Mark for your help. ---------------------------------------- Knowing is not enough, we must apply. Willing is not enough, we must do. --So said the ever wise Bruce Lee Memorize and live by it!- DrDan1
- Post #6
- Forum: HTML, XHTML & CSS
-
2 Col layout, But SEO friendly
Soooooo close.... <html> <head> <style type="text/css"> <!-- .container { float: left; width: 100%; } .rightcol { background-color: #FFCCCC; float: left; margin-right: 170px; position: relative; left: 170px; width: 100%; } .leftcol { background-color: #0099CC; width: 170px...- DrDan1
- Post #4
- Forum: HTML, XHTML & CSS
-
2 Col layout, But SEO friendly
Ah.. but I have indeed consulted my good friend Google. And I found that exact same site, however you'll notice that both those columns are fluid. I need the left navigation column to be static. The closest I have manged to find is...- DrDan1
- Post #3
- Forum: HTML, XHTML & CSS
-
2 Col layout, But SEO friendly
Hi. I am attempting to create a page with a header and footer and 2 columns. The navigation column on the left should be static, while the right one will be fluid, accoring to the size of the screen or window. Simple enough to do, but for SEO reasons, I need the right column source code to...- DrDan1
- Thread
- Replies: 5
- Forum: HTML, XHTML & CSS
-
Show unique primary key from record just submitted
Now I'm going to have to buy a new keyboard :) Thanks. I knew it's be something simple! ---------------------------------------- Knowing is not enough, we must apply. Willing is not enough, we must do. --So said the ever wise Bruce Lee Memorize and live by it! -
Show unique primary key from record just submitted
Hi. The answer to this is probably so simple I'll end up cracking my head on the keyboard later. Using a very simple example, I have a table with just 2 fields. A primary key consisting of a unique auto-number and a name field. A user would submit their name in a form and the ctahing page... -
email from exchange server into MySQL database
I THINK I DID IT!!!! :-D I got it to move an email from the sent box to a sub folder of the sentbox called 'moved' Thanks again. couldn't have got this far without your help. <?php //$sentItemsFolder = 5; $realMessage = 43; $outlook = new COM("outlook.application"); $mapi =... -
email from exchange server into MySQL database
Thanks. I'm really grateful for what you've shown me so far. If you get a chance if a few more days that'd be great. :) I can get the script to move the email from and to default folders. i.e. From '5' for sent items to '6' for inbox. (I had some fun when I got those mixed by accident)... -
email from exchange server into MySQL database
Hmm... I'm getting somewhere. I've decided to run this as a script rather than via apache. The script will update the database with email properties, such as body and subject. That I can do ok now. But of course I don't want it to do the same messages all the time, so I'd like it to move the... -
email from exchange server into MySQL database
Thank you so much Ingresman. Even if I don't get this sorted, you've shown me a lot and given me much to think about. I'm currently reading about objects and classes. I also found this link that may be of help: http://www.prd-software.com.au/prd/support/kb/kbarticle.asp?id=115... -
email from exchange server into MySQL database
Here is my entire code: <?php $sentItemsFolder = 5; $realMessage = 43; $outlook = new COM("outlook.application"); $mapi = $outlook->getnamespace("mapi"); $mapi->logon("drobertson","2Dive49"); $sentFolder = $mapi->getdefaultfolder($sentItemsFolder); $items = $sentFolder->items... -
email from exchange server into MySQL database
I'm trying the above code but I keep getting timeouts (decided to just play with the sent items for now): Fatal error: Maximum execution time of 30 seconds exceeded in C:\Server\Apache2.2\htdocs\tests\outlook.php on line 35 I've tried playing with the code a little but much of this is new to...
