Search results

  1. C

    Form/Subform check for data

    @ Uncle Gizmo This last one with an empty database is working fine! @ Mark_ Thank you for the corrections, it's working!
  2. C

    Form/Subform check for data

    Dear friends, I've tried to create a message box with dlookup, to check for empty sub forms, before exporting to pdf. The results i get is only 1 line in the message with only one section. I've tried it with 3 sections (with and without data) but i get always the message for section 1...
  3. C

    Form/Subform check for data

    I'm sorry, i've tried the code you prompt for the control check. The last request works fine "Message ok"
  4. C

    Form/Subform check for data

    I did as you request, i had all the sub-forms open (even a new one with missing information) but it's like button doesn't work. I'm familiar with access, but you never know what you may find! Thanks! For this project i cannot see any other way of designing it It contains a lot of...
  5. C

    Form/Subform check for data

    Still nothing....
  6. C

    Form/Subform check for data

    I'm sorry Uncle Gizmo, I did use the code you've suggested in the main form. My subforms load by button, that's why propably nothing happened.
  7. C

    Form/Subform check for data

    Nothing happened!
  8. C

    Form/Subform check for data

    @June7 -Structure unfortunately isn't identical and i need to enter a lot of data and calculations! (Each product's report will be about 15 pages. Each sub-form contains about 10-20 fields with page control etc...) The only field that is the same in each table is the product_id. -My knowledge...
  9. C

    Form/Subform check for data

    Yes, a separate table for each section. When there's no data, i'm thinking of the following solutions: 1st option: A case statement which checks (with dlookup) for records in every section. A message will appear everytime there's no data and user will be prompted to enter the data. 2nd...
  10. C

    Form/Subform check for data

    Hello everybody! I need your valuable help once more! I've got a product database with a main product form and 10 sub-forms. Each sub-form loads in a new window, by pressing its button. Main ID is Record_ID and it's unique (no duplicates) for every product. Second ID is Product_ID which i...
  11. C

    Field Combination

    @Mark thanks! I've tried it and the result wasn't good enough. I kept it as a subreport. Thank you all!
  12. C

    Field Combination

    @jdraw Report (subreport actually) will collect data under the same ID from the main form. Main form will have the Record ID and ID which is the same for the subform's data. Guys, I think it's better to leave it record by raw...
  13. C

    Field Combination

    Hello my friends! I need your valuable help once more! I'm trying to create a report which will contain only 2 fields: -ID (will be the same for all records) -Description (which will be different for each record). Maximum records will be 5. My question is, if there's a way to show in...
  14. C

    Subreport question

    Hello everybody! Could you please help me with the following? I've got a subreport which contains 2 fields (ingredient and code). data example: Ingredient; Code --------------------- Ingredient 1; 1000 Ingredient 2; 1500 Ingredient 3; 1600 Ingredient 4; Not declared Ingredient 5; Not...
  15. C

    Combobox values

    Hello everybody! I've got a form called ingredients (fields: name, code, date) In another form which contains a subform as a datasheet, i've got a combobox which source is the name field of ingredients. Is it possible, when the user selects an ingredient in the combo, when he adds a new...
  16. C

    Database lock

    Thank you all! I'll try to keep the objects and menus as hidden as i can!
  17. C

    Database lock

    Hello my friends, I've got a request for a database but i would like to lock the file so when the user will work he will not have access to tables/forms/code/design etc. An experienced user could use shift to unlock/unhide the tables/routines/forms etc. Do you suggest any way to totally...
  18. C

    Database problem

    I will correct it, i have the same way of declarations in 2-3 modules. Thnaks!!!
  19. C

    Database problem

    Hello, problem solved. For a reason it stopped in this part: strPathAttach1 = filename1 I changed to "manual" strPathAttach1 = "c:\temp\Customer Samples\SampleAnalysisRequest.xlsx" and it worked. jleach: Option explicit was "missing", added in the top of the module. JHB: I've created the path...
  20. C

    Database problem

    I've corrected it but i still get the message. When i compile it, i don't get any errors in the code. Should there be any mulfuction between the office versions?
Back
Top Bottom