Search results

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.

"£" seems to indicate you may be in the UK. Make sure your Azure database is in a data center near you, not in say Asia or USA. As an example, on the portal home page I hover over Resource group, and it shows my resources correctly to be in West USA: As another example, here I am in a command...

"... recommended MINIMUM versions ..."

The old-fashioned way. I saved a color bitmap at (in this case) 48 x 49 pixels. Then dropped a button on a form, and clicked on the ... button of its Picture property and selected it.

b/w only?

WRT the connection used by SSMS: it says so on the Connect dialog: ADO.NET

I just tried it with a basic Azure db, and it was also almost instantaneous.

These are all instantaneous for me, with a local SQL Server.

That query needs another clause: GROUP BY SalesPerson

Hi Josef, I think assigning the result of DLookup to a string somehow modifies it because this fails: s = DLookup("myReplicationId", "tblAccessReplicationId", "myShortText='aaa'") DumpBytes s while this works: DumpBytes DLookup(...) I'm tempted to see if I can hook up a debugger to the...