Search results

I'll help out whilst plog is away. Where does Table1 come into play? I don't see it used in your query. If you were to use just Table2, then the SQL of the query would be: SELECT Table1ID FROM Table2 WHERE [Location] = "Home" OR [Location] = "Office" GROUP BY Table1ID; Or SELECT DISTINCT...

Let me jog your memory, how do you handle String in a SQL query? Have a think and then look at the SQL statement again.

Have you read through the links posted? I also explained how you would do it in my last post.

View > Immediate Window Or Ctrl + G Re-run your code with that line added to it and it will show the result in the immediate window.

Following my advice from before, have a look at the following link that discusses using a Totals Query: https://support.office.com/en-za/article/Sum-data-by-using-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a ... only include the field that you would like to get the max of, click the sigma...

So Sue, I've had a quick look at this and it seems that the only two ways of adding an image to a Word document is through the path to an image file on disk or pasting the image from the clipboard How is the image saved in Access? In an OLE field or it's embedded in an Image control? Have you...

Debug.Print SQL to the immediate window and you will spot the syntax error.

Ok, paste the entire Change event here with the suggested changes.

Oh! He'll get bored and come back someday, maybe as burrina or someone else. ;)

Looks like this is a purely Excel VBA question? You've actually posted in the Access VBA forum ;) I would use explicit references: Sheets("SheetName").Range("U" & inputRow).Value = Sheets("Data").Range("BL" & dataRow).Value Here's a tip (if you don't already know this): With Sheets("Data")...

Solved? What did you end up doing?

The fairly new Attachment datatype is supposed to be much better compressed than the old OLE datatype, and as a result reduces (not eliminates) the chance of bloating. Perhaps you can explain this to your boss and see what s/he says.

Good! Doing the manual process makes you appreciate how everything will eventually come together. I have some other advice related to managing the shortcuts which I'll mention much later. WorkField is not a valid environment string. An environment string would be something like TEMP. For...

I was pretty slow there jd :)

Your images didn't show up. Is the field in the table/query that is bound the form? If it is then, put the following code in the After Update event of the option frame: Me!FieldName = Me.NameOfTextboxThatDoesTheCalculation ... that's a rather long name ;) It seems you already know that it's...

Right! So how are the subforms filtered? I.e. are they linked to the parent form and is the user also allowed to apply a filter on them?

To debug your code, comment out the On Error GoTo line. But before you start writing code have you done the basic manual tests? I.e. creating a shortcut on the manager's machine that opens the form to the specific record?

I don't think that Format() will return a properly formatted date with such a string. Use the raw date value from the field and format your date as a US date: DoCmd.OpenForm "TreatmentsTB1", , , "DOV = " & Format(Forms!FormName!DateField, "\#mm\/dd\/yyyy\#") Or: DoCmd.OpenForm...

There's nothing better than opening the file in its host application. Is your employer also against this? What I mean is that you can still store the file in Access, but use the host application to open the file. There's an activex control called MS Office Spreadsheet X.0.

Within the frame of your first post, you'll see a drop down button and within that you should be able to find the mark as solved button.