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...
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...
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...
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...
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
Since most other forms in the db have a...
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...
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...
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...
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...
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...
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...
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, ""...
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...
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...
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...
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...
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)...
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...
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...