Search results

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...

Hi, Wonder if anyone might be able to help me out. In the detail section of Access report, there is three subreports laid out as follows subreport1 subreport2 subreport3 Depending on the certain criteria, subreport1 and subreport2 may appear in the report. subreport3 will always appear on the...

Hi, I have a report that has a sub-report (sub-report1) in it. Based on the value of a field say studID, i'd like to be able to hide/unhide the sub-reports. What i'd like to see in the report is StudID 1 subreport1 StudID 3 StudID 4 StudID 5 StudID 6 and so on Here is the code Private Sub...

Hi Boblarson, Thank you for your reply. No, i don't define lookup in that table. I tried it but could not see if it would help solve my problem. (sorry if i misunderstood you) For example table "company" CompanyID CompanyName CityID ... table "City" CityID CityName CityPopulation...

Hi, I have problem with pdf-ing a report that has record source coming from a query namely from the two tables joined based on the same of several fields (foreign keys). I have PDF coding that would turn Access report to PDF report. It has no problem when the report's record source is from one...

Hi, I have data of type "number" shown in the drop-down combo-box in a form. It has some codes in the event of "After Update". My problem is that i can't type in something like 13* in the combo-box in order to get anything starts from 13. It says "The value you entered isn't valid". The...