Search results

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

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

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

Hi, I wonder if i could get some help here with the SQL insert into table. I got Syntax Error when executing the following code strSQL = "INSERT INTO [Time Sheet] (SFirstName, SLastName, Department_No, Status, subject_taken)" strSQL = strSQL & " VALUES ('Mike','Fraser','01','FullTime',3)"...

Hi, I was wondering if i can get some help here. The aim here is moving data from excel to Access '03. At the moment, i'm having troubled in finding out a way to open a database and execute SQL - insert the data into the table. Set cn = New ADODB.Connection With cn .Provider =...

Hi, just wonder if anyone might be able to help me here. I have a report that displays a set of records containing years, values, and total as follows ProjectName Department 2006/7 2007/8 2008/9 RF transmitter Electronic 20 20 30 Banking...

Hi, wonder if anyone might be able to help me here. In the query, I have two tables, Projects and Plan Summaries. They both have one field in common which is of type number, "PS_ID" So in the query, i was trying to perform dlookup as follows DLookUp("[PN_Code]","[Plan...

Hi, I was wondering if i could get some help here. I'm getting the following error message when trying to open MDB Access file. Microsoft Access cannot open this file This file is located outside your intranet or an untrusted site. ... I did not get any problems like this before i upgraded my...

Hi again, I have a form that has a listbox showing records and other buttons. One of the buttons is labelled "Convert to PDF". What it does is instead of getting a report but the report you get is in PDF format. I've got the working codes here that does what i want it to. The problem here is...