Search results

Hi pr2-eugin first of all I describe my problem: e.g. I writing order number 1: I'm creating a new folder in my disk e.g. C\Myfiles\ClientX\27-03-2013 then I past files into that folder e.g. x.pdf, z.doc, y.tiff. Then I copy path from Window "C\Myfiles\Clientx\27-03-2013" and past to filed...

Think it could be a field, Data type "Memo" with "Rich text" to have something like this: "1. x.pdf 2. y.tiff 3 z.doc" I found some code: With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run" .MatchTextExactly = True...

I have bound form multiple items with 2 fields "path", "files" and one button "show files". Would like to, past path to one of them, like e.g. (C:\MyFiles) click button "show files" and in the other field should appearing files from destination (c:\Myfiles) e.g (x.pdf, z.doc, y.tiff). Is it...

I found in properties "cycle" :)

I have a bound form. My problem is navigation, I don't want to move from record to another, I only want to move in fields between one recored in table. I have navigation button option "no" but I still can move between records using "tab" key. It's really big problem:/ Please help me!

It must be that key because so far it was paper orders (with that key) for many years and now it will be electronic database with the same rules.

I would like to define primary key to show in default value "n/=Right(Year(Date());2)" n - next real number =Right(Year(Date());2) - equal two last digits from year The big problem is when we have next year e.g. 2014 real number should count anew. E.G 6/13, 7/13, 8/13, 9/13, 1/14 I tried to...

John how do you past image in to the message:p?

Thx John, I know about this function in properties, but I think I gave bad example. I have unbound form with unbound subform. See attached Image. Value from field number (form) should be default value in column (subform). VBA Code could be placed in number field (form) after actualization.

e.g. I want to set "10" as a default value in to my unbound subform (in column). How should I write line a code for that?

Any ideas?

Thanks for insight Doesn't work - attached screen. I change column name from "year" to "years" cause was resserved by access. I use unbound form, with subforms. It is complicated but I try to build unbound form to data entry, to fill tables with relationship. I can't find any solutions on the...

1. No. Order_number is field in my open form, AutoNumber is column in table "OrderTab" 2. Actually Form is unnbound (It must be unbound) but in this example I have only one table - OrderTab and only one form.. So this table is a recordsource of the form.

Yes I have special button "write new order" to open form. Marlan this is all of code? I read something about "variable", "dim", "dbs.OpenRecordset" but I don't know how to put into a code correctly. What about plus text from "year" column? Me![Order_number]=OrderNumber - this will create new...

I'm looking for three days solution and I can't find. I'm beginner in access so it is too hard for me. Please help me! I will put this code in "On load" on my form. This code should add a new record in OrderTab, take a number from AutoNumber, then plus text from "year" column in the same table...