Recent content by gemma-the-husky

No doubt you send a command to the eBay system requesting your orders between a certain date range, and they will send the data back in a JSON file, complying with the documented structure for orders, so you also need to study how to obtain the exact columns you need from JSON files. If the...

A quick Google found this https://developer.ebay.com/api-docs/static/ebay-rest-landing.html I've not looked, but I expect it will be technical and won't be easy for vba users.

@amorosik eBay surely won't make it hard for developers. They must expose their methods somewhere. You will need a username and login credentials though.

Basically the restive API exposes some methods. You call the message by sending a correctly formatted JSON string, and interpreting the JSON string that gets returned.

I've posted some stuff about interfacing access with a restive API. There isn't much information regarding using VBA.

I actually found it quite tricky to find and download, and to install 32bit on my new machine. It was tricky removing all the parts of 64bit office that were installed by default, and which prevented the installation of 32bit.

It's only very rarely that I use anything other than long for a discrete value.

@MattBaldry Personally, I would avoid trying to store a cumulative/running total in a table. I don't see the point especially as changing the sort order will change the running total. Can you not find a way to use the overall total of a (data)set to produce what you want?

Isn't it sufficient to count the records in each table? Why is the table size critical?

I haven't read the whole thread. I would tend to either rename a processed file, or move it to a different folder, or even both. Then you only have the new files to consider. In any event, I would still check for duplicate documents in any imported file, as it's quite possible you will receive...

Will you be able to re-use these class modules in other apps? If you need to budget for many companies, then I can understand perhaps. If it's only one company then I struggle to see the point. In fact, budgeting is one area where I found it easier to use excel. I had an excel template that...

It's not creating a new dbs though. It's taking an accdb, and trying to revert it to a mdb. It can't be easy even if there are no advanced features. Maybe you can't even copy and paste objects from an accdb firm on to a mdb blank form. No doubt you can copy and paste code though. I'm not sure...

You can create you own menus. Do you mean the switchboard. Just import an A2003 switchboard and switchboard items table. It still works fine. That's what I use. A modified version, but A2003 code. You don't want to insert objects into a database. Just link to the file and windows/ access will...

No. A2003 was mdb only. Mdb will still run on current versions. When you change an mdb to an accdb you get warnings, so I guess it's not trivial to reverse the process even if you don't use advanced constructs.

If you can find it, I actually think the best inventory database was a MS template I called Dharamsala Tea. I called It that because that was the first product. Just a brilliant example. The only thing I changed was to have stock movements inwards as positive and outwards as negative so you...