Search results for query: *

I have an appointments table that I have created an appointments form from. I have a main data entry form to which I have made the appointments form a subform within this main form. I have created a control button below this subform on the main form that I would like to click to take the...

Hey Stix! I actually don't know anything about the Outlook Object Model...I am just kinda the developer and administrator of my company's database on the side. My degree is in Finance, and work in Sales...the database is a tool I use so I developed it last summer to meet my needs, it worked so...

Hey THanks Stix! But it didn't work for the calendar side of it. It will work for contact and emails but not to schedule appointments. Madetoheal13

Hey all is it possible to link Access to Outlook so I can make a scheduling table for appointments. Then in a form be able to click a button and have access send the appointment to My outlook calendar? I am sure you can the only problem is that I have a main accounts in a form and have subforms...

Ok cool...last question...where do I put the form reference? in the VBA code? Madetoheal13

Ok I think this is the problem. I have a main form then I have a subform in that main table which was made directly from my Appointment table. I have the code and command button written in the main form, but it is referencing the fields from the subform. How can I click the button on the main...

OK I did this and it compiles fine. When I go to click the command button that will trigger this code, it comes back with an error 2465 saying that it cannot find the field referred to in my expression. any thoughts? Madetoheal13

OK I have this code above here written and it compiled fine. Then when I go in and click the command button I have created to execute this procedure I get error 2465 which says that my database can not find the field "AddedToOutlook" referred to in my expression. It is both in the table I have...

Hello all! I have a question. Is it possible to link MS Access to Outlook? Specifically...My database is of my company's customers (specific retail locations). I have a data entry form that draws form a Customer Table, Contact table, and Face2Face Table (which is information from actual in...

Hi all! Ok, here goes. My question is regarding reports...I have a simple report with data from a query....The report has store name, address, city, state, and phone number. I have the query sorted by state then by telephone number. I also put this same filter/sort set up in the actual report...

Hey MajP!!! Thanks! Worked like a charm...to think I've been searching for an answer for over a month...and all that was missing was the word "New"....Thank you soooo much. madetoheal13

Hi! Thank you all for your help but I've tried all this. My first posting above shows the exact code from my subform. I have declared an instantiated it in the subform as well the main form. Again, there is a field in the main form which triggers the same popup calendar and it works perfectly...

Hello! Yes it does have [Event Procedure] in it. I have this same calendar in a different spot on the form and it works fine. In this case, the field is in a subform within the main form and in the form's Load event...there are 2 procedures running...as you can see above. again the error I am...

Hey guys. I am inserting a pop up calendar into a field of a form. I thought it was coded right...but when I tab over to the field on the actual form I get an error message. The code: Option Compare Database Option Explicit Private strGlobalUser As String 'This declares the MonthCalendar...

I have code that has a routine running in Sub Form_Load(). In this same form I want to run a calendar module so here I am creating the instance of the class. The code compiles without error but then when I go to the actual form and tab to the date field, an error pops up and tells me that I need...

I have code that has a routine running in Sub Form_Load(). In this same form I want to run a calendar module so here I am creating the instance of the class. The code compiles without error but then when I go to the actual form and tab to the date field, an error pops up and tells me that I need...

Hey THWatson thanks! However, I have checked and all my tables are correctly related all with rules of referential integrity. I am not sure where to go from there. Madetoheal13

Hi all! I have an access database that is replicated on a dozen mobile computers, that my company's sales reps use. Each sales rep has his/her territory. Code was written to extract territory specific info from the tables, to be displayed in a data entry form with only that info. The code then...

THis line higlighted below: intFace = .Fields(0) CODE 'Update Face2FaceReports1 table Set rstFace2Face = DB.OpenRecordset("Face2FaceReports1", dbOpenDynaset) Set rstFace2FaceUser = DB.OpenRecordset(Trim(strGlobalUser) & "Face2Face", dbOpenDynaset) Dim intFace As Integer With...

OK Here is the code..... the line below....under 'Do While Not .EOF'....it says....'intFace = .Fields(0)' this line is higlighted yellow... CODE 'Update Face2FaceReports1 table Set rstFace2Face = DB.OpenRecordset("Face2FaceReports1", dbOpenDynaset) Set rstFace2FaceUser =...