Corrupt field in table?

G

Guest

I have a table of vendor parts in a program that has worked for the past 5
months. I got a notice from my client that the vendors parts (PartNum) was
not working right anymore. I told them of the possible causes on why it
happened. But the big thing is, how do I fix it. This is what I've tried so
far. Importing the front-end db into a new one, Do a make table query on the
vendor parts to create a new table, changed the field name, copy the data
from the bad field into a new field. Did a C&R on the database. No luck with
any. The program runs fine on my machine. I copy my version to the client
machine and it quits working. Also we tried to uninstall the Access Runtime
in the Developer Extensions. It says that it uninstalled but Control Panel
says that it's still there. Am I missing something????
 
G

George Nicholson

Are you and your client running the same verison of Access? (Help>About)
Specifically, any chance your client was updated to SP3 (only recently
available) and you are not?
 
G

Guest

George,

I just updated my version of Access to SP3. And now my application is not
working either in the same way my client app is not working. This being said,
I'm pretty sure that SP3 killed my application. Do you agree? I won't be able
to reply until Monday as I'm leaving my office. Thx.

Craig
 
A

Allen Browne

There are some problem with SP3 for Office 2003.

The problem field in your table: it is a combo box?
If so, try removing anything you have in its Format property.

3 of the SP3 bugs are listed in the yellow popup box at the top of this
page:
http://allenbrowne.com/tips.html
 
G

Guest

Allen,

I have no formattting in my combobox. Just two fields PartID and PartDesc,
just showing the description and having the PartID as the bound column.

This is just killing my apps.
 
A

Allen Browne

What about the Format property of the field in the *table*?
That's where the problem lies.

If it is not that issue, you might try asking Access what's going on. With
the list/combo box showing nothing when it should, open the Immediate Window
(Ctrl+G) and ask question such as:
? Forms!Form1!Combo0
? Forms!Form1!Combo0.Column(0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help with combo box auto fill-in field in form written into table 4
Filling in fields to a partially complete record in a table using a form 0
Calculated Form Fields do not fill data into related table fields 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Adding Records to Multiple tables from One Form 1
Displaying from multiple recordsources 1
Choice in combo box determines other field 1
Create a web site link from a part link and a data field in access 2003 1

Top