Search results

HI I have maintainence database. what I have is a table called machines , one called tasks another for the tasks information and I want to try and automate it more if possible let says I have a drilling machine , that needs 6 tasks doing to it , 1. check oil ( daily) 2. check...

hi I have a form, and 3 subforms within it the first form lets me select a "group no" and description the first subform lets me select a assemble part number and is linked via that group number the second subform lets me select parts for the assembly the last subform let me...

HI , I have a table with over 10000 records and it is growing the part numbers all begin with 1/ then either a.p.c and s ie 1/a, 1/p these are followed by numbers 1/a264-001 0r 1/p264-001 the a.b.c.and s represent the name of the company the 264 represents the family of...

thank you now working ok steve

hi. I have a form that whe opened it opens in datasheet view but when I open it with this code if opens in form view could you please help me so that it opens in datasheet view from my code Private Sub Command375_Click() Dim strInput As String Dim strMsg As String Beep...

hi, yes. but I need a invoice header, for invoice dates, shipping cost etc and special invoice information that is not on the order details. and don't want them to be. i also need a invoice qty field for all the items in the order incase I part invoice the some of he order. but i could...

hi I an trying to get the order details into the invoice report except for the order qty as his may vary but I need to be able to change that in the invoice details form If I put all the information in the invoice details form it works Ok But this is not the correct way steve

hi I have a query that I am really struggling with. been working on it for days I am trying to create a invoice for the 8 items in the orders subform on the "invoice form " but I need to be able to have free input to the "quanity 1 "field as I might not invoice the full amount at...

hi thanks yes having tried to save a file like that would not work thanks. now ok steve

hi, I did try this but got this error message " the output to action was cancelled" I used this code ' strFullPath = varFolder & "\" & "Ackowledgement number " & " " & Me.ID & " " & Now() & ".pdf" steve

hi, I have a macro that sends a report to a folder in " my documents " below is how the file name of the report is created but I have discovered that if a need a paper trail it cannot do it as when I resend the report it just over write the old one. can a date and time be added to this...

hi , thank yo for all your help it work great really appreciated steve

hi, I would like to be able to open the form in ADD mode but not sure how to do that also if possible how to minimise the form instead of closing it thanks steve

hi, this is the code I use to get the user to put the password in how can the code be changed to hide the password when the user is inputting it can an input mask or colour of the text be changed for when they input it thanks steve Private Sub Command369_Click() Dim strInput As...

hi thanks the database that you sent back does not have any button on saying quote to quote that why I am confused could you please resend me one with both buttons on if it is not to much trouble steve

hi, thanks or trying to help me . 2 things I cannot see where I can copy quote to quote when I copy quote to order it is doubling up the order details thanks steve

hi , thanks for your help I cannot get it working I have attached the file for you to see what I am doing wrong thanks steve

hi , this is the code that I have tried to modify and sql I have but like I mentioned the subform details keep doubling up and I don't know why

hi, the copy of the main form works ok to the new quote. this transfers ok. It then gets the new quoteID ok and puts it into the append query. but this is doubling up in my new quote that's the bit I am struggling with this is the part of code that gets the new quote id and...

hi, with help from a member I can now copy a quote form and subfrom to an order. this works great I have been ask if I can now copy a quote to a new quote, also the subform I have tried to modify the macro to suit what the other member did for me but it is not working correctly when I copy...