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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by markvan
-
Variable interferring with SQL
Thanks Skip Works perfectly now ! Mark Van Laarhoven Dot Imaging Online Printers, Sydney, Australia. www.dotimaging.com.au- markvan
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Variable interferring with SQL
I am attempting to update the notes field of my Orders table with a new note. The newnote variable has the existing notes and the new note appended at the bottom and can be a few pages long. When I attempt to run the SQL SQL = "UPDATE Orders " & "SET Orders.notes = " & newnote & "WHERE...- markvan
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
UPDATE Orders SET Selected = -1 WHERE OrderID = OrderID;
UPDATE Orders SET Selected = -1 WHERE OrderID = Me.OrderID; This brings up a parameter request, why isn't it recognising the current record, is it because the Me. refers to the Macro rather than the Current Record? Mark Van Laarhoven Dot Imaging Online Printers, Sydney, Australia...- markvan
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
UPDATE Orders SET Selected = -1 WHERE OrderID = OrderID;
Problem with my WHERE How do I reference the current record here WHERE OrderID = currentrecord.OrderID ? I have a button that runs a macro in the detail section, so I need it to work only on the current record. I know this is basic, sorry. Mark Van Laarhoven Dot Imaging Online Printers...- markvan
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Is it possible to bypass all the Dialog Boxes when running a macro?
Problem solved I used this code: Private Sub btn_SendActivityReport_Click() On Error GoTo Err_btn_SendActivityReport_Click DoCmd.SetWarnings False Dim stDocName As String stDocName = "Macro_Send_Activity_Report" DoCmd.RunMacro stDocName DoCmd.SetWarnings True...- markvan
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Is it possible to bypass all the Dialog Boxes when running a macro?
I have set up a series of queries that are activated by a macro, which works like magic, BUT..... You have to click YES YES YES YES YES YES YES about a dozen times. Is it possible to automate the "Yes"s and get rid of all these confirmation screens? Mark Van Laarhoven Dot Imaging Online...- markvan
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Exporting New Data Only
This was much easier than I expected. I added a new field to each table with either "New" or "Old" values. Then I do an append query copying all "New" records to a new temporary table, that I export as an excel spreadsheet and send via email. Once that is successful I do an update query that...- markvan
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Exporting New Data Only
Thanks Jerby & PHV. I understand your suggestion about having a NewRecord field, and seems like a sensible solution to me, I will be trying that today. I will read up on Replication as I don't realy understand the issues. I will probably need to start using some VBA or Macros which will be a...- markvan
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Exporting New Data Only
I have an Access solution that my Sales team uses remotely, i want them to be able to click a button, that will export all their new entries from a specific table. They email that file to me, so I can add it to the master table that combines their entries with everyones. What is the best...- markvan
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Storing HTML Code as a String
it works just as Christiaan explained Mark Van EZ-PC Help www.ezpc.com.au- markvan
- Post #7
- Forum: Visual Basic (Classic)
-
Storing HTML Code as a String
Thanx Christiaan I will try that when I get back to college. I will post back here to let you all know how it went. Mark Van EZ-PC Help www.ezpc.com.au- markvan
- Post #6
- Forum: Visual Basic (Classic)
-
Storing HTML Code as a String
Sorry Chiph that does not work! Dim xhtmlheader As String = ""<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >"" Still no good! PS how do you do the CODE box in these...- markvan
- Post #3
- Forum: Visual Basic (Classic)
-
Storing HTML Code as a String
How do I store some html code as a variable or string without the html syntax messing with the vb.net syntax? Dim xhtmlheader As String = "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"...- markvan
- Thread
- Replies: 6
- Forum: Visual Basic (Classic)
-
Help Updating the database
I have these 2 buttons, the load button works, it gets all the data into the dataset and I have bound some txtboxes to the dataset so it displays the relevant info. My problem is when I try to update the changes I make. Please comment on my code as I have stuffed around with this for hours and...- markvan
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Help with string length for textbox
LOL, sorry again guys. Guess what? now it is working and I have checked it thoroughly. Here it is: Dim strFile As String = "WelcomeMessage.txt" Dim lines() As String Dim tr As IO.TextReader Dim inttemp As Integer Private Sub Form1_Load(ByVal sender As System.Object, ByVal...- markvan
- Post #5
- Forum: Visual Basic (Classic)
