Search results

  1. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Thank you so much.
  2. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Little problem, the data went all the way to row 66 instead of row 6 in Excel can you please check the code again maybe I messed something up with the Excel formatting. Thanls
  3. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Thanks the error is gone and the data is exported to excel.
  4. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Attached is a Sample Database with similar codes, query and table.
  5. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Yes sir, I used the FrmFilter to filter the data in Query. The plan is to filter the data with the Reg, Prov, Mun, Brgy and Date and the Export to Excel button is also on the FrmFilter form.
  6. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    Thanks for the reply but the field names matched.
  7. P

    [Help]Error: 3061 = Too few Parameters. Expected 1

    A little background Im trying to Export a Query to Excel. One of the field in the query has a criteria that is use to filter the data in the query. Im pretty new to VBA that is why I have no idea how to solve this. Here is the code Im using. On Error GoTo SubError Dim xlApp As...
  8. P

    Importing to existing table

    Thank you for the reply. I got a Run-time error '3134' Syntax error in INSERT INTO statement Dim db As Dao.Database Set db = CurrentDb db.Execute "INSERT INTO Temp_DV " & _ "SELECT FROM Tbl_InvDV " & _ "IN C:\Users\DSWD\Desktop\Inventory of DV_28-01-2016" Set db = Nothing Is it possible to...
  9. P

    Importing to existing table

    Good day everyone. I need help on this matter. Im using this code to import a Table from a different Access database. DoCmd.SetWarnings False DoCmd.TransferDatabase acImport, "Microsoft Access", selectFile, acTable, "Tbl_InvDV_28-01-2016", "Temp_DV", False DoCmd.SetWarnings True Im sorry...
  10. P

    Detail Section in Report Keeps on Repeating

    As the title suggest the Detail Section on MS Access report keeps on repeating. Im quite new to Access so I have no idea whats going on and how to solve this. See attached for reference. Background on my report. -All the text boxes are unbound -I got the data using the Dsum function...
  11. P

    [Help]My font label keeps on changing

    Sorry for the late response and thanks for the reply. I kinda figure it out, Im not really sure how it happened. This is how I resolve it. 1. View the form in Design View 2. Open the Design Tab in the Form Design Tools 3. Click the Text box or Label Controls 4. On the property window change the...
  12. P

    [Help]My font label keeps on changing

    Now my report is doing the same thing. It keeps on changing into Trebuchet MS. Is there a default font setting somewhere, maybe I changed it without knowing or something.
  13. P

    [Help]My font label keeps on changing

    Im using 2010, maybe Ill just have to make it again. Maybe this is just a glitch or something. Thanks anyway.
  14. P

    [Help]My font label keeps on changing

    Thats the weird part it keeps on changing to Trebuchet MS every time i change the view and when I turn it back to Design View turns back to Calibri.
  15. P

    [HELP] Import Spreadsheet to Access Table

    Thank you that does it. I have some questions regarding the importing, but I think I should just create another thread for it. Thank you so much.
  16. P

    [Help]My font label keeps on changing

    I have this really weird problem and I dont know how to solve this. Im pretty new to Access and VBA so please bear with me on this and I apologize if this is a stupid thing to ask but I really have no idea how to solve this. As the thread title suggest my label's font keeps on changing. On the...
  17. P

    [HELP] Import Spreadsheet to Access Table

    Thank you Cronk its kinda working now. Regarding the database that Im working on. I kinda have a problem with the data types I hope you dont mind if ask. In the excel file there are several types of data most are numbers(Integers) and text I got those covered, I think but beside those are also...
  18. P

    [HELP] Import Spreadsheet to Access Table

    This is what the Immediate Window displays. Im really sorry guys as Ive said Im really new with this and have no idea about whats happening most of the time. INSERT INTO Tbl_FundsData([Reg], [Prov], [Mun], [Brgy], [NoSubProj], [SubProjTit], [FundSrc], [Modal], [Cycle], [RecDate], [SubProj]...
  19. P

    [HELP] Import Spreadsheet to Access Table

    I dont really get it but there is no generated sql, I did use the Debug.Print but it doesnt shows anything. I somehow fix the error but the WHERE NOT EXIST is still not working since its still copying duplicate records.
  20. P

    [HELP] Import Spreadsheet to Access Table

    CurrentDb.Execute ("INSERT INTO Tbl_FundsData([Reg], [Prov], [Mun], [Brgy], [NoSubProj], [SubProjTit], [FundSrc], " & _ "[Modal], [Cycle], [RecDate], [SubProj], [AppComGrants], [Rehab], [Taf], [LCCcashSPI], " & _ "[TotLCC], [TotProjCost], [GrantRel], [Trnch1], [Trnch2], [Trnch3]...
Top Bottom