JC21
Last Activity: Dec 29 '07, 01:21 AM
Joined: Nov 7 '06
Location:
-
Thank you for the input puppydogbuddy, sorry for the late reply. -
Access 2003: Comparing field in one table to another
Hi All,
I would like to know how do I compare one field in one table to another in another table. I have one table which is the Archive table. It keeps a history of everything, I have another table which is updated weekly. In both table there is a field called status. If the status of the field changes from last week then on the form I wanted the status field to be bold. I was thinking of something like
If tbl_weekly.stat us... -
Hi mmccarthy,
I was away for few days; sorry it took so long to reply back. I am trying to build a small db for one of my friends who rents out landscaping equipment. Each equipment can be rented only for a certain amount of days. On the [TblEquipment] I have a list of all the [Equipments] and the [#ofdays] it can be rented for. [Tblcoinfo] contains the fields
CoName, CO#, Equipment, DateRent.
I created a query which...Leave a comment:
-
Access 2003: date calculations
Hi Guys,
I am currently trying to create 2 reports and I need some assistance. I am going to give an example of what I would like to accomplish and hope someone can guide me in the right direction. I have a query which was created from table CustInfo. The query has the fields CoID, Name, Date1. I wanted to calculate the days between Date1 and Now. I was able to do so with this expression =DateDiff(“d”,[Date1], Date()).
... -
Thank you very much for your help.Leave a comment:
-
Access 2003: Current month display
Hello all,
I have a question on MS calendar. On one of my forms in my DB I have the MS calendar. My question is how do I set the calendar so that the current month is always displayed. Currently when ever I open the form the month of December is the default month. I always have to go into the design and change it to the current month. Is there a way I can set it to always display the current month. Thank you for any advice. -
Filter by multiple combo boxes
Hi guys,
I was wondering if someone could give me some insight on this. On a form I would like to have 3 combo boxes which can be used as filters. I would like the information to be displayed on a Subform/Subreport and then be able to print a report. For example Filter1, list the company name. Filter2 list the options (open, close). Filter3 is related to the company acct balance, the options are (<$1000, >$1000, >$5000).... -
Hi NeoPa,
It took me a while but I was able to figure it out. Thanks for helping me out. With you guys helping me out I am definitely getting better at this.Leave a comment:
-
Hi NeoPa,
Can you please tell me how this can be done in SQL? thanks for replying.Leave a comment:
-
Changing Default Value
Hi All,
On my main table(tblCust) I have a field called Status, the default value is set to No. All the accounts currently in the table have a default value No. On my form I have a combo box(cboCust) when an option is selected from the combo box, the account is copied to another table. In the After Update event in the combo box there is an event procedure.
My question is there a way for me to change the default value of that... -
Thank you NeoPa, it worked!Leave a comment:
-
Access 2003: Date restrictions
Hi guys,
I have a couple of questions about date restrictions.
On one of my forms in my DB I have the MS calendar. The question I have is how do I prevent the user from selecting a date in past and from selecting no more than 45 days into the future. Example today is 12/08/06, I would like to prevent the user from selecting 12/07/06 and unable to select anything pass 01/22/06. Hope that makes sense.
Second part... -
Thank you for all your help mmccarthy. Sorry I took so long to reply back.Leave a comment:
-
I’m not sure how to add UnAvail to the query since [Qry SP ALL] is getting all its fields from [Tbl PATRIALS]. Should it be included in the table? I am lost on this one. Please let me know how to add it to the query.
Thanks!Leave a comment:
-
Here is the SQL code for [Qry SP ALL]. I think this is what you meant by posting it.
code:
SELECT [Tbl PATRIALS].ID, [Tbl PATRIALS].[ACCT#], [Tbl PATRIALS].[MR#], [Tbl PATRIALS].[PATIENT NAME], [Tbl PATRIALS].P, [Tbl PATRIALS].S, [Tbl PATRIALS].[SERV AREA], [Tbl PATRIALS].[ADMIT DATE], [Tbl PATRIALS].[DISCH DATE], [Tbl PATRIALS].[TOTAL CHARGES], [Tbl PATRIALS].[PAT PYMT], [Tbl PATRIALS].[INS PYMT], [Tbl PATRIALS].ADJ, [Tbl PATRIALS].[ACCT...Leave a comment:
-
Ok I made progress but right before it was going to append the acount I received this error.
Error:
Runtime erro '3073'
Operation must use an updateable query
Code
Private Sub ComboActivity_A fterUpdate()
'assuming all values are available on the form
DoCmd.RunSQL "INSERT INTO Tbl_AcctActivit yWcodes([Acct_#],[PT_Name], [Acct_Balance], [Activity_code]) " & _...Leave a comment:
-
I think I got it now, I forgot to create a value for the [acct bal]. the [activity code] is suppose to go with Me.ComboActivit y. Hopefully that makes sense.
Thanks,
JC21Leave a comment:
-
Hi mmccarthy,
Forgive me but I did not completely understand the question. What I want to do is have the acct#, Pt name, Acct balance and the option selected from the combo box to be transferred to the table. What changes do I need to make in the code for this work?
Thanks,
JC21Leave a comment:
-
Hi mmccarthy,
Thanks for helping me with my problems. I was wondering if you or someone could look at this code for me. I received this error when I selected an option from the Combo box.
Error
Run-time error '3134':
Syntax error in INSERT INTO statement
Code:
Private Sub ComboActivity_A fterUpdate()
'assuming all values are available on the form
DoCmd.RunSQL...Leave a comment:
-
Can anyone give me some assistance with problems above. Thanks in advance for any help you can give.
JC21Leave a comment:
No activity results to display
Leave a comment: