Search results

I finished making my Access database, but I'm not to fond of the aesthetics of it. I've never been a very artsy person and I'm not too satisfied with the way my forms look. I work for a pretty big corporation, so I want my form to look professional, but sleek. If you think you have a nice...

mispost....

cool thanks, I took a db class last year and totally forgot about indexes. thanks.

How do you Index in Access? Good tutorial or article?

Thanks for all the help so far. I have one more question. Say I'm querying or making a report on a table that has 100,000 records. This query/report has equations, conversions, etc (things that slow down a query), would this query run at the same speed if the table had 1 million records? I'm...

well how many rows can one Access table handle without it becoming to large to handle?

bob, I know the design is flawed. The data in the tables for each year consisted of MILLIONS of records, so this was the only way to separate the data accordingly. The tables are updated from teradata every night, so these are solid tables and I can't change the tables at all. Is there any...

I'm looking for the best solution for this problem, any suggestions on how to tackle this would be great. My database runs reports off of two tables,'dataPY' and 'dataCY' (PY = previous year 2007, CY = current year 2008). When the year changes say it's 2009, the Database Admin will take the CY...

run it through the recordset.. see if it is null, if it is null display a message box saying no records.

are you using the special Relationships window for tables?

is this the right section for this question?

My database imports data from an Access e-mail. Everything works fine, but the subject part of the email which goes into a memo field of my table drops off bullets that are in the e-mail. I think it's because they aren't characters, they are symbols. Is there anything I can do to make Access...

Yeah sure.. I'm still trying to figure out the bullets part, but this is what I have so far If OlMail.Subject Like "bi*" Then rst.AddNew rst!Name = OlMail.SenderName rst!Subject = "Report" rst!DateSent = OlMail.ReceivedTime...

nevermind i got it

anyone???? can someone atleast show me how to do this... If OlMail.Subject Like "Bi*" Then

I have this code where it will find unread e-mail and store it to an Access table. Option Explicit Option Compare Binary Private Sub ReadMail_Click() Dim Olapp As Outlook.Application Dim Olmapi As Outlook.NameSpace Dim Olfolder As Outlook.MAPIFolder Dim OlAccept As...

bob, so there is no way to expand this in any way? I have some databases with 40 tables.

Sorry if this has been discussed! I have Access 2007 and I hate how the object window (view tables, queries, forms, reports, etc) is one single column. I have databases that have 20 tables and 20 queries and it's pretty hard to find what I'm looking for sometimes. I'm sure some of you have...

I'm not sure if this is a query or report problem, so it is in both areas. let me know and i'll delete one of the postS! I have this query: SELECT Owner, lgtn, Count( lgtn) AS Cnt, States FROM [bare chassis BRIO] GROUP BY Owner, lgtn, States HAVING ((( CountOwner) Is Not Null)) ORDER BY...

I have this query: SELECT Owner, lgtn, Count( lgtn) AS Cnt, States FROM [bare chassis BRIO] GROUP BY Owner, lgtn, States HAVING ((( CountOwner) Is Not Null)) ORDER BY Owner, lgtn, States; Which will output this report: Owner__length__Cnt__States flex__20________4__ Virginia...