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

    Remove data from word document after position x

    I have a word document that contains a brochure. I need to remove all data after a given point as it is not needed. I guess that I need a simple macro that loops through the document, positions the cursor at point x (below 22 on the ruler) and then deletes all the rest of the data on that line...
  2. Greyfleck

    Discard Saved data when loading reports option

    I am new to CR. I have the basic version with VS 2008 professional edition. I am using a book:CR Basic for VS 2008. It tells me that I can discard data by checking an option on the reporting tab of the options dialog. I have searched everywhere for this option but to no avail. Can anyone...
  3. Greyfleck

    Webbrowser change page error

    I am working on VS 2008 and have a simple form on which I have created a webbrowser. It happily shows the first page but, when trying to show a new page, it opens a new window, briefly shows the new page and then closes it again leaving me with just the original page display. I am not attempting...
  4. Greyfleck

    Deploying a windows based application

    I am trying to follow microsoft's walkthrough http://msdn.microsoft.com/en-us/library/k3bb4tfd.aspx just to familiarise myself with the process. However I come unstuck on page 2 To add the windows-based application to the installer I cannot process step 3 "in the Add Project Output group...
  5. Greyfleck

    Concurrency - VB 2008 - Access 2007

    I have a single user application with an Access table :- Horseid autonum Date datetime Course text Time datetime Horse text Done Bit I load the table into a dataset (where done <> true) and, after processing set the Done field to true. this is fine as many records as I want and...
  6. Greyfleck

    Basic SQL Insert command

    I have spent the past couple of hours 'googling' this command and to a man they all give examples of the Insert statement using literals. I have a simple table: Horseid int iscontrol Mdate smalldatetime MCourse varchar(50) Mtime smalldatetime MHorse varchar(50) MChecked bit I have 4...
  7. Greyfleck

    VB &amp; connection strings

    I am using VS 2008 with sql server 2008 I wish to write a small test app to try out my new found skills but have hit a brick wall. I do not wish to use the binding adapters et al (so called VCR controls) but wish to utilise my ADO.net skills thru code. My 'brick wall' is in the connection. Do I...
  8. Greyfleck

    Please point me in the right direction

    Having spent the last two years writing with Access (2003/2007) and finding the deployment (security messages et al)just a pain I decided to change tack and try VB (after all VBA to VB should be a doddle right>?) I am finding it really hard to get into the VB mindset and am looking for a good...
  9. Greyfleck

    How to remove the Developer option when .ACCDE

    I have now created my .accde which appears suitably protected but retains the Developer option under the Big Microsoft button. Does anyone know how to prevent this option appearing please. Jon
  10. Greyfleck

    Is there a way to tell if the PC is running Vista or XP

    I am running some tests which work fine on XP but poop themselves in Vista. Is there a way I can tell which operating system I am working on within the code so I can stop duplication ... Thanks
  11. Greyfleck

    Deploying in XP good, in Vista Error 3027!

    I have a split database. My forms are deployed under Program Files and my data under My Documents - Trusted Access Sites ...etc I use the same deployment software (Smart Install Maker) executable for both machines. XP works well - Vista fails with error 3027 and the database opens read only...
  12. Greyfleck

    438 Object doesn't support ....

    folder_path = "c:\program files\MWT\9f7bfg.txt" fs = CreateObject("Scripting.FileSystemObject") If Not fs.folderexists(folderpath) Then fs.createfolder folder_path End If I am getting the 438 error on the createObject line I am guessing that perhaps I have a...
  13. Greyfleck

    Dynamically link tables using ADO and a password

    I have 3 dbs, forms, data and password. I have password protected data and password but now cannot open the databases. I link the tables dynamically. My code is datapathextra = "_data" mydot = InStr(1, datapath, ".") workpath = Left(datapath, mydot - 1) worklen = Len(datapath)...
  14. Greyfleck

    Synchronizing From a popup

    I have two forms. A property form and 'select address' popup form. If they select an address from the pop up I wish to populate the main form with their selection. I have beaten myself up over this for far too long and would really like some help. I have tried it with a query and requery, AND as...
  15. Greyfleck

    How to select all but the first record

    I have a table of many records. I need to select all but the first one of a given type (Types being 2 chars)... any suggestions would be gratefully received.
  16. Greyfleck

    Pre Printed Stationary and Access 2007

    I have a 26 page pre printed government document that I have managed to fill by taking each page and handling it as a standalone report. Some of the pages simply have to print the jpg background some have bound and some unbound controls. I have tried to create a master report bringing them all...
  17. Greyfleck

    Printing onto Proforma Sheet using unbound controls

    I am trying to print onto a preprinted document (that cannot be changed - it is a legal doc) and am struggling on page 2. The first page prints correctly but on subsequent pages the data prints 1 cm higher. The whole page is stored in the detail section - no headers or footers. Can anyone help...
  18. Greyfleck

    SQL Newbie! Joining tables and getting them to update

    I have two simple tables linked address table (LAT) and a Properties table (PT) the LAT has fields LinkCode Text (from one of many types of contact) LinkId Number( As above ) AddressId Number (The Primary Key of the PT) The PT has fields AddressId Autnum followed by address details I have...
  19. Greyfleck

    Access 2007 keeps crashing when reviewing a report

    I have a simple split database. I created a simple report that reads a table directly (no sql etc.) and then prints group totals (badly as it seems to do it twice). The code is in groupheader0.format. After closing the database and re-opening it the report appears to be corrupt and Access...
  20. Greyfleck

    How to link db's in Access 2007

    I have two dbs, BRX and BRX_data which contains the tables. I have a start up module that runs the following code. I have managed to get the code to work but have had to hard code the "BRX_Data" bit & the "Msys" bit (to avoid Access tables). Any clues as to how I can do this without the hard...

Part and Inventory Search

Back
Top