Search results for query: *

If I make my updates to the data using my SQL View in Enterprise Manager I do not get any kind of error about can not update data in multiple tables. I only get this error when I update the data using Access Database linked SQL Server View. I get the error when using the access forms and if...

I have an Access Database linked to many SQL Server Tables. Each of the Access Database Forms had a query for it's record source. To try to speed up our database, I replaced the Queries behind the forms with SQL Server Views. This works great EXCEPT if update information in a forms that...

In my Access Database, I am linked to a SQL Server view. The SQL Server view uses multiple SQL Server tables. I get the following error message when I try to update muliple fields in the view "not updatable because the modification affects multiple base tables." I can update multiple fields...

I have a table called tblAssetvalue. Each month my users input the value of their house forsale. In my report I need to show the most resent value and the one previous. I can get the most resent easily by grouping on max date but how can I get the one previous?

That worked. Thanks!!!

The following is an Example Access Query I want to put make into an SQL View. The iif(isnull) is not working. Need help on writing the SQL Statement. SELECT Column_A, Column_B, (iif(isnull(Column_A),0,Column_A))-(iif(isnull(Column_B),0,Column_B)) as Column_C From Table1

The groups are not too big. This is a report listing each month and the people on vacation that month. It is grouped by Month and there are usually less than 5 people listed each month. It lists one group after the next but which is what I want but I want it to go to next page if can not fit...

On my report I am trying to keep group together. I have the group header, footer and details properties set yes on keep together but it still page breaks in the middle of a group? Why? How can I keep my groups together on same page.

When I enter data in my sub form I get a Microsoft Access message saying "Field can not be updated". I press the OK button and then I am able to enter my data. This happens When I go to the first field (which is a date field) I start to enter my data and I get Microsoft Access Message "Field...

Please help me with this report layout. Table1 Name Group Kay DBA Jen DBA Jen FCO Jen MGT Joc MON Joc MGT Report Currently Looks like this: Kay DBA Jen DBA FCO MGT Joc MON MGT I would like the report to look like this: Kay DBA Jen...

I have a Tabular Form with 5 columns. Only two of the columns are updateable, the rest are locked. I want my tab key to only tab to the two unlocked rows and then go to the next record. If I set the locked columns to enabled NO it works but I don't want enabled NO, I want to only have the...

It worked:) Thanks for taking the time to help me figure this out!!!

I am trying to figure out how to write a query that groups on Max Date then Max Amount. Below is example table and what I want for results. Table1 AcctNum Thing Date Amount 1234 Cat 1/1/05 200.00 1234 Dog 1/1/05 300.00 1234 Fish 5/2/04 200.61 1234 Bird 3/1/05 600.51 4321 Dog 2/9/05 200.55...

Got it to work. I was grouping on months so that is why min, max, first last was not working. Thanks.

First, Last min or max does not work. If I use Min or First I get only H in 1/1/07, I do not get anything in 1/15/07 or 1/30/07. Help..

I am trying to do a cross tab report with days as column header and UserID as Row Header. There will only be one code per day. I want the report to look like the report below. How do you do this? I can't get it to show the code, I can only get it to show sum, min, max..... Table: UserID...

I have a Form with a list box set to mulit Select Simple. I want to use that list box in a query. The Form Name is frmAccount. The List box name is AcctType_ListBox. I am using a textbox named AcctType to store the listbox selection values separated by commas. The code and query is below...

I think I got it fixed. I totally deleted that text box and recreated it and now it seems to lock as it should. Thanks for your time on trying to help me!

I do have the allowedits code in the Form OnOpen event. I have tried it with and without DataEntry = False In the GotFocus() sub program, if I take out the below line all works the way it is suppose to. I don't know why this line of code is turning allowedits to true...

When my form opens I have code that will lock certain users from making edits, additions and deletions to the data on the form. If get_windows_username() = "KTKISLI" Then Me.Form.AllowAdditions = False Me.Form.AllowDeletions = False Me.Form.AllowEdits = False Me.Form.DataEntry =...