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: huzza
  • Order by date
  1. huzza

    Update code not linking form and table, WHY!!!

    Hi, replace both instances of [ with [ in my previous email Richard
  2. huzza

    How to export to a password protected database ?

    Hi Missy, Before you use that code I've noticed that it changed a [ into [ so you'll need to alter it. That's strange that's the second piece of code that I've posted that has had &#91 put in instead of something else. Richard
  3. huzza

    Data Populating Table but Not Saving On Form

    Hi Mel, Sorry about that the code seems to have been corrupted when I posted it should read: DoCmd.OpenForm "Reimbursement Subform", acNormal, , "[CustomerID] = Forms![Site Information Form]![CustomerID]", acFormEdit, acWindowNormal
  4. huzza

    Aggregate Feature that works with strings

    Hi, Thanks for letting us know, that could be really useful. Richard
  5. huzza

    How to export to a password protected database ?

    Hi, Try changin the SQL to: INSERT INTO RECEIPTS IN 'C:\CASH\VER2\DATABASE\BRANCHDB.MDB'[;PWD=jigglypuff2000!] ( CASH_SHEET_DATE, BRANCH_NUMBER, TILL_NUMBER, RECEIPT, STANDARD, ZERO, PRESCRIPTION ) SELECT RECEIPTS.CASH_SHEET_DATE, RECEIPTS.BRANCH_NUMBER, RECEIPTS.TILL_NUMBER, RECEIPTS.RECEIPT...
  6. huzza

    Access project. How to resolve parameter, instead of prompt box

    Hi Jerry, I don't think you need to specify the module name you should be able to just state pubParentID and pubKeyID if the variables are public/global. I think you only use module references for callings functions and procedures where there is more than one of the same name. If there was more...
  7. huzza

    Need help on Soundex logic

    Here's a couple more sights to try. The second is a code repository with downloadable source code for various soundex functions Richard http://www.freevbcode.com/ShowCode.Asp?ID=147...
  8. huzza

    Need help on Soundex logic

    Hi, you may find this article of some use http://www.vb-world.net/articles/soundex/index.html the link goes to the first page of the article to skips to the code choose "The Algorithim" from the "This Article" section on the right. I've also seem details on it in use in a vb...
  9. huzza

    Dual Fields in Indexes

    Hi, I think it is basically talking about secondary sort. I.e. when the bathroom column is ordered any results that have the same number of bathrooms are then sorted secondarily by some other column, but not bedrooms. When the bedrooms were sorted in order those for which the numbers were tied...
  10. huzza

    closing forms - easy one.

    Hi sC, open form 1 in design view and get properties on it then goto the event tab. Click in the on close event then click on the ... button at the end. Choose code builder and paste this line in between the Private sub and end sub lines. DoCmd.Close acForm, "form2", acSavePrompt All...
  11. huzza

    MultiUser Lockup

    Hi Monica, it might be worth checking the user permissions on that database. If you go into Tools, Security, User and Group Permissions... For each user and group check their permission for the database object (select database from right at the top of the dropdown list) has open exclusive...
  12. huzza

    Data Populating Table but Not Saving On Form

    Hi, are the controls on form 2 bound to the table? do you have any code that runs as you exit the form to save the data or is it done automatically? If it is then it could be that it is taking you setting the value in the CustomerID field as an indication that you want to add a new record. What...
  13. huzza

    Autolaunch of macro...

    Hi Terry, it may be worth trying it with all the warnings on to make sure it doesn't give some message that may explain why it would fail on the second run through. Also what is the exact message it gives when it can't connect (is it that all time favorite ODBC call failed)? Does the table...
  14. huzza

    Aggregate Feature that works with strings

    Hi, The only thing I can suggest is if all the activities have the same number of subactivities then you could use columns in your report. If you set the number of columns equal to the number of subactivities+1 and group by the activity. Have the activity 1, activity 2 etc in the group header...
  15. huzza

    Automatically Connecting to Oracle database in code...

    Hi Terry, I not sure what code you want it depends if you want to open an ODBC database or link to it. However you can get most of these details from the access help. If I read what you're saying correctly then you want to know what connection string to use. The easiest way to find this out is...
  16. huzza

    How to disable Menu bar on start up

    Hi Kelvin, unfortunately I don't think there is any way around it as what is effectively happening is access loads, then your mde loads. This means you always see the access menu bar until your mde or mdb is loaded. Richard
  17. huzza

    Access project. How to resolve parameter, instead of prompt box

    Hi Jerry, where is the variable defined? Does it refer to a control on the form? What part of the data tab have you put the paramter under and can you say exactly what you've put there? Richard
  18. huzza

    Update code not linking form and table, WHY!!!

    That's strange! It still asks you to enter the parameters manually? oh well. If you want to change the orderby property on the form in code use the following: [code][forms]![SEND OUT FOR REPLATE].orderby = "fieldname"[code] obviously replace fieldname with the name of the field you...
  19. huzza

    How to clear search box after leaving the field?

    Hi, you could try putting the following in the on exit event of the combobox: Me.Combo0.SetFocus Me.Combo0.Text = "" You'll have to change combo0 with the name given to your combobox. Richard
  20. huzza

    Access, Oracle, and things that go bump in the middle of the night...

    Hi Terry, sorry about that last post as I said I'd not checked it out by then. I'm wondering if the example under the "errors collection" part of access help will be of any use as it shows looping through the errors to show them all. The other thing I've just thought of is where...

Part and Inventory Search

Back
Top