Search results for query: *

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?

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

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...

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...

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...

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 =...

I am having some problems with figuring out how should handle report query. I have a dropdown box, the user can select A or B or leave blank (Null). If user selects A then then query should be BankNo = 77 If user selects B then then query should be BankNo <> 77 If user does not select...

How do you round a number to the nearest thousand. For Example: round 96,452 to 96,000 round 96,500 to 97,000

I am not able to use <> in the report Filter. For Example, I have a report that lists 150 records. If I use ReportFilter below I get 10 records. Location = 77 If I use ReportFilter below I get 150 records. Location <> 77 I should get 140 records when I have ReportFilter Location <>77. I...

I am trying to change an Excel If statement to an Access iif statement. =IF((AND(E2="",G2="")),Now()-D2,IF((+G2-$D2)>=0,(+G2-D2),(+E2-D2))) I don't know what to do with the AND. Kaye

I have a form with a textbox. I have the textbox default to a sentence from information in a table, see example sentence below. I want the text box to have the dates and amounts highlighted in a different color than the other words in the sentence. Is there some way to change color on certain...

I want to be able to lock all the input fields on a form. Is there some way to do that with a command or do I have to lock each of the objects separately? In my table I have a column called lock. If lock is set to true then I want everything on the form to be locked. I want my users to be...

I am using the following code in a form to search for last name. Most of the time the code works just fine and it finds the person I want. But some of the time it does not. For example, I search for Last Name “Swift”. The code will bring me to last name “BAGGETT”. No where in the “BAGGETT”...

Our Access Database is totally form driven. The users should never have to open a table or run a query manually. All the users need to (or suppose to) do are in the forms. Is there some way that I can lock the tables so my users do not have access to open and make changes directly in a...