Recent content by peterjb44

i did restart it and i tried a new database too, still wasn't working i even reinstalled office too that was a weird one and this was me :banghead: , lol

i could see the buttons, but nothing happened when i clicked them it works now, http://prntscr.com/4iqyms thanks for your time vbaInet peter

Hi, not to worry i got them working Access Options. Click Current Database. Clear the check boxes "Enable Layout View" and "Enable design changes for tables in Datasheet View". Click OK. now working!!!! i rechecked the two above that i just unchecked and it still works i guess it must of...

Hi vbaInet, in form design tools in design tab there are buttons in tools add existing fields, property sheet, tab order and 3 smaller buttons subform in new window, view code, convert forms macros to visual basic its the add existing fields and property sheet button there that are not...

Hi All, I have a problem with two buttons, add existing fields and property sheet when i click them they do nothing at all, so i cannot do what i need to do how can this be solved?, i have uninstalled and reinstalled office 10, but its still the same :banghead: thanks peter

Hi All, this is weird...... it works only if my customer already has equipment that has been added to their company, but it shows that equipment data including company and not a blank form with only the company name in :confused: this is the code i am using private sub...

not sure how to do this :confused:

Hi Alex, it is a form in datasheet view, yes it has multiple companies on it thanks peter

Hi Alex, I've got a datasheet open all the time SubEquipmentFDS which has CompanyID on it, can that be used? thanks peter

Hi Alex, thanks, that works, but i also can open EquipmentF from another button on my navigation main form and now i get name? in the CompanyID is it not possible to do code for my OP? how can i get rid of name? which is now on EquipmentF when i click the other button? thanks for your help...

Hi Alex, Thanks for your reply, yes both forms are based on different tables....CustomerT and EquipmentT Company field in CustomerT is related 1 to many to CompanyID of EquipmentT the only data i need pre filled is the current Company in CustomerF form which is open then when i click button...

Hi All, been trying to figure this out.. i have a customer form and on the form i got a button to add equipment which opens another form, my question is how can i get the same company name from the customer form to be in the equipment form once i press the button? i have done this so far...

sorted, thanks paul

thanks paul, i got that working, but it goes to microsoft one note :/ instead of opening the report Private Sub Report_Click() DoCmd.OpenReport "CustomerAddressEquipmentR", , , "company = '" & Me.Combo10 & "'" End Sub

Hi All, This is more than likely very easy to sort, but i can't work it out I have done a report for customers and their equipment, but it lists every customer, what do i need to do just to get one customer and their equipment on the report?? thanks peter