Recent content by whatisahandle

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 Jeff, Thanks for your answer on this, it was quite helpful. However I am wondering how to allow the user to cancel his operation if he decides no to go ahead: when I click the cancel button, the beforeUpdate event gets called first and I am stuck in a loop. Do you have any advice on...

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

I found the answer. Here is why it does not work: 1- Access is expecting a primary key id in order to delete a specific record. 2- If the parameters have the same names as the table fields Access gets confuses them, and the query returns all the rows (every field beeing equal to itself ...)

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

So is there any way to write to the application log in VBA ? Chris

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

Dear bobbster2000, Thanks for wanting to help, but please read the post before answering: what you suggest is exactly what I have already tried as I said in the post. 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...

Yes, the fields are all nullable, except the primary key which is an identity field.