Search results

I think there was a sort or filter in place for some reason. After going through the individual settings on the second form and reverting them back to defaults everything started working properly. Happy days!

We have a form in our database that I would like to add a button to which opens another form when you click on it. I can get the button to open the other form however if I try and edit anything on the form the message "This Recordset is not updateable" appears in the bottom left hand corner of...

The format property of the textbox on the form is currently #;-#;"";"". If I change it to ;;0;0 it causes strange behaviour when clicking in the text box. I tried changing the format to General Number but this then omits the decimal places. I then set the format property to Standard (don't...

Hi all, Could anyone tell me how to make a text-box field on a form display a zero? We have a form linked to a table on our jobs database and I need the ProposedFinalBillAmount field on the form to display a zero. The field on the table displays 0.00 which is fine, however the form clears a...

Hi all. Just wanted to come back and say thanks again for all the assistance with this project. We went live with the database about six weeks ago and it turned out to be a big success. No problems whatsoever and the introduction of the database has made a big difference to the organisation of...

Thanks Gasman - I went with the filter parameter within the report itself.

Hi all, We have a report in our job database which lists all of the jobs currently booked in; it sorts each record based on the date it was booked in. I would now like to create some additional reports, for example all jobs booked in over 60 days ago. Is it possible to add selection...

Thanks a lot for the replies. Much appreciated. I'm not familiar on how to test if there is anything to display first or the Nz() function - any pointers on how to do these? We would need to be able to either hover the mouse over the field if there is some text in it already, or be able to...

For the text boxes/fields where they already have some text in that works perfectly, however when I click in to empty text boxes to enter some comments I get: Run-time error 94 Invalid use of Null

Hi all. I have a text box on a form which allows users to enter comments in to a record. The field is a standard short-text field but I was wondering if there is any way to configure the field on the form so that if the user hovers their mouse over it then it would display the entire contents...

Many thanks for the replies. Makes sense that Access itself is required. Cheers

We have almost finished testing our database and will be looking to go live with it soon. In terms of preparing the database for end user access (approx. 50 people on and off) is it best practice to leave the database in .accdb format and for users to load it via Access on their own...

We have an Access database with various forms, reports etc. I would like an email to be sent out automatically each week which contains a PDF version of a report as an attachment. It would need to run automatically according to a schedule rather than requiring input from a user. We use...

After referring back to some code with comboboxes which you previously helped me out with I figured it out: DoCmd.OpenReport "All Open Jobs", acViewPreview, , "[dbo_tblPartner.ReportField]='" & Me.PartnerCombo.Column(1) & "'" This seems to work great. I added this to the After Update property...

It would be column 1 from the combo box that contains the value to pass to the report - would I need to specify this somewhere in the code? Also, would the code go on the After Update property of the combo box?

I agree a combobox would probably be better for this. As you rightly say if personel change it means editing the form. I can add the combobox to display the correct source list of people, but what would be the right code to use? This is the code that I have in place for the text box: Private...

The first one worked a treat: "[dbo_tblPartner.ReportField]='AT'" Thanks very much to you both.

Thanks both. I removed the parameter from the query and used the code below to run the report however the report just runs without displaying any data. If I can get the report to run and select all of the records where tblPartner.ReportField equals the initials AT then I think it will work...

Thanks Minty I've had a play around with this using the On Click property of a text box. I can get the report to run using this code: DoCmd.OpenReport "All Open Jobs - Partner Select", acViewPreview - This runs the report as normal and prompts for the initial's to be typed in. But if I try...