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

  1. mfd777

    Print to PDF using Office 03, XP, and PDF 6.0

    If the PDF printer created on each workstation has the same default name (Adobe PDF), then one solution might be to amend the page setup on the report to use this specific printer. Therfore, no need to amend registry to set up a different printer as a default.
  2. mfd777

    Subform Issue

    Thanks for your suggestion Zion7. To keep the function applicable to all forms, I need to programatically determine if a form is loading as a subform or a main form. Are you aware of a property on the form that I could read?
  3. mfd777

    Subform Issue

    I am having an issue with implimenting specific security in a database. The requirement is that when a form loads, a function is called. This function runs through all the controls on the form and sets them to disabled based on information held in a user security table. The calling form passes...
  4. mfd777

    Use ADO to create querydef

    Thanks for the advice guys. I was trying to avoid creating SQL Server objects such as views and Stored Procedures. Perhaps a paramaterised stored procedure is the way to go. This should negate any inefficiencies used by using ODBC rather than OLDDB?
  5. mfd777

    Use ADO to create querydef

    ...the recordsource for our forms, use DAO, as follows: Declarations: Dim mysql as string Dim dbs as database Dim qdfname as querydef mysql="select * from customers where cust_id=12345" dbs.QueryDefs.Delete "Customers_qry" set qdfname=dbs.CreateQueryDef("Customers_qry") qdfname.sql=mysql...
  6. mfd777

    Apply a file extension change to an entire folders contents?

    ...can do a bulk extension change through DOS. The following would be the senario: 1)Go to DOS prompt. Click on start run and type cmd (for NT) or command for Win 95/98 2)Type in the following command: ren c:\mydir\*.jpeg *.bmp This means rename all files with a jpeg extension to a bmp...
  7. mfd777

    500,000 KB vs. 20,000 KB

    Just a word of warning regarding compacting. Apart from the defragmentation of the database, compacting will reset any deleted autonumber values, where new records have not been subsequently created. For iunstance, some users may use a temp table to generate an autonumber, and periodically flush...
  8. mfd777

    Export delimited text with a macro or code

    Right click on query and choose export. From the wizard that comes up you can select a fixed width file. Click on advanced and you can select options for delimiting dates and times. If you intend to export regularly click on "save as" in this advanced window to save the export...
  9. mfd777

    Upsize, is it possible for me??

    Just a note on upsizing to SQL server. I agree that you should not need to. If you do, you export tables to SQL server and then link to these tables. If the linked tables have the same name as the native access tables, then your application code/queries etc.. should not change. This will not...
  10. mfd777

    multiuser with sql server

    To set up SQL server link do the following: 1. Ensure tables exist in sql server 2. Open ODBC administratot (control panel, if using win2k then administrative tools section) 3. Create a new dsn type of your choice (user, system or file). Click on add. Select microsoft sql server driver...
  11. mfd777

    Creating fields which change on mouse over

    A nice alternative was posted here some-time last year. It may not be what you need but I find it good. 1. Select all the controls that you wish to highlight 2. Set the background colour to highlight colour of your choice. 3. With the controls still selected, set the back style property to...
  12. mfd777

    access format problems on different computer

    Following on from DonQuichotes' quote, you may be simply missing a reference in computer B. To fix this, open any module (or code in a form). Now click on tools --> references. If any are expected and are missing the work "MISSING" will prefix the offending reference. Click on this...
  13. mfd777

    Autocomplete not working in VBA

    When I type in a command that would bring up the list box of available arguments, the list box disappears automatically. Also when you press space bar the space disappears. Anyone else come accross this before?
  14. mfd777

    Breakpoint not working

    I have an access 2K database running in access xp. Recently, the database has decided to ignore any breakpoints I enter when trying to step through code. Has anyone seen this before?
  15. mfd777

    Run-time error '13' in DAO

    Solved problem. Needed to prefix declaration of recordset with DAO
  16. mfd777

    Run-time error '13' in DAO

    When trying to open a recordset I keep on getting @Run-time error '13' Type mismatch error. Code is very simple: Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = db.OpenRecordset ("test", dbOpenSnapshot) The @test@ query opens fine in the database window.
  17. mfd777

    Page total on report

    How can I get a page total prior to reaching end of group? I have a report that has three pages of detail. One page one I need a total for "inv_val" field in the page footer. On page I need to show the total in the page footer but only relating to details printed on page two etc...
  18. mfd777

    Show number as text

    Thanks Lightning. Function is perfect!
  19. mfd777

    Show number as text

    Does anyone know of a function that will display a numeric value as english text e.g: €3,417.98 Should result in: "Three thousand, four hundred and seventeen euro, ninty eight cent". Thanks for your help.
  20. mfd777

    Typing in code

    This has happened to me a number of times on different workstations. Has anyone out there any suggestions. When typing in code in a module, two things happen. When you hit the space bar the cursor automatically moves back to the left unless you type within a second or two. The text is also...

Part and Inventory Search

Back
Top