General

Hyperlink Command Button
I want to add the Insert hyperlink function to a command button on a form, at present I have a field on a form that requires a different hyperlink for each record so the user, click ito the field then selects the insert hyperlink button on the tooldbar, but i want to remove this toolbar and have a command butto... 15 Feb 2006 12:21

Assigning sequential numbers
Hi I need to assign sequential invoice numbers to orders starting from the last highest number + 1. I have tried the following code; UPDATE Orders SET Orders.[Invoice No] = DMax("[Invoice No]","Orders")+1 WHERE Orders.[Invoice No]) Is Null AND ... The problem is that all orders get the same number which is ... 16 Mar 2006 09:04

I am trying to convert an access table into a fixed length text fi
The problem I am having is that I cannot convert an access numeric field into a fixed length, right justified, zero filled numeric field. In the case of a numeric field with 2 defined decimal places, I am unable to tell the conversion process to drop the decimal indicator while retaining to characters to the r... 13 Feb 2006 22:44

HELP
Will someone (an expert) please help me figure out how to prevent the following error from occuring: "Couldn't Update; Currently Locked" This error displays when i click on the plus sign on the table record, to display the Subdatasheet. I noticed that if there are several users entering data into the table t... 13 Feb 2006 13:52

Adobe PDF hyperlink
I'd like to add a hyperlink to an Adobe pdf document. The Adobe open parameters permit one to link to specific pages (using "&page=n" where n is the page number) appended to the URL specifying the file. When I do this in Access, though, it returns a file not found error. I have tried using either the page nu... 13 Feb 2006 10:12

reverse coding for calculation
Hello, I am creating a form that will be used to calculate scores on a psychological test. In order to obtain an overall score, some responses need to be reverse coded (e.g., if a person answers "1", it is changed to "4" and vice versa; if a person answers "2", it is changed to "3" and vice versa). Could s... 12 Feb 2006 23:45

Database template for classroom attendance purpose
Hi, I am new to Access. Is there any already-made database where I can record student general info (name, address, email...), classes they are taking (English, Math) and class attendance(with boxes for each classroom session for every student)? This is for a non-profit tutoring center for high school students. ... 13 Feb 2006 01:49

Access, ask a query what other database objects use it and where
I am astonished that Access is still largely unsearchable. I desperately want to be able to search the entire database for the name of a query such that if I rename a query or change it in some way I know what other queries, modules reports, forms, or macros will be impacted. Even better still would be able t... 11 Feb 2006 23:52

Compiling a Database of First Names/Gender for Market Research
I am compiling a database of first names and the assigned gender. So far the database has ~80,000 unique names from various countries. The database will be run against clients' customer data to assign gender and then be used for market intelligence/clustering analysis. I have two questions: 1. Does anyone know o... 10 Feb 2006 13:09

Delete from C#
I have a simple access database with one table name "Models". When I try to delete using the following code I keep getting the error: Could not delete from specified tables. Any help is greatly appreciated, I assume it has something to do with permissions. Code: OleDbConnection dbConn = null; OleDbCommand ... 10 Feb 2006 16:17