Search results

thanks, i appreciate your help

thanks for your reply.... yes, more or less, that what i was after. which bits need to be edited in the module for it to work with mine? thanks for taking the time to help

hi everyone, just wondering if it was possible to have a box that returns the % completion of the current record depending on how much data/how many of the fields of the record have been filled out. e.g. fields with containing data / total number of fields * 100 possible or not? if...

thanks for your reply...i was looking for something more detailed...i want to type the postcode and the address options pop-up. i was wondering if it was possible to link it in with an online lookup or something?

hi guys, Just been asked this and not sure if it is possible... they do not want to pay loads of money to the royal mail for their postcode/address data. but they want a faster way (like typing postcode and address options popup) of entering addresses. There are tons of websites that can be...

it didnt work for the ongotfocus event but it worked for the click event...thanks for the code

i wouldnt mind them scrolling through the subform if it were to move the page down to see other records. the fact is that when scrolled it makes the records disappear/become invisible. The data is still present but it looks as though the subform is empty.

Hi guys, not sure which section to post this so i hope here is ok... ive made an input mask for a postcode field. problem is its really annoying having to click the beginning of the field to enter data in the correct area of the input mask. Is there a way to automatically set the cursor to the...

you may need to make a query that counts the amount of each product in the report. Then you just multiply the qty of each product bought by the price of each product to get the total from that product. i have attached an example of the query just make a list box or something based on the query...

hi everyone, i have searched the forums for hours but cant find an answer... i have the mousewheel.dll to disable scrolling through records with the mouse. this works fine for my main form. however when i click on my subform (continuous) and scroll it makes the records in the subform...

PERFECT! the report that these figures were based was linked to a query where the dates on a form determined the results. I had to also add a date column with the same date function like Between(start) and (end)... for it to work in the correct context. thanks for your help...

sorry for wasting time....done it... was very obvious

been trying for hours to fix a problem. my db was working but now when i open one of my forms it opens with a enter paremeter value box saying Forms!frmServiceDateSearch.txtSearch and then the second one saying Forms!frmServiceDateSearch.txtSearch3 its probably something really obvious that...

thanks dreamweaver, useful to know but boblarson's idea was more helpful...thank you both

haha, don't worry i did it just as you replied. thanks for the idea, just takes a bit of thinking....

ok, but how does the form return results on a report? i know how to make search forms that use queries to search in txt boxes. i also know how to include a calendar to enter dates. but i return results to a list box. how do you return many results to a report.

thanks for your reply. is there no other way? does that mean you have a form with the start date/end date boxes in and when you click a button it puts those values into the query which opens the report or something? is there not a criteria you can put into the query that would accept anything?

hi everyone, i have a query that is used to generate a report. the report is based on date so i enter the following into the date criteria Between [Please enter the date you wish to start the report] And [Please enter the date you wish to end the report] it works fine however the problem is...

hi everyone, i have made a report of all the services we offer. I would like to know the code to put into a text box at the bottom of the report to tell me the count for each service and the total that the service has made, for example Finishing Touches = 3 (bought) Total from service =...

FANTASTIC!!! you have no idea how much you have helped me the past couple of days.... so much thanks! i will be sure to pass knowledge on! thanks again