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 TouchToneTommy 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: *

  • Users: markvan
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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"...
  6. 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...
  7. 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...
  8. 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...
  9. markvan

    TransferDatabase to linked tables?

    I have a reporting system that has new records each year for the new students. I need to make a macro that will grab the comments for subjects and append them to the linked tables my mdb uses from an external mdb file. I have gone the regular route of TransferDatabase and can easily import into...
  10. markvan

    Coding GoToRecord on a subform?

    I have been stuffing around for hours, trying to goto a record on a subform, from a report. Form is called frm_NAV Subform is called frm_reports The field I want to go to is ReportID. I keep getting &quot;OBJECT NOT OPEN&quot; errors. Suggestions Oh gurus? Mark Van EZ-PC Help www.ezpc.com.au
  11. markvan

    Getting back to a subform from a report

    This is my code: Private Sub Report_Close() On Error GoTo Err_Command198_Click Dim stLinkCriteria As String Dim mainNav As String mainNav = &quot;frm_NAV&quot; stLinkCriteria = &quot;[ReportID]=&quot; & Me![ReportID] DoCmd.OpenForm mainNav, acNormal, ...
  12. markvan

    A ¦ B ¦ C ¦ D ¦ E ¦ F ¦ G ¦ H ¦ etc..... Navigate a Recordset?

    I have a list of 300 names in a recordset I want to put links at the top of the page like: A | B | C | D | E | F | G | H | etc..... So you can move to the names beginning with whichever letter you choose. Can I target parts of a recordset? or am I missing the obvious, help please! Is there some...
  13. markvan

    Date format prob I think?

    I am passing a date from the previous page, and am filtering the recordset for the current page by that date, I get this error: ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record...
  14. markvan

    80040e14 error, field not updateable, Why not?

    I am filtering records in the recordset by the field &quot;MeetingID&quot; and wish to be able to update the other fields in this recordset. When I try to update, it gives me the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Cannot...
  15. markvan

    running an Append Query from ASP

    I have a Database that needs to use an Append Query, to populate forms. It works great offline. Now to get it working remotely? Using UltraDev4 ASP/VBscript can I execute the append query on the server copy of the Access2000.mdb? How? I can run simple queries, but not my Append Query? !!!! HELP...
  16. markvan

    Picking up an Initial Value from the URL

    I am passing values to my page using &quot;GET&quot; method adding ?username=&quot;whatever&quot;? to the end of the URL. How can I set the Initial Value of a field on my next page to the username in the URL? I imagine I need to put something in the Initial Value box in the properties for that...
  17. markvan

    Autocompleting a Field for a Record Search.

    How can I create a search for records that automatically filters to the letters entered. eg. List of names like &quot;Doofus, Dopelheimer, Dorcas&quot; that will come up when the search field is simply &quot;do&quot; Better still, if I enter &quot;do&quot; it would autocomplete to give me...
  18. markvan

    How can I Calculate % from 2 subforms?

    I have 2 subforms subfrmContactsInACell subfrmContactsNotInACell These are built on queries to count the records The subforms have the purpose of displaying the record count using =Count([ContactID]) Where do I go from here? I have tried an unbound field with the source set to...

Part and Inventory Search

Back
Top