Search results for query: *

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

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

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

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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

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...

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

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...