Why become a Member?

runningthumbnail1

Access World is the #1 site for Microsoft Access help on the internet! By joining our discussion forum, you tap into our bustling community of Microsoft Access users. We have experts who help [...] Read more »

Why use Microsoft Access?

whyaccess

Microsoft Access is the most popular database in the world and there is good reason for it too. It is not just because it is included with Microsoft Office and therefore distributed to [...] Read more »

What is a Microsoft Access forum?

whatisforum1

Many people are not aware of what a discussion forum is and how it can help them. If this is you then read on. You are about to discover how immensely invaluable they [...] Read more »

Expert Volunteers wanted!

writinghelp1

If you are an expert in Microsoft Access and want to contribute to the body of knowledge we are creating on this site, then we are very grateful for any articles that you [...] Read more »

Latest Forum Threads

  • Subform refresh hangs
    Hi All: I have a form that has a data source set to a simple query off of a table. The form has a subform that has a child/parent relationship (date filed). The subform has conditional formatting set for all of the fields. Moving through the records […]
  • Need to log data changes in readable format
    Hello, I need to find a way to log data changes that are being made in our database. From the reading I've done online I need to turn on the system stored procedure for change data capture (sys.sp_cdc_enable_db), but I only have the standard edi […]
  • Formatting of Control
    I used conditional formatting in my continuous form which really works great. So if the field says red, I can paint it red. I initially started writing code to achieve this but does not look like it works well in a continuous form. Anyway, I have a l […]
  • Field Truncation When Exporting Query to Excel
    Hello All, I have programmed a command button to export a query into excel using 'DoCmd.TransferSpreadsheet' within a form and it is truncating the memo fields within the query to 255 characters. I know this is an easy question, but how can […]
  • Imported data doesn't show up in form using query for data
    Right now I have a table that has "FirstName", "MidName", "LastName", "SSN", and "DOB". To help make searching easier to find data I have a form based off a query that pulls all of the above data, but […]

Homepage