In my database, I have a date and time field. Using conditional formatting, I would like to highlight this date on a form when the entered date = today. The...

I've been using Excel and Microsoft Database prior, to create a database of Foundations. I'm trying to switch over to Access 2007, but I need to be able to...

how do I get individual pictures to asosiate with records on a form. I want the picture of my record covers to show up within the form without clicking the...

Hi Thanks everyone for your help with my first novice question. I have another one. I have two tables set up a cash at bank and also all the cash receipts...

I am still quite new to Access and don't really know any VBA code so I hope someone might be able to help with this. I have two forms, each based on queries...

Hello, First, I would like to preface by saying I am an intern and my time is ending soon. I want to have this working before I leave. What I want: I have a...

I get an error when compacting any Access database templates, or apps I have created. I use Access 2000 with XP Pro. "Microsoft Access can't delete...

I have a 2008.NET application which uses an Access 2007 database. its installed on my PC which runs Vista in a sub folder to Program Files. I have the config...

Could someone please advise me how to Compact & Repair a Data Base n Access 2007. I understand there is a Bug and you can lose your Data Base...

Hello I have a query that has two fields "CurrentYear" and "CurrentMonth" I needed to find the lst day of the current month. I tried example but gives wrong...

i have a table with 100 odd names and the members id list is the primary key with auto number i then select names from this list and create a second table...

I'm just learning Access (teaching myself) and am in need of assistance. I have a table that I need to query that will review all the records in the Acct Nbr...

I am using an append query (Query1)to add the name of the current logged on user to a table using Expr1: fGetFullNameOfLoggedUser() I then have a text box on...

I have a report rptEmployees, based on qryEmployees. Is there a method by which I can create a series of reports, based on that query, but on opening, will...

I am trying to get a bit more sophisticated and was stumped on how to specify which table will be left and which will be right. A seemingly simple question...

I have a query that runs expired certifications for me. I would like to drop this information into a mail merge with "Your certification for ... (column...

I am working on a project that I want only fields with information to print out for each contact. So if I answer yes, true in a checkbox other fields will...

Hi I have this result from a query. If the sale date and the receipt date are the same I don't want to bring them through in my query. Easy to do in excel...

i am in the middle of developing a barcode recording db. User will input product code, quantity and serial number (SN). There are 9 products, where each...

I am trying to sum a colume that has some cells with '#N/A'. The cell with the total, displays a '#N/A' now. How can I have that cell display the total of...