Search results

Private Sub lstShows_DblClick(Cancel As Integer) If Me.lstShows.ItemsSelected.Count > 0 Then MsgBox "Select a show please" End If If Me.Check30 = -1 Then DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows '.Column(0) Else DoCmd.OpenForm "frmEventsEdit", , , "EventID = " &...

Okay, that does work, but it still gives the error.

http://www.access-programmers.co.uk/forums/showpost.php?p=1458662&postcount=10 That is what im trying to do. I have 3 records for that show, but when I click the Copy button, it only copy's the FIRST records for that show. What I need, is for it to copy all 3 records.

Hello! I have a list box, and if the user doesnt select a show and double clicks on the top of the list box, then it gives the whole Run-time error '3075': Syntax error (missing operator) in query expression 'EventID = '. Now, what I would like to know is there any way to block that error...

Not sure what you mean there.

Truth be told, I just want a button to do it, that ways it faster, quicker, and much easier for the user. I was thinking of using .column but it doesnt seem to want to accept that...

Show Name Date Total Per Day Sales Hootin n Hollerin Gainesville 09-2015 1 $86.85 Hootin n Hollerin Gainesville 09-2015 2 $468.74 Hootin n Hollerin Gainesville 09-2015 3 $892.75 As you see, its usable, buts its not how I wanted it.

Okay, I am able to copy and paste the data now, but the problem is the format its in. That is what I want, but, I have multiple days, and its only copying the first record. As you can see in the image, that it still only copys one when I push the button, even though there are 3. Here is the...

Thanks! That worked perfectly!

I want to change the date to show what I really wanted. I dont want it turned into "d" I want it turned into a number. 6/5/2015 was the "1st" day of that show, thus it is "day 1" 6/6/2015 is the "2nd" day, thus it should be "day 2" Does that help?

[Show Name]---------[Date] -----[Gross Sales] State Fair 06-2015--- 6/5/2015-- $89999 State Fair 06-2015--- 6/6/2015-- $999946 State Fair 06-2015--- 6/7/2015-- $12345 State Fair 06-2015--- 6/8/2015-- $15646 I want it to look like this: [Show Name]--------- Date]-- [Gross Sales] State Fair...

Hello! I have lots of shows, and each show has dates. A start date and a end Date. I am trying to figure out how to get access to show me days per show. For instance, if the show start on 6/1/2015 and ended on 6/4/2015, when I create a query that shows that shows dates, and lets say the gross...

Sorry for the long wait! Been really, really, really, busy. Just got around to using it, and figuring out how to. It is exactly what I wanted. Thanks a TON Sneuberg! That will help a lot with being able to tell how many real days we have been doing shows and such. Thanks again!

sneuberg got it, its not that hard. The date diff will say its a 5 day show because that is how many days are between those 2 shows dates. But, I dont want that, what I want, is those 2 days overlap, and I just want the total ones. If the show dates were 1-1-2015 to 1-31-2015 and the next show...

Kinda. I have Show 1, its dates are 1-1-2015 to 1-3-2015. That is a 3 day show. Now, I have Show 2, its dates are 1-2-2015 to 1-3-2015 That is a 2 day show. My current data would say thats 5 days, when in the end, its just really 3 days.

Hello! I have 2 fields, Start Date and End Date. I am trying to figure out the "true" days between them. The problem is, im using date diff, but most of my days have other dates that happen on the same, or during the other show dates. Am am trying to figure out, how many days do we "truly" go to...

Private Sub Command2_Click() Dim ItemIndex As Variant For Each ItemIndex In Me.lstPrint.ItemsSelected Dim WordObj As Object Set WordObj = CreateObject("Word.Application") WordObj.Documents.Open "C:\Users\User\Desktop\Labels\" & Me.lstPrint.ItemData(ItemIndex) & ".doc" WordObj.PrintOut...

I dont think im going to be able to get that button then...Your code has lots of "this = that" so im all confused on what "this" is when its really "that" I am going to keep trying sometime tomorrow. My head hurts after looking at that all :) Thanks for your current help though! After using...

Just thought of something. How would I go about doing this, but with a multi select? Thanks! EDIT: That is going to be a LOT harder then I thought... I got this code, and it gets me what is selected. Im just not sure what to do with that. Private Sub Command6_Click() Dim ItemIndex As Variant...

Yes, but what if the user only wanted 1? Or then 2? That is why im thinking just printing one at a time should be good, and if they want more, to click more :) Thanks again!