Hello all, I have a form that gets its data from a query that is inner joined with 3 tables. I am not able to edit the form. I have a similar form that gets...

When do we have to use the correct builder.As I know there are 3 builder:Expression,Macro,and Code builder.I mean like,at specific time we use 'this builder'...

I use =HowManyWD("01/10/2002","31/12/2002",2) to count the number of (in this case) Mondays between two dates. I need to make allowances for Bank Holidays,...

posted this on forms discussion too - but I am a beginner :-) I have a subform, which is linked to a query, which shows all records frm a master table and...

I selected TOOLS/DATABASE UTILITIES/SWITCHBOARD MANAGER and configured a switchboard. How do I start or run the switchboard? I see a switchboard items table...

Hi, I am working on a database and now i m stuck somewhere so need your help. I had an excel sheet which i exported to access, now in excel this was 1 column...

Hi Everyone, Could someone please help me to achieve the desired requirements of this command button. I have a switchboard which has a button to open the...

I have a data entry form to take payments from a client. On the form is a 'print receipt' button which calls a single page report. If I put in a payment and...

I am newbie to access, I have database with many yes/no fields. I have to create report, using form, where users have to select yes/no...

I have just started to create a normalised DB and need help in transferring data from un-normalised DB; 10,000 + records in the un-normalised...

I made a database using Access 2003, split it into front and back-ends, and now I'm discovering that computers with Access 2002 won't work with it. I had...

I'm wishing to have the input in certain fields automatically made UPPER- or lower-case but I'm either not understanding the Help files or I'm doing something...

Can I link tables from my local computer to a web server where we store the back end of an access 2003 database?

I have a database on my domain server. Additions and updates are collected as a CSV file. I need to append the new entries to a desktop and also update...

On my old Windows 98 computer I had Office 97 professional - with Access. My new computer has Windows XP and Office 2003 Small Business Edition - which does...

I am working with the Event Management Database Template. So far, it works perfectly for what I want to do except for a few things... I have multiple events...

I have a main prospect table that I need to input info from another table that holds school information. How do I lookup the school information from the one...

I want to add an text box or label which will display the number of sales an agent has made on the agent form I have named the form frmAgent as it is based on...

Sometimes, while working in Access 2000, I'll want to save a copy of the file I'm working on as a separate file (with a different name). In other MS Office...

Hi there 1. I have set up a combo box with three columns: Owner, InvestorID, FinancialYearEnd. When I enter the Owner info, it runs the AfterUpdate...