Search results

Wait, i see it at the top of the Detail section. Hmm. As the form itself doesn't fit into the screen without the need to scroll, i find that when i scroll half way down, with a textbox half visible, minimize the application, then restore it, the ghost is there when i start to scroll again. I...

When i change the special effect from Raised to Flat, i don't see any lines or dashes... Might this be an issue your end and not form related?

Personally, i'd have a completely Unbound form, and then badge the timestamp to the record on Save/Append. This way, you capture an accurate timestamp, as opposed to a timestamp of when the form was opened. Alternatively, close and re-open the form after each save is completed?

Can you upload an example? Zip it if necessary.

I named the module the same as the function, that was the problem, i wasn't aware of that fact! Will learn from my mistakes! I must be having a moment of blissful ignorance... enlighten me? ;)

Ah, didn't realise that. That's cracked it, thanks alot for your help!

Does your tab control have a border? if so, set it to transparent. Set all other borders to transparent too.

The function is definitely in it's own Module, and not in a form module. Please see the images attached to demonstrate this issue. Any further help would be greatly appreciated!

When i try to run the query, it returns a 'Undefined function in 'GetFrameValue' in expression' message. Have i missed a trick?

Good afternoon, hope Christmas and New Year went swimmingly for you all. I've got an unbound form which on select a Command button, appends the data into a table. This works fine. However, i've now added an unbound frame into my form, and i'm trying to append the selection in this frame, but...

Right click on the button, select 'Properties', select the 'Options' tab. You'll then see 'ControlTip Text', enter your desired message. Save the changes. Open the form in Form View, hover over the button without moving your mouse, and see the message. Does this meet your needs?

This would be useful to me actually, which event would you expect it to be placed in, vbaInet?

No problem, glad i could help!

Select the 'SetWarnings' option at the start of your Macro, set it to 'No' At the end of your macro, select the 'SetWarnings' option and set it to 'Yes' If SetWarnings is not there, select 'Show All Options' button in the main menu ribbon. Does this do what you need?

Easy as that, thank you very much! Perhaps should have done abit more digging before i posted... Apologies.

Hello all, I have created a purchase order system, with a Parent Form containing data from 'PHeads_tbl' and a subform containing data from 'PLines_tbl'. Financial information is held in PLines_tbl, and it has now been requested to have the Sum of all records in the Sub Form to be displayed on...

Thanks for the advice bparkinson. I've done abit more digging, and it seems that i can use the MERGE statement. I think i'll try and build my statement, then try to place it in a Store Procedure. If you have any suggestions or tips, then please feel free to chip in. Otherwise, thanks for...

Afternoon all. I've got an interesting one for you... I have a product table, which i want to update using either SQL query, store procedure, or the SSIS import routine. ProductTbl ProductCode XRef ABC ABC123 XYZ XYZ123 MNO MNO123 I have...

Or... Private Sub Frame177_AfterUpdate() If Me.delivery = "1" Then Frame184.SetFocus ElseIf Me.delivery = "2" Then Me.Frame184.Enabled = False End If End Sub

Try.. Private Sub Frame177_AfterUpdate() If Me!delivery = "1" Then Frame184.SetFocus ElseIf Me!delivery = "2" Then Me.Frame184.Enabled = False End If End Sub