Recent content by johnnyc

Yes that makes sense, when I review the query behind the form all values reflect 255. Below is what I am able to provide, let me know if this triggers an idea of why all values seem to reflect 255. VBA (copied from above) Public CurrentNumber As Long Public CurrentColor As Long Public...

Thanks Mark, Yes mine is also a continuous form. When I create a blank db and recreate Wayne's code on a continuous form it works as I would expect. The database we are currently developing has too many company specific information to post and may remove the item that is stopping the...

I know this is an old post but I am hoping someone can assist. I was able to download Wayne's Sample and it works great. When I implement the same idea on a continuous form, it works only for the 1st record and doesnt run the function for the other records. Is there a property or something...

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 Paul, that is true but because its in the restrict string, that also errors.

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

Your right, that is what you just did. I am only replying to my initial post for the future me's that search and find this.... Initially I created a function in Outlook that that checks for items in the inbox. What i was attempting to do was from an Access db, open Outlook and run the...

It doesnt matter what is in the function, the issue is attempting to call it.the function is just a message box. If you know how to call it from Access please response, if not please stop wasting peoples time.

We are looking to run a Sub "Runme: from a module in Outlook through Access. I have looked everywhere and spoke to some other analysts on our team and we are stuck. Replies that can assist with this problem are greatly appreciated.

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 CJ, when i change the Table1 field "rec" to text format and use the below script it works, so i dont think it has to do with reserved word. i think i am indicating a date time variable incorrectly by using "#". Do you know if there is another indicator for date time instead of "#"...

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 Bob, i would set a Event Procedure on each Button Properties "On Click" event with the following statement: (formname being your form name) -No button procedure Forms![formname].[field2].Visible = True Forms![formname].[field3].Visible = False Forms![formname].[field4].Visible =...