Search results

Thank you Crystal, will give it a look.

Hello Arnel, the line wksData.Range("A:" & Chr(65+Ubound(lstBanks)).Select shows an error. Some missing bracket? Thank you

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...

Thank you Gasman, would you assist me with some code? Thank you

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...

Wow thank you Arnel. It's years I search the web for help on MS Access and have to admit that your replies are fast, easy and have always a solution. Thank you

Thank you Arnel, I am getting an error (7971) and have noticed that after a security warning that advises about hyperlink from trusted sources, at the beginning and end of the hyperlink I get an #. Obviously this # are not in the hyperlink. Another think I did not indicate before, is that the...

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...

That's just perfect! Great help. Thanks Arnel

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...

Tbl2

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...

Thanks

Thank you Bob, I was hoping there was a way to adjust the number of columns and their with dynamically, basically in an automated way depending on the number of fields of the query selected in the combo.

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...

Thanks you. I like the idea but honestly would not know how to write this code. Or should I use a macro?

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, ""...

Thanks you quick reply. Walked through my code and ....yes, it was just a typo with the query name. Thanks

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...

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...