Form1.visible = false
form2.visible = true
tezza98
Last Activity: Oct 7 '08, 11:44 AM
Joined: Mar 28 '07
Location:
-
when you select the the record you need to pass the record values to the chart, you can pass them in different ways depeding on how the chart works, but basically you need to chart values to point to the record values, so you need to pass the record values from the subform, maybe using the onclick or ongotfocus method, pass the values to the chart variables, and then refresh the main form or chart.
check out this site for more detailed...Leave a comment:
-
try this
you could even tryCode:SELCT [tblFees].Acct_Num, [tblFees].Fees_Allowed, [tblFees2_on_Release].Fees_Allowed FROM [tblFees] INNER JOIN [tblFees2_on_Release] ON tbl_Fees].Acct_Num = [tbl_Fees2_on_Release].Acct_Num WHERE [tblFees2_on_Release].[Fees_Allowed]<>[tblFees].[Fees_Allowed]
...Code:SELECT [tblFees].Acct_Num, [tblFees].Fees_Allowed, [tblFees2_on_Release].Fees_Allowed
Leave a comment:
-
when the user clicks the save button check to see if the inputs in the subform arent null
if they arent null then save the records, if they are null , pop up a message box, and set focus to the null input
...Code:public sub on_click() If Me!Subform1.Form!ControlName.Value Is NULL then Msgbox "this subform value must not be null Me!Subform1.Form!ControlName.setFocus Else
Leave a comment:
-
If I get the jist of what you want - a user enters the dates and saves them, he can then change the dates up untill 24 hours, which they are then locked, the submit button locks the date permantly?
On your form where the users enter their date i would write some vb code for the textboxes of each date, to compare the current date with their date, and lock that textbox if it is less then 24 hours.
pseudocode cos im lazy...Leave a comment:
-
when the form loads try
does the same thing as the filter button on the top menuCode:Me.FilterOn = False
or add a button that executes this code to clear the filter, or use it on the open event
or
[CODE]
If Me.FilterON = True then
Me.FilterON = False
End If
You see where im going with this, have a play around with it to find the best place to put the codeLeave a comment:
-
how its done in Using MSACCESS and VB in one of the programs that i have helped write.
create a simple form, with the text you want to display
Put the time consuming code into the form, so that it runs when the form is activated.
On the next line of code, close the form.
so when you want to run the code, open the form, and the code runs, then the form closes.
There...Leave a comment:
-
Steel mills make steel, thye dont need steel at all - trick question.
also to what is as big as elephant but weighs nothing is -
an elephant in space
it weighs nothing, since weight = mass x gravity...Leave a comment:
-
You have put in redundant zeros, so yes technically it is wrong - seeing as mathemetiticain s are a lazy bunch, they dont like to write anything extra if they can avoid it, all youve done is more writing for yourself
when you write 2.05, you dont write 2.0500000000000 0000, instead you write 2.05, it is the same foe Scientific notation, unless the decimal place is specified, ie write 205,000 in scientific notation accurate to the 8th...Leave a comment:
-
2
1
3
is the answer,
i thought it was some binary code to start of with but it is much simpler
i do actually know the answer, i didnt pull these numbers from thin air...Leave a comment:
-
i feeel likea real idiot now, i solved the problem by binding the oRS value to a variable, and that fixed the problem,(its always the last thing you try)the only problem i have now is that for every row this yes/no message appears
waring you are about to append 1 row(s)
anybody know how to remove it???Leave a comment:
-
Help using recordset to insert data into a table **URGENT**
Hi im creating a function to insert data from a MYOB file into an Access database. what im trying to do is copy entire tables from MYOB into ACCESS.
Im using a simple Access Database with so there is no back end, the table are part of the front end
i have a button to run this code
...Code:Private Sub Command0_Click() Dim oRS As ADODB.Recordset Dim DSN As String Dim connection
-
Creating A DSN using VBA
Hi im using VBA to create A MYOB_ODBC User DSN
here is my code
...Code:Option Compare Database 'Constant Declaration Private Const ODBC_ADD_DSN = 1 ' Add data source Private Const ODBC_CONFIG_DSN = 2 ' Configure (edit) data source Private Const ODBC_REMOVE_DSN = 3 ' Remove data source Private Const vbAPINull As Long = 0 ' NULL Pointer -
Thanks, I know how to do it in PHP, i did some research, and your right, you cant dynamically create a unique default value
Anyway Ive figured out a solution, whoever made the table set up two fields, one called SampleNumber, and one called SampleNumberNul l
SampleNumberNul l uses this computed Column Spec
which in reality holds the default...Code:(case when [SampleNumber] IS NULL then [ID] else (0) end)
Leave a comment:
-
Urgent help with default value Or Binding MSSQL
Help please, Im using SQL server Management Studio Express and i want to change the default value of a varchar(50) column.
i want the defaultdate to be like this
'5/04/2007 11:15 pm System generated'
So i have tried to do this:
(getDate())+'Sy stem generated'
(getdate()).'Sy stem generated'
but neither seem to work
these two actually put the entire string as the default value... -
For those interested, i may have a solution, im gonna try it now
what i have done, is used an old copy of my Access Front End that is connected to the client server, it says disconnected in the title bar, and i have imported all the forms and reports from the new version, so hopefully on the client machine it will workLeave a comment:
-
Thats not gonna work, because the client version is an Access runtime environment, and the tables and stored procedures cant be accesed through accesss. I can only change them in SQL server...Leave a comment:
-
think that if you go into the design view of the Table in Access, and in the columns tab for the field you want changed, make identity = yes, identity seed = 1, and identity increment = 1, this might workLeave a comment:
-
Help with changing the Database connection in Access
Help please, Ive been developing an acceess database front end attached to a SQL 2005 Back end, for a client, and i have to put the new front end and back end on thier PC, Simple yes, but im runnning into a huge problem.
My front end points to my server: w2Kserver1 with databse called Fuel,
And I need it to point to the clients server: cleintServer1/ThisComputer with database called fuel.
The client machine doesnt... -
I found the soultion and here it is
It works perfectly
Code:OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text;Database=\\w2ks1\MSSQL\DATA\FUELBCP', 'select * from TRANS.csv')Leave a comment:
No activity results to display
Leave a comment: