Recent content by Monardo

I don't think so. First of all the code is as simple as it could be (I added VBA in the original post). Secondly, it's just one form with 4 unbound textboxes (I just mentioned 3 in the example). And thirdly, the code works if editing/entering of first textbox is finished, but comes up only if...

Sorry if I was unclear, but I don't think it's convoluted at all. I added the code in the original post as requested. I am not duplicating any data. As all textboxes are unbound, nothing will happen if user closes form in the middle of entry, as intended. To un-simplify, instead of 1 button...

Hello, I have a form with 3 textboxes (itemCode , txt1, txt2) and 1 button (simplifying for this example). The textbox itemCode has an input mask. User must: 1) manually enter itemCode , 2) click the button and vba script fills txt1 and sets focus to txt2. Private Sub button1_Click()...

I totally agree, it made no sense. It was said as a comment to a form with 7 or 8 tabs.

Hello everybody. I almost never use Tab Control on a form, as I always thought it was not worth the "trouble", but today someone said that Access does not like having too many forms. So basically it made me think: Is it better to use for instance 10 separate forms or 1 form with 10 tabs. Or...

Well, thanks for your time, especially @arnelgp. Could not solve the problem programmatically, but I solved it by cheating. I just created blank.png with plain white background and I added path to query, where it should be empty. Still would be interesting if there is VBA solution.

It's already Across, then down.

To clarify bit more: The query output looks like this ID LabelText Path 1 "" "" 2 "" "" 3 "N001" "C:\img\N001.png" 4 "N002" "C:\img\N002.png" 5 ""...

Well, the [path] in query is never NULL, it's either "C:\img\1.png" or "", specifically to accommodate Me.Image.Picture attribute.

Hello, I have a report for printing labels on a grid of let's say 3 by 6 on A4 paper. These are peel-off labels, which can be printed either full sheet or just 1, depending on needs. The report's Record Source is a query, which contains always 18 records (to cover 3x6 grid), and 3 columns...

Hi, my question is not about mysql v postgresql in general (on which there are tons of articles), but rather if there is any preference when used in conjunction with MS Access.

The server PC is Linux and although I read that SQL Server has been ported to certain Linux distros, somehow I don't feel comfortable. Also price? You are welcome to change my mind?

Hello, Probably asked many times, but I guess I could not choose correct keywords in Google to get answer. So question is simple, I am torn between using either MySQL (or MariaDB) or POSTGRES as a backend for Access. Is there preferred choice and why? Better ODBC driver for either of them? Any...

Slightly modified as: WkBk.Close SaveChanges:=False, filename:=File_Namedid the charm. Thanks vbaInet

So how do I "Close" it, what would be the line of code?