Search results

Yes that is a string. I read this code as: we have a form frmAccounts, with a subform Register. The subform has a control CkDate. We're setting fld to CkDate's name. That seems equivalent to: fld = "CkDate" When you hit Debug > Compile, which line of code is highlighted, and what is the error...

> strRange = GetDateRange("CkDate", cboDate.Value) You're sending cboDate.Value to RangeType As Integer Is that really what you wanted? Note that today's date expressed as a number is 46005, which would overflow the integer data type. (in the immediate window) ?CInt(Date) Overflow ?CLng(Date)...

I share my mother tongue with the OP so I understood right away. Same for the UI elements in Dutch. I should have translated "map" for you.

Then you did not follow the instructions from the OP. See #24. Note that the MDE is compiled for 32-bit.

Too bad, so sad, but we do not have access to local variables from VBA (a comparatively VERY simple language). That's why we have to pass them into our function. Python: name = "Alice" age = 30 print(f"My name is {name} and I am {age} years old.") VBA: Debug.Print StringFormat("My name is {0}...

That is indeed what function modStrings.StringToDictionary is for.

Re OpenArgs, I highly recommend borrowing modStrings from the Northwind 2 Developer template, and using it to parse the several OpenArgs arguments that are passed as name/value pairs. I talk about it in this YouTube video, at 35:34.

One possible solution would be to implement a MRU list like we did in Northwind 2 Developer Edition. That gives user a different way to access the 20-or so most recently edited records again.

That is the biggest rub for me so far. It leads to more clicks and more forms popping up to get things done. For many of my customers high-speed data entry is very important. Plus, the aesthetics of it: no dropdowns, no checkboxes, no radio button groups etc. I know beauty is in the eye of the...

You don't have to delete it every time; you can set the SQL property and use it again. I do this all the time for passthrough queries to SQL Server. I create ptTemporary1 through 10, and round-robin pick one, set the SQL statement (usually a call to a recordset returning stored procedure) and...

@Imb: I entered a few persons and groups, then tried to associate a person to a group. Clicking on New PersonGroup I get this form, with yellow textboxes where I was expecting comboboxes. I read that you mostly use textboxes. Are we supposed to type the names here? I found out that in other...

@DHookom: the app compiles for me (A365-32). Do you need to decompile?

Then pull it ONCE. Something like: insert into myLocalTable select * from mySapTable where myDateField > DMax(myDateField, myLocalTable)

I think you need to prefix the path to your database with the path to msaccess.exe

Welcome Malcolm. That sounds like an ambitious project. Ask lots of questions in this forum, especially about the correct database design. As an engineer you will appreciate that the best homes are built on solid foundations.

Zip files can be attached as well.

The junction table (we could call it MachineParts) with the Tag field will likely have several records, one for each machine/part combination. That is good! Your desire to have all the tags in one field is likely because you are thinking ahead, to a time where you're creating a report with all...

Good for you for asking questions early on. Getting the database design correct is an absolutely essential step. What I am hearing is that you have machines, and each machine has zero or more parts, and those parts can be of different kinds (e.g. LI or PT). You need a table to list the...

One more suggestion: SSMS > Tools > Import and Export Settings > Reset all Settings.

Oh Chatty... You don't understand the scope of "advanced" and "comprehensive", and you have not read the "Features not covered" section on this NW2 help page. In fact, the inventory system in NW2 is VERY BASIC, and not meant for any real-world business.