Recent content by tru-

yes I have been searching and I cant find the answer basically I have two buttons to open a form called frmInvoice, one button I want to open the form and allow edits, the other to not allow edits the code is being run from frmMenu I tried the obvious frmInvoice.AllowEdits = False but it...

someone please? I really need to get this done, I can't ask anyone/anywhere else I've been told to try INSERT INTO [tblInvoiceToProduct] ([Product ID]) _SELECT ProductID FROM [tblProduct] but that doesnt work

I didnt know whether to post this here on in the table forum, so sorry if its in the wrong place!! Ok, so in the frist screenshot the green box is based off of the table labelled 3. The red box is comprised of the InvoiceID from table 1, ProductID from table 2 and name/price is drawn from...

I have a form with a sub-form and a sub-sub-form :p If I try to delete the record being viewed in the sub-form using With DoCmd .DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 .DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 End With Then I here a ding (like you do when you try...

I've tried using that example on a subform, when opened on its own as a form it works but when I try to open it when its as a subform I get debug come up, highlighting RecordsetClone.MoveLast & RecordsetClone.MoveFirst. Any solution?

I did but didnt find anything so posted, I always search first :) thanks

At the bottom of the form where the navigation buttons are it'll say 1 of 8 records, how can I get this into a form? (I want to have some text saying Viewing 1 of 8 Products). Also how can I copy a record from one subform to another? The first subform is like a catalogue of items, the second is...

that doesnt work cos that would set them for frmPassword not frmAddEditProducts

Private Sub btnConfirm_Click() On Error Resume Next DoCmd.Close acForm, Me.Name End Sub Private Sub Form_Unload(Cancel As Integer) Dim password As String password = "closeme" If enterpassword <> password Then Cancel = -1 MsgBox "Incorrect password!"...

Else: DoCmd.OpenForm "frmAddEditProducts", acNormal DoCmd.MoveSize 200, 2000, 15000 'if password is true then widen form frmAddEditProducts.Form.AllowAdditions = True frmAddEditProducts.Form.AllowDeletions = True frmAddEditProducts.Form.AllowEdits = True Debugger...

I have created a form which contains fields also found in tblProducts. frmProducts - ProductID, Name, ProductCategory, ProductSubCategory, Description, Price, Quantity I have made cascading combos for the ProductCategory and ProductSubCategory fields, the row source for these two fields are in...

none at the moment, I'm new! (as you can tell :p)

how do I make a form closure password protected? basically a customer will be using a a form to browse products and the only way to have access to the rest of the DB is to enter the correct password to close that form when a close command button is clicked (more security features protecting rest...

I'm using DoCmd.Maximise on open, I've also got rid of the toolbar, Windows min/max buttons and the close button no longer work. However I still have my taskbar and the bar that you get at the top of all your windows in Windows which contains the program name or in this case the form name (the...

that when the mouse is placed over a textbox, text will show up in a seperate textbox with text in dependant upon which textbox the mouse is over? going on the same idea how could I get text appearing in a textbox depending upon which value was chosen from a combo box??? thanks :))