Search results

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

Thank you Rich for your reply. Yes, but do you have the solution to my question? Thank you in advance

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

Thank you Rabbie, I tried the code but got the following error quoted : "This expression you entered as a query parameter produce this error: 'microsoft office access can't find the name 'Projects.PS_ID' you entered in the expression' " That's what makes me wonder too. It didn't like it...

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 BJS, I hope you still visit this forum or anyone might be able to help me. I have the same problem as BJS with the following error runtime error '2191' - you can't set the control source property in print preview or after printing has started. and tried to put his solution into code. I got...

Hi Moniker, No, I actually have the value "2008/9" set by typing into default value on the control's property sheet. Then, i decided to be able to modify or re-set the default value thru coding on the form. Thank you in advance

Hi Moniker, Thank you for your reply. Yes, that works and what you've written there is what i've got at the moment in my codes. It does change the default value of the combo-box. However, the value stays there as long as the database isn't closed or shut. As soon as the database is closed up...

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

Dennisk, Yes, it works now. it didn't work because the form was closed. I suppose i have to put the code in the if condition to check whether the form is open or not. Thank you for your help

Thank you Dennisk for your help. Yes, it works now. But how do i make it changed permanently unless someone comes along and set the default value to be some other years. What i mean is that at the moment, the Year combo-box shows "2008/9" because that year is written in the default value field...

Hi again, looks like it hasn't been my day. I have another issue again and am confused why it doesn't work. I was trying again to set a button visible to false on another form. Here is the code. Private Sub CM_PDFConverterOFF_Click()...

Hi, I was wondering if anyone might be able to help me here. I was trying to set a defaultvalue for the combobox on another form. It works but shows a different value from what i want it to be. Private Sub CM_SetDefaultYear_Click() [Forms]![CHW_Startup]!CB_Year.DefaultValue = "2010/11"...

Hi, I was wondering if anyone might be able to help me here. Today, i was trying to implement some codes i found on the internet that allows me to turn the Access report to PDF. Here is the site: http://www.mvps.org/access/reports/rpt0011.htm However, it didn't work for me. I don't know if the...

Hi, I was wondering if anyone might be able to help me here. Today, i was trying to implement some codes i found on the internet that allows me to turn the Access report to PDF. Here is the site: http://www.mvps.org/access/reports/rpt0011.htm However, it didn't work for me. I don't know if the...

Hi, I was wondering if i could get some help here. I got error message saying "user defined - typed not defined" and it's highlighting the first line that is WorkBase as Database. Here is my code. Dim WorkBase As Database Dim WorkRS1 As Recordset Dim rsNew As New ADODB.Recordset...

Hi again, Is it possible to sum up more than one field in SQL query For example Sum(Projects.[2008/9]) AS [SumOf2008/9], Sum(Projects.[2009/10]) AS [SumOf2009/10],... is it possible to do sum(Projects.[2008/9],Projects.[2009/10])? I tried this and it returns error. Maybe it's a cannot do...

Hi, I was wondering if anyone might be able to help me. I need help to solve this issue. i have a query that returns records. The query is as follows SELECT PSQuery.System_Name, PSQuery.Purpose, ProjectQuery.Project_Name, ProjectQuery.Completion_Date, [Framework Outline].Objective...