Search results

Thnx for the info, I haven’t and i have made many databases, neverhadyhis problem. Ithink something is corrupt.

thnx, george i am an experienced developer, no beginner. Both are number, access 2010 doesn’t has long integer as a seperate type.

I get this error when linking PK to Fk with referential integrity , Also with a newly created test db. It looks like my Access is corrupted, or am i missing something. I noticed that that Access started numbering my databases again with nr 1 >> Database1 I am using Access2010

This is the first time i had the idea to make a seperate notes table, to have an easy overview of all the customer related notes, i really didn’t see this (problem) coming. It has cost me a lot of time, but like always , the learning experience is worth a lot 😃

Thnx, well explained..

Thnx, this brings me closer to the solution. I thought this would be an easy query, how wrong i was...

I understand your question, but it's one big mess of everything i am trying...Thnx anyway

It will work when i link T_Contact to T_Note but if I also link to T_EmailAccount it does't.

That's shitty, i wanted one table with all my notes linked to different tables...

I want to make a seperate table to store al my notes "T_Note". The Table 'T_Note" is linked to every table wich should have a Note field. So for instance table: T_Company can have a note and T_Contact can have note. Next i want also a seperate table "T_MailAccount" for all the email adresses...

Converting the string 240114 to an actual Date (isoDate or local dateformat) is an interesting question ?

If the barcode and the batch numbers always have the same length, then you can use the Mid() function like mid("1524011410612768240DA110587",3,6) wil give 240114.

I think that you have to scan 2 times to get both the barcodes. Most scanner can be set with a automated "Enter" after the scan this trigger Access to go to the next field/control. So two barcode fields makes the most sense to me. The question is, which data are you going to link to which of the...

I experimented with the data macro, but it doesn't react to entries which are not made directly (by hand) into the table. Entries by code or on another way (linked table) did not trigger the table macro.

I believe that you can email directly from certain sql servers as reaction to a trigger. https://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger

Do you know it there is an example/link with JavaScript?

Does the WebviewControl.Object.Document.Write still extist? I use this a lot to write/load an html string from my datatabase directly into the Webviewcontrol?

Does the WebviewControl.Object.Document.Write still extist? I use this a lot to write/load an html string from my datatabase directly into the Webviewcontrol?

I see many problems. I think rebuilding the database from scratch is the best. If the layout of the forms suite you, then you could copy these to the new database. I am not working on a project currently, don’t mind helping you a bit (till new project hits my front door..). I will need a copy of...

I haven’t read all the replies, but i think there is a simple way. Make sure that your subform/childform has an [event procedure] this can be without any code, then you can reference any control directly by just using. Form_SubformName.controlname. That’s all. You also will get intellisense…