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

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

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

Hey all! I am getting a runtime 6 error message "overflow". My database was working fine, and then I replicated it. Now when logging out on a replica...before closing...this message pops up. All updated info..is updated and kept in the tables. But updated info does not show up in reports. Any...

Hey all! I am getting a runtime 6 error message "overflow". My database was working fine, and then I replicated it. Now when logging out on a replica...before closing...this message pops up. All updated info..is updated and kept in the tables. But updated info does not show up in reports. Any...

Hi all! I have a question. I have a MS database that has modules written to extract specific user information i.e. travelling sales representatives. THe database runs fine but really slow. I have 3 questions. 1. I assume splitting it would keep information safe but would also let the database...

Hello all! Ok I set up my database like 4 months ago and I thought all was going fine until today I tried to add new records to my main table subsequently adding a new record in 7 related tables. It didn't work out as planned. Upon further inspection...it looks like all of the primary...

Hello. I wrote yesterday about a filter problem I am having. I went to school for finance not computers so when people responded to me the assumed I knew what they were talking about...or that they sent me to check out information somewhere else. I am sure they understood it or was able to...

Hi all. I am almost done creating my company's database and now it is time to assign the company's users securities. I did it a couple times with the wizard to almost lock myself out a all but one. Thankfully I was able to sign in as the administrator and export the database to a new file to...

Hi all. I am almost done creating my company's database and now it is time to assign the company's users securities. I did it a couple times with the wizard to almost lock myself out a all but one. Thankfully I was able to sign in as the administrator and export the database to a new file to...

Hello! I am the adminstrator for my company's database, that I would like to go live with next week. I almost have it completely done but am new to Access...(pretty much learning it on my own). I would like to split the database I guess (is what these forums are telling me). I have 3...

Hello again. First See my 1st thread please. Ok, I tried another route to the way I had my form previously set up. Instead of subforms within a main form, I built a query from that form including all relevant fields from my form, which were located over 7 tables. I then filtered the query by...

Hi all! Ok here is my dilemma...(I have another but will write a more taylored thread.... Ok, I have a database that has 7 tables all with relationship. The main table serves as the source of a form in which the other 6 tables are subforms in that form. As I move from record to record in the...