B
BC-w2k3s
I have a standard, unbound form. It has around 30 fields of various types.
I created a simple Select Query.
"SELECT Forms!frmWorkOrders!txtWO_ID AS WO_ID,
Forms!frmWorkOrders!txtWorkOrder AS WorkOrder, ...etc"
The query was intended as a quickie aid for me to create a report off the
data input into the form. This is a single record. No fields or even combo
boxes/controls are bound to anything.
First, I Load the data into form. I then open the query. Data is displayed
correctly for the text fields. However, the Date and Checkbox fields are
blank. The integer fields come up fine. But, long Integers come up weird.
They come up as single character ...either boxes or upper characters like the
'yen' symbol or such.
And...here is where it gets weird again. If I go into Query Design, my only
option after that is to switch to SQL View. Everything else is grayed out.
Once I goto SQL, I then have the option of the Query Design again or the Data
View.
I tried decompiling. I tried starting a new mdb and importing. I even tried
repair/reinstall/remove&install (in that order) trying to get it work. The
other odd thing is that now, when I try to create a report, access freezes up
on me completely. Its all patched.
Is there a way to do a complete uninstall and clean out the registry and
start from scratch without having to reinstall the entire OS, too? When I
uninstalled and installed Office, it had preserved all of my settings. So, I
am curious if this might be where the issue is.
I created a simple Select Query.
"SELECT Forms!frmWorkOrders!txtWO_ID AS WO_ID,
Forms!frmWorkOrders!txtWorkOrder AS WorkOrder, ...etc"
The query was intended as a quickie aid for me to create a report off the
data input into the form. This is a single record. No fields or even combo
boxes/controls are bound to anything.
First, I Load the data into form. I then open the query. Data is displayed
correctly for the text fields. However, the Date and Checkbox fields are
blank. The integer fields come up fine. But, long Integers come up weird.
They come up as single character ...either boxes or upper characters like the
'yen' symbol or such.
And...here is where it gets weird again. If I go into Query Design, my only
option after that is to switch to SQL View. Everything else is grayed out.
Once I goto SQL, I then have the option of the Query Design again or the Data
View.
I tried decompiling. I tried starting a new mdb and importing. I even tried
repair/reinstall/remove&install (in that order) trying to get it work. The
other odd thing is that now, when I try to create a report, access freezes up
on me completely. Its all patched.
Is there a way to do a complete uninstall and clean out the registry and
start from scratch without having to reinstall the entire OS, too? When I
uninstalled and installed Office, it had preserved all of my settings. So, I
am curious if this might be where the issue is.