I'm trying to achieve the same thing on a form, but no satisfaction so far. Firstly, what goes on the front of =MakePercent(), to avoid a compile error? If I...

Hello, can anyone tell me how I would be able tell in code if a field on an unbound form has been edited before I perform an action? Below is my...

I have placed a control in a form to calculate a due date based on a start date I enter in a field. My problem is if there isn't a date in the start date...

I know a template for Access 2000 is available for download, but I'm interested in templates for either Access 2007 or Access 2003.

Hi there In my database, there is field called Student_ID which is a long integer field which someone has created manually. I want to have all new students...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I have an .mdb file on a shared directory on the network. When multiple users try to open the file, the second user gets a "File Not Found" (+ path of .mdb...

Hi - again. :) In my database, I will need to be able to have several people adding info at once. If my switchboard opens the forms in "add" mode, can...

I would like to create a new table by importing an EXCEL spreadsheet. The EXCEL spreadsheet includes a column containing hyperlinks. I tried importing the...

I have a table with 3 columns: SUBJECT_KEY, TOPIC_KEY, FIELD_KEY, DTEXT . For example: SUBJECT_KEY TOPIC_KEY FIELD_KEY DTEXT 100 ...

I can't get auto number to turn on after i have inputted some numbers in to the primary key column

I have written a small DB app in Access 2000 and have used replication to keep two copies on two computers (different users) in synch for over a year. Both...

Hi How do I bookmark a record on a bound form? This form(A) is not editable and when I want to edit the data, I open another form(B) to edit it. Let's say...

I currently have an Access 2003 database. In a Student table, I have SSN field that stores the last four digits of Social security number. I also have a...

Hi! The first question is: I have a total in a report, and another total in the subreport. I need to get the difference between them. I have: = -...

I am trying to use Expression Builder to concatenate certain fields. Can anyone tell me how I would start the expression? Thanks in advance.

$B$"(B

This is about as lame a way of contacting the company with a problem as I've ever seen. The package says one thing, and the reality is another. I'm taking...

I needed to use this one table in excel for 5 different databases, is there an easy way to do this instead of making 5 different copies of the file...

I have an Access 2003-database for postcards, in which are (amongst others) a table for the postcards and another table for the color of the inscriptions on...