Search results

Let me try again, as I was tired. . . after 12 hours of work the brain gets woozy I have a subform and one of the subform input controls is a combo box to select the correct quota level, based upon the subform control NY_SALESPLAN. The control is on the subform, and is populated. . . the name...

I have a subform and one of the input controls has a combo box to select the correct quota level, based upon the sale_com_plan. The control is on the subform, and is populated. . . SELECT QUOTAS.JC_Bookings FROM QUOTAS WHERE (((QUOTAS.Comp_Plan_Code)=Forms!sfrmESSR.NY_SALESPLAN) And...

thanks I didn't know that one. . . thank you very much. . sportsguy

Sorry, its late as in time of say and deadline, and I should know this. . . But the record needs to stay visible and only change when a new employee is chosen from the main form. . . just point me in the right direction thanks in advance sportsguy

Its the engineering laptop version, and the SQL Server syntax boxes were checked. . . never mind. . . sportsguy

I have a new laptop from work, Dell Latitude E6500, XP, Office 2003, dell image, 4 GIGS ram, P9600 chipset. . . Access doesn't work correctly, query below will not return anything SELECT CITYSTATECOUNTY.City, CITYSTATECOUNTY.State, CITYSTATECOUNTY.County FROM CITYSTATECOUNTY WHERE...

what is a hot industry to be in, is Hyperion Essbase and Planning, which is much cooler than sql tables. . . and working in an external hosting and maintenance facility. . . Alot of mid size companies don't want to internally staff the resources to operate and maintain specialty software when...

i program access most times, as the oracle programmers take months to do what i can do in access in a few hours for data analysis and reporting. VBA is a requirement for custom data transformations due to the multi dimensional data sets. . I also write scripts in Hyperion Essbase as I designed...

Well, it wasn't me, the Office 2007 updates solved the issues. . . although Vista x64 business is not 100% stable yet, it is fast sportsguy

kind of strange that there are three items in the query setup box that I can't make to be active, insert columns, delete columns, and delete rows. and no, I don't want to use workarounds for habits which I deem efficient, just because the software is buggy. . .:confused: sportsguy

sounds like a course problem .. . . sigh

Have you tried concatenating similar query or table fields into one field? example: Select [FirstName]&" "&[MiddleInitial]&" "&[LastName] AS EMPLOYEENAME, [Address1]&" "&[Address2]&" "&[City]&", "&[State] AS ADDRESS, . . . . that cuts down on the number of controls to place on the report...

Vistax64 OS, 8 gigs ram (fast) MS Access 2007 (just converted) trying to insert a column in a long query. . . highlight field, go to ribbon under query setup, and the insert row is activated, but the insert column is NOT activated. . . how do i insert a column? or is it me? thanks sportguy

DUH! gawd am i slow. . . i haven't done any in depth coding for about 3 years. . i forget so quickly! thank you Bob larson! sportsguy

:rolleyes::eek::( Evidently, a form control value can not be used in the where clause of a query executed by ADO. . . i find that strange, but that is the error, or I have written the sql code wrong. . . so I have to either execute an existing access query, or scroll through the record set to...

I am not sure which required field is missing, can anyone make an observation which I cannot seem to see. The point of the code is to verify the computer logon name against a predetermined list of logon names before continuing. The approved logon names are in a table, which is selected in a...

Function ReplaceWord(anyString As String, whatWord As String, withWhat As String) As String 'ReplaceWord([CustomerName],".","") Removes a period Dim anyLength As Byte Dim WhatLength As Byte Dim I As Byte anyLength = Len(anyString) WhatLength = Len(whatWord) For I = 1 To anyLength If...

very simple select Iif([State]="FL",[Gross],0) as FL, Iif([State]="NC",[Gross],0) as NC, Iif([State]="NY",[Gross],0) as NY, Sum([Gross]) as TotalGross, Sum([Net]) as TotalNet, Sum([Count]) as TotalCount FROM TABLENAME; this query is more efficient than a crosstab, as the query only goes...

retrieving from an SQLServer 2005, two table query, to populate a local access db, I get the following error message the table name which begins with ap is an append query any suggestions for what is causing the issue? is it a decimal field to long integer conversion? thansk sportsguy

thanks neileg that reply makes the most sense, since i have been writing them previously, and never ran into this problem before sportsguy