Search results

I am working on a Navigation form with 3 pages. When I click a button on the main form unrelated to the pages, I am trying to determine what page is currently selected. Keep in mind, all pages are tied to the same subform, just filtered differently when the page is selected. Can you help...

I have code that from DB1 opens DB2 and runs a Function in DB2. The DB2 function produces a Boolean result that i am trying to get back to DB1 without success. Any suggestions? below is the script. Sub Test22() Dim AC As Object Set AC = CreateObject("Access.Application") rc =...

Hey Guys, I have a split database.... In the front end, i have a form that connects a bunch of tables. My issue is that because 2 of the tables are a One to many relationship, it is making my form read only. These 2 tables are linked from the back end database. Table1 = MainT (has...

Hey Guys, There are different reasons why I am looking for this to happen but basically i have the below script: For Each Item In offexchfldr.Items.Restrict("[SenderName] = '" & frmfm & "'") ' Select Items that match Sender Name on form If Item.TaskSubject = subid Then...

Hey Guys, I have an Outlook Function that i am trying to run from Access. What i am looking for is to Open Outlook through Access and run the Outlook function from Access. Please assist

Hey Guys, i am having an issue with sql in vba using a variable for a date time field. i know you identify date variables with # i know you identify text variables with ' But now i have a date time field that is set to date but when i run the sql it does not find a match. i have confirmed...

Hey Guys, i have a query with the following criteria in one of the fields: >=DateAdd("m",-12,fom()) And <=DateAdd("m",1,fom()) fom is a function for first of the current month. i need this query to be specific to what month it is when its ran so i want to only have this criteria if the...

i have 2 tables that i am linking on a field that matches with null values on both tables but it either pulls nothing or when i put a right join pulls just one tables data. i have also confirmed both are pulling from the same data source, so no issues with field properties and confirmed they...

there are many threads about Table Linking but i coud not find one that answers my specific questions. 1. Can i either prevent database from linking to my tables? (or give permissins ) 2. If not, can i make the table read only when linking? 3. Is there a way to confirm what databases are...

I have a split database. When the front end db is updated, i am attempting to delete the end users copy and replace with the updated version. I have gotten as far as being able to open Database A, Open Database B with A and Close Database A, but it will not let me delete Database A from B...