I've been away from Access to long, and can't remember how to do this. There is a table, tblEmployees, and another, tblEvalHistory. Each EmpID in tblEmployee...
Ok, I have looked at the Time Card that MS Access has, and I have tried to do this on my own. I am ready to pull out my hair, because I keep confusing myself....
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
Hi friends, I am stucked here in the problem getting the message "The field is too small to accept the data". At my end i have tried to rectify it but could...
Hello, I have a form in a 2003 mdb that uses a WebBrowser control to display web pages. When the webpage has a form on it that includes a textarea field, the...
Dear All, I have split the database into front and back end. And now I found that it is necessary to create indexes on some fields to increase the searching...
We have an ADP which runs fast in access 2000. The same adp runs significantly slower when opening forms in Access 2007. An Sql2005 trace reveals the following...
Thanks, BillM and JohnV, I will try the Tabbed Documents from Access Options off the Office button. In the meantime while blindly forging forward, I ran...
thoughts, comments, warnings appreciated! I have a couple of design changes that need to get done when I move the backend from Acces to SQL Server. Some of...
Any explanations would be appreciated! I keep coming across "T-SQL" (transact SQL?) referenced as the version of SQL that SQL Server understands. The examples...
I am confused about the visulization effect, what makes it happen , etc. I have 4 tables daisy chained. Now I know I have seen that table grid view, in which...
Is it possible to return two fields from an in(SELECT statement? I need to filter records on both ShiftDate and ShiftNo (1 for days, 2 for nights) where...
I have a form that has a dropdown list. On one pc the first name column does not populate; it works fine on all the other pc's. All pc's have MS updates and...
I have beleived that when i create a popup form, when that application is run, and the popup form is opened. I beleive if I changes its dimensions and/or...
We have an ADP which runs fast in access 2000. The same .ADP runs significantly slower when opening forms in Access 2007. An Sql2005 trace reveals the...
I tried using the code DoCmd.RunMacro, "OutputPDF" to output a report in PDF format. But when I run the code it tells me "Argument Not Optional." I can't...
I have a new part number macro that send an email. I would like for it to grab the user name or network id and add it to the email! Any ideas on how to get...
I am ceratin what I am about to depict is old hat, I just have not been up against it before. Problem: I want to create a Master report, so I used the report...
Hello, Since I am using Office 2007 under Vista, I am aware of an inconvenience in opening a table or query: It opens in an akward position within the Access...
Pros, For the life of me I can't find code or property or whatever, to determine if a current record is locked at the form level. What I'd like to do (since...
Hi all The above database file is uploaded in file section. It is a database developed in MS Access with out the knowledge of programing.Suitable for any...
What is the syntax for adding a hyperlink to the Outlook message body. Hyperlinks.Add doesn't work. Code sample below: Thanks in advance! Mike With MailItem ...
Hi im a student in northeast Ohio training for my microsoft certification. Are there any national websites, great books, or local northeast Ohio user groups...
Hey everyone, I really feel silly asking this question because I'm a 14 year Access veteran who should know the answer, but I don't, and maybe in asking it,...
Hi, Is there ANY reason to have a 0 length string somewhere? If so what is it? If not, then why are 0 length strings allowed at all? For what it's worth, I...
Being a relative beginner in creating a true "relational" database this database normalization thing is something that I’m just having a difficult time...
My company does a lot of work on semi-trailers and occasionally we get one in where the VIN stamped on the trailer does not match the VIN on the registrations....
Hi, All, One of our IT folks is pushing to upgrade our backends to SQL server over an IP connection (at least I think that's what it's called when you have to...