Search results

Explorer is also a good idea however, what do you do if there are multiple users in it and you want to see all of them?

Dear All, In previous versions of Access I could easily see who is in a particular file by opening the lock file with Notepad However if I open a 2007 format lock file I can only see weird characters there instead of user IDs I checked an API called AppUser but it is outdated and does not work...

I tried the following expression in a new query: Endof1: nz([endof];DLookUp("[endof]";"[query2]";"[query1.dateof]=" & [query1.dateof]+1)) but got the following error message: Syntax error in number in query expression query1.date=2010.09.02 Shouldn't dlookup work to get the next record's...

Thank you! I managed to accomplish this in the meantime However it turned out that instead of this it would be better to see how many hours passed between two dates I have successfully created queries to display the dates and also the differences (please see screenshot) But unfortunately I...

Could you please be more specific? What fields shall I join and how can I do that for the previous day? Many thanks in advance

Thank you Avelino, that works really fine!!

Dear All, I have a table that has a field that may contain null values In some cases it may happen that there are 2 null values one after another (pls see screenshot attached) How could I somehow indicate when there are 2 null values one after another? (eg put an X in a new field or something...

Dear All, In Trust Center settings there is an option group where user can enable/disable macros (there are like 4 options) My question would be: how can I toggle these options through VBA? (so without going to Trust Center and enabling them manually) Many thanks in advance

Dear All, I have a table that is displayed and modified through a form. One of my fields contains numeric values but as some of them begin with 0 I have set the field to Text format How can I make the form display this field with digit grouping? (eg: 011111111 => 011 111 111) Or other...

Dear All, I have a table that is displayed and modified through a form One of my fields contains numeric values but as some of them begin with 0 I converted the field to Text data format Now my question is: How can I set the form to display the values of this field with digit grouping? (like...

I get #Error values in the field...any suggestions please? Thank you

What other criterion shall I use? Thank you in advance!

Dear All, I have an aggregate query that displays certain fields of a table I would like to display the values of the previous record of one of the fields I have used this formula: Expr1: DLookUp("[creditlimitcp]";"[tbl_annualdata]";"[yeardata] = " & [yeardata]-1) but it only works for one...

Dear All, I have a simple problem but I was not able to solve it yet: I have a table the content of which is displayed by a form. I have an aggregate query that has 2 output fields. (both fields exist in the table as well) Upon opening the form I would like the query to filter the data the...

Dear All, I have a db that contains several forms. Each form has a print button, when clicked the form gets printed with the current record. I would like to have a new button that if I press, certain forms get printed to one single file. (pdf or xps) So literally the forms' print 'previews'...

It works perfectly! Thank you very much!!

Hello! Of course, here you are: Dim olapp As Object Dim olns As Object Dim olfolder As Object Dim olitem As Object Dim olattach As Object Set olapp = CreateObject("Outlook.Application") Set olns = olapp.GetNamespace("MAPI") Set olfolder =...

Hi, Yes, but unfortunately if I add this line I get an error message that Object is required Any ideas please? Thank you!

Dear All, When sending emails through Outlook in Access I would like to somehow enable delivery receipt Could you please help me with the code? (I would just need that specific line) Many thanks in advance! :)

Dear All, I have a database that contains data for all the users (data like salary, etc) The users are maintained in Active directory (and also in Microsoft Outlook 2007) I would like to somehow achieve that if a user opens the database he/she can only see his/her data (so basically his/her...