Search results

thought as much. Thanks anyway

I saw the button but was wondering if its possible to create a custom command to print. I have had no luck so far and was wondering if anyone had any ideas how to print the report from the control viewer

is there a way to print the report from the report viewer via code? Or do i have to call the orginal report and print from there? Cheers Chris

IMO That has worked beatifully. Thanks for the idea Chris

IMO Thanks for that mate - i had'nt even thought of going down that road. Ill look in to it. I had thought of just maximising access again when a report was required but puting the report on a form will look much better. Cheers Chris

Hello I have developed a database and to make it look a little more like a standalone application i have been using API functions to minimise access and by setting the form Pop-Up property to true the forms are still displayed - which gives the forms the appearance that they do not belong to...

Hello Is it possible to limit the amount of characters that are enterd in to a text box. ie set the maximum length to 4? Thanks Chris

Thanks for the reply Rich My problem seems to be in the WHERE Statement of the sql the date function you provided calculates the correct date but it doesnt to delete the records. Ie it doesnt delete the records that are older than the current date. (WHERE MeetingDate<" & DeleteDate & ";") Has...

I ma having trouble with the DB execute statement. i am trying to delete data from a table that is over thirty days old. Curerntly i am using the code: Dim DeleteDate As Date DeleteDate = Format(Date - 30, "DD/MM/YYYY") CurrentDb.Execute "DELETE * FROM tblCustomerMeeting WHERE MeetingDate<" &...

I need to add a collection to the row source IE i could have three names in my collection ie Dave, Paul and Mike. If i set the the RowSourceType property to ValueList i could add the names Manually seperting with the ';' character. I had hoped that i could somehow add the collection to the...

HEllo Is it possible to add the results of a collection to a list box? Cheers Chris

Yes. When the form is first loaded both combos are empty. Once a selection is made to teh first the second is populated and repopulated if changed.

Thanks Fizzio ill give it a go heres the SQL SELECT DISTINCT [tblEndUserDetails (Original)].[Country] FROM tblEtheylene, [tblEndUserDetails (Original)] WHERE ((([tblEndUserDetails (Original)].[MarketType])=[forms]![frmaddEnquiry]![cmbMarket])); Chris

sql statements in the row source

Hi I have a query on queries. I have a combobox in which the row source is decided by a query that depends upon the result of another combo selection. My problem is that this combo is very slow to populate. Although the tables where the info is being taken from are not that great in size. Is...

Thanks everyone got that sorted i knew you could select many primary keys in one table but hadnt realised exactly what it did. Now i do Cheers Chris

Hello Is there a way to determine if a enitre record in a table is unique rather that the individual field of a table? I need to prevent records from being entered if certain records are the same as previose records. IE i need to allow an entry where field1 and field2 are unique but in their...

I knew that...Honest!!! Thanks all

Hello This is probably a daft question but... I have hidden a table and i have tried everything i can think of to get it back. Does anyone know how to unhide a hidden table? Thanks Chris

dcx693 That would obviously be much easier. Thanks