Search results

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 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, 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, 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...

Hi Everyone, I am trying to import individual Excel spreadsheets into Access and then keep these spreadsheets as individual tables when importing them. I have found code at accessmvp to do so; however, I need to also move the worksheet to an "imported" file and remove the imported worksheet...

Hi, I am trying to extract information from a fillable PDF form that my company has created. Rightfully so, they have completely locked down all options, so I am not able to convert the file in Adobe Reader to a text file. I've seen options to extract information using VBA code with Adobe...

Hi all, First off, I apologize for asking the what I assume to be one millionth variation of this question. I am very perplexed right now, as to what I am doing wrong! Previously, I have typed in =[var_name].[column](1) into an unbound textbox which will then show the second column of the...

Hi, I have a form with four pages and subforms on each page. I am having issues with scrolling on pages 2-4. The first page will scroll correctly (to the bottom of the form), but the other pages will not scroll at all. I did enable the scroll bars on the subforms, but they will only scroll to...

Hi, I have been developing a database for my group, which they will be using mainly for data entry. Most of them have never used Access before and are nervous about switching over from Excel. I'm nervous about the behavioral shift that needs to happen and how to guide people through this...

Hi, I have a form based off a query that pulls information when inputting an ID. For example, user clicks the form, then a pop-up box (from the query) occurs, then after adding ID, the form with populated data appears. However, I would like to change some control properties on the form...

Hi, I am trying to disable a field in a form based on a value in a field on a different table/form. I have been able, through simple VBA code, to disable fields based on a value in the same form. Is there VBA code to do this? If so, could you please give me an example? Or are queries/sub forms...