Hey Guys,
I would like to say thanks very much for this.
** Snip **
Cheers
					
					
						User Profile
				
					Collapse
				
			
		
	- 
	
	
	
	
Last edited by NeoPa; Mar 2 '12, 12:16 PM. Reason: Removed hijack part of post. If you have a question then feel free to ask it in its own thread as per the rules. - 
	
	
	
	
Problem checking textboxes for null
Hi Guys,
I am completely lost, trying to get the code found in:
how-check-if-all-textboxes-form-null to work
I am trying the code but I keep getting the error;
'The object doesn't support this property or method'
Runtime error '438'.
...Code:Dim ctl As control Dim check As Boolean check = TrueLast edited by TheSmileyCoder; Mar 2 '12, 11:12 AM. Reason: Moved question to its own thread. New question=New thread. - 
	
	
	
	
I placed it in the id text box Before Update event as it didnt seem to work in the forms before insert event. do you think this will cause me problems?Leave a comment:
 - 
	
	
	
	
Open form based on parent form - auto add PersonID
My main Person Form has a button to add accounts. This opens the accounts form in Edit Mode. It is a continuous form.
I have setup my relationships but when The account form opens I would like the PersonID to be automatically populated in the first blank record so that I can add an account, I would also like the next new account to add the same PersonID in the same way that that a Subform would do it. Can anyone help with this?... - 
	
	
	
	
Thank you.
I have another query which I have placed in a new thread.Leave a comment:
 - 
	
	
	
	
 - 
	
	
	
	
Autonumber each new record per ID
Morning All,
I have having a little difficulty here. I have a user form where users will add a number of accounts for one person. Each person has a unique ID. What I want is when each account for this person is added to the form for some type of autonumber but for the autonumber to restart for each new Unique ID.
I.E
Mr J Bloggs Unique ID = AA124
Account 1 SubRef = AA124 &"1"... - 
	
	
	
	
Not sure if you will know answer but could you take a look at this thread for me:
http://bytes.com/topic/access/answer...cells-template
Thanks...Leave a comment:
 - 
	
	
	
	
Can I export Form&subform fields to excel cells in template
Hi all who wish to help,
I have created a database that contains five different tables. Each linking to a main table through an ID.
The database opens asking for an ID. When ID is input and the relevant command button is clicked a form opens spplying details for this individual as well as any other data from the other tables in subforms.
The overall form and subforms are based on queries.
... - 
	
	
	
	
Thanks guys, sorry for delay, only getting round to working on again now. Will get back to you if there are any problems. Although i doubt there will beLeave a comment:
 - 
	
	
	
	
Are these two items linked at all by a unique ID?
If so then through the relationships you need to make sure there is a relationship between the two, then click enforce referential integrity and click cascade delete related records.
Save the relationship. Then when you delete one the other should deleteLeave a comment:
 - 
	
	
	
	
 - 
	
	
	
	
Nick,
Do you want the query to run for this fiscal year or for the fiscal year that the query is run, i.e. if you run it in two years the query would then run for that fiscal year?Leave a comment:
 - 
	
	
	
	
Split first two words of string into new field
Morning All,
I cannot find the answer to my question anywhere.
I have an address field named 'ADDRESS'. I want to run an update query so that the first two words of the address are split into a new field named 'AddressSplit'.
Therefore if the full address showed the following
'Ruby Cottage Edinburgh Scotland'
I would get 'Ruby Cottage' in new field.
Likewise... - 
	
	
	
	
Thanks but this still doenst enable to form to open with just the records for the user logged on. Would you have any solution to this?Leave a comment:
 - 
	
	
	
	
Form to Open and Automatically provide users records
Good Afternoon,
I would like some help on creating some code on my forms Load function so that when a user opens it they will automatically have only their allocated records available for viewing.
A bit of Background;
I have a table that lists a number of companies and the contact details for these companies. Each company has someone that deals with them. The field name in my table to indicate this is... - 
	
	
	
	
Count query counts records not companies
Hi,
I'm new to using queries in Access and am stuck on trying to run a query from a table.
I have thousands of records with fields such as customer name, Company Name, Company Country and Balance. What I want to do is run the query to count the number of Companies within a country. As there are thousands of records one company may be in the table up to a couple hundred times and will be named a few times overs for each... - 
	
	
	
	
Sorry first paragraph wasnt clear
I have created a command button that will open a form in datasheet viewLeave a comment:
 - 
	
	
	
	
Creating a Command that will Run a Top 20 Query
Hi,
I have been creating a database in Access 2003, I have created a form that will show information about a company. On this I have created a Command Button that will a form of the customer details for the relevant company that is shown on the form. I have the code below which is from a wizard
...Code:Private Sub Disclosures_Click() On Error GoTo Err_Disclosures_Click Dim stDocName As String 
No activity results to display
							Show More
							
Leave a comment: