Search results

Hi Dudley, It seems that the line, If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord 'error 2115 on the docmd statement Try replacing it to "DoCmd.RunCommand acCmdSave". I have replaced it and so far it's working.

Hi, Yes, use the ListCount property.

That’s right Neil, all Wedge/USB Type emulates keyboard action, the only exception is Serial Type where it uses supplied or customed software to input data into the form’s control. I have never seen any customed Serial Type that will work with Access yet. It is usually activated by openning a...

I do not know how you design your database and forms for the scanner. I would suggest a “hidden” textbox. Don’t touch or set the control properties Visible just leave to “Yes”. Set the control’s “Back Color”, “Border Color”, “Fore Color” to the same color as the form’s background color. So that...

Hi, I hope you did not used missinglinq's code when you set both to "Yes"?

Hi Bob, Hmmm…That’s ironic, as you said “the scanner essentially becomes a keyboard”. Than missinglinq’s code will set the KeyCode = 0. That will defeat the use of a scanner. I have done this before by locking the controls, as I recalled, it works. I don’t have a scanner right now to check...

Hi, If a control is Disable, your Barcode scanner will not be able to input data. Just set the control to "Locked = Yes". Leave the Enable = Yes.

Hi Tony, The code will only work for a stand alone form. Changes are needed further for the code to work. So have you check? You need to check the subform RecordSource "DataType" on the column/field of your Transactions Table and also check the Primary key "Index = No" or "Yes (Duplicates...

Hi Tony, Until we get the reply "DataType" is correct. There will be no suggestion. Do check the primary keys of all tables and the relationships. What the code does is to copy the last record into the new record. This include the Primary Keys!

Hi Tony, I don't think you understood what Moniker meant. Please refer to your table column/field datatypes, make sure that both the Tables "Products" and "Transactions" match.

Hi, "Date" is a reserved word in Access. Rename it if it is possible else use a square bracket like [Date] = #" & Me.txtdate & "#. PS. The correct one is [Date] = #" & Me.txtdate & "#" . seems like you missing one more qoute.

Hi Jennifer, How do you want to limit the records? What is the form's recordsource? Maybe you can use "TOP 5" and filter it by descending? snip

Hi Pete, Here's something I found at Steven Lebans ZoomInOut Hope it works for you.

Hi, Have tried using the code on your Next & Previous buttons?

Hi Kleenex, Go here For Steven Lebans RowNumber me grabbing a box of Kleenex tissues:p

Hi Walter, Good to hear from you.

Hi missinglinq, I have seen such complaints before. Access 97 and 2000 works well at 800x600. If you designed the forms on a computer with a resolution of 800x600 and copy this database into a computer with a higher resolution of 1024x768. You'll see that your forms will not be centred. If the...

Hi, Make sure that your Window XP Display Properties is set correctly. The Default Setting is "Normal Size (96DPI)". If you selected Large or Custom, maybe that's why it's not centred?

Hi, If the user is looking at "Subform 3" and clicks the "next or previous record" button on the MAINFORM , then "Subform 3" must always display the LAST related record. What i have at the moment is > On each SUBform's OnOpen event : DoCmd.RunCommand accmdRecordsGoToLAST I realize you also...

Hi, The Tab OnClick Event may or may not work. In my version of access the event didn’t even fire up. You might want to try to use the Tab’s OnChange event. This one works for me. Here my code. Private Sub TabCtl0_Change() Select Case Me.TabCt10 Case 0 Me.YourFormNameHere.Setfocus...