Search results

Hello all, Thank you for your input. Using the information provided and the database isla posted i was able to get the OLE objects working using the bound OLE Object box. I had to use about 3 different queries to string everything together. :D I put the OLE object into the same table as my...

I tried searching for it too but every website wants a credit card. that's too bad, that looks to be exactly what i need. Would i use an bound object frame in the detail field of my continuous form? How do i link this to my table image?

I embedded them in the table for now because this is a split system with multiple users having a different drive map on their computers, i dont think path linking will work.

Hello, I have a form that allows multiple users to sign an agreement. combo box (cboyesno) choices are Undecided, Yes, No I have a continuous form that reviews all the open agreements where all parties have not selected Yes. These are open agreements. I would like to display a nice custom...

Please see attached. frmProjectManagement is the form that works correctly when opened alone but has a problem from my main form, under tab project management. When clicking the command buttons to filter.

bump........

That did it thanks.

Hello, I have 2 fields in a form. [Budget] and [RemainingBudget]. I would like to use conditional formatting so that when the remaining budget falls less then 10% of the remaining budget the text will turn yellow. How would i write this?

I'm using 3 command buttons that reference a combo box. Each one uses a macro using the apply where filter [ProjectStatus]=1 [ProjectStatus]=2 [ProjectStatus]=3

Hello, I have an unbound navigation form that houses a tabbed control. Within the tabbed control is a continuous form based on a query. I can filter this form just fine if i open it by itself, but if i open it from within the navigation form i get an error. Action or method is invalid...

Whoops. Just when i thought i triple checked everything. I guess it helps to have a fresh set of eyes look at it. Thanks for your help. :o

See the attached link the download the file. Please note that the table and form names are different then i previously stated. I simplified them for the forum post. http://s000.tinyupload.com/index.php?file_id=75662675278900075975 the project management section is what you should be looking at.

I do use a where clause on the open form statement in VBA if that makes a difference to filter the ID to match the ID.

All forms are directly from the table. No query is used. I have also double check all form properties to ensure Allow Deletions, Additions, Edits and filters are "Yes". Record locks are also "No". All fields are also enabled and not locked.

I'm having a problem with a form with multiple subforms. I have a main navigation form (frmHome) which has a tabbed control (tabCtl1). within the tabbed control is another form. (frmProjMan) this is a continuous form to display all projects. Control source is tblProjMan When a record is...

Well i ended up getting it by using a Dlookup on the table values. Private Sub Command68_Click() Refresh Dim StrResponse Dim StrComment Dim Response As Integer Response = MsgBox("Would you like to notify the MOC Initator of this response?", vbYesNo + vbQuestion, "Client Prompt") If...

Just to give you a run down from the start including an answer to your question. User 1 creates new record in formnewrecord. User 1 closes form. User 2 opens continuous form and selects the record above to open formReview User 2 selects and answer in combobox and leaves a comment in text box...

Ridders, i currently have this textbox using conditional formatting to enable/disable using the following expression [RDReview]=1 And [ProductionReview]=1 And [MaintenanceReview]=1 And [SafetyReview]=1 And [SiteManagerReview]=1 How would i combine this with the code you provided?

Regarding your previous message. There are no errors, the only problem i have is when entering the data into the form and then clicking and submitting the email, when the email is received the data i asked for in the VBA is not there. If i close the form and reopen the form and send the email...

Private Sub Command68_Click() Refresh Dim Response As Integer Response = MsgBox("Would you like to notify the MOC Initator of this response?", vbYesNo + vbQuestion, "Client Prompt") If Response = vbYes Then Refresh Dim strEmailAddress Dim StrSQL StrSQL = "SELECT * FROM qryMOC"...