Search results

Yes, but only when I pick 31-1-06 from the calander. If I pick 28-2-06 then I want only those records which are from February 06. So, the query will need to look at the unbound field that contains this information - but I am not sure how to achieve this. Thanks for your help so far. Cheers Rob

Hi RG No, sorry, I have the calander, what I need is to be able to select records based on when they occured. IE if I spent a certain number of hours working on a project in various different days in Jan 06 and then spend some more hours on the same project in Feb 06, I want, at the end of Jan...

Hi I have a subform on which I log the times spent on any particular project. I have another subform on which I want to select a month and use this to select all the instances on which work was done on any given project for a particular month. I would prefer to use a pop up calender to...

Hi Nateobot No, the global Tools/Options settings seem to override any SetFocus commands in the code behind the button. I'll see if I can figure out ghudson's suggestion - not quite sure where these SetOption expressions go however!!! Thanks again Rob

Hi nateobot Thanks, that works to a certain extent, but it also changes the default in the 'Look in' field as well as the 'Match' field. I want to look in only one field - as defined by a SetFocus code in the on click event of the button. Cheers Rob

Is there any way to change the default settings on the Find and Replace dialog from 'Whole field' to 'Any part of field'? Thanks very much in advance. Rob PS Happy Christmas!!

I have a calculated field whcih returns the amont of time spent on a project and it is formated to hh:nn:ss. I would like to be able to multiply this by the hourly rate for the project which is in pounds sterling. At the moment I have =[TimeSum]*[RateChargable] but this does not return the...

I have a form showing projects and on this a sub form which calculates the number of hours worked on a project on any given day (it uses a simple stop watch routine with start and stop buttons). What I would like to achieve is to be able to create an invoice report which will show the time...

Thank you very much Ken. It works perfectly now........the phrase "Why didn't I think of that!", springs to mind! Thanks again, cheers Rob

I have a problem with an IIF statement which I am hoping someone can help me solve. I want to print an envelope – rptC3DEnvelopeDL. The data from this envelope comes from a form – frmClients – which in turn has a subform on it – sbfClientContact – which gets its data from a form – frmContact...

I have a form – frmProjects – on which I have put a subform which has a stopwatch on it. What I want to achieve is that I can keep the cumulative times for any given project on any given day so that they can be totalled and billed accordingly. I am sure this is easy but as I haven’t worked on...

Thank you very much Doc Man. Your suggestion seems to have worked. I have never had need to look into references before - I guess I shouldn't have worried. Thanks again Rob

Just upgraded and I get this error message whenever I open a form and quite a bit of my code does not seem to work. Your Microsoft Access Database or Project contains a missing or broken reference to the file 'MSOWC.DLL' version 1.0. Does any body have any clues as to how I can solve this...

Hi Namliam I sent a version to namliam@hotmail.com. Did it arrive?? Cheers Rob

Hi Mailman Tried to delete as much as possible - still too big to send to the forum. Can I email it to you direct? Rob

Hi namliam It's hard to know what to send - the database is too big, even when zipped, to send in its entirety and its very hard to split it up into bits. If I get a chance maybe I'll make a small sample dbase showing what I'm after. Thanks very much again Robert

Thanks namliam Yes, I'm afraid I do need help. My VBA knowledge is sketch at best, so any advice or more detailed help would be very greatly appreciated. Thanks again for your reply Cheers Robert

I have a combo box - cboSupplierName - which is synchronized to another combo box - cboProductCategory - on the same form - frmOrders. Thus suppliers only appear in the second combo box if they fall within the category selected in the first. This category is initially selected on a combo box on...

Thanks AlanS The list box is currently unbound. What should the control source be? The Row source for the list box is the table which contains the ProductCategoryID and the ProductCategory. Is this what you mean by the selected property? Sorry if these are basic questions but my knowledge...

I want to base a subform on selections made in a multi select listbox on the main form. Currently I have created a hidden field on the main form to hold an index of each of the values of the selected records from the list box and I am using this hidden field as the criteria on the query which...