Summary: in participants table I have : FirstName, LastName and ParticipantName_tbl. in the participant form I set the code for participant name as: Me.Par...
Summary: This is an Access db to track leave slips. To enter new time we have a form with a combo box, choose a name in the combo box, then a subform shows tha...
Summary: I am having a problem in Access 2002 and was wondering if > anyone came across it. I have a table that requires more > than 255 fields and because Ac...
Summary: Hi everyone, I've a problem regarding the Date/Time field in Access 2002 (XP). When I want to create a table i don't get the data type "Date/Time" in ...
Summary: I have a report which has images on it. Print preview shows the images while in Access, but when I print it (either to a printer or to a pdf file) the...
Summary: Is it possible to do Excel style pivot tables within Access 2000 I have a table in my database which lists records in the following fields format:- N...
Summary: Maybe you're trying to use an advanced wizard not installed during setup. This is from access help. Which wizards are installed This topic provides r...
Summary: I am having a problem with Microsoft Access 2002 mail merging to Word 2002. I am storing a date field in my database in the format "dd MMMM yyyy". Whe...
Summary: I have a system inventory in Access. I need to write a query and report to list all items that do not have a complete inventory. I do have a y/n field...
Summary: Hello all, I have 3 fields in an Access 2k database. The first field contains the Item Cost, the second is the Number of Items and in the third the T...
Summary: hi! i wanted to know how to add expressions in access. like if there is a field 'quantity' and it has numbers. what i want is that when the quantity g...
Summary: I have a combo box that is automatically filled with a list of client names when the form is opened. The only probem is, the text of the combo box (w...
Summary: Dear, I have a customer database using MS Access 2002. It has a field save the customer email address. I would like to export all of the email address...
Summary: Hello, My problem in Access is in the Form, when I use the Scroll, he pass to another registry And the Key-Tab when you are in the last field he ad...
Summary: I'm not an expert at Access, but I think you'll get this error if it has assumed a datatype which it cannot then apply to the whole file. It sounds li...
Summary: I'm trying to import a large text file into Access. The data is separated with commas, but there are no line breaks. Each line just runs together. ...
Summary: I am trying to create a query in Access that will prompt the user for a company abbreviation, then will return results only on the company the user ty...
Summary: Link the form to the table (properties, Data, record source) and then add the fields you want. this is one of the most simple functions of access. hav...
Summary: hi all i am developing an access application on a windows 2000 machine using Access 2000 In one of the tables i have used the date() function as the ...
Summary: I recently converted a MS Access 2000 database to MS Access 2002-2003. Now all of the buttons in my forms no longer work when the .mde form is access...
Summary: I’ve been using MS Access 2002 for over a year now on my computer and it has been working fine up until now. I can open up a database fine in Access...
Summary: I have a database table which contains client information. I have created a form where you use a dropdown box to choose a field to search by, then ty...
Summary: I have a table in Access with a column (field) that is populated with numbers but has some blank cells. I need would like to write a macro that will ...
Summary: I have created a timetable in access. The timetable is based on information from a query. The query includes, the following fields from the following ...
Summary: I have a calculated field call(brew) on a form. This field (brew) is the sum of two other calculated fields. I need to pass the data from this calcul...