Recent content by moscgama

Hi Moke, Thanks so much for your response! Sorry for being a little vague about my structure. This is not my exact case, but the following is an example of what I'm trying to do. Let's say I am running a clinical trial for a cancer drug. I have tables for the beginning cancer information...

Hi everyone, I'm having a problem needing to pull out a record that may be in one of many, unrelated tables. I'm have a union query set up that lists all of the IDs in all of the tables and have DoCmd.OpenForm code that will check to see if the ID is in the table then open the form that...

Hi, I'm unadvisedly added a navigation form to my database for aesthetic reasons, which has caused me a lot of headache. Anyways, my navigation form contains five subforms. Each of the subforms are based off of the same table. I would like to be able to add data to each of the forms for the...

Hi Sneuberg, Thanks for your response! I'm sorry if I wasn't clear, but the combo box isn't in the navigation control and is on a separate form. I click the dropdown on the other form, which then opens up the form with the navigation control on it. I would like the form (and navigation...

Hi guys, I was not very smart and added a navigation control to my form instead of a tab control. However, I'm trying not to switch over. My goal is to use a combobox to select an ID that will then cause the form and navigation controls to pop up with the correct ID's data. I have the query...

Hi Sneuberg! Thanks for your response! I haven't had this issue before, BUT I don't really copy many forms myself. I just usually create new forms. I'll try creating a new database and see if it happens again!

Hi, I am trying to copy a form (3 time) with in the same database and am having issues with a button that closes the current form and opens the "switchboard" form. When I make changes the button on any of the copied forms they all update with the changes I made to the rest of the forms. For...

Hi, Happy New Year!! I am trying to loop through newly imported tables from excel and add the excel file name to a column in the new table. However, I'm getting an "Run-time Error '91': Object variable or With block variable not set" at the line "strrename= strsql1 & tdf.Name & strsql2 &...

Hi Everyone, I have written code to look up a value in a table that then enables or disables a subform in my main form. The code works, but I know it is now as efficient as it can be. The main problem is that I have multiple values that determine if the subform should be enabled or disabled. I...

Hi, I'm importing multiple Excel workbooks and need to save the workbook name somewhere in the Excel spreadsheet before importing or saving the workbook name in the Access table after importing. I'm using one of Ken's import codes: Option Compare Database Public Function Impt_Sero() Dim...

Hi, Just to finalize this post, I was able to find code on another forum that solved my final problem. The code is as follows: Thanks for everyone’s help! Best, Moscgama

Hi, Thanks TJPoorMan for the response! I've finally have gotten back to this project and have tried to get the code to work for a few days with no luck. I keep getting the Error: Run-time Error '91': Object variable or With block variable not set I believe the error is coming in at the...

Hi, Thank you both for your help! Smig, I tried to create one table that combined all of the tables into one, but some of the information is duplicated when adding the tables together. The issues arises because I need these individual records for later data processing. For the first step of...

Hi TJPoorman, Thanks so much for your help (and sorry for the almost two week delay)! It works!! However, I am stuck again. :( I have tried to figure out how to remove the reference to the first table I loop through (I hard coded it) and loop through all of the other tables. (I am basically...

Hi, First, sorry if this is posted in the wrong thread! I couldn't decide where it actually goes. Anyways, I am pretty new to VBA coding and need some help with running queries on specific tables. This is part of a multistep process, of importing data that needs to be transposed before...