Search results for query: *

Hello Guys, I wanded to ask a few questions to see the limits of access. 1) Is it possible to drug and drop from one form to another? Say that the drug and drop data are from a query or a table, and will be transfered to another table (a new project). 2) Is it possible to have access open up...

Hello, I was trying to modify the check box size on a form, but without success. Is it possible to make the check box control bigger in size??? I was unable to do it. Can anyone advice? Cheers

I need help,to display the todate day in a query cell. Is there a module that I can write to create a todate() function? Thanks in advance. Totis

Hello, I have a table as below. One of the fields has hyperlinks to a specific location. If I have a form that shows all these data, how do I create a command button that will open the hyperlinked data? Thanks in advance. Table Index Description Location 1 Document1 C:\my...

Hello, Can anyone help me find the correct criteria for a query? If I have three tables say tableA tableB and tableC and a form FormA. TableA has X and Y values in a field called [PolicyType] TableB has A, B, C, D, E, and F values in a field called [InsuredItems] and the corresp[onding X and Y...

Hello, If I have a query with the following sql: INSERT INTO T_ProjectPhases ( ProjectNo, Phase, PhaseDescription, Item ) SELECT Forms!Switchboard!Active_ContractNo.Caption AS ProjectNo, T_ProjectPhases.Phase, T_ProjectPhases.PhaseDescription, T_ProjectPhases.Item FROM T_ProjectPhases GROUP BY...

Hello, Happy Christmass to everyone. I have a question of using a module function in a query: Performance Ratio: E(t): Earned man hours at time t A(t): Actual Man hours expended at time t E(t-1): Earned Mhrs at time t-1 (previous month) A(t-1): Actual Man hours expended at time t-1 If I have a...

Is there a way to make this work????? It works if I make an append to and delete query and run them sequentially through a macro. Is it possible to make this sql work using an update query??? Otherwise is it possible to use a module to update a table?? Cheers UPDATE [Control Plan] RIGHT JOIN...

Is there a way to split a field's record into two if a condition exists? I am breaking my head to find a way to do it, but I have seen something similar to this. For example if the difference between two fields, eg. the enddate and endmonthstartdate, is negative then it would split a field...

is it possible to split a row of a table or query into two rows? This is a mathematical sort of question. for example: [startdate][enddate] [value][Duration] 18/01/04 04/02/04 100 18 To be changed to this or something similar: [startdate][enddate]...

Hello, Is it possible to add another symbol instead of "." in this module??? Can I have two symbols at the same time such as "." or "-"? Cheers Public Function basChopLast(strIn As String) As String Dim MyAry() As String MyAry = Split(strIn, ".") If (UBound(MyAry) > 0)...

Want to change this function Public Function WBSTopLevel(Val1 As String) As String If InStr(Val1, ".") > 0 Then WBSTopLevel = Left(Val1, InStrRev(Val1, ".") - 1) Else WBSTopLevel = Val1 End If End Function to this Public Function WBSTopLevel(Val1 As String) As String If InStr(Val1, "." Or...

Can anyone make the following sql work? I get the message operation must use an updateable query. Thanks. UPDATE [earned mhrs update] INNER JOIN [Earned Mhrs Rollup] ON [earned mhrs update].PackageID = [Earned Mhrs Rollup].[Package ID] SET [Earned Mhrs Rollup].[Package ID] = [earned mhrs...