Hello, Earlier I had a problem with creating a database design for a sports club and fees. However I think I have a solution tables that I will made are: 1. Customers (Customer ID as Primary Key) 2. Contract Type (Contract ID as Primary, linked to Customers through Customer ID) 3. Payments (Payments...

Hi I have a database which we have created to hold amongst other things serial numbers. The serial number is stored in the table as a Number field with the following attributes Field size : Decimal Format: 0 0000 0000 0000 Precision: 13 scale: 0 Decimal places: 0 Input Mask: [blank] Caption: serial number...

Hi I have a database which we have created to hold amongst other things serial numbers. The serial number is stored in the table as a Number field with the following attributes Field size : Decimal Format: 0 0000 0000 0000 Precision: 13 scale: 0 Decimal places: 0 Input Mask: [blank] Caption: serial number...

Hi. I created a query using a TRANSFORM statement that shows me the data I want to use. Now I am trying to use the results of this query in an Access report but the data in the PIVOT field "Quad" is not always the same. Since the values in the field QUAD become the field names for the report...

All, I'm having trouble passing a string to a module. Basic setup. I have a form that pop up with a series of check boxes. The user inidicates which ones they want an initiates a proceedure. The proceedure tests which check boxes the user ticked and forms a string of the corresponding query names...

I noted on my reports that I generate from Access 2003 that our company logo was missing. Upon further investigation, I also noted that the logo will not appear in the inbedded OLE field. When I right click on that field to attempt to bring up the properties dialog I receive the message "The OLE...

In a form I have with a subform (based on a query that draws fields from one table for the main form, and fields from another table with a one-to-many relationship with the first table for the subform) and when I go to type a new record into a row on the subform, after typing the first character I get...

I have adapted from EE the following vba, which works well, but need to limit to Monday-Friday dates. Can you help? Tks! Private Sub cmdAddFloatSched_Click() Dim rs As DAO.Recordset, db As Database Dim i As Integer Dim sSQL As String, uSQL As String, strFloat As String, sDate Set db = CurrentDb sSQL...

I have installed an ASP.NET application on my laptop that is running Windows XP Professional. When I try to open the app I get the error message below. I have granted access to anonymous users. The solution mentioned, "To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties"...

I have installed an ASP.NET application on my laptop that is running Windows XP Professional. When I try to open the app I get the error message below. I have granted access to anonymous users. The solution mentioned, "To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties"...