Search results for query: *

Hey there ! You could search for MIR in the access forum . That was something i had done to read text from a file and add those required into access database. Maybe this could help you kick start things. Cheers[emoji3] Sent from my iPhone using Tapatalk

managed to make it this far Private Sub DataGridView1_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick Dim row As DataGridViewRow row = Me.DataGridView1.Rows(e.RowIndex) frmReport.ReportViewer1 = ? End Sub...

Thanks it worked like a charm, it would take some time before i get things rite. Next, how do i open a record in report viewer with a double click. Do i need to start new thread as this tread is answered.

Was wondering if you could help me out with SQL code

Not sure about vb.net but in vba its like "between forms!frmsearch!Fromdate AND forms!frmsearch!todate thenfrom forms we just call that query.

Hi jmcilhinney, Total sorry if i were not clear with my posts, here is my query search which didn't work out when i executed it SELECT FIleID, MIRType, MIRSeq, ProcessedOn, PNRCrDate, MIRCrDate, BkgTkgPCC, BkgSignOnTkgSignOn, FIleName, PNR, TicketNumber, [TCN#], PaxType, Passengers...

well thats how i've done. The query is available but how do i change the dates to a text box and show it up on the form. I've don't it for a single text field and it works fine on the form but the date range seems to be a little different.

I've added a date range query and when executing it works perfectly, since VBA is so different from VB.net i've no clue how to code it in a form. My form has two fields namely, txtFromDate and txtToDate. and my query is like this SELECT FIleID, MIRType, MIRSeq, ProcessedOn...

Hi JohnH, i've managed to change how the form loads. The form loads fast as the FILL is not used and moved that to a button when clicked populates the whole database. I know thats kinda stupid to do as the db grows its going to be a problem. On my access VBA i've used a date range to avoid the...

anybody, a little help !

Hi JohnH, tried your code here as shown below Public Class frmSearch Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'Backup_GAPDataSet.qryMIR' table. You can move, or remove it, as needed...

Hi jmcilhinney, without the filter shows all the data how can i stop it from loading when the form loads and rather display them as the text box is filled-in.

Ahmmmm ! didn't know what put in since am not much of a "Programming guy". sorry about that and how do i correct it ?

Tried GetDataAsync() gave an error " 'GetDataAsync' is not declared. It may be inaccessible due to its protection level. "

Hi jmcilhinney. Thanks for the reply. Your links did help me get started. Was creating a form to search a query in Ms access. Manged to do all but a little in doubt about the below code. all works well but do not wish to display the data as soon as the form load Public Class frmInvoice...

Hi all, I've managed to create an ms access application. i wish to do this in Vb.net with MS Visual Studio. Would that be possible. I've tried a bit but the codes are different.