Search results

I am trying to run a report and im getting an error message saying 'Cannot open any more databases'. The database is quite big, 12MB, and has numerous tables, queries, forms and reports. The report consists of a number of subreports but I have a similar report that opens up fine. Has anyone...

I was recently told by a SQL Server developer that you should never use a _ (under score) when naming tables, stored procedures etc, for example, tbl_Project_Details as SQL has issues with the _. Would this be an issue with MS Access? I have a fairly large database, just over 8M in size, which...

doesnt work

on all the subreports or the main report????

I have a report that contains 9 subreports. Each subreport returns records for a particular sections. Each section starts on a new page, so there will be a minimum of 9 pages each time the report is run. This works fine but when a sections has no records to return there is a blank page printed...

I have a memo field on a form and i've just realised that by pressing the return key you move off the memo field and onto the next control. I pressed the return key to go to a new line, is this not possible?

I have subforms on a tabbed form (one per tab). I have placed a text box on the subforms to count the number of records, which I then display on the main form so user knows how many records there are without having to scroll down the subform. This all works fine but when there are no records...

thanks that works, must be because im using a pop up form, usually I use a normal form, the report opens but the form is still open in the background.

yes, I close the pop up after the report opens

I have a simple pop up form that I am using to get the user to enter certain parameters that are feed through to a letter report. When the report preview opens the parameter values have been carried through as expected but when I click the print button on the menu bar nothing happens. I changed...

I have used DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF, "Template.doc", True to output a report to MS Word but it doesnt carry across the look of my Access report. I had labels coloured grey with darker grey borders etc. Is this possible or is it only possible to copy across text?

I have a report that is made up of 10 subreports. I have created the 10 subreports and linked them to a main report. They are all in the detail section of the report. I want each subreport to start on a new page but cant figure out how to do this or if it is possible.

I am pulling a comments field from a table into a continuous subform via a query, can I add an unbound text box to the continuous form that will place a number beside the record or is there something that can be done at the query level to do this? I dont want to use the records ID field as the...

I have a 2 continuous subforms on a form, subform 1 is linked to the main form and subform 2 is linked to subform 1. All working fine. However I have noticed that it can be quite difficult to tell what record in subform 1 relates to the records you are viewing in subfrom 2. I was looking to...

I created a database and used this code to populate a continuous form. It works fine. I have now decided to use a SQL Server backend. When I go to open the form now I get an error message, 3622, "use dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY...

thanks, works a treat now!

I have put a piece of code on the after update event of a form to insert what unit has updated the record last. Private Sub Form_AfterUpdate() Me.ProjectWithUnit = Me.Unit End Sub The form is made of a tabbed form. I have code on the load event to fill out 3 fields, the username, user...

I have a table of 6 counties, when my form opens the continuous form is populated with the six counties names in the table, users then tick check boxes to shows which counties are included in their programme. There will be no more records added so therefore the blank row isnt needed.

I have a continuous form subform on my main form, I have populated it to show that choices avaiable. This works fine but it shows blank fields at the end for a new record. Is there any way to remove this new blank record. I have tried to change the properties to allow no additions but then no...

I have thought about trying to set up a project documents database, it would hold details about a project document and then attach the document. I am basically trying to mirror a similar Lotus Notes system my company uses. I have created small prototype containing a table and form. The form has...