Recent content by associates

Thank you for your reply. Sorry that I forgot to mention that I am on a different form somewhere else but trying to get into a subform within another form. I wonder if this is possible. Thank you

Hi, I was wondering if I could get some help with Access form. What I was trying to do is to disable a control on a subform but with no success. So the VBA code I use is [Forms]![BookOrder]![myBook Order Details].Form!status.Enabled = False where: "myBook Order Details" as a subform resides...

Thank you for your reply. Just wanna tell you that it works like a charm now. Thanks a lot for your assistance. Good on you

Hi, I was wondering if I could get some assistance with my Access 2010 report query. How do I hide a text box control when the value is NULL in the Access report? What happens now is I got empty spaces showing in the report when there are no values. Any help would be greatly appreciated...

Hi, I am creating a database for recording meeting minutes using Access 2003. It has functionality such as adding, editing and deleting minutes records. The challenge I am facing here is say that we have added a new meeting minute no. 1 to the database for project 'A'. The challenge is whether...

Hi Modest, I was trying to retrieve all entries from my LDAP server through Access 03 and bumped into the thread you posted a while ago. I personally found your codes here are very helpful for me as it helps me find a way to connect to the machine where LDAP server resides. Anyway, I run into...

Hi, I figured it out by using the autoform Datasheet view. However, i have another question to ask. how do i control what fields to be displayed in the subform? I mean i saw a database where it has subform with almost all the fields in the table but when you do form view, you can only see three...

Hi, I was wondering if anyone might be able to help me here. I have a form and would like to add a subform to it. The problem is i couldn't get the subform to show in the datasheet view. Everytime i view the form, the subform actually shows in the form view. Sorry for asking this silly...

Hi, I have a problem when updating the date in the table using sql in Access 03. When the current date is 2nd of Feb, the problem seems to arise. I don't have any problems if the day is greater than 12. It seems that when the day is less than 12, it gets confused as to whether it's a month or a...

Hi, I need help with the following question. I got the following error when loading up a form: IIf(Not IsNull([SubJobName]) Or [SubJobName]<>"",[SubJobName],[JobName]) AS Expr1, [SubJobs].Status Can you have IIF statement in the query expression? because it said "Syntax error in string in...

Hi, I was wondering if i could get some help here. In the startup under tools option in the menu in Access 2003., is there any way of coding it so it would display windows database, allows display status bar and other settings there? Currently, i have unchecked pretty much everything except...

Thank you MStef for your reply. That would work but i would like to use the help file (by pressing F1 button to bring up help file). I have found the link that shows how http://support.microsoft.com/kb/242433/EN-US/ Everything works but the only problem is that the image doesn't appear. I...

Hi, I was wondering if anyone might be able to help me here. I would like to create a help file for the Access database we created for our client. I have a user manual document saved in RTF. What i would like the users to be able to press F1 button to retrieve the user manual document. I have...

Hi, I was wondering if anyone might be able to help me out with the following problem i have. In the Access report, i have a textbox whose control source has the following value in it. ="Student ID: " & Forms.EditStudForm.TB_studID & " Student Name: " & Forms.EditStudForm.TB_FirstName & "...

Hi, I have a report that has a sub-report in it. I was wondering if it's possible to do the following. when one of the fields in the sub-report has no value or data, i would like that field to show "None". If there are values or data, then shows the data otherwise just "None". How do i do...