Recent content by spilwayboy

I am trying to run the code for the dialog box but am missing the reference to the dialog box library in VB. I have been trying to ad it to no avail. Is this something that can only be used if you have the developer edition of access? I found where you can download the control from at...

This thread also did exactly what I was looking for except if there is not value in the columnExcel leaves the column out. I tried the nz() expression in the query but then Excel does not recognize the nz function. Any suggestions, other than that it leaves out 2 columns it works great. The...

That also helps thanks for the code. Spil

Thank you very much for the reply. That will help greatly. Spil

Thanks for the help and direction I will give it a try. Regards, Spil

I do not, but when I see a piece of code I can figure out what it does and how to change it to suit my needs but not really start from a blank tablet. I have some small code pieces that export to bookmaks in word if that is the same procedure. I am not sure though. This is the code I use for...

Both parts if you do not mind, I can change the code to suit my table mnames and stuff but do not know how to start on the code, but can understand how to switch sheets. Thanks, Spil

This code is very helpful to what I am doing as far as switching sheets, but is it possible that one of you guys would mind posting the code that actually picks up the table values and carries it to excel? That is what I am looking to do also besides switching sheets. Thank you for all of the...

I have the following code that mail merges access to word fine: Private Sub Option6_Click() ' Open a Fax Cover Sheet in Word and insert text - used by menu command. Dim dbs As DAO.Database Dim rstMergeThese As Recordset Dim oApp As Object Set oApp = CreateObject("Word.Application")...

That took care of it, I know it must have been the way I was holding my mouth or where I was putting the code. you the man. Thanks, Spil

I have some combo boxes that have the not in list event procedure set to this code and the code works great for adding new records to tables. Here is the problem. I used a string command like "Me![City] = StrConv(Me![City], 3)" to capitalize the first letter of each word and had it in the...

I have a form where a hyperlink is used and I do not know if you want to go this way but this code will open up the hyperlink editor and will allow them to just point to the file location and it will store the hyperlink for them. I just put it in the "got focus" event of the textbox field. On...

I have a form that is set up with Company information as one tab and another tab at the top is contacts so that there can be multiple contacts for each company, anywho this is the problem. I have a field that is a text field holding email addresses for each contact and have the following code...

I have a form set up with a text box that is an autonumber field that indexes on each new record and a subform on the same form that that is linked to a query. the query criteria is set to the textbox that is an autonumber. I need to rerun the query on entry to the subform or on the focus...

I placed the break point and did the F8 thing and it broke on the first line "Dim db as database" and it breaks on "as database". Could this be a wrong variable callout. That one and the one underneath it do not turn blue after the as like the rest of them which leads me to believ it is wrong...