| Thread | Last Post | Replies |
|
| question about totals query and max value | 29 May 2008 13:31 GMT | 1 |
I have a table called TblProjects that contains all details related to the project, I have a table called TblProjectUpdates which contains a weekly update for each project. The relationship is one-to-many TblProjectUpdates
|
| No allow to import the access file | 29 May 2008 12:36 GMT | 1 |
I don't want to let anybody to import the forms, tables, queries from one access to another access. It is possible ? Thanks, Jason.
|
| DAO, Recordset, RecordsetClone, ADODB | 29 May 2008 12:24 GMT | 2 |
Could anyone tell me what are the Definations of DAO, Recordset, Recordsetclone, & ADODB. when, why & which conditions we used them in our database
|
| Auto capitalise doesn't work | 29 May 2008 11:27 GMT | 1 |
I need to capitalse all alphabets entered by user so i've set the format as <. This works fine with the boxes of only text data. but one of text box data is a alphanumeric data where this setting doesn't work. any guess why and how it can be made to work.
|
| Access 2003 Crashes and corrupt ADP projects | 29 May 2008 11:04 GMT | 13 |
we have a big big problem. We have a large ADP project (900 objects Forms-Reports-Modules) Recently the project has become unstable. Not always, but often, when modifying a Form or a Report the program crashes
|
| Inserting between databases | 29 May 2008 07:25 GMT | 2 |
Can an insert query that inserts values from one table into another take one of its tables from an sql server database? The sql server is accessible either via domain or ip address. I prefer not to link the sql server tables as linked tables raise issues form time to time and ...
|
| Total of fields calculated by formula on form | 29 May 2008 04:47 GMT | 2 |
I have an access database that you can input students answers to a test. A field then determines if this is the correct answer or not with either a 1 or 0. Here's the formula:Correct/Wrong1 =IIf([Student Answer
|
| code problem | 29 May 2008 04:45 GMT | 1 |
hi... i want this code record fields(name,IPCMref and POTdec),only with value of fields is not exist in table...the problem is that code record fields when this exist in table.
|
| How do I do this | 29 May 2008 04:39 GMT | 1 |
I have a TblProjects that contains details referring to a project. I have another table called TblProjectUpdates that contains weekly updates for each project, the realationship is one-to-many, because each project has many updates.
|
| Auto Expand Drop Down Combo Box | 29 May 2008 04:22 GMT | 1 |
I have a combo box that is populated with state abbreviations. For some reason, this one box does not autoexpand. For instance, I type in az, it should choose AZ from the list. The Auto Expand property is set to yes. I'm sure I'm missing something totally easy, but I just ...
|
| Bookmark feature on a data entry form | 29 May 2008 03:43 GMT | 1 |
I have a data entry form and wanted to use the bookmark feature to allow for managers to lookup or access a completed form. it seems the bookmark only works for the most recent entries but when you go out of the database and back in the bookmark doesnt seem to work.
|
| primary key | 29 May 2008 02:23 GMT | 4 |
Would it be possible to make the primary key of a table which is AutoNumber, have or start with 3 digits? Instead of 1 can I make it to show 001 then 002 and so on? Thanks
|
| Adding User Function to Database | 29 May 2008 00:52 GMT | 1 |
I am working on adding a user function where users "log on" to use the database. Each user will be assigned certain records and only the assigned user can make changes. My plan (and please tell me if I am going about this wrong) is to
|
| Input Data Through Form on Corporate Intranet? | 29 May 2008 00:01 GMT | 8 |
Is there a way to show a Form on a corporate intranet, and allow a user to input information into a Table in an Access DB. I was thinking of creating a tool, like an HTML browser, that allows a user to input some information into one of my tables. If so, how can I establish a ...
|
| Calculating UPCA Check Digit | 28 May 2008 23:24 GMT | 4 |
I have a Access query that pulls a UPC code from a field in a linked SQL table in our company data base (Great Plains) I have a number with 11 digits, and I need to generate a 12th digit which is called a check digit. I have a formula by which I can calculate this check digit in ...
|