Search results

Thank you David! That does exactly what I wanted!!! Simon B.

but that would be a pass-through query, which is executed on the back-end... not executed by Access...

well... I have no experience with multi-valued fields in Access... but from my experience with other DBMS I wouldn't touch it with a ten foot pole.... I hope someone else can help...

damn jdraw... you're too fast...

Should be like this: SELECT tbl_clients.[Client Name], tbl_client_day.clientID FROM tbl_clients INNER JOIN tbl_client_day ON tbl_clients.clientID = tbl_client_day.clientID WHERE tbl_clients.[Client Name] NOT IN (SELECT [Client Name] FROM tbl_prog_day) ORDER BY tbl_clients.[Client Name]; if...

Hi, MINUS is not supported in Access. You'll have to use a NOT IN or a 'frustrated join' to replicate it... If you post your query we could possible help you out. Simon B.

Hi, My app is split into FE/BE. BE is password protected. FE is not, relies on Windows login for rights. Password to BE is "stored" in FE's table connection strings. Importing a table from FE then gives out the password to BE. Is there a way to prevent the tables (and links) from the FE from...

Hi Garry, That does exactly what I wanted!!! Thanks a lot!! Simon B.

I think jdraw has got it... your data is not saved until you change record... so you are still querying the same data, no matter what is in your textbox...

Hi, Did you make sure that the AfterUpdate event is really defined for intAmount? It happenned to me once that I had it in code but not in the properties in design mode... You could also insert a breakpoint to make see if it is executed... Simon B.

Hi Wayne, No, I don't NEED this.... It's quite complex for my "curiosity of who use the shift-key". And it would not work since the shift-key is disabled. I was hoping for something in the like of : Application.ShiftKeyWasUsedOnOpen = True :) Thank you anyways! Simon B.

Hi, Is there a way to know if the user was pressing the shift key when opening the DB? I know how to disable it, I just want to know if a smart *ss tried to open it with the shift key.... Thanks, Simon B.

Hi, Here is one solution. Add this code to a module: Public Function fMax(item1 As Variant, item2 As Variant) As Variant ' Returns the highest of the 2 items If item1 > item2 Then fMax = item1 Else fMax = item2 End If End Function Then use it like...

Here is the Outlook fix if anyone is interested: http://http://support.microsoft.com/kb/287816/en-us Simon B.

Found the problem.... When opening the received message in Outlook there is an option in the "Format" menu to cancel line feed... Not sure how it is called in English... Anyways, just need to un-check that... Now if anyone knows how to have that disabled by default it would help a lot!!!!

Hi, I'm having trouble with the body of my message using SendObject In the preview (before sending): Hi Mr .... Here is your ..... Item 1 Item 2 Item 3 ... Thank you .... When the email is received it looks like this: Hi Mr .... Here is your ..... Item 1 Item 2 Item 3 ...

Hi, 1) is easy to correct: Private Sub cmdPrintMapArea1_Click() On Error GoTo cmdPrintMapArea1_Click_Err DoCmd.RunCommand acCmdPrint Exit Sub cmdPrintMapArea1_Click_Err: If Err.Number = 2501 Then MsgBox "You cancelled.....", vbOKOnly Else ' If you want to...

Hi, Here is a suggestion: After you populate all your controls, you could take a "snapshot" of their values, like looping through each of them and keeping their values in a array. Then, when selecting a new record do that loop again and check if any value has changed. That would not...

Hi, What's the data type of PrimaryDataID in tblPrimaryData? Simon B.

Hi, As Kryst51 mentionned, you should check for zero length string. Changing your condition to this should cover both nulls and zero-length: IsNull([Parent2]) OR [Parent2] = '' (single quotes here) HTH Simon B.