Recent content by StuartG

Thanks Arnel. Will I need to create two separate tables or can I add the info to an existing table in our DB?

Hi all, I have been tasked with implementing a new field into our DB but not sure how to do it. Hopefully I can explain my requirement here. If the user selects "Biopharma" I only want them to see the results listed in the "Market Sub-Segment and so on. Market Market Sub-Segment...

Morning all. I currently have two departmental databases and I am currently working with our local IT department to get the DBs into SQL. The current setup is users have the FE on their Desktops linked to the BE through a network drive. Would it make sense to keep the two Databases separate...

Hi all, Thank you for the continued support but I've another issue. I have a main menu which has some graphs on it, see below: Unfortunately select users are reporting to me that they keep getting the following error message. Could the graph's refreshing at the default interval be...

Thanks Arnel that seems to have cracked it. I guess that will show each QTR through this year and then revert to QTR 1 next year?

Hi Minty, thanks for the reply. I did that on the order booked column as i learnt that users want to see it by the date the order was booked. I copied as you had done.

Hi all, I have created some Graphs based on a query but the results are not reporting my requirements. Issue Below is the query I only wanted it to include all orders apart from orders not yet booked. Graph output No records showing Desired Effect. I would like the graph to show only...

Excellent, this worked perfectly :) Thanks Minty!

I clicked the "Save comment" and it does the spell check and then comes up with the error message, it is not alerting the user they have not completed the "OrderProcesser" field just throws up the error. could it be that the If Len code is in the wrong place?

It does not seem to like the first line? I've provided the full line of code for reference. Private Sub cmdSave_Click() Dim strSql As String If Nz(Me.Comments, "") = "" Then MsgBox "You have not entered a comment", vbCritical, "Nothing to save"...

Thank you Minty. I've done this and it worked :) Once last question.. If i wanted the form to check whether the OrderProcesser field had been completed prior to saving how would I build this into the code. I'd want it to read. "Please complete OrderProcessor before saving" I've used inbuilt...

I've updated the line, but i now get a Private Sub cmdSave_Click() If Nz(Me.Comments, "") = "" Then MsgBox "You have not entered a comment", vbCritical, "Nothing to save" Me.Comments.SetFocus Exit Sub Else Call SpellChecker(Me.Comments) End If ' append new comment to...

Thanks for the reply. How should I write it though, should i just slot it into values. Private Sub cmdSave_Click() If Nz(Me.Comments, "") = "" Then MsgBox "You have not entered a comment", vbCritical, "Nothing to save" Me.Comments.SetFocus Exit Sub Else Call...

Hi all, A form was designed for me by a member of our Forum and i've been requested to add a column but the results are not showing and i cannot work out why and hope someone could help. The issue is the OrderProcessor is not showing in the memo log box when the user saves the comment. When a...

Thanks as always DBguy, most helpful :)