Recent content by SyafiqIzzat

It still doesn't work. Anyway, I already opened the link yesterday when I search for ways to import data from Excel. What it does actually? I added new data in the Import file then I moved to Access and click the button "Import New Arrival Report" but why the data new data didn't appear?

So I have to replace the filename to my excel's path directory?

oh really? is it possible to change the type

I'm sure it is located in the root directory, as you said I might place it at subdirectory, I copy and paste the file there and change the path of the VBA code. Still, the result is still the same.

Greetings, Can someone justify what's wrong with my code below. DoCmd.TransferSpreadsheet acImport, 8, "Info", "C:\Test1.xls", True, "A1:E60" It said Microsoft Access db engine could not find the object "C:\Test1.xls" I already added reference to Microsoft Excel Object Library but still it...

I think I have found the solution to my problem. SELECT name, price, warranty_available, exclusive_offer FROM Products UNION ALL SELECT name, price, guarantee_available, exclusive_offer FROM Services; UNION ALL works perfectly in my case as I want to combine the fields into one by different...

Thank you for the reply but I think you got my question wrong. Actually it is not that I want to combine eg. First Name & Last Name in one field. Referring to example in my first post, I have two tables with same field names. Let say both tables have fields of Name and Product. In field of...

Well, you got point there. It is actually because of supervisor. I am an intern student and he wants me to come out with a project whereby he wants the user to insert data in Excel and the other processes would take part in Access. I try to convince him to use Access fully but somehow he wants...

If I need to update 10 tables, so I have to drop 10 tables and go on with the import wizard like 10 times? :confused: I prefer to have a button in Excel whereby after you update the table and click the button, it would be added in Access automatically. I want it to be so and I know it is...

Because there are many sheets in the Excel and whenever I update the data, it needs to be done by using the Import Wizard. I want to automate this part. I've tried linking the tables, it is not the best option since in Access the linked table's design can't be modified. I will need to select...

Good Day, I have difficulty in doing my database project. I have an excel workbook where users enter all the data in the cells. Later, from Access I need to import all the data that I have filled earlier in Excel. I know we would need to use Import wizard. It is tedious to do so moreover if...

Hello all, I wanna ask about SQL codes on how to join 2 fields from 2 different tables in Access into 1 new field in new table proposedly. It is not that I want to combine those two fields into 1 new combined field like this. (many turned up giving this solution) First Field (First Name)...

I tried the syntax but still nothing change. I don't know what's wrong but the column is not hidden.

Thanks for the quick reply but somehow the code doesn't work right. Sometimes, it works and sometimes it didn't. My idea is actually to have a check box; when it is checked, then this field will be hide/unhide. Is it possible?

I have created a split form in Access 2007; I have added a number of fields to this form. Is there a way in VBA to hide or show selected fields (columns) in the datasheet? I deperately need help. TIA :)