Recent content by Clueless Newbie

Duckomenta :)

Thank you! I'll try that a.s.a.p. and will let you know if it worked. :) (It's not a shared drive, so I'll give your first suggestion a shot first.)

Hi once again! :) I've just taken over a project from a colleague and have already encountered a strange problem: When I try to open a form in editing mode, I almost always get a message that I don't have exclusive access to the database (everything's stored on a local drive, mind you), so any...

It's OK, no need to reply anymore. :) I did it the long way in the end.

Hi all! Here's another one of my stupid questions: I have a string ContractNumber = "9" & Ziffern & ID "Ziffern" is just a sequence of Zeros ID is a numerical value starting with 1 The problem is: ContractNumber is supposed to always have exactly 11 digits. The first digit is always a "9"...

Hi all! When replicating a DB in Access 2002, how do I know which of the above I should use for which copy? What's the difference between the local, the global, and the anonymous type? Which one should I use if I want to store the design master and my (separate) database on a central server (no...

In theory this works fine, thank you! :) But I've just received a mail that this feature isn't wanted anymore... :rolleyes:

Hi all! I'm trying to transfer data between two tables. This is the corresponding query: INSERT INTO tblData ( KundenNr, AngebotNr, LaufzeitSAP, SAPAuftragsWert ) SELECT tblExcelimport.Debitor, tblExcelimport.SaM, tblExcelimport.Laufzeit, tblExcelimport.Wert FROM tblExcelimport WHERE...

Great idea, thanks a bunch! :) Just in case anyone is interested: Query "navigation" = SELECT DISTINCTROW Daten.Kunde, Daten.KundenNr, Daten.ID FROM Daten WHERE (((Daten.deleted)=False)) ORDER BY Kunde, ID; Navigation code: Private Sub Forward_Click() Dim db As DAO.Database Dim rs As...

Hi all! I was wondering: Is it possible to create a navigation button that finds my current/open recordset and takes me to the next recordset in alphabetical order, even though my primary key is a numerical ID? How would I go about this? Can I combine "DoCmd.GoToRecord , , acPrevious" or...

Nope, I don't. I have to admit that my query was a lot of "trial and error". It took me a while to get it formated in such a way that it worked. That's why I was wondering whether it can be improved in any way. I have a textfield ("suchkrit") containing the search string in my form...

Interesting thread. :) In a similar function, I'm using " OR (nz(Address,'')) like '*" & Me!txtSearch & "*'" instead of the solution posted above. It seems to work fine for numbers as well as text and date fields. Can anyone tell me what the advantages of dcx693's solution are, please? I'm...

Hi! I'm not sure whether I understand you correctly, but maybe this helps? SELECT Table_1.id, Table_1.quantity FROM Table_1 LEFT JOIN Table_2 ON Table_1.ID = Table_2.ID WHERE Table_1.quantity <> Table_2.quantity

He asked: I really don't know why you're wearing a bra. You haven't got anything to put inside. She answered: So? Your're wearing pants too, aren't you? He asked: Shall we swap positions tonight? She answered: Great idea! You put yourself behind the ironing board while I lie around on the sofa...

Well, it didn't quite work as intended, but luckily I have a drop-down list "Auswahl_Name" in Form_Datenerfassung which contains an overview of all recordsets. This came in handy. When the user agrees to the duplification, this is what happens now: If MsgBox("Ihre Auswahl wird nun...