Search results

I took a look and it looks interesting. They have a feature for importing an Access DB on their structure, but I have yet to better understand exactly what I could do with a free account ... I was also wondering if there was any Android app for DB management to which I could export/import my...

Yes I looked into it, but it's rather expensive ... I am doing this for myself, not for a corporate, I was looking for a free or almost free solution ...

Sorry for bothering again with this issue. I've been looking everywhere on the web but found no viable solution. My minimal target is being able to just view my data online, e.g., via browser on the phone, no need to edit/delete/insert from the web view. I could also assume to create a view in...

Yes, it could be a temporary solution just to try, but is not really what I was looking for ... I don't have a real server and this would mean keeping my laptop always on even when I'm not at home, that is not feasible for me

I will give it a look, thanks!

Rdp means anyway having Access running open on my laptop and connecting to my laptop from my cell ... I never did it, I don't know if it is manageable from the tiny display of a mobile device, plus I should always have my laptop turned on ...

Sorry for taking so long to reply. My database is made up of a main table containing about 7000 records, plus some accessory tables containing from a dozen to a few hundreds records. In all, the database file is no larger than 7 MB

Correct! I would prefer to be able to move the data online somewhere, but using what? MySQL? I could accept having my main database on my laptop and then periodically syncing it online ... but how? And how about accessing data in a safe way, with a minimal form for data selection?

Hi everyone. I'm going to make some silly questions, I know, please bear with me. I have an Access database that I developed through the years to keep track of my collections. I am the only user, no need for concurrent users at any time. I developed nice and useful forms and the application...

HEY IT WORKS !!! GREAT !!!! And I didn't have to change the column name either, it was actually C :p THANKS!!!! :D Alex

Sounds great thanks, but it gives me a syntax error in VB ... what's wrong btw? :( (I copy-pasted your code as is)

Thanks thanks to both to take care of my problem!:o I think I didn't explain it thouroughly. Actually, I don't manipulate excel cell data from VB code. From VB code in Access I just throw inside an excel sheet what I extract from an SQL query on my DB. That is, I do not work on excel cells one...

Oh no problem :) Well, I put the data into excel from an access query that is run from inside VB code in a form. The data inside excel sheet goes right. Problem is that when you open the sheet, you have to double click INTO each cell containing the URL and hit ENTER in order to "activate" the...

Hey thanks for the suggestion. But, where would you use this method? Here's a snippet of my code that generates the excel sheet: 'access recordset for data to be copied Dim rs1, rs2 As DAO.Recordset 'create excel application object Set xlapp = New Excel.Application 'open the workbook Set wb =...

Mmmm ... interesting! But where would you use it? In the VB code that generates the xls sheet? Here's a snippet of that code: 'access recordset for data to be copied Dim rs1 As DAO.Recordset 'create excel application object Set xlapp = New Excel.Application 'open the workbook Set wb =...

Hi everyone! I hope this is the right place where to post this. My problem is this: I have a piece of VB code in my Access application that creates an Excel sheet from the results of a query on the database. One of the fields in the query contains an URL. What I'd want to accomplish would be to...

More ... I posted this question because if I check the "Run As Administrator" box on the msaccess.exe executable file, then each time I double click an mdb file to open it, it opens but I also get a warning popup telling me that Access was unable to open file blablabla.mdb ... If I launch Access...

Thank you for your reply. Actually, I tried unchecking the "Run Ad Administrator" on the executable file and it opens smoothly, while I still can execute any VBA code and also shelling out .... I am the only configured user on my computer and I have an administrator profile.

Hi everyone! I am currently using Access 2003 on Vista and I read somewhere in the forum that you have to configure the executable msaccess.exe tu run as administrator on Vista for it to properly work. Could someone kindly explain me why this has to be done and what happens otherwise, i.e., what...

Hi everyone! I am currently using Access 2003 on Vista and I read somewhere in the forum that you have to configure the executable msaccess.exe tu run as administrator on Vista for it to properly work. Could someone kindly explain me why this has to be done and what happens otherwise, i.e., what...