Search results

I have a workbook with multiple sheets and what I would like to do is be able to filter the data on Sheet 1, using the filter selections (Data > Filter), and then auto filter Sheets 2 and 3 to only show the selected filters from sheet 1. Example: I filter Column 1 on Sheet 1 and only select...

There are 8 records in the table and then an unbound field I am using for the Servings value, but for some reason, its only using the quantity value of the last record entered for the quantity value of all the other records, or if I select a row in the table and then click the update button...

Hi all, been awhile since i've been around, but working on another Access database and have a question so I figured what better place since you guys have helped in the past!! I have 2 tables with one being a temp build table where I can do quantity calculations (Table1) before moving it to the...

I have a main form with a tabctrl, and on tab 7 i have 2 forms that we will call formA and formB, both linked to the main form via facilityID What I would like is to click a button in formA that will add a new record to formB. When I try either of the following...

Is it possible to validate only numbers are entered when using a User Propmt Query? I've tried the attached and it still allows letters or nothing at all and because my SQL Table DataType is 'Int" it just leaves the filed blank without erroring.

I have an access query built to pull a record from a SQL linked table, if it matches a value from a local table, however when I run the query, I am promted with Enter Parameter Value db_CurrentUser!UserName, which is the name of my local table and value I am trying to match. If I manually...

Having a brain fart and can't seem to figure this one out, please point out the obvious that I am missing :) my code is erroring with "Run-Time error '3075': Syntax error (missing operator) in query expression "InvoiceDetailID='23". Dim rs As Recordset Dim s As String Set rs =...

I have a main form with 2 SubForms on it. on SubForm 2, I set the Order By to MaintenanceID Desc and when I open that form on its own, it sorts correctly, however when I lauch the main form, SubForm 2 no longer sorts correctly. Please advise what I am missing thank you

For some reason, whenever I load my form with a tab control on it, the 1st tab that loads displays a blank form, when I click on any other tab and click back, it is displayed correctly. this just started happening for some reason after a compact and repair, any thoughts??

I have this database that i've been work with for a few years now and it has grown into a beast thanks to help from several of you, but now I am running into an issue I haven't come across yet. Basically most of the database is filterable by a Facility Name, however today I encountered our...

Trying to run dbcc checkident (NewFacility, reseed, 0) and getting the following error, even though the table exists. Msg 2501, Level 16, State 45, Line 1 Cannot find a table or object with the name "NewFacility". Check the system catalog. Any thoughts??

I am using the following code to generate emails from my Access database using a locally installed version of Outlook and it works without issues, but what would I need to change to be able to use Outlook 365 Web? Dim oOutlook As Object 'Outlook Dim oEmailItem As Object 'Email Set...

I have an unbound text box on my form and for some reason I can click in it, but I can't type anything in it. If I switch to Design View and then back to Form View, I am then able to type in it. Any thoughts ??

I keep the the above error when running the following query DELETE db_TempAddEquipmentToTicket.TicketID, db_TempAddEquipmentToTicket.EquipmentID, db_TempAddEquipmentToTicket.EquipmentCategory, db_TempAddEquipmentToTicket.Equipment, db_TempAddEquipmentToTicket.EquipmentName...

I have a bit of code that searches through some records and generates emails based off of the results, but for some reason, when the email is generated, it is adding a carriage return or something that is making txt drop to the next line and I can't seem to figure it out. Here is the bit of...

I have the navigation pane set to be closed via the Access Options, however there are occasions when I need to use so have I have code to enable /disable it as needed which works fine. This issue i'm running into is when the navigation pane is active, my forms shift to the right and I can no...

I have this same line of code on the double click event for 3 different fields on my form. 2 out of the 3 opens the form correctly when I double click on them, however when I double click on the last field, the form opens behind instead of in front. The only difference between them is the 3rd...

I have a table in a SQL backend with a column set as nvarchar(MAX) that has a string of characters that is 402 in length. I have a query that runs to create a new local table on the access front end and copy the specific info in it, however for some reason it is only copying over the first 255...

Previously I was able to generate a few emails using the code below, and when I would click the Send button, they would send without needing to open Outlook. 'Starts email Set oOutlook = CreateObject("Outlook.application") Set oEmailItem =...

Since the first issue was resolved, I started a 2nd thread. Please feel free to merge the two if warranted I would like to group the emails per facility,i.e. Facility 1 - Test@email.com; Test2@email.com Facility 3 - Test3@email.com; Test4@email.com; Test5@email.com so I setup the following...