Search results

I've tried the following unmatched record query that returns one record that is present in the "tbl_Variant_qry" table but not in the "tbl_Variant" table, however, when I convert the select query to an Append query shown below I get an error message "You've tried to assign value to a variable...

I would like to insert records to "tbl_Variants" where [ID] (primary key) doesn't match records from the "tbl_Variant_qry" table. There is one record that fits this description however the query fails to insert that records. Please suggest how to fix the query. Thanks, Mila Here is the sql...

Hello, I would like to send a query to R and execute R script from a command button in Access. Has anyone done this before and can suggest how to implement this? Thanks, Mila

i got it working!!! I've replace the query with a filter. Thanks for your help, Mila Private Sub cmb_info_Click() If Nz(Me.ID) <> "" Then Debug.Print Me.ID Debug.Print Me.cnv_id [Forms]![frm_combined_CNVs_with_Comments]![frm_cnv_reportable_comments].[Form].Filter = "cnv_id = """ &...

Hi, Thanks for your response. I understand that this might not be an ideal design but is there a way to refresh a subfrom from another sub-subform? If it can't be done please let me know and I will have to figure something out. Thanks, Mila

Hello, I've made a complex sub form configuration (please see the attached image). I have a series of sub-sub-forms with buttons next to each record. When the button is pressed I would like to query another subform "Reportable comments". How do I correctly refer to that subform from a button...

I've done some reading and many suggest creating a side end. http://www.granite.ab.ca/access/temptables.htm Is this a good idea? Thanks, Mila

I'm planning on splitting the database and storing the tables on a network drive. About five people will get a copy of the front end. I'm not sure where the temp table will be stored front/back end and which end I need to repair.

Yes, I was thinking of rerunning the temp table code each time the user accesses the data, but now I'm really worried about the bloat problem and not sure what to do.

Thanks Steve, You are saying that I can find vba code somewhere that will compact and repair database safely each time it closes and thus eliminate the bloat problem?

Could you please explain what the "bloat problem" is? Also, what's wrong with the code that updates the real table? I'm using an update query that seems to work ok. There could be a maximum of two users making changes to the "real" table and they will enter into separate user-specific fields...

Hi Steve, I expect a lot of data in the database and worried that the dlookup method will not work. I'm trying a different method. I converted your query to "make a table" query and use that table as the row source for the form. However, I'm worried since the table will be constantly deleted...

It’s almost working! I run vba code to make a new table each time user clicks on project. The code deletes the table and recreates it. This works great. However, when I open the form that is bound to the table that is recreated with “make a table query”, the form is blank. After I use...

Hello, There are two tables (tbl_Variants) and (tbl_Variant_qry) with identical fields (I verified that they are spelled correctly). “tbl_Variant_qry” is created from make a table query and will be constantly updated (deleted and recreated) I’ve created a query that should update records...

I figured this one out! I had to create a parameter in the query. Thanks, Mila

Hello, I’m trying to pass a parameter (one of the query fields) from a form to a query but I get an error that item is not found in the collection, however, that field exists in the query (see SQL below). What is wrong? Query SQL: SELECT tbl_Projects.run_type, tbl_Projects.run_name...

@JHB, This sounds like a great idea that is hopefully going to save me lots of time and tears! I have a few questions if you don’t mind: 1. It looks like every time the “make a table” query is executed it overwrites the previous table, correct? Is there a way to suppress all of the prompts...

The query is read-only because I use Group By clause.

Expression like this: instr(gene_panle, panel) > 0 that will return True or False?

I wish I could.... it's a crazy query, or actually six different queries joined together. Any other options? I only need to be able to update four fields. I was thinking about adding two forms one would contain the four fields that need to be updated with updatable record source and another...