Search results

I have a form and a two subforms within it. The subforms are the problem. I'm having a problem finding out why the field in the Reports table gets set to zero when a new Status report is added. The sub forms in question are called frmStatusReport and frmProject_sbfrmProjectStatus. The main...

I could use an example. Im pretty new to this. Thanks

I have a form that has a DELETE button on it. When it is pressed, the record is deleted which works fine. Now I would like to APPEND the record to a table "Archived Records" before it is deleted. In addition, I would like to include when the record was deleted with a time stamp. The table...

I'd be glad to email the form code so you can see what I am trying to do. It may be to big to post here. Thanks.

I'd be glad to email the DB to you if it would be easier to see what I have done.

Sorry to be so dense, just trying to learn. Could you explain further in more detail and provide an example. Thanks for your patience.

Sorry to be so dense, just learning this. So could you provide a working example? Thanks for your replies.

Here is what I came up with: I went into the Tab property of each form element at typed “Required” no quotes. I then entered the following in the Before_Update sub: Private Sub chkCompleted_BeforeUpdate(Cancel As Integer) If chkCompleted = False Then lblDateCompleted.Visible = False...

Thanks for the code, but there are 4 i do not want to test. Is there a work around that? Thanks

Will this list each field? Still a little confused.

I have a form I need to validate with the code below. While this may work it would be a lot easier on the user to be presented with a list of incomplete fields at time of either Cancel or Save rather than potentially having to answer multiple warning boxes in succession (I know that would...

Do you change the query to a make table query before the join or after?

OK thanks. I will give it a go.

Hi I am new here. This is probably an easy question but I have not been using access long and would appreciate some help. What I want to do is query two tables. The first table has fields INST_NBR and PRICE_LIST that I need to find a match on in another table with the exact same field names...