Search results

Beuhler . . . . Beuhler . . . . Beuhler . . . . Beuhler . . . .

waffle, if its all numeric data, write the query as follows: Select StockCode, Whouse, Iif([Period]=12,[Close],0) AS Period12, Iif([Period]=11,[Close],0) AS Period11, etc. ; then create a second query that will group and total the first query. . Select StockCode, Whouse, Sum([Period12]) as...

i am using access against an Oracle DB through an ODBC driver, and when appending records to a local table, if access gets an Oracle record error "#deleted", the append query aborts. . . that's fine, but I can't figure out how to trap the error to get the rest of the records. . . ugh! see...

you might want to try you might want to try (value=0 AND name <> HOT) OR (value= Is Null AND name <>HOT) Value 0 or Is Null sportsguy

When i try to create a combo box with the wizard, i don't get the third option: Find a record on my form based on the value I selected in my combo box. how do i get there? thanks in advance sportsguy

small number total up to 8 fields, 2 yes/no fields 300 records. . not big

sorry, there are too many requests and not enough information to easily create the required reports for my customers. I want to copy a table/query with yes/no fields and paste into excel with the boxes for the yes/no fields. . . I can't remember or figure out how to do it. . . I know it can...

the computer next to me doesn't have the standard menu showing, and I can't figure out why, because the settings are the same as mine. WITHOUT File, Tools, etc, its hard to teach a new person how to use it. . . where do i look, how do i get the menu bar back. . . thanks sportsguy

Just goes to show you that my description of Access HACK is correct! thanks for the reminder about format, i forgot completely about it. . . sportsguy

so far, what i have found is that loading a null field to a table that has a date field formatted as short date causes the error. I changed the date field format to blank, and all is well. . . put that one in your list of weird error messages sportsguy

running an append query from one database to another. . . INSERT INTO ACEINVOICES ( YYYYMM, District, SRSA_Nbr, Category, TaskNbr, StartDate, EndDate, BillingType, [Transaction], UOM, Quantity, Rate, INVExtAmount, INVTax, INVTotalAmount, ItemNbr, ProductGroup, CustomerNbr, CustomerName...

WTF does this mean? ugh nothing on google with this error message thanks sportsguy

ah, bracket, that is what I was missing, thanks its a reserved character.. . . sportsguy

Text field "CM#000001" How do i write a where criteria to exclude all records that start with "CM#" like "CM#*" does not work like 'CM#' & "*" does not work thanks sportsguy

posted before I found the answer, end of day, tired, If Me.RevenueType = "Booked Est SMP" Then ' Change Font to Bold for all Controls in Section For Each ctlDetail In Me.Detail.Controls If Left(ctlDetail.Name, 4) = "Mnth" Then With ctlDetail...

I need to change the control format property from standard to percent, and 0 decimals with standard to 1 decimal place with percent. . its not working, and I know where, but I can't find the proper coding. any help is appreciated, thanks sportsguy Private Sub Detail_Format(Cancel As...

Fofa, I am going to guess the biggest issue you have is table design and normalization. I bet with some design issues worked out, you DB could be smaller, and load much faster. actually, i have worked the table designs down as small as possible with normalization, with each table in its own...

as far as my job situation, am moving to a dba role from finance, but in the forecasting role, which I am helping to design. . . so this will eventually get transferred to someone else. . . well, I got the SQLServer Express downloaded and installed, and have some data into it, so far so good...

if anyone else would hire me I would be outta here without second thoughts or regrets, and have had interviews, and resumes reviewed. . . I just have alot of limitations while helping to fix a dysfunctional company. I have made alot of improvements fixing a company that was shrinking into one...

Here are the details yes, the question is a bit vague, but I was not asking a specific design question, just a general question looking specific experience. The amount of data that I am handling is two years of transactions in a $2 billion construction company, because the IT department is...