Search results

Hi, the main form contains controls that are same in Form A , subform B If i follow docmd openform B, then i go to correct record, yes okay, but i don't see form A. Only form B and her subform C. If i make docmd openform A, then I go to A but i see the first on the list record B, then i have to...

And this txt, is the copy paste from web on the txt

Hi, please check

Hi, many thanks. Is there some limitation in the number of records ? When i copy paste 5-6 records, it works. When i copy paste 200 or more, (average in real life is 300 records) the whole application goes off . I get the message that database is in inconsistent state ??

Hi, the second sample, made this result, jump one field.

Hi I have three tables, linked one to many, table A, B and C; Then, I have Four (4) forms. three of those (Af, Bf. Cf) are form subform subform Af (single), Bf (single- child of Af) , Cf (continue form, child of Bf) and the continues form ABC which combines few basic details from A B C and works...

Many thanks for your reply. No, it didn't work. If you want, visit the web site of COSCO , The address is https://elines.coscoshipping.com/ebusiness/containerTareWeight/query Then just copy paste few container numbers as below, the system will return a table with data such as Field 1 CNTR...

Hi there I have created a table with four fields, no primary Key, just 4 short text fields. Field1, Field2, Field3, Field4 . This table is tailored to the exact same format as one web page that I copy paste data. However, when I copy from web, i must paste in an excel, then copy from excel and...

Hi, many thanks for input. After tried several methods, i found that, an image from library, right click, replace, you can chose and save another image , then this new image,will replace the old one from all previous form and report areas it was sitting. The reason I want to save inside access...

Hi Could we store in a table, few pictures, say company's logo, and then with dlookup function, use this picture in forms/reports? This would save space and if logo or company changes, we just replace the data from table and we keep on using batabase. What method should we use ?

Okay, i found it and now works perfectly. I should type correctly the field property (not the control source) Now works

Yes, the code highlights exactly this part, now i am not on my work station and can't copy paste but this is it

Hi, i will upload, but, this error stands for control property field name error ?

Hi , i have converted this code to my database field names. I get the error "Compile Error: Method or data member not found" in this part of code "FROM [Order Details] WHERE OrderID = " & Me.OrderID & ";" (this is as per Allen Browne example) "FROM [Of2] WHERE OF1ID = " & Me.OF1ID & ";"...

Hi, I have a form/subform, one to many. This is about a quotation. On the form, I display the main quotation details (quotation number, customer name /customer folder number, validity, etc) while in subform (data sheet format) I type the cost, charges, surcharges. Each form has minimum 4...

Hi, I have created a table/form in which i store all of my business app passwords. I use more than 15 applications, each one requires a password that i must change every 30 or 60 days, different format so, not possible to keep one pass for all. In the form, i would like to create a button, next...

Many thanks Minty, solved

If i click yes, it outlines several other trans2 etc that can load and then "id" is not an index in this table

Hi After several months working from home on my laptop, (with access 2019) now i return at office and try to use the application on my business pc (access16) Unfortunately i get the error "An error occurred while loading 'trans1' " I copy paste the application on a memory stick. The same...

No need, now i have got it with this " SELECT Table1.Field1, IIf((select TOP 1 field1 from table1 T where T.ID < Table1.ID ORDER BY ID DESC)=[Table1].[Field1],1,2) AS Expr1 FROM Table1; " I am deeply grateful, i don't know how could i ever return this to You ....