Search results

Hi Mihail! It is not a problem of locking the records - which I solved allready - it is the problem of seeing ALL records on this form.

Hello! I have a problem with an Access 2010 accdb connected to SQL-server 2008 tables. There are 3 users entering data in a certain form. Whenever a new record is added, the recordcounter in the navigation bar does not show the actual number of records and a new record of another user cannot...

Meanwhile, and by chance, I found the solution by myself. So, for those who are interested in: With wdDoc .Bookmarks("Signature").Range.InlineShapes.AddPict ure "mysignature.png" 'then you have to convert from inlineshape to shape .InlineShapes(1).ConvertToShape ' (1) stands for the first...

Hi! I send a picture (transparent png) from access 2010 to a word bookmark and would like to place it overlapping the text. With wdDoc .Bookmarks("Signature").Range.InlineShapes.AddPicture "mysignature.png" .Bookmarks("Signature").Range.InlineShapes.ShapeRange.WrapFormat.AllowOverlap = True...

I solved the problem by myself: creating a public function, adding Application.SetOption "Confirm Action Queries", 0 Application.SetOption "Confirm Document Deletions", 0 Application.SetOption "Confirm Record Changes", 0 into it, and calling this function in the Autoexec! It works. Why it...

Hi! In a startup-form I have following options to avoid annoying system messages in an ACCESS 2010 RUNTIME!! (.accdr) Application.SetOption "Confirm Action Queries", 0 Application.SetOption "Confirm Document Deletions", 0 Application.SetOption "Confirm Record Changes", 0 But they do not...

After some days without reading this code I found the solution by myself. Well, I did not find the reason why the codes skips out of the loop, but i found the solution why the collection did not its work: I forgot to add the current doc to the collection when looping throught the view!

Hi All! I have a problem with Lotus Notes which I cannot solve for a long time although searching and serching a lot in the web. I receive mails through LN and loop through a certain folder, reading DeliveredDate, Body, Subject and writing those items into an Access-table. This works fine...

Hi CJ! YES I did !! Please have a look 2 postings before!! But I missed a certain button for Thanks! Maybe it was on another Forum with the button... Again, YOUR posting was MY solution! Michael

Hi CoffeGuru! That does not work, as the FirstTimeFrom is not mandatory the earliest TimeFrom! That was my Problem. The only solution seems to be the one from CJ. Michael

Hi CJ! Thanks a lot, it worked!! BR Michael:D

Hi CJ, Thanks your reply , I will try it tommorow. Seems to be a "subsubsubquery", but looks good. Thanks Michael

Hi Brian, Yes it is. As I wrote, the assignment to a team is not chronological on the timefrom. It may happen, that you define a timefrom 16:00 until 19:00 at team 5 and later the assigner give this employee another duty from 13:30 to 16:00 at team 7. This record will have a higher ID but...

Hi! I have following problem, which I cannot solve. My hopes are on you specialists. I have a table with assignments if employees to teams. PositionsID(autowert),EmployeeID, timefrom, timeto, TeamNo 3, 123, 13:30, 16:45, 4 4, 123, 17:00, 19:00, 7 5, 432, 17:00, 20:00, 8 6, 987, 17:00...

Thanks for the replies, I get my code number from DLast ...+1 and it works. Regards Michael

Hi! Access 2010 frontend, SQL-Server 2008 R2 backend During filling a form, I generate a code which should include the ID of this record. But the ID is not available before update of the form. If I save the record before all fields mandatory are filled, i get an error of course. How can I...

Hi JHB, Thanks a lot for your fast reply. I will test it until thuesday with my database and reply then. Just had an overview on your code. Why do you delete the tmp needed tbls and then create them again and not just delete the records in those tbls? Is there any special idea behind? Thanks...

Hi JHB, Thanks a lot for your fast reply. I will test it until thuesday with my database and reply then. Just had an overview on your code. Why do you delete the tmp needed tbls and then create them again and not just delete the records in those tbls? Is there any special idea behind? Thanks...

Hi, I have a difficult problem to solve. Here is the description of the problem: A certain number of teams of employees, which per default have to include a variable number of female and male members per team and each team should be filled automatically from a table of employees showing name...

Hi! I migrated an A2010 accdb (the BE with tbls) into a SQL-Server 2008r2 DB, added timestamp-fields, indexes, etc. The Access-FE remained mostly unchanged. The main-form (frmEmployees) receives its data from a view form the server. This main-form contains 6 subforms with a parent/child...