| Thread | Last Post | Replies |
|
| How to show both Yes/No in a query? | 09 Nov 2004 17:06 GMT | 2 |
I have a query and a InputForm. Query: Field1 (Yes/No) Forms![InputForm].[CheckBox]
|
| dynamic subforms | 09 Nov 2004 15:51 GMT | 9 |
Currently I'm developing an Access app, but I'm running into a problem. Our database contains a lot of tables with the same format:
|=====| |=====| |=====| |tbl1 | |tbl2 | |tbl3 | |
| Comparing Database technologies | 09 Nov 2004 15:31 GMT | 4 |
OK I don't know if this is a suitable forum really for this but I wonder if anyone has any good URLs of places where I can compare different kinds of database techonologies? I.e. Access vs Oracle vs MySQL etc for all sorts of things like web suitability, speed and cost
|
| Access2003 security warning | 09 Nov 2004 14:16 GMT | 1 |
Anyone knows what the registry setting must be to turn of the security warning. Thanks Alfred
|
| Input-Form-Building Problem | 09 Nov 2004 13:01 GMT | 3 |
I have the following Access-related problem. Given a set of problems, which have several alternatives (possible solutions) and criteria for these solutions, I need to give values for these criteria. It comes down to four interrelated tables, for each
|
| Combining fields in a table | 09 Nov 2004 12:57 GMT | 1 |
This is probably something really easy, Well I hope anyhow. I have three fields used for barcoding, in one table F1, F2 and F3. I want the three fields to be able to be combined to complete an EAN13 barcode. (F1=2 digits, F2 and F3 = 5 digits each. Totaling 12 digits. EAN13 ...
|
| select tablename.fieldname yet error 3079 | 09 Nov 2004 11:35 GMT | 4 |
This is my query: SELECT DISTINCT relatie.relatieID FROM Relatietype INNER JOIN relatie ON Relatietype.relatietypeID = relatie.relatietypeID
|
| Format field to 'Date' | 09 Nov 2004 11:14 GMT | 1 |
1) I'm using a program that save data automatically into a database. I'm using access to view the data using queries. In the 'StartDate' field the data appears as a number (e.g. 38299.6143981482). What can I do in order to view this data as TIME/DATE?
|
| Is there a better, faster way? | 09 Nov 2004 10:52 GMT | 14 |
Looking for some opinions on alternatives to programming with Access. I find that quite often I need to loop through my recordsets (first to last) performing calculations and was wondering if there is a faster alternative than Access?
|
| PARAMETERS FOR STORED PROCEDURES (UPDATE, APPEND) | 09 Nov 2004 10:24 GMT | 4 |
A question concerning Access Project with SQL Server: I use a stored procedure that is calling several other stored procedure which update or append values in several tables. All of them are stored procedures with input parameters by which they filter rows to be updated or
|
| date problem | 09 Nov 2004 06:19 GMT | 1 |
Hi what is wrong with the following ' I try to force mmddyyyy format -- tried it every each way Forms!EmpPayMonthParForm!Bdate = Format(Forms!EmpPayMonthParForm!Bdate.Value, "mm dd yyyy")
|
| Deployment issues | 09 Nov 2004 04:24 GMT | 1 |
Folks, I want to deploy a access application on a isp server. Has anyone done this? What are the issues encountered. Is there other ways to make this app available to 5-10 users in different locations? Is a front end/back end solution viable in this situation. What should
|
| Access 2000 under Win XP crashing after long term use? | 09 Nov 2004 04:04 GMT | 1 |
I have a client who has been running my Access 2000 system for a while now (about a year and a half) and is suddenly encountering lots of problems... as in misc. fatal errors that shut the database down. Hard drive space looks good (I think): about 3 GB of about 8 GB free
|
| Error 3061 Too few parameters. Expected 1 from Access 97 | 09 Nov 2004 02:31 GMT | 2 |
There have been LOTS of postings about error 3061, but mine seems to be an even simpler case than the others. I have a simple **FUNCTIONING** query called qryEdits. Copying the SQL from the query, it reads:
|
| Re-linking tables could not find installable ISAM | 08 Nov 2004 22:21 GMT | 1 |
In the module below, I get a "Could not find installable ISAM" error on the tdf.refresh link. The NewConnection refers to a valid database/table. My References include VBA, Access 9.0 Object Library, DAO 3.6, OLE and VBA
|