Search results

Yes, the master/child fields are still linked. I have so many forms, tables and queries it will take me a long time to import everything into a new file. I've tried compact repair, but no luck. Thanks

Hello, All of the sudden, the three bound subforms are not being recognized by the Parent form. I get an error message "run time error 2455 invalid reference to property to form/report". I opened all of the forms and they populate on their own but do not work when bound to the Parent form...

Sorry, i found the problem. I was missing "s" in tbl_Projects. Also, i changed how I was calling the function and it now works.

Here is how I call the function: Dim varR As Variant Dim run_name As String run_name = Me.txtCurrentRun.Caption varR = DLookup("[user_role]", "tbl_User_Control", _ "[ID] = 1") Debug.Print varR Call Modcontains.CompleteReview(run_name, varR) I'm still not sure what "too few parameters"...

Too few parameters error in function Hello, I've wrote a function that should accept two parametes and the third one is optional. However, if I don't supply the third parameter "compare_res" when I call the function, I get "too few paremeters" error. Is there a way to avoid this error? I...

Refreshing didn't help. The form connected to the table is a sub-form. Also, when I add a new record the form is filtered... not sure if it's causing the problem. When I open the table, I see the added record but it's not visible on the form.

Hi Dave, "data entry" was set to No. I set it to Yes but the same problem persists. Thanks

Hello, I use the following code to add a new record line and populate it with values. Dim str_sampleid As String If Me.cmb_samples.Column(0) = "(All)" Then MsgBox "Select sample to add new record" Exit Sub End If Application.Echo False Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec...

@Minty, I've tried it both ways. It still throws an error. The code seems correct to me but yet I get error messages when I run it. Thanks

Hello, 1. I get type mismatch error at: strWhere = strWhere & "([run_date] >= " & Format(Me.txtStartDate, conJetDate) & ") AND " if either the start or end dates are left blank. I'm not sure why this is happening. both field types are "Short Date". 2. Also, after I clear "Refresh Button"...

Here is my latest attempt: strSQL = "SELECT tbl_panel_genes.Panel_Name, ConcatRelated(Gene_Name,tbl_panel_genes,[Panel_Name] = """" & [Panel_Name] & """""") AS Expr2" strSQL = strSQL & " FROM tbl_panel_genes" strSQL = strSQL & " GROUP BY tbl_panel_genes.Panel_Name...

Hello, I would like to convert a query that uses a function to vba: I'm using the following function: http://allenbrowne.com/func-concat.html This works well as a query: SELECT tbl_panel_genes.Panel_Name, ConcatRelated("Gene_Name","tbl_panel_genes","[Panel_Name] = """ & [Panel_Name] & """")...

Hello, I import data into a temp table and then run an Update query (below) to add data to the accrual table. I want to display a custom message instead of "Primary key violation error" if the user tries to import the same file twice and terminate the program. The "run_name" is the primary key...

thank you!!!!

Thank you, it worked! One more follow up question if you don't mind? What is better db.Execute strSQL or Set rs = db.OpenRecordset(SQL, dbOpenSnapshot) to execute a query statement? I'm writing a function that will execute one of the queries specified in the select case statement. I'm...

Now I get a type mismatch error at SQL & "WHERE [tbl_Variants_temp]![sample_name]) Not Like " * str_HD * "" Please advise... Sub excsql() Dim SQL As String Dim str_HD As String str_HD = "HD753" SQL = "INSERT INTO tbl_Variants ( sample_id, flag, gene, exon, cDNA, aa_change, AF, FR, RR, FA...

Hello, Please suggest how to convert the following SQL to VBA. I get an invalid character error at "_". Thanks for your help. Dim SQL As String SQL = "INSERT INTO tbl_Variants ( sample_id, flag, gene, exon, cDNA, aa_change, AF, FR, RR, FA, RA, cosmic_id, transcript, conseq, zyg, amplicon...

Hello, I'm trying to look-up calculated field "items" from "qrysamplecount" query and display it in another query "qryProjectDlookup". I'm not sure why it's not working. The first query is called "qrysamplecount" and returns the number of samples for each project and the main query is called...

Hi Steve, sample_id is unique but the sample name can repeat. So yes, in way sample type can be the same. please see the attached. Thanks, Mila

Hello, A continuous form “frm_Projects”has a list of distinct projects and attributes (created date, number of samples, sign off dates). The query behind ”frm_Project” form uses tbl_Project and tbl_Samples and Group by to count the number of samples in each project, thus I don’t want to add...