Search results

Hi all i had the fsetaccesswindow module working fine but now it has stopped doing its job ( gone on strike ) I have made no changes debug is fine on loadevent i use call fsetaccesswindow (SW_SHOWMAXIMIZED) any ideas please

now i am getting ENTER PARAMETER VALUE FORMS!FD!FDSUBFORM!JOBID any other ideas

I have a query that i want to look up values from a subform any ideas my form is called FD with a subform Called FDSubform and a field named JOBId Basically after the subform shows me results from the main form the query will look up the JOBId from the subform at the minute i am getting in...

sorry getting confused now as i am a bit new to this i have a form called FD within the form i have a subform call FDSubform in the subform is the field JOBId the subform is based on a query called QueryFindRecord which looks up values in the form header which works fine i just want...

still cant get it to find the control my form is called FD my subform is call FDSubform so is it Forms!FD!FDSubform.Form!JOBId or Forms!FD!FDSubform!JOBId

I am trying to enter a criteria based on the JOBId to open a query so if the job number is 258 when i click the field it then opens the query i am fine with the commands it is just the criteria for the query i can do this [Forms]![Deliveries]![JOBId] But what is the subform version is...

http://www.postcode.org.uk/country/uk/_postcode-distance-calculator.asp

Hi all, Is there a way of screen scarping a website to give me the results on my form this will be based from a postcode to postcode mileage result thanks all

I have a form that looks up various records the current funtion i use are like this Expr1: [bookingdate]=[Forms]![FindDelivery]![bydate] Or [Forms]![Finddelivery]![Bydate] Is Null How do i get to look up the month values i.e. if i select october i want to see records entered in october

I am trying to create a form to search records from a table the text boxes and combos will be: By Specific Date By Date Range By Customer By Order No By Invoice No By Month Any ideas on the simplist way of tackling this as i dont want to really create millions of queries if possible Many...

I have a form that shows me all invoice numbers that have not been invoiced and a command button to the right of the invoice number that prints the invoice but what i am trying to do is when i have printed the invoice for the given invoice this is then updated to Invoiced=Yes here are the...

I have a report for print invoices these are printed from a form so i can either print the invoice for a selected customer or print all invoices the problem is when i print for a selected customer the report is fine but when i print all, i am getting all records for every customer on one...

probably really simple but i need the code or a macro to print 2 copies of a report the report name is DetailedInvoice thanks all

Hi all, i am looking at changing my address fields with 1 list box the problem i think i am going to face is that these fields are automatically filled in from results from a query but i need the address to have a couple of blank fields for the house number any ideas

how do i do this

I have a form based on a query for jobs that have not been printed Can you add some sort of grouping to the form or query as at the minute the form looks like this please note that these all have a seprate job id and the only information from the query i want to see is this customer inv...

Hi there thanks for the reply, the problem i have is that i have never used modules could you explain where and how i use this thanks

hi there i have a report based on a query where all my records are printed based on where the invoice field = "no" then i have a button to print these i am trying to put a page number on the report so if there are 3 pages for a given customer it would be like 1of3 2of3 3of3 then the same...

thanks for your reply tried that and got totally confused with the whole setup as my orders are quite different as i do not have products etc.. any other sugestions this task i thought would be quite simple but this does not look like the case

Hi all i need urgently if any body can help with the following i have finally got my customers, invoice and invoice detail to communicate with each other ( finally ). but what i am trying to do is on my form i have the invoice as the header and the invoice detail subform below and i am using...