Search results

pat & namliam, thanks for the inputs..... :cool:

thanks Pat, it worked on forms and reports. Just curious about it, is it possible to store the difference in a third field? how bregs:)

Hi, I have here a situation wherein i have two date fields a "start date" and an "end date". I would like to have a third field in the same table that would automatically store the date difference of the two fields in minutes... How will this be done? Any help is highly appreciated.... thanks

try: obxls.Workbooks.saveas ("D:\NTL\Phase II Data Comparison\Output Files\Data Comparisons\" & filename ".xls") to save file automatically.. :)

hello all, I have a question on replication, 1. Do i have to redistribute replicated copies after some modifications on object in the database? 2. Does synchronization on replicated copies includes the modifications on forms, reports, queries, objects etc... from the master database? 3...

:) Thanks for the idea TimK...... it worked this way... . . . xlapp.ActiveWorkbook.SaveAs ("C:\" & " BSSDAR" & Format(date, "mmddyyyy") & ".xls") . . . thanks :)

Thank you very much Timk, for your help....:) I still have a question though regarding saving of files with "save as" method... from the code below, how will the code be if i would have the file be automatically saved as another file name bearing the current date when the file is generated...

Hello TimK The table being querried has the fields arranged in this order... network_element, implementation_date, activity, mar_reference, service_affecting, site_name, start_time, end_time, notes, remarks, contact_person, bsc_engr, date_received, issued_by... how would i remove the field...

I'm just wondering if how important will setting a primary field be in an access database. Will this ease some processes? I created a database but hasn't yet figured out the importance of a primary field.... thanks :confused:

Hi Timk, Thank you very much of your help, finally it got working. I have modified some of the code you gave... here is the modified version of the case statement... If [Forms]![frm_reports]![frmnetworkelement].[Value] <> "BSS Iligan" Then strSQL = strSQL & "WHERE...

yes the [network_element] is a field name.. It is like if you chose "BSS Iligan" in the control(forms!frm_reports!frmnetworkelement) the query would output all the records between the "beginningdate" and the "enddate" Else it the query would return the records with the specific value of the...

Hi Timk, I am still getting the "too few parameters. expected 1" error at this line.... Set Rsdb = DB.OpenRecordset("qry_bscactivity", dbOpenDynaset) attached is the edited code. I removed the AS expressions on the query so as not to complicate/confuse me.... thanks

:) thanks Tim, The code below from the one you supplied prompts a "syntax error": & [forms]![frm_reports]![beginningdate] "# And #" _ & [forms]![frm_reports]![enddate] & "# " _ & "ORDER BY [tbl_bscactivity].[network_element] DESC;" plsss help me again million thanks

hello pat, I had tried your suggested script below but it prompted a run time error: OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET. the error points to the line: Set QD1 = DB.QueryDefs![qry_bscactivity]

I would like to ask your help regarding parameter queries. I badly need this with my project. Please share me a sample database file that uses the parameter query.....:confused: I wanted to learn the querydef method, how to reference a value. Method below was suggested to me but then i dont have...

:confused: i'm having a hard time with what you are suggesting. I am still learning(newbie) VBA, i havent have any idea about create/using Querydefs. Can you please share with me a sample database that i can study. Also i dont know how to reference values from a form. please help me....

Can somebody please help me with this: highlighted during error: Set Rsdb = DB.OpenRecordset("qry_bscactivity", dbOpenDynaset) heres the code: Private Sub Command0_Click() Dim DB As Database Dim Rsdb As Recordset Dim i As Integer, j As Integer Dim RsSql As Variant...