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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. markvan

    Variable interferring with SQL

    Thanks Skip Works perfectly now ! Mark Van Laarhoven Dot Imaging Online Printers, Sydney, Australia. www.dotimaging.com.au
  2. markvan

    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...
  3. markvan

    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...
  4. markvan

    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...
  5. markvan

    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...
  6. markvan

    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...
  7. markvan

    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...
  8. markvan

    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...
  9. markvan

    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...
  10. markvan

    Storing HTML Code as a String

    it works just as Christiaan explained Mark Van EZ-PC Help www.ezpc.com.au
  11. markvan

    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
  12. markvan

    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...
  13. markvan

    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"...
  14. markvan

    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...
  15. markvan

    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...
  16. markvan

    Help with string length for textbox

    Sorry guys one mistook in that code, it works but duplicates the first line in the output. All you need to do is comment out this line then it will work perfectly: 'txtWelcomeMessage.Text = tFile.ReadLine() Cheers, Mark Van EZ-PC Help www.ezpc.com.au
  17. markvan

    Help with string length for textbox

    Thanks Christiaan You solved my problem, works perfectly. This is the working code in case anyone else needs it: Dim strFile As String = "WelcomeMessage.txt" Dim lines() As String Dim tr As IO.TextReader Dim inttemp As Integer '=========================================...
  18. markvan

    Help with string length for textbox

    I am successfully displaying the content of an external text file in a textbox txtWelcomeMessage. The problem is, it only displays the first 120 or so characters from the text file. I upped the MaxLength property on the textbox but it makes no difference, I think it has to do with the variable...
  19. markvan

    Newbie needs help, simple question I think?

    Solved my own problem thanks if you want to know how changed formula to =$A$15*B20+B20 it now copies down all the cells updating only the B column. Mark Van EZ-PC Help www.ezpc.com.au
  20. markvan

    Newbie needs help, simple question I think?

    My formula is =A15*B20+B20 I want to copy this down the column of cells, but when I drag it down I get =A16*B21+B21 then =A17*B22+B22 etc. But I want it it to be =A15*B21+B21 then A15*B22+B22. How can I copy it down all the cells, updating the B? but keeping the A constant on 15? There are...

Part and Inventory Search

Back
Top