Search results

hi, I have a form that has a drop down box in it this drop down box allows me to select a number and that number refers to a part description if I select the same number more than once . the query I run will show that number and description as many times as I have selected it in my...

hi I have a table called allevents and another called tblevent the 2 forms that I use are linked by a field called eventid the table tblevent will have say eventid 1 but the all events could have many records linked to eventid 1 in the table called allevents there is a cost...

hi I have a form that has a long date in it example sunday, 06 March 2016 I want to be able to sort my query without sunday in it I have tried the "left" function and the crtieria not "sunday" but neither work any help appreciated steve

hi, I have a table that say has 1000 records in it called " all events" I have a subform called tasks which comes from a query from the table " all events" at present the query is set to "no" on the completed field I also et the date field to <=now() + 7 so I only got 8 records in my subform...

hi I have a append query that looks like this what can happen is that the user could append some of the data twice is it possible to create a macro that would look at the " eventid " and the " eventdate" and not append any of the records that are the same thanks steve

hi, I have an "eventstart" field AND a " periodfreq " field , a drop down box with ( periodtypeid) 1. days , weeks , month, quarter , year and I have " recurringcount" field this then gives me an end date for the recurrence to fininsh with this formula below...

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...

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 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, 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, 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, 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...

hi In my forms quote and orders I have subforms these subforms fetch parts from the stocklist when I select the productno the material comes with it ( all good) what I want to try and do is not limit the productno or material to the stocklist when I try to changed limit to list to "no" it...

hi , I have a form called "stocklist2" I also have a table called " allocation" I want to put a field in the stocklist form that looks for the material in the "allocation" table. sums up the " qty allocated" from that table and returns that value in the stocklist form. the field in...

hi I have a table called stocklist and a table called stone type the stocklist could have many parts the same but a different colour/type at present the user has to look thro many records to select what he wants I have been asked if it possible to have the stonetype list come up then...

hi, this is the formula In my query Unit price: [itemcost]*[exchangerate] I would like it to also have the discount taken from it . the field name is discount , but I am not sure how to put that into my query. it is a percentage discount any help appreciated steve

hi , I have a form called "quote" and a subform called "quote details" I also have a form called "orders "and a subform called "order details" is it possible to press a buttom and copy the form I am in in "quote" which includes quote details to a new form in "orders" and order...