Search results

Hi TanisAgain, Thank you for your reply. All right, i'm going to do it as instructed by the link you pointed out. Most of the databases we have there are created internally which means by us. So you can assume they are all pretty trusted people. :) Now, one more question is that assume that i...

Hi, I wonder if anyone here might be able to help me out here. I've been pondering this issue for so long and i was almost giving up. I've been getting this warning everytime i open up an Access file (.MDB) especially, when trying to open up a file that's sitting on another computers. i have a...

Hi, I was wondering if i could get some help here. I think this is to do with the security issue. I usually double-click to open or run an access file (for example student.mdb) that sits on the server with no problem. But this time, nothing happen when i did double-clicked on it from my laptop...

Hi, I wonder if i could get some help here. I was trying to clear up specific cells. Here is some of my code Worksheets("sheet1").Activate Worksheets("sheet1").Range("inputData").Activate I have defined a cell with a name called "inputData". Then, i used the offset thing. Now, i...

Thank you Peter for your reply. I tried your code but unfortunately, my Access 2003 didn't recognise the following line of code. Dim appXL As excel.Application Dim wk As excel.workbook I got error that says "user defined type not defined" Do i need to import any libraries? Also, i...

Hi, I was wondering if anyone might be able to help me here. I have a question. Is it possible to create new worksheet in Access using VBA code? What happen is that i have a form in Access that would export data from Access to Excel. I know that i could use the built-in feature provided in...

Thank you Brian and Shades for your reply. But i don't know how to apply it to my existing code. It's my mistake not to tell you in advance. Anyway, here is my code For i = 0 To (UBound(x)) c$ = Chr$(65 + i) + Trim(Str$(Count)) With...

Hi, I was wondering if i could get some help on some issues. I'll post two questions separately as they are different questions. First question is I don't know if this is possible in excel. I know that we can apply conditional formatting on a single cell. is it possible to do in a range of...

Hi I think i have got it working now. For some reason, it just doesn't like the star "*". But as soon as i replaced it with "%", it then works fine. Thank you very much for all your time.

Hi again, I don't know if i could get response ASAP as i have to get this to work. I know you guys are trying to do your best. It's just me that unable to get this query statement to produce some recordset. (frustrated) don't mind me :) anyway, i got error from this line of code as follows...

Thank you to you both, KeithG and Neileg. I tried to use openrecordset as you said but got compilation error. It says user-defined type not defined and it's pointing to "set rsNew1 as DAO.recordset" Here is my code Dim rsNew1 As DAO.Recordset Set rsNew1 =...

Thank you for your reply. I still can't get the query to work in the code. I have tested by putting the sql query statement in the queries and it produced result. Here is my code StrSQL = "SELECT [Plan Summaries].PN_ID, System.System_Name, [Plan Names].PS_Name, Projects.J_ID...

Hi, I was wondering if i could get some help here. I got problem while trying to perform sql query. I got an error message saying "No value given for one or more required parameters". I think i know what caused this but i just don't know how to get around this. The query I'm trying to...

Hi Jeff, Thank you for your reply. Sorry i could not find the button "unblock" under properties. There are two tabs - general and summary. And there is no button "unblock" under the general tab. But i'm not sure if this is to do with where the file sits on. The Access file(.mdb) resides on...

Thank you boblarson for your reply. Please find the attached jpg file - access.jpeg that contains a print-screen photo of the warning. No, I'm still getting that screen. This access application is not obtained from the internet. I have also adjusted the macro security from medium to low and...

Hi, i was wondering if anyone might be able to help me out here. I've been spending hours but to no avail. It seems to be a very trivial problem but i'm just out of luck. I've been getting this pop-up message everytime i try to open up an access application such as .mdb files. Open file -...

Hi, This is a weird one. I'm working on an Access application 2003. I have one report that has a textbox that has a control source as follows ="Filter: System " & [Forms].[qfProjects].[TB_System_Data] & " : Project Code " & [Forms].[qfProjects].[TB_Project_Code_Data] & " : Project Name " &...

Hi Stopher, Thank you for your reply. It works now. No, you're right. it's a clumsy of me for not being able to pay attention to that obvious missing link criteria in the openreport call. I must've been half asleep while doing that. It works well now. Thank you for pointing that out.

Hi, I was wondering if anyone might be able to help me here. I have two tables, staff_table and salary_table. Staff_table has the following fields, Staff_ID, Staff_FN, Staff_LN,... Salary_table has the following fields, Sal_ID, Staff_ID, Sal_Date, Pay_Amt,... In the salary form, i have a...

Hi, I was wondering if anyone would be able to help me here. I have a database created in Access .MDB. It operates allright on my machine. However, since this database is done for my client, i have a problem i need to ask for help. My client doesn't have microsoft office software installed...