Search results

  1. J

    Subform on TabControl

    Hello, I am designing a simple db and have created a main form (frmMenu) with a tab control with three pages. On each page, I have placed a different subform. On page1, I have Subform1. This form gets its records from Table1 and has an unbound combo box that allows to move directly to the...
  2. J

    Combo and Sub Form

    Hello, I have created a form on which I have placed a tab control with two pages. On page1, I have a combo with its record source from a table (tblState) and a subform (SubState) with its record source from a query (based on the same tblSate). On the same page1 I have placed a textbox that...
  3. J

    Error Message when closing form: Cannot contain zero length string

    Hello, I am getting the following error message when closing a form: Run Time Error 3315 – Field XXX cannot contain zero length string. My db is update every month with data that I import from a text file. Data is imported in a table (table1) and displayed in form1 using a query as records...
  4. J

    Copy and overwrite objects

    Hello, I would appreciate any help with some code or advice on how to provide future assistance with my db. Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc. I was thinking of a way (copy object method?) that...
  5. J

    Hide Form

    Hello, For my db, I have created a form which I use as a kind of login screen that has a combo from which users select their name. Once selected, a command opens the main form. DoCmd.OpenForm "FrmMenu", acNormal, "", "", , acNormal DoCmd.Maximize Since most other forms in the db have a...
  6. J

    Export to Excel - Colum formatting

    Hello, I am using this code, to export data from a list box to excel. It works great but the only problem is that it does not keep the last column formatting. In my db it's a text (can contain numbers and letters). When I export I get strange numbers like 4564.15+65. I was wandering if is...
  7. J

    Change name to Report

    Hello, I have a form with a cmd button which executes a macro to export a report of this form via email as a pdf file. The file shows the same name of the report (report1). I was thinking to change it's name and have used a solution which have already uses with the printcurrentrecords on forms...
  8. J

    Listbox with Hyperlink

    Hello, I was wandering if you could help me out with this. I have created a table with two fields: Title (records list name of mostly used web/intranet pages) Web Pages (hyperlinks of the web/intranet pages in field Title) The data type of the web pages field is set to hyperlink and I am able...
  9. J

    Export list box records to excel

    Hello friends, Searching several web sites, I have found a great code to export contents of a listbox directly to Excel. The only problem is that it does not export the "0" column. My listbox has 11 columns and the code exports data starting the count from column 1. Is there a way anyone can...
  10. J

    List box query criteria

    Hello. I would appreciate some help in trying to solve this problem. I apologize if I have not been too clear. My db has a form with a combo, a list box and two tables. The combo is used as query criteria and has it's record source in tbl1 Tbl1 has has three fields: Codes, Prefix and...
  11. J

    Change column count in listbox

    Hello friends, Can anyone help me with this doubt? I have a form with a combo and a list box. The combo lists the various queries. Depending on the users' selection, the combo propagates it results in the listbox. My problem is that the listbox is set to 2 columns but some queries will required...
  12. J

    Sent report as pdf file and change its name

    Hello, I am trying to change the name of my report before sending it as attachment by email. DoCmd.SendObject acReport, "Myreport", "PDFFormat(*.pdf)", "", "", "", "For your Info: " & Forms![frmMain]!LastName & " - " & Forms![frmMain]!FirstName, "Your action is required. Thank you", False, ""...
  13. J

    Change list Box Record Souce

    Hello, I have a form with a combo and a listbox. I would like to change the listbox records source depending on the selection of the combo. The combo's records source is Table1. I have then created two queries that should populate the listbox: If Me.myCombo.Value = "Clients" Then...
  14. J

    Message box is no records found

    Hello, I am sure this has been discussed many times, but still having some problems in finding a solution for my db. My form (frmMenu) has 4 textboxes, 4 cmd buttons and a unique listbox. Textboxes are used to type the queries criteria (I have 4 different queries). The form also has another...
  15. J

    Show field value in form caption

    Hello, I know this may look strange but is there a way I can add the value of a control (ex. a value of a textbox) in the forms' Caption field from the Property Sheet? Thank you
  16. J

    Text box as source criteria on subform

    Hello friends, Thanks to your terrific help. I have been able to almost complete by small application with exactly all the functions I wanted. There is still one other thing which I just cannot resolve. I will briefly explain what I need and post a sample of my database. My database has a...
  17. J

    Clear contents of texbox in Subform from Main form

    Hello, I have a main form with two cmd buttons. The first cmdbutton opens a subform on which there is a textbox that I use as a query criteria. Results are displays in a listbox always on the Subform. On the main form, I also have a second cmd button that should clear the contents of the...
  18. J

    Multiple SubForms

    Hello, I have created a form with several cmd buttons which should open different subforms. I would like that these subform open only on the click event and once closed either close down or are hidden. All the subform should have a specific position, in a sort of a frame (in my sample Box3)...
  19. J

    Only show fields with records

    Hello friends, My db has two main tables (table1 and table2). Table1 gets its records periodically from a text file that I import and that I cannot change. Table2 is used to store new data, like changes in phone number, email, addresses, etc. I use this table like an historical log and need...
  20. J

    Print Current Form

    Hello, I have a form with two tab pages. One picks data from a table, the second one has unbound fields that once updated are saved into a different table. I am having problems in printing this second page. I have tried two options: 1) The following command: DoCmd.PrintOut acSelection...
Top Bottom