Search results for query: *

Hi, When I try to open a specific access report in design view, Access gives me this error: "The instruction at "0x77fcb2b9" referenced memory at "0x8e552699". The memory could not be written." and then it just crashes. This happens only with this report. I...

Hi, I have a form in which the delete button calls the following line of code: DoCmd.RunCommand acCmdDeleteRecord this is to delete the current record. The problem is I get an Access built-in messagebox which asks me to confirm the deletion. If I answer no, I get this run time error...

Hi, I would like to do a validation on a field an prevent the user from leaving it if the validation is unsuccessful. To do this I do a setFocus on the current field in the Sub "txtPassword_Exit" event. But it does not work, the cursor goes to the next field anyway. What is the...

Hi Folks, I have this Query Definition: PARAMETERS [nom_gabarit] Text ( 255 ), [NoCompagnie] number; DELETE * FROM cat_gabarit WHERE nom_gabarit = [nom_gabarit] and NoCompagnie = [NoCompagnie]; The query deletes all records in the table, even when I run it in design mode. The table is in...

Hi Folks, I have this Query Definition: PARAMETERS [nom_gabarit] Text ( 255 ), [NoCompagnie] IEEEDouble; DELETE * FROM cat_gabarit WHERE nom_gabarit = [nom_gabarit] and NoCompagnie = [NoCompagnie]; The query deletes all records in the table, even when I run it in design mode and Access asks...

Hi, Is there a way to programaticaly set the page margins properties in an Access2000 report (The ones from the "page setup" menu) ? What I am trying to accomplish is to have mirror margins in a report so both sides of a paper page can be printed an bound together as a book. I know...

Hi, I have some ASP code which works fine on an SQL7 database but not on SQL2000. It looks like this: ' -------------------------------- Set cmdLoad = Server.CreateObject("ADODB.Command") cmdLoad.CommandText = "{? = call usr_GetCountProduitCatalogue(?,?)}&quot...

Hi, Could someone tell if its possible to use the App object in VBA ? I would like to log errors with App.LogEvent but the VBA compiler does recognize the App object. Is there another object that could be used instead ? Thanks, Chris

Hi, Could someone kindly show me the way to read the values from a multiselect listbox in Access ? The access help files are not too helpful on this ... Thanx Chris

Hi, I have a combo box in a form header and would like to give it a default value so it is not blank when I first open the form. In the combo properties there is a row source which works OK (i get a choice list), but no matter what I put in the "Defaut Value" property it does not...

Hi, I am trying to insert rows in a table with the SQL statement at the bottom. Because of the outer joins, some fields are null when no match is found. Because of this, Access keeps giving me a "Record as been deleted" message and no insert is done. However when there are no null...

Hi, I have installed access97 on an NT 4.0 Server. When I run my application in the dev environment it breaks on the ucase statement (it says "cant find project or library"). Help ! Chris

Hi, I have a master report calling on 4 sub-reports which contain images in the page header and footer. For some reason the images dont show-up when the sup-reports are called by the master, but only when I call lauch them individually by hand. Can someone help me ? Chris