Search results

Hi all i have 2 forms for one of them i use the setfocus event to take me to a field on the form that is still open the small niggling problem is that when i go to type it bleeps at me and wont let me enter anything i have to manually click on the field then start typing any ideas i use...

Hi all i am starting my new database project and would like to know if somebody can help with the following structure I would like to create relationships between my tables mainly for invoicing purposes we run a small transport company and these are the tables that i will be using the...

i have a form that shows me a distinct value which is the invoice number for a given customer as the same invoice number for that customer is in quite a few records and the query only shows me 1 of the records how do i create an update query so that say on a form the invoice number is 6145 and...

Hi all I have a form that has a control that is deaulted as "no" i want my button next to the control to open a message box that will ask me are you sure you want to mark as invoice if user is yes then the field will change to YES is user no then the field will remain the same thanks...

Hi all, How do i force a newline in my message in the message box funtion i.e. message would show like this Hello World Welcome to my World How is yours Thanks all

Hi all, I have a form and when i close this i want to goto a control on the form that is still open how do i do this Postcode Form on Close goto control "delcontact" on main form thanks simon

Hi all, Simple probably i know but i forgot how to do this my form is from a query how do i hide the blank record at the botton of the form that shows (new) thanks simon

no it is a query with this under the JOBId Field Criteria = [Forms]![fd]![fdsubform]![jobno] which looks up the JOBId in the subform I can edit the record if i enter the JOBId manually so think the problem is something to do with subform because when i open from subform it finds and opens...

Thanks for you reply Main Form = Not based on anything ResultsSubform (within Main Form )= recordscource is a query based on field value from main form fields i.e. JOBId, Customer, Town etc.. Edit Record Form=Seperate Query used from subform field value i.e. JOBId So when i open main form...

I have a form with a subform that displays search results from the main form and a button to the side of each record displayed that when i click on the button it opens another form that shows me the full details of the records the problem i have is when it shows me the record with all the...

i have a form that looks up records then displays them on a subform i want some sort of field to show if no records then display Not Found in a text box or something and Records Found if there are records thanks simon

We have 2 printers on the same PC On one of my report we print a parcel label which we use printer 2 which is a thermal printer the problem i am having is it keep printing from the default printer HP LaserJet I have tried using specific printer in page setup and chaging to thermal and...

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