mycall
Last Activity: Mar 21 '07, 12:54 PM
Joined: Jan 24 '07
Location:
-
You either have a control on your report which has its controlsource set to what is being prompted for or it is somewhere in your query or report recordsource, have a 2nd look ;) -
>>>>1. I have heard its not good to do this. Is this true and if so why?
First of all i dont think it is possible in access. You would need to use code in real time to go through and make your own autonumbertext. Its prolly not a good idea cos it makes the task a lot more complicated. If you want a text field as a primary key then you are better off having it as a user defined input otherwise having code for when a record...Leave a comment:
-
Access Look and Feel - Disabled fields
I had a quick look but couldnt find much on this.
What i have is a contiunous form with each row having an 'edit' button. By default all feilds have been set to disabled to stop the user acciddently changing data in the bound tables. Im using code along with MS built in conditional formatting so when the user clicks the edit button on a particular row it makes all the controls enabled for that row and they can then edit the data. ... -
>If you're talking about maximizing the window and resizing the window by
>using the mouse, this does not increase the size of the form, this only
>increases the size of the window. The size of the form remains the same
>regardless of the size of the window.
Yes this is what im refering too.
What is happening is that when i open the main form on computers with different resolutions...Leave a comment:
-
Change Selected Record on Continuous subForm
I have a subform which is bound to the contents of the Asset table. at the end of each row i have also added an 'edit' button and a 'Delete' button.
All textbox controls have been locked by default to ensure that the user dosent acidently change the data in the table.
What i would like to do is when the user clicks on the 'edit' button for that record it unlocks all the controls (and perhaps changes the background colour)... -
Resize subform to fit Detail Section
Hi There,
Im having a bit of a problem tryin to get my subform to automatically stretch to the size of the detail section when the main form changes size.
I have set the autoresize on both the main and subforms along with the can grow/shrink settings.
I also tried some code which almost worked on the onload event on the main form.
Me.frm_subAsset Edit.Height = Me.Section(0).H eight
... -
Search Entire database for String???
Is there an easy way to search all tables using a string as search criteria.
I have started writting a heap of nested for loops, getting table defs and fields however it is becoming a little bit of a pain.
Is there some kind of select statement one might be able to write in SQL that will search all tables and all fields.
I would ideally like to go through the database searching for say 'EXT2' and then... -
Just wanted to say its all working now so nvm... for anyone who comes across a similar problem i used the following code:
Function GetPayment(ddat e As String)
On Error GoTo Err_GetPayment
Dim str2SQL As String
str2SQL = "SELECT tblPayments.Pay mentAmount "
str2SQL = str2SQL & " FROM tblPayments "
str2SQL = str2SQL & " WHERE...Leave a comment:
-
Extracting Data from embeded SQL select statement
Heyyas.
I am trying to print out a report which lists account details and payment amounts from january to december. I have following tables:
Payment(payment No, DateOwing, amount, accountID)
Account(account ID, Name, Address,.....)
The report is made using a query which just lists all the account details. Then i have 12 text boxes which go horizontally across from each account record. In these text boxes...
No activity results to display
Leave a comment: