Search results

I have just been fiddling around with the code and it works beautifully I made a slight ammendment so a message appears when you are at the end of the recordset saying The only thing is could I stop the default values coming up as the last record? Thankyou Dcb and Zigzag, I wouldnt have...

sorry Dcb, I stand corrected, your coding works

Hey Dcb, I just tried your code and thats not making a difference either

Hey guys I attach a sample of the database.....another thing I have noticed is when I click the next button (Later Notes), eventually the textboxes show default values....... Anyway, I hope the database gives you an idea George

Ok, I'll just make a sample now

I have just tried using the above code and it works, it takes me to the same recordset with the Id number equal to the number in the textbox, however once I reach the end of the recordset now, I am getting the error I have altered my code now to cater for error 2105 instead of the error 2905...

Hello Zigzag, I just attempted that and its not making a difference...thankyou for your response though George

The textbox is on the form, and it is retrieving its value from a textbox in another form with the below code in its default value.. =[Forms]![frmIssues]![Issue Reference] The buttons then browse all of the records that have the same Id number as the number in that textbox. Hope that helps...

Hello Dcb, thankyou for your reply The only problem with that is that the buttons are running with macros..... Amateur, I know, the only reason I am not running my buttons with vba, is because when I press the buttons next or previous, I want the records being retrieved, to have their Id...

Hey guys I have a form with textboxes retrieving data from a query. On the form I also have 2 buttons. One takes the user to the next record and the other takes the user to the previous record. The problem arises when the user reaches the end of the record set...basically runs out of records...

Hey guys, Jr you are right! Below is a snippet of the code: Private Sub Report_Open(Cancel As Integer) If ([Forms]![Cars1]![ChckAss] = True) Then Visible = True Else Visible = False End If End Sub I was also majorly going wrong with the fact that the form was...

Thankyou smig, I will try that and let you know Thanks again

Hey guys After reviewing my snippet in the post above, it couldnt be further from the truth. Below is a more refined snippet: If ([Forms]![frmCars1]![ChckAss] = "True") Then rptIssSummary.Visible = True End If FrmsCars1 is my form, ChckAss is the checkbox in that form and rptIssSummary is...

Hey guys I have a few subreports in one report. I want the condition where if a checkbox is checked in another form to determine if the subreport is going to be visible or not in the main report. Below is a snippet of the code I am using but it doesnt seem to be working. Private Sub...

That is what I am trying to do aswell. I have 3 independant reports, each with their individual queries, but at one point I need to combine all 3 into one large report, does anybody know how to do that?

Hey mate, how exactly did you alter the settings?

Yh, thats a point, as I dont have Visio installed on my computer :confused:

Oh ok, thanks again for your response atomic shrimp, I wonder what would be the advantages of using visio charts, and if so if theyre flexible whilst imported into access. If for instance the data changes, will the chart change accordingly :confused:

Thanks for your response atomic shrimp, if it is a visio chart, is it possible to integrate a fully functional visio chart into access, which varies upon data and what have you, or is it just simply a model which the previous developer used as an example? Thanks

Hello guys I am creating a database for my new employer and in the database he wants me to include the same chart which I have attached. Now I have searched around in the internet for this including other posts on the forum and havent seen anything like this before. In the model database...