peter1234
Last Activity: Dec 21 '09, 06:48 PM
Joined: Nov 11 '09
Location:
-
Creating Relationships in Microsoft Access versions prior to 2007
Is it possible to create Relationships in Microsoft Access versions prior to 2007? -
Use of "Public Type" in ACCESS 2003
You may want to know that the problem reported in ACCESS 2003 does not exist in ACCESS 2007. -
Many thanks for all the comments, particularly to OrangeCat.
The posted code was tested with different variable names. My objective at the moment is to establish the differences between Access 2007 and 2003. I would like to ensure the work I am doing in 2003 will work in the next version of Access.Leave a comment:
-
Use of "Public Type" in ACCESS 2003
Could you please confirm if 'Public Type', as defined below, is possible with Access 2003. Symilar example found in a book for Access 2007.
The error message inline 7 is:Code:Public Type TypeName Type as String Temp as Single Protect As Boolean End Type Public Function FnName() Dim Var1 as TypeName Dim Var2 as TypeName ........ End Function
... -
Thank you for the responses. I have made some changes with no results.
...Code:Dim TotalDays as Integer Public Function DaysInYear (ByVal Year As Integer) As Integer Dim LeapDays As Integer LeapDays =0 If Year Mod 4 = 0 Then LeapDays = 1 TotalDays = 365 + LeapDays End Function Public Function GetDaysInYear () GetDaysInYear= TotalDaysLast edited by Frinavale; Nov 25 '09, 07:15 PM. Reason: Please post code in [code] ... [/code] tags. Changed quote tags into code tags.Leave a comment:
-
Many thanks to ajalwaysus.
I have a GetDaysInYear function linked to a second text box to extract the number of days in the year. The error message remains:
The error message given reads:
Control can't be edited ; it's bound to the expression 'DaysInYear([Text_year])Leave a comment:
-
User Function with input variable as
In the example below I have chosen to define the input variable in a text box called Text_year. The function is run from a for with a Toggle Button. The text box in the same form. My purpose in to invite user to input a year in the text box to obtain the number of days in that year.
The error message given reads:
Control can't be edited ; it's bound to the expression 'DaysInYear([Text_year])
The function:
... -
'CHARTS in Access'
Thank you for replies.
I have managed to produce charts in ACCESS and agree that they could be less flexible than those from Excel. The advantage in my view is having all the information under a single umbrella.
One of the things I have not been able to do is to display the labels in a bar chart. For instance, product names. All I get is numerical labels for the y axis.
...Leave a comment:
-
Setting Passwords --
I am most embarrassed for posting this question:
While reviewing ‘the security section’ and setting a password I seem to have made a typing error. The password selected is not recognized by my database. Is there any thing I can do to disable the password? I do not wish to lose the notes and exercises made on a 300 page book.
Thank you in advance for any suggestion. -
CHARTS in Access
I am trying to add charts to forms. For my examples I have chosen fields from tables in Northwind Sample Database. The number of categories in the fields selected could be greater than 20.
In all the examples I have tried to create ACCESS returns a chart for an ‘East, West, North’ table. The table is a very simple 3 by 4. Could the problem be that ACCESS cannot chart complex data sets and the chart I see uses a default? -
Report totals for the various MS ACCESS versions
I am trying to produce study notes for ACCESS, and for many days I am stuck trying to produce totals and subtotals for table ‘Order Details’ from ‘Northwind Sample Access Database’. The fact that I am working in two locations and using two versions of ACCESS has made it clear that there is no webpage that lists clearly, step by step, the procedure, by ACCESS version.
In ACCESS 2000 I have unsuccessfully applied the code in...
No activity results to display
Leave a comment: