Search results

I have a form with a query based bound combo. The same combo can be found on another form which can be launched from the original form. I want to update the combo on the original form with the same value as the combo on the launched form (after update). In my after update event I have the...

Thanks Wayne. I was hoping to avoid doing either of those because; 1. If I have to change the query in the future it means changing the code rather than editing the query in the query generator which is inconsistent with the rest of the database. 2. I didn't really want to write a function...

I have a query which has a form field name as part of its criteria. There are two forms which access this query from their onload event (its a delete query). I would like to vary the field name in the query dependant on which form is executing the query. i.e If form 1 runs the query I want to...

Thanks Wayne. I'll try that. Can I assume then that errors cannot be trapped and reported during the printing process? There are other potential problems that could occur that I would like to make provision for.

I've developed a report which uses code to set the properties of a picture control in-flight. I use this method to display unbound jpegs. Occasionally a file name is incorrectly entered and when the report runs it fails because the file does not exist. When running the report in form view an...

I am writing a complex report which contains 18 subreports. I have been suffering problems all along with errors related to the number of databases that are open and seemingly the amount of memory being used. Essentially the report is all based on data from a single query but because it needs...

I have a form with a subform with a subform. All of a sudden the second subform has stopped appearing on certain records. Yet if you go into design view and back into form view and select the same record its back again. This form has been heavily redeveloped recently and the table that it is...

Sorry to be a pain but this really is causing problems. Does anyone have any ideas?

I am getting error "too many databases open" when running a new report with 20 subreports. Does anyone know what causes this?

I have a certain set of tables in my database that are used in a particular section only but keep reporting the following errors; Not a valid bookmark The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time...

SELECT tblCustomerEnquiry.EnquiryNumber, tblSiteDetails.SiteName, tblContact.CompanyName, tblSurvey.ContractNumber, tblBulkID.ContractNumber, tblProject.ContractNumber, tblCustomerEnquiry.ContactID, tblCustomerEnquiry.DateReceived, tblCustomerEnquiry.ContactSourceID, tblCustomerEnquiry.Quoted...

I have a "search form" which uses combo boxes to select records and display them in a list box at the bottom of the form. There are five combo boxes all accessing one field from a table using a query. The list box is based on a cross table query of the five tables and uses the values in the...

Thanks guys. I thought that it would be a feature of Access somewhere but the methods you've given are effective. FYI; I used the Control Source of a text box. Cheers.

I've got a label followed by a variable length text box followed by another label. How do I format my report so that the second label moves left or right dependant on the length of the text box? i.e My name is [text box] and I'm pleased to meet you. How do I get pleased to meet you to move...

Hi all I am compiling a report which will have several pages (about 12) of text containing variable data followed by a variable length section of 1 record per page and finally a conclusion, again with variable data. The report builder seems to restrict me to 55cm in the report header which...

Hi all. Get a compile error "Sub or Function not defined" on the following statement (the AddrOf bit); Sub sHook(Hwnd As Long, _ strFunction As String) lpPrevWndProc = apiSetWindowLong(Hwnd, _ GWL_WNDPROC, _...

I've got a listbox control on a form which I'm populating with a query each time the form is loaded. The query will only ever select one row. I would like to place the contents of the Listbox control into a string but I'm having real problems. Despite the fact that I can see a value in the box I...

I think you've misunderstood. I'm supplying the date range as a parameter i.e 01/05/2004 - 04/05/2004. For each date within that range I need to run a distinct query headed by the supplied date. If I use 'between' I'll get one query with all of the data for this period. I can't group by a date...

I've developed a query that uses a date from a control to produce a report headed with that date. I'd like to modify this so that I can enter two dates and produce a report headed with each date within that range or alternatively run the report for each date within the range. Is this possible?

I've tried this but with no success unfortunately. My subform is actually part of another subform as well. I've tried [forms]![MainForm]![SubForm]![subfrmQuote]!