Search results

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

ok, i will try to do a report, then i guess i will try codes on this forum again....maybe thats why they didn't work!! thanks peter

Hi pbaldy, thanks for your reply yes sorry, all the data off the current form .HTMLBody = "Text" & Me.TextboxOnForm & "more text" & Me.AnotherTextbox that works for customer details - which is a start (even tho i would need about 20 extras, lol)...........thanks for that :) but i also have...

Hi All, i've looked this forum for working code to send current form via email, but nothing seems to work for me, i did manage to find code what did work to send email when i click button on the form, but there is no code in it to save current form and send that. this is the code i found, is...

Hi kyo, thankyou for all you have done, works again :) peter

Hi JHB, thanks for the reply, but i really have no idea where to look and how the log works, i copied it from a site and it was working for me so i kept it, lol......i have got a older version of my db with it working but i still cannot find what is causing the problem :banghead: thanks again...