Search results

that didn't work either, but what did work, is I set every control TAB Stop = NO... so I don't think the Setfocus had anything to do with it, I just gave it no where else to go so this doesn't appear to be right?

Hi, K, I have this Database that I setup last year and I know it was working, but I just looked at it again yesterday to start working on it again and here is my issue.... Access 2007 now on windows 7 ( previously 2007 on XP)... just mentioning that because its the only thing that changed...

I always do this, as soon as I post, I figure it out. this gets me the value.... FldNme = rs.Fields(FldNme)

Kinda confused, can someone help me with this.... For Each fld In db.TableDefs("tblLabelFile").Fields FldNme = fld.Name FldNme = "rs!" & FldNme the above tells me the field name, which I then want to...

I have searched Hi and low, and I see many people have this issue, but I can't seem to fix it. I first create my Text file by exporting as a CSV with no field headings, I need Pipe delims so I edit the csv and replace comma with Pipe delim… so I then import that file and create my spec, I have...

it was a text box, but I don't think the control is available to pass data in the open event... possibly LOAD, either way the format event works. I was making a shipping label, in case anyone wonders what this is for.

ok I got it, should have put into the format event Thanks for the help guys

I understand all this, but when I try to assign a value to the text box I get an error saying "You can't assign value to this object" I even tried with a hardcoded value?

ok, I'm having trouble passing the OpenArg... Private Sub cmdPrintShipLabel_Click() On Error GoTo Err_cmdPrintShipLabel_Click Dim stDocName As String Dim copy1 As Integer copy1 = Me.txtCopies For copy1 = 1 To Me.txtCopies stDocName = "rptShippingLabel2"...

I don't get it everytime

I guess I should do away with the "DoCmd.PrintOut" and use the open report alone with acNormal and use a loop from my copies text box...like you thought I was doing.

I need an event that fires everytime the page prints a copy... I thought ON print would work, but I don't see it firing everytime

I don't need a loop, this is what I am using... Private Sub cmdPrintLabel_Click() Dim stDocName As String stDocName = "rptShippingLabel2" DoCmd.OpenReport stDocName, acViewPreview DoCmd.PrintOut acSelection, , , acLow, Me.txtCopies DoCmd.Close End Sub

Hi I'm using the Openreport method, and using a text box to control copies, how can I get the copy number to show on the printout for each page printed?

thanks, I had that on the second one, but I guess I need to add a second one to the main expression.

I have 2 tables linked in a query..... TransActionDate REC-ClosedDate 26-May-10 27-May-10 27-May-10 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 27-May-10 27-May-10 27-May-10 [ProductMovement] is the main table and the join is set to...

ahhh ok now...for some reason it wasn't popping into a new window when I tried it yesterday...so yes your right the same functionality in both (FF & Chrome).

well He's 16...and you know Kids and the internet :) I think that is what I'm trying to say, grab the tab and drag it to a separate window...Firefox doesn't do that ( you can drag them left right on bar only). I wonder how long before we get in trouble for turning this into a Random discussion :)

Ya I know I can switch the tabbing off in options >Current DB... as far as FireFox, the Tabs don't pull out like Chrome..my son actually showed me..you can also drag them back up to the tab bar and it snaps in

Well lets say your working on a query and you want to look at the table, I just like to be able to see them both at the same time (tile horiz), or maybe a report and table. look at Google Chrome as an example, grab a tab and drag it down...it pulls away into it's own window...that's what would...