Search results

Dim WordObj As Object Set WordObj = CreateObject("Word.Application") WordObj.Documents.Open "C:\Users\User\Desktop\Labels\" & Me.Model & ".doc" WordObj.PrintOut Background:=False WordObj.Quit Set WordObj = Nothing Got it! Combining your code, and some other code I found, I can now print with a...

That does it! Thanks! Now, one last thing, how would I print that on open? Like, have it print that?

Error 490: Cannot open the specified file. That is the error im getting. And, yes, I am positive that I have the correct path. I changed it from !Labels to labels. In case that was doing something. How do I add .doc onto the ending? I think that is the problem. If I put Bazooka in it, it...

Yes, I have. Ya, thats just how I name the important folders I have.

That first shows it red, and 2nd, it doesnt let my use it. It just errors.

The entire database, or the SQL for the query?

Okay, I got that done. Now what? Its a query that has its Criteria field set the the Show ID that is open in the form that I would copy the data from.

Hello! I have a subform that has my daily sales per show, and what im trying to do is, click a button, and have it copy the daily sales for that show, so I can easily paste it else were. I know its possible, I just dont even know were to start looking to begin. I looked some, and the problems...

Private Sub Print_Label_DblClick(Cancel As Integer) Call GoHyperlink("C:\Users\User\Desktop\!Labels\[Model]") End Sub That is what I want. I'm just not sure how to get the [Model] part to work...Because, it would just get its name for the file, from the name that is open on the form. I'm just...

Ish. I want it to open the corresponding Word doc. I know how to open a form up, but not open up a word doc from access.

What items? I have a tblItems that has each item, and a qryItems that has all the info from the items.

Hello! I have lots of items, and each item has a label for it that I can print out. What I would like, is that I can have a command button named "print labels" And when the user clicks that, it prints the correct label for that gun. How would I go about doing that? I also have around 80 items...

One last thing, the end result, how would I view that in a form? When I try to just click and drag it into the form (in design view) it has its Source Objects set to nothing. And when I set it to the qry, it gives me the error in the attached image. Its also not creating a sub form like every...

Well, I just had to past the !form!name!Text in the Criteria again :) Thanks man! Helped a TON! I went through lots of forums looking, and decided I would ask the experts :) Thanks again!

Okay, that is what I have, but the problem I have, is in the picture, you can see I have referring to a form, and those Text boxes. But, the query doesn't do anything. Im not sure what im doing wrong.

Hello! TRANSFORM Sum(qryItemsSold.Quantity) AS SumOfQuantity SELECT tblItems.Model FROM tblItems INNER JOIN qryItemsSold ON tblItems.ModelID = qryItemsSold.ModelID WHERE (((Format([Date],"yyyy"))=[Forms]![frmreports]![Text22] Or (Format([Date],"yyyy"))=[Forms]![frmreports]![Text24] Or...

I found out what I had to do, and this create a Relationship between the Show in tblShowSales and the tblShows. But, the problem I have is that my shows have names, like MO State Fair 08-2014. That 08-2014 comes from the qryAdminEvents that adds the StartDate to the ShowName. But, the problem I...

Hello again! I have a tblShows and a tblShowCosts. TblShowCosts has a lookup field that it gets its info from the tblShows. Now, I have a form frmEvents I can use to edit the show names. What I am trying to do is, when I edit the show name from frmEvents and it changes in tblShows, I want it to...

Sorry about that, I I figured it out awhile ago. Profit Rating: IIf(Sgn([1-Star Profit])+Sgn([2-Star Profit])+Sgn([3-Star Profit])+Sgn([4-Star Profit])=4,"❹❹❹❹",IIf(Sgn([1-Star Profit])+Sgn([2-Star Profit])+Sgn([3-Star Profit])+Sgn([4-Star Profit])=2,"❸❸❸",IIf(Sgn([1-Star Profit])+Sgn([2-Star...

Hello! I have 4 fields, each of them are in the report, and they have Conditional formatting, so if its > 1, then red. What I need to do is, if 4 of the fields are normal, then make this field blue. If 3 of the fields are black, then make this Blue, if 2 of the fields are black, then make this...