Conversion from Paradox to Access problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I converted a client's database by saving the database to dbase5 using
paradox. then i openned it in access and saved it as an mdb.

Now they tell me that some records are missing. I can't figure out why. any
thoughts?

Also, I recreated their forms so they can work. But, on one form, when they
open it up, it shows the records and they can make changes. This is not a
good thing. I would like to lock the ability to make changes to records on
this form unless they hit a key combination like CTRL+F9 which would unlock
the form and give them the ability to change a record. Is this possible? How
can I do it?

Finally, I created one form where they can add records, but it doesn't show
any records. Now they tell me that they need to be able to highlight the
record field, then search for a record and have it come up. It isnt doing
this. I compared all the settings between this form and a form that does
work. What do I need to do to make this work?

Thanks for any and all assistance.

Mike
 
Mike said:
I converted a client's database by saving the database to dbase5 using
paradox. then i openned it in access and saved it as an mdb.

Now they tell me that some records are missing. I can't figure out why. any
thoughts?

Also, I recreated their forms so they can work. But, on one form, when they
open it up, it shows the records and they can make changes. This is not a
good thing. I would like to lock the ability to make changes to records on
this form unless they hit a key combination like CTRL+F9 which would unlock
the form and give them the ability to change a record. Is this possible? How
can I do it?
Click to expand...
Set the forms AllowEdits property to No. I would suggest a command button
on the form rather than a key combination. Most key combinations already
have some meaning and may cause unexptected results. Ctl+F9 is Set Next
Statement in Debug. In the Click event of the command button:
Me.AllowEdits = True
Finally, I created one form where they can add records, but it doesn't show
any records. Now they tell me that they need to be able to highlight the
record field, then search for a record and have it come up. It isnt doing
this. I compared all the settings between this form and a form that does
work. What do I need to do to make this work?
Click to expand...
You can't do both with this form. It appears the Data Entry property of the
form is set to Yes. This means only new records can be added. You will
either have to use the technique above for changing the Data Entry property
if they want to look a record up or create another Edit form where they can
look up and edit existing records.
To be able to locate an existing record in the form's data source, I suggest
a combo box with a record source based on the key field you want to search
by. Since this key field should not be changed, I suggest putting the combo
box in the header section as a unbound contorl. Then when the user selects a
record with the combo box, you will need to locate and display the record.
Here is an example piece of code that should go in the combo box's After
Update event.

Private Sub cboMActivity_AfterUpdate()
Dim rst As Recordset
'Find the Master Activity Selected
Set rst = Me.RecordsetClone
rst.FindFirst "[MActivity] = '" & Me.cboMActivity & "'"
Me.Bookmark = rst.Bookmark
rst.Close
Set rst = Nothing
Me.txtDescription.SetFocus

End Sub

And one last question for you. What percentage of your billing rate do I
get :)
 
Back
Top