Search results

I made up this function, It does what I nead it to, but the date seems to return as a Text type and not Date...doesn't make sense as all declarations use "DATE" type? I even added a Cdate at the end? It's a work in progress, but I don't get why the date is not the correct data type...

Ok nvm, I found the solution by adding the button to the "Quick Access toolbar". You have to select the command from "Form Design Tools| Arrange Tab"....you will see the actual toolbar NAMED UNGROUP.... After that I noticed the same Icon was already beside "Tab Order" on the Arrange menu...

I have a DB created in 2002 version, I can't ungroup my controls. I've seached all over and everyone says go to "Arrange" tab and the click "REMOVE" ( couldn't be more obvious huh?)...ya well that doesn't work because the button isn't available ( suggesting they aren't grouped)...If I click on...

Ok, I did not figure out why, other than maybe it is a 2007 thing, but I just put ="____________________________" as the control source and made the control transparent and my lines Print...so I won't worry about it...I just like to understand what was happening.

I’ll explain what I want to do,so if there is a better way, please let me know, otherwise maybe explain what is wrong with what I have. I’m printing 2 copies of a report, I want one copy to say “Original” and the other to say “Carrier copy” I simply used the Printout command and referred to...

I keep getting myself bogged down with what seems like it should work... the code below is on the "on Exit" of a control on my Subform, yet it keeps triggering while I am tabbing out of fields on the main form...makes no sense, I'm not even touching the control yet? Private Sub...

thanks Coach! you got it! Good eye, I totally missed that.

thanks lagbolt, it sounded like a good idea, but doesn't work. The before update of the form does not "fire" at that point it seems.

I'm setting this code up and I have it working, except when the UNDO is initiated, I was hoping it would delete the record, but it only clears the field and sets focus to it. Private Sub Skid_BeforeUpdate(Cancel As Integer) 'Checks if Pallet is already used or if it is closed ' If it is...

just a note, this helped me with my subform.....I placed it in the On current of the sub form.... Me.RecordsetClone.MoveLast Me.RecordsetClone.MoveFirst I was having difficulty with the subform navigation buttons enabling thanks

arghhh LOL that was too easy.... I just didn't think I needed 2 lines, thanks for the help. Private Sub Skid_Type_AfterUpdate() Me.tblArticleDetail_subform.SetFocus Me.tblArticleDetail_subform.Form.Article.SetFocus End Sub

I've looked over this link, but i can't get the syntax right.... this is what I have before looking at the link.... Me.tblArticleDetail_subform.SetFocus It will set the focus to the subform, but I want to set focus to a control on that form but can't figure it out. i thought this should...

Thanks for the Reply JoanneJames as far as I know this: Me.RecordsetClone.RecordCount gets the Count. I changed this line to <= 1 If Me.RecordsetClone.RecordCount <= 1 Then 'There is only one record And put this in the open even, probably very "Hackish" of me but it seems to be working...

when I use this code, the navigation buttons get disabled, but if I try to Debug, it gets really confusing...I get mixed results...using "F5" and "F8"...sometimes it disables the "next" and other times it doesn't. all I'm trying to do is eliminate the message saying you can't go to the...

good Points Razor, I forgot about the barcode Fonts... we use WASP and Labelview Labelview works with Zebra Printers, which are good for Highoutput...and you need a special printer that handles Printing onto RFID....for normal barcodes just use WASP. * with custom label sizes, you sometimes...

rex were trying to tell you that your database will be no different than as if you were typing into fields, but what you will need is to have a dedicated PORT in order for Data to always pass to the Database whether or not it is the active application...unless you don't see that as an issue?

PS2? isn't that for Gaming LOL...your old...:p You can get them with USB these day's...just kidding Unc..it's Friday and I'm itching to get out ( hope the network police aren't watching) http://www.motorola.com/business/v/index.jsp?vgnextoid=1722e90e3ae95110VgnVCM1000008406b00aRCRD

well you don't really need to Integrate anything, you just need a scanner/Reader that will pass the data with a <CR>, and you would need a Printer like ZEBRA that can Print the RFID ( I assume you need it as a Label)

Just a quick update....I was able to figure it out with the scenario mentioned above. I create a temp table that creates a record for every pallet, I added some dummy fields to the table and use them on the Subreport. you can see the subreport on it's own is not much use but when linked in the...

Brian/Stopher, The general idea seems to be working with what my coworker gave me, but I will have to play around with it. Thanks