Search results

Hi, I have made a query to select multiple records (of a Yes/No type field in the table). All other fields of the query must be read only except this check box field. An easy solution given is to create a form (in Datasheet view) based on the query and choose NO for Enabled in property box. The...

The Problem is solved...someone had applied a filter in the row source query builder. I removed that filter and the problem is gone :)

Hi, One of my forms in the database is not showing some records in a particular field. Although those records are entered through the same form and are shown in the table, yet some of them are not visible in the form. This is happening only in a particular field, and in that field, some...

Someone has told that if I split the database and convert the front end to accde format in the older version of access 2007 instead of converting it in my computer, it will solve the problem.....Is it helpful? (I am asking before trying it, just to save the time if it is not helpful)...????

I have tried this also, but still it is giving Unrecognized data format error message....:(

I can open it from my PC, but cant open it from other PC....And precisely, this is the problem. :)

I have checked and here is the detail : My computer...Access 2007 (12.0.66.6.1000) SP3 MSO (12.0.6607.1000) Part of MS Office Professional Plus 2007. Other computer...Access 2007 (12.0.4518.1014) MSO (12.0.4518.1014) Part of MS Office Enterprise 2007. Any updates for this problemz???

Thanks for your reply :). Both computers have Access 2007 installed on them. Both have XP operating system. For the bits part, i am not aware of it. how to know the bit versions?

Hi, I have made a database, splitted it and then made the front end as accde. After that I copied both Front end & back end files in a shared folder. It is working fine as long as I am using it from my computer, but when I go to the other computer and try to open the front end, it gives the...

Actually, I just want to avoid a situation where the data entry operator could select the data from both comboboxes (cboPartMark & cboItemDescription) by mistake, in one record. The control sources of these two comboboxes are two fields in one table. And if one is filled, other must be empty in...

I put it in after update event and it worked but if we again uncheck the first control (which is a check box in this example), it acts as per the code and change the visibility.In this scenario, the data entry operator can input data in both cases by mistake .How to avoid this? I am writing the...

It is indeed helpful, but unfortunately I still dont know where I should put this code. I mean , should I put it as after update event or after click event?. I put it in after update event and it worked but if we again uncheck the first control (which is a check box in this example), it acts as...

It will be helpful if you include an example :)

Hi, I have combo box in a form. I want to enable (to highlight) some controls in the form after selecting any value from my combobox. For example, There are three values in the combobox. And : When I select value1, I want an unbound combobox1 to be enable (This combobox is synchronized with...

Thank you very much for mentioning the mistake :)

In the form Transactins, two comboboxes Categories and ItemNames are working fine. But other two (WorkOrders and Products) are not working same way.

Zip file is attached here..

Hi... The problem was solved and after that I added two more combo boxes following the same procedure in the same form, but this time it is not working and displaying following message: runtime arror '-2147352567(80020009): The value you entered is not valid for this field The first two...

Thanks...the problem is solved :)

The problem is that the data entry will be done on another computer, and I would frequently export that table to an excel sheet and copy that sheet to my computer (by usb, not networking) and it would be linked to my data base. In this case. kindly suggest, how to see the category name instead...