Search results

Is there a rest API available? That might be a possible way. I checked your link, and that's what it is, but it's hard to find VBA code to do it. I'm sure I have posted some previously though. One issue is that to download a PDF, you collect a string of bytes. But the trouble I found and I...

Bear in mind that its most likely common for users to be placed in groups, and rights and privileges are often based on the group membership rather than the user. I'm not sure whether that applies to what you are trying to do, but it does simplify things if it can be done that way.

I don't understand this. A sales processing control system ought to start with an order, and end with an invoice. Preparing a despatch note is part of this process, surely.

The best starting book I found was by Alison Balter. Covered everything you might need, although at the time it was for A97/A2003. Those versions are perfectly adequate to develop great databases, although later versions included some new bells and whistles. It's really helpful to start with a...

If you aren't careful someone will draw the short straw and get more than his fair share of work, using an alphabetical formula like that. I expect there are a lot of names starting with B for instance.

I've done this sort of stuff before by letting users enter a string and splitting it into its substrings, then searching for matches in the product descriptions on the substrings. This was an effective alternative to multiple combo boxes. So you enter something like "8 black widget" to reduce...

If you can't find a fix you could tell your users not to preview the report first, or to rerun it without the preview.

Is there a report on print event that you can use to reset your internal counters. I understand the issue, but I can't recall how I fixed the same problem.

Thanks. Unignored now. I didn't know we could even ignore threads .

I keep seeing "ignored thread" for modules, on the home page. I imagine I must have accidentally set a thread as "ignore". How can I find the thread please and fix it?

In your city table, I would not store strings for the country. I would store a lookup ID to a country table. Ah. I can see it's a query on top, and you have that structure. I'm not used to tabbed displays.

100k records isn't that many. What issues are you having, Mike?

Surely one problem is that developers end up giving way stuff that's taken them a lot of hard work to develop. For example, it really was difficult to find and build parts of an application to manage interfacing with a Restive API instance in Access VBA, and process the JSON responses. It was...

I had some excel files that Access didn't like. They had been produced by SAP, I think. Do you know what system produces the files causing your problems. What file types are they? Can you get csvs instead?

Maybe there's something funny in the column headers for your version 20. Underscores, or something like that. Maybe it's the full stop/period in the file name causing confusion. In fact, can you have a period in a file name?

In general cleaning large amounts of dubious data is not going to be easy.. If it's an ongoing issue, then I still would explore considering a table based control system, as you could freeze the current problems and work on them without continuing data errors complicating things.

I expect soundex would allow duplicates, because they sound correct. You want a way to prevent typos. When you let users type text you are going to get loads of errors. Something like 7mm will be entered as 7mm, 7 mm, 7m.m. and loads of other things. It's very hard to make anything foolproof.

I thought you said that the colour element of the openargs failed, and I thought it might be connected with the fact that openargs is a string. I have sometimes passed multiple openargs elements with a string separator, and parsed the string accordingly, but without using a class.

Might the data be there, but the button text colour is being changed to be the same as the button face, somehow? What do you see in properties, format that identifies the button. The numbers don't seem to be a button image that MS would provide?

In this sort of technical case,can you not control the permitted values by using a table of values, including the id of the user who created the value? Then the "genus name" or whatever in the "subject" entity becomes a numeric id, (referencing the permitted values table) and your problem...