Search results for query: *

Thanks guys

Hi Guys, How can I create a desktop Icon for my Access Application? Thanks in Advance

I'm going to dazzle you with my technical prowess here ... It's an ActiveReport ... it just prints/outputs the data ... (yeah, profound right? haha). My knowledge is limited to the fact that you just kind of point/link the field(s) in the report design to the appropriate field in the database...

In my COMPARE_REC table on the SQL Server side there are 5 records. The reports should resemble (these figures obviously don't add-up) : Dept FY04XP FY05XP FY06XP ABC 123.45 234.56 345.67 BCD 456.78 567.89...

I have only 5 records in my table but when I run the following code below (without) the loop, it prints only the first record in the table and with the loop it prints only the last record in my table to the report. How can I move through (print) all the records in my table to my report...

Thanks for your responses ... I just got back from my vacation last night (5/25 - 6/2 - as you can image I'm exhausted ... not that anyone cares!). In any case, Jerry's explanation is correct ... the problem is that there will be multiple records that do have the same remark (my search field)...

Thanks Bob for responding. Unfortunately it didn't work - the list is still blank. I'm sure I messed up something. Private Sub List1_Click() Dim Template As String Template = "[ERemark] = '" & List1.List(List1.ListIndex) & "'" rs.Filter Template 'With List1 'rs.Filter = "[ERemark] = '" &...

I'm trying to extract the info from the SQL server. The query on the SQL side is kind of huge so here's a small piece of it: SELECT dbo.ALLOCATED.*, dbo.OBLandEXPD.*, dbo.ALLOCATED.SumOfASal * .4344 AS SE_ASal, dbo.ALLOCATED.SumOfASal * .5656 AS RE_ASal, dbo.ALLOCATED.SumOfAAwd * .4344 AS...

I have multiple records grouped by Branch which rolls all records in the "View table" up into 5 records(again grouped by Branch). When I used the DAO control I was able to generate one report with all 5 branches (on separate pages) with: Private Sub ghBranch_Format() ghBranch.NewPage =...

Thanks George that was it. Be patient with me ... this VB novice is learning. Thanks again.

Thanks George that was it. Be patience with me ... this VB novice is learning. Thanks again.

I hope I can explain the issue I'm having suffiently ... in any case here it is: I connected to the SQL server successfully but I'm having problems generating my reports anyway. And I suspect it's due to the & "" below ... but if I remove them I get an error too. Field1.DataValue =...

How can I find a record in a recordset (connected to the SQL Server via code) I modified my code to look like: Private Sub List1_Click() Dim Template As String Template = "[ERemark] = " & Chr$(34) & List1.List(List1.ListIndex) & Chr$(34) rs.Find Template End Sub Result: the list was blank...

You're right. My eyes are SO tired but everything seems to be fine now. Thanks George and JerryKlmns; You guys are my heroes.

Private Sub cmdNav_Click(Index As Integer) With rs cboABranch.Text = !ABranch cboASuppliesType.Text = !ASuppliesType & "" txtASal.Text = !ASal txtAAwd.Text = !AAwd & "" txtABen.Text = !ABen & "" txtAOT.Text = !AOT & ""...

Thanks George it worked. However, I find that if I stop on say record #25 and I edit it and save it and then move to another record before I close the app ... record #25 is saved twice deleting the immediate record in the direction in which I moved after I saved record #25 (I hope I explained...

Now I can see the first record only and I can edit that record only. Anybody know how I can move to the subsequent records? I added the following code to my Form_Load(): With rs cboABranch.Text = !ABranch cboASuppliesType.Text = !ASuppliesType & "" txtASal.Text =...

Thanks JerryKlmns that worked. I can update (add new records) the database on the SQL Server side now. Now I need to figure out how to edit, navigate and generally maintain the records ... since I can't see them when I load the application.

Thanks gmmastros & JerryKlmns for responding. Now I *have a connection but I cannot see any of the current records in the database (hence I cannot edit or update the records). *However everytime I try to add a new record on the VB side - I see a new record on the SQL side but it's an empty...

Sorry for the long code (below) but I am still trying to get a connection to the SQL server. When I run the app, I get a run-time error '3704' with the description Operation is not allowed when the object is closed Please help! I've attached my entire code for the data entry form: Option...