User Profile
Collapse
Profile Sidebar
Collapse
jinalpatel
Last Activity: Jul 21 '09, 05:35 PM
Joined: Mar 27 '08
Location: Indianapolis,IN
-
Just FYI. I reposted because I thought that the experts might not have seen my earlier post. I already reported your answer to the admin for being so rude. -
Action Failed Error
I have a report which is based on a macro. Macro is serieas of open queries and a single open report query. When I run this report from my switchboard form it gives me the following series of errors.
First it says
"Please wait a moment while queries are run. The report will open automatically.C lick ok to continue.
When I hit "OK", there appears an "Action Failed" dialogue box, which has only one activated... -
also, pendragon software creates its own tables. I want half the data feeled on pc and other half on PDA. I want something like this. When user enters new records, that unique primary key should be created like autonumber is incrmented by itself when you are entering new record.Leave a comment:
-
OK I am sorry for replying late but I was on vacation. I need this kind of primary key because I am working with pendragon software which syncs with PDA units. It is possible that if two inspectors are inspecting the same nursery at the same time(thats why I am taking "seconds" in consideration), if the nursery farm is more than 300 acres.
I need to create this unique primary key to keep the master records unique.
Thanks...Leave a comment:
-
How to create unique primary key?
I want to create a primary key that is combined with several fields
Autonumber+Insp ectorNo(1 to 5)+CountyNo(1 to 35)+Date
How to create it ? Where to write code for it?
Please help!! -
jinalpatel replied to Form opens in the center and we have to scroll up to go on the top of the formin AccessThanks you Neo Pa. I will keep in mind because the project is already given to the customer.
Thanks much for giving an idea.Leave a comment:
-
Thanks you much guys!!
I found that there was no unique index set up for both the primary (composite key - in the table properties) I set that property to yes(with no duplicates) and it gave me another error saying that there is duplicate data in the table. I removed the duplicate data and it allowed me to enforce referencial integrity..Alth ough it is weired that I tried 2-3 time before and it didn't work but finally it works fine.
...Leave a comment:
-
Yes primary key is Property. It is one to many relationship. One Property can have multiple tract_sum.Leave a comment:
-
No unique index found for the reference field of the primary table."
I am getting this error when I try to enforce referencial integrity from Harvest II table to tractsum table I have attached the relationship diagram. Please give me the hint about possibilities of situation why this error occurs?
Thanks... -
jinalpatel started a topic Form opens in the center and we have to scroll up to go on the top of the formin AccessForm opens in the center and we have to scroll up to go on the top of the form
Hello!!!
I have an extra long form. When I open it, it opens in the middle of the form.I have to scroll up to access the fields written on the top of the form.
Why is that? Which property should I have to set so that the form does not open in the middle of the form?
Form's Autocentre property is set to No -
Perfect...
I think my hard work to explain you worked and it is working with just a single line of code.Perfect!!! Many many thanks to you for helping out..
I just wrote
Code:Private Sub Form_Current() optProjects_AfterUpdate End Sub
Leave a comment:
-
Ok
When the user navigates through records, the records are changed on each and every tab. (normal behaviour)
Here, on the first tab it changes the option automatically but does not change the respective form based on that option on 11th tab.
I think this is the issue of refreshing the data each time user navigates through the records. I need to somehow find the way so that the access refreshes itself and show the respective...Leave a comment:
-
Ya it only depends on the option selected.
The showing of a subform on the 11th tab does not rely on any other attributes but the option button..Leave a comment:
-
No I have a optionGroup not a single option button. This group has three options and user selects one of them and be able to see the respective form on the 11th tab.
It works very well when we are entering new record. But does not update the form according to the option selected for the previous data.
Sorry I didn't get the part that says to do something with form's current event.
Can u give a little more hint on that, pleas...Leave a comment:
-
I am sorry but I am too impatient..I have one more question regarding the same issue.
When we are going through records using record navigation, it does not change the respective form on 11th tab although it does show (and change it while we are going through records) the option selected previously..
why is that and how to fix it?Leave a comment:
-
Here is the code if anybody is looking at this thread for help themselves!!
...Code:Private Sub optProjects_AfterUpdate() If Me.optProjects.Value = 1 Then frmConstructionProjects.Visible = True frmNonConstructionProj.Visible = False frmAquisitionProjects.Visible = False End If If Me.optProjects.Value = 2 Then frmNonConstructionProj.Visible = True frmConstructionProjects.Visible
Leave a comment:
-
-
-
Where to write the code for show/hide the subform and how?
Is it under the click event of the 11th tab (page)?
something likeCode:If Me.optProject = 1 Then Show "frmConstructionProjects" End If
Leave a comment:
No activity results to display
Show More
Leave a comment: