Search results

I am setting up message boxes in selected fields on my database, triggered by the MouseDown event (right click), to provide user-friendly help to inexperienced users. (ControlTip text is too short for my purposes.) This works well - the message box appears - but when the user clicks OK and the...

However, this article may help solve your problem: https://msdn.microsoft.com/en-us/library/office/gg251104(v=office.14).aspx

It's a bit tricky. Your colleague is using the Front End from another location, and the error seems to be because the Front End can't locate the Back End (which is on your network). Presumably the database is shared, so it wouldn't make sense to copy the Back End to your colleague's computer...

Ridders is right - for example: If Dir([FilePath]) = vbNullString Then MsgBox "Filepath " & [FilePath] & " can't be found." Exit Sub End If

Hi again, In the SELECT section, you have to repeat the table name for each value, so: strSql = "INSERT INTO [Dispensing 2] ( [Drug name], [File ID],[Quantity],[Expiry Date], [Batch Number],[Replaced Quantity],[Availability], [User1] ) " & _ "SELECT [Dispensing 2].[Drug name], " & lngID & " AS...

It means that the vba is producing a folder path or file path that doesn't exist. For example, you would get this error if you were working on your office network, then took the database home and tried to run it there. It wouldn't be able to find the network path. From Wikipedia: Folder path...

I don't have experience of this, but looked it over and did some googling. In your travels, did you come across this link: https://msdn.microsoft.com/en-us/library/ee336038(v=office.12).aspx If not, it must be worth a read as it's Microsoft from the horse's mouth.

Since there is unlikely to be confusion between surname and event type, you wouldn't need to specify which was which. Just get them to input one parameter, or two parameters separated by commas. Then you can parse the resulting string into two variables (or one variable and an empty string)...

Minty is right, but you can at least add a bit of help, changing the parameter to: [Please enter Start Date (mm/dd/yyyy)] It's important the date ends up in the US format (mm/dd/yyyy) because you otherwise get ambiguous errors in SQL. If you allow entry a different way (e.g. dd/mm/yy) you need...

You have the Insert SQL statement: "INSERT INTO Table2 ( s1, s2 ) SELECT Table2.s1, " & lngID & " AS Expr1 " & _ "FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.s2 WHERE (((Table1.ID)=" & lngOldID & "));" For each field in the INSERT INTO statement, there are values in the SELECT...

Hi Frank, We're all new - most of my training was via Access VBA for Dummies! The first thing is there needs to be a way of identifying which is the default Recycling Facility in the (presumably) Recycling Facilities Table. This could be a boolean (yes/no) field, e.g. called Default Facility...

Glad it worked. Don't forget to mark the thread as Solved (in Thread Tools top of page)

I have updated the code from the database you provided and it is below - and I tested it - it works. I have added notes in capitals preceded by "***" to show where I have made changes. You needed the primary key value of the Original table1 record, because this provides the link to the S2...

3 weeks later I sort of cracked it - good enough for me anyway. I basically added an OR criteria expression to the combo row source query to include any record where the subform join field (Master / Child) is the same in the current subrecord. So now the combo box list includes all the...

Just a thought, but if you use Memo (aka Long Text) fields you can specify Rich Text format. Then when you enter the text it works just like Word - i.e. fonts can be set from the menu as you type. I would imagine you having a Paragraphs table and each record would be a pre-set paragraph which...

Glad it worked Frank. Please mark the post as SOLVED.

I think he had it right: i.e. how do we conclude whether, for example, 36 is a power of some number or not - yes it is the second power of 6 (6 X 6) - i.e. 6 squared. On the other hand 37 isn't a power of any whole number. The question is whether it has an exact root. I think that's what he...

Hi Prabha, I think you need to put together a function that first gets all the prime factors of the big number, then works out if there is a precise square root, cube root etc. For example, the number 676 has prime factors 2, 2, 13 and 13. In other words 676 = 2 X 2 X 13 X 13. So the square...

Hi Frank, Just to check I'm reading you correctly: All the activities you require are in the Subform; The text boxes are supposed to populate on selection from the Combo Box; You have code in the On Load event of the subform to select from the Combo Box; This selection doesn't populate the text...

I joined too late to have direct communication with David, but have looked at some of his posts and the very moving tributes above. The overall impression, more than his being knowledgeable and helpful, was that he was a kind man. I hope his family can draw comfort from reading these, at what...