Search results

Hi I've been searching the forum and the web regarding my problem with my subreport repeating for every record in the database. I only want the one page I'm looking at. I have a patient DB that will run reports for the viewed person. It works fine but I've placed the subreports in the detail...

Hi I have a patient journal db. By law you have to be able to "sign out" the textboxes and checkboxes so they not can be edited. How do I lock the the fields? I've tried a code found on the forum locking specified field, but I have multiple fields and there will be a lot of hands on specifiing...

Hi I found this that I would like to use. I've been looking for a Event calendar for quite some time that looks like the calendar in outlook. But this doesn't work. Can't add apointments through form. Can anyone help me make this work or do you have another working "outlook like calendar" Mikael

Hi I found this that I would like to use. I've been looking for a Event calendar for quite some time that looks like the calendar in outlook. But this doesn't work. Can't add apointments through form. Can anyone help me make this work or do you have another working "outlook like calendar" Mikael

Hi I found this that I would like to use. I've been looking for a Event calendar for quite some time that looks like the calendar in outlook. But this doesn't work. Can't add apointments through form. Can anyone help me make this work or do you have another working "outlook like calendar" Mikael

Sorry guys/girls can't save it in an earlier version because it uses features in access 2007. Anyone with access 3007 that can give me a hand?

Hi Does anyone know how to filter by month in this? There is a filter for week. Thanks Mikael

Ok, I have multiple posts that I want to protect with this code Private Sub Form_Current() If IsNull(Me.Debut) Then Me.Debut.Locked = False Else Me.Debut.Locked = True End If End Sub How do I do THAT?

I tried it with a button, but then it locks it for editing with a new post as well

Thanks Bob Can you use the code with a button that says "sign" and it will aply this? Do I just create one and use this in the code builder? If IsNull(Me!YourFieldNameHere) Then AllowEdits = True Else AllowEdits = False End If

locking records (legal purpose) Hi I'm making a journal and will be able to lock records (legal purpose) when pushing a button. Just like signing. But I will be able to add a new record when treating the patient the next time. Thanks Mikael

Hi Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003? I have tried setup2go and it makes a fine .exe file. But I can't make the package with access runtime. Thanks Mikael

Hi again I did try the subform before I posted the question and that works fine. But the finished program will have a large picture, so that's why I wanted to open it with a button in it's own window. any suggestions?

Hi again Here is db attached for the error problem. If I want to add a knew post and then add posts to the form opened by the button it doesn't work. How can you solve this? Use the form searchaddress..... Thanks for all help

One question though If I enter a new post (name) and push the button to enter the form and want to enter some new info. It returns an error. Do I have to fill out the FK numbers by hand? To get it to work? Mikael

Thank you very much That's exactly what I wanted. I knew it had to do with relationship between the tables. I tried a lot of different ways, but it didn't work. I will study your example and try to understand it. thanks Mikael

Hi I've run in to some problems and I can't get it right in my head. I have a name search form and a form that I want to be able to access through a button (don't want to use subform). I want data to be connected between these to forms. Example: If I type "lar" in the "last name" field and...

Hi I have this Form with a searchoption and two subform displaying information about the person displayed. But I want two be able to choose a date for a person and it will display that dates topic only. (there will be more text in that field later on) But how do I do that? A combobox I guess...

anyone?! Please! Mikael

That worked like a charm! Didn't see it at first. Now I have one more question! Now that the subform is working I want to be able to filter on dates for each person. The best would be a combo box that remembers the persons dates for each visit thanks See attached DB