Search results

Thanks Mile. I somehow lost track of this my question. giedrius

Hello, I was just wondering if there are any differences in mde files created with Access 2000 and created with Access 2000 Developers Edition? I have read the articles about licencing and limitations of runtime application and before opening my pocket for Developers Edition I want to make...

I am not sure I know what translations symbols are? ggv

They read Numeric Decimal. ggv

Hello, I am using A2K table documenter to print the fields and their definitions, however for some fields (with type Numeric Decimal?) the documenter says that the field type is ": Delete Query", size 16. What could that mean? Thanks, giedrius

Yep, thanks. I suspected there might be no way to check this situation. Never found a corresponding property. But, as you suggested, there are other ways do achieve the result. Thanks. giedrius

Wayne, I actually did not reach the stage of deployment of my application yet, therefore all this is happening on a single machine. The references listed are always checked. After your hints I, though, recall that at some stage I tried to rename my own functions so that standard ones are...

Hello, I have set conditional format on datasheet subform so, that if a field is <>0, the background gets green. How can I check in a field or event on the Main form that conditional formatting has been applied and to which of the records on the subform? Thanks, giedrius

I use functions Replace and InStrRev, which are standard in A2K, extensively in my modules, however I had to "hard code" them explicitly as they are not accessible with the following references enabled: VB for Applications MS Access 9.0 Object Library OLE Automation MS ActiveX Data Objects 2.1...

This is great elegant solution. Thanks a lot. giedrius

I did not follow textbook advice and put customers and suppliers into one table1 with fields partnerId,partnerName,partnerAdr. I also have a products1 table with fields prodId,prodName,prodCustomerId,prodSupplierId. The last 2 fields refer to partnerId in table1. I want to run a query to find...

Hi, I seem to have a problem importing data from Excel sheet with MS Access 2000. For some reason Access would skip a few records without telling it (in fact it tells, but in a very strange way - "The contents of fields in 0 records were deleted, and 0 records were lost due to key violations")...

Hello, I came accross a strange problem. I need to use national characters in the form's buttons. When I set caption property in the property box, MS Access 2000 shows all the characters with no problem. However, when I try to change button's caption in VBA, national characters are displayed...

OK folks, thank you very much. I'll use a combination of both tips. Is there some point system to award for accepted answers? Please advise as I am new to this forum. giedrius

Could it be because I am invoking the form in record add mode with acFormAdd in another form: DoCmd.OpenForm "Supplier", , , , acFormAdd, acDialog, NewData Any ideas? Thanks, giedrius

I found the following code in MS Access help, however it produces run-time error 3426 "This action was cancelled by an associated object". Private Sub partnerKodas_AfterUpdate() Dim rst As DAO.Recordset Set rst = Me.Recordset rst.FindFirst "partnerKodas = " & Me!partnerKodas If...

I have a simple bound form where one of the controls is bound to a field with No duplicates property. When user enters a duplicate value in the control when entering a new record, MS Access 2000 gives a warning message. How do I avoid this warning message and check if value entered is unique...

What if I already am passing an argument? IS there a possibility to pass 2 or more arguments? giedrius

Hello, How could I check where from my form was called? I need to trap when the form is called from the switchboard or directly by double-clicking on it in the Forms window. thanks for any tips, giedrius

I have read a few posts regarding this problem, however it is still not clear for me what is the best solution. I created a form with a wizzard (Expedition style, with this yellowish background), then dragged it onto a blank two-tab form. It looks ok in design view, however when I run the...