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 derfloh 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: Malc8179
  • Content: Threads
  • Order by date
  1. Malc8179

    Calculate Weekending

    Hi Guys i have this in a bit of code DATEADD(d, - DATEPART(dw, dbo.TimeSheets.Date), DATEADD(d, 2, dbo.TimeSheets.Date)) its returning sundays as the start of a new week not the end of the week (works fine for all other days in the week) any ideas what in doing wrong
  2. Malc8179

    Selection.Find errors out when not found

    Hi Guys i have a bit of code that loops through a number of rows then looks for the information and changes a bit of data when the selection is not found it errors out with error 91 i have added an error trap but it dont work any ideas Public Sub AddMissingAlpha() Dim strvalue As String Dim...
  3. Malc8179

    Screen freeze when running code

    Hi Guys I have a small issue I'm looping through a very large word document changing certain characters to other characters namely apostrophe to an apostrophe with a carriage return , the code also updates the status bar with progress The issue I have is the screen freezes not updating the...
  4. Malc8179

    Looping Through a Word Document

    Hi Guys Im new to coding in word i have an issue im trying to set up a loop that will find a section of text carry out a process, the issue i have is looping until the search text can't be found, I have set the start of the loop to Selection.Find.Found = False, this seems to stop the loop...
  5. Malc8179

    Word and Mail Merge

    Hi Guys I have a merged document that contains nulls each line is a link to a address field Strand Consulting Ltd 50 Essex Street NULL NULL London NULL WC2R 3JF any ideas on how if the the field contains null how i can move the next field in so the data should look like Strand Consulting Ltd...
  6. Malc8179

    Create a new instance of excel when opening a workbook

    Hi Guys I have a excel spreadsheet that when its opened it needs its own instance of excel have you any ideas on how i can achive this Malc
  7. Malc8179

    When Closing Access 100s of apps open on my desk top

    Hi I have an issue that when a user closes a access database she sometimes get around a 100 apps open up things like auto suggest dropdown, sys fader gdi+ Window
  8. Malc8179

    Saving Records on a Form

    Hi Guys I have a access form that is bound to a table when the users make a change in a field on the form and move to the next field or record the record is saved, the users have asked if this can be changed so they have to click a save button to commit any changes before they can move to the...
  9. Malc8179

    Open excel docs from a folder

    Hi Guys I have 980 excel docs in a folder i want to run a script in excel that will open each file in turn copy the file name store the the file name in a list im able to copy the file name and store the file name i am stuck with opening the files from the folder in turn
  10. Malc8179

    Unable to open a list in a datasheet view

    Hi Guys Im trying to open a list in datasheet view, all i get is an error any ideas
  11. Malc8179

    Open Import Data Dialog Screen

    Hi Guys I need to open the import data dialog box as part of a script, any ideas on how to do this Malc
  12. Malc8179

    Insert data from Excel in to a sql server database table

    Hi Guys Can you help I’m building have a excel compiler that creates a set of data to be added to a table in a database on a SQL server, the users can run this at any time the issue I have is how do I insert in to the table from excel using code
  13. Malc8179

    Setting Record Locking

    Hi Guys Any idea on how i can set the option "Edited Record" on the record locking section on the advanced tab of the Options Menu using VBA Malc
  14. Malc8179

    Set a MS Access Report Recordsource from a script

    Hi Guys im trying to change a reports recordsource from a bit of code im using Reports!GND37R01.RecordSource = "qrygnd37r01" and i get a runtime error 2451 any thoughts
  15. Malc8179

    Open a ms access report from a excel macro

    Hi Guys Has anbody an idea how to open a ms access report from a bit of code i need to write in excel

Part and Inventory Search

Back
Top