Search results

Please check if your linked ODBC SQL Server table has edit permission or not. Access Update query works in a different way than SQL Server. 1) You need to make sure that both of your queries are editable. 2) Also, many to many don't work.

What is your new case?

Change the Rowsource, Property of the ITEM control and write one line VBA code on AfterUpdate Event like this: Change the ROWSOURCE of Item filed to Select ITEM_CODE, MIN_QTY FROM YourPic2Table ORDER BY ITEM_CODE. Now go to the Format tab of Property Sheet and change the Column Count to 2 and...

I agree with The_Doc_Man. Try this work around: CDate(REPLACE([p1ok],".","/"))

Hi, As per the data, the query is giving you the correct result. If you see your data closely, you have two Action_ID for same customer in Question_Created table and two in Question_Responded table for the same customer and you are using join on Customer_ID field. Basically, your record is...

There is a comma before WHERE clause which is wrong. Try this: strsql = "UPDATE PARTNER SET EndDate = #" & EndDate & "#, Active = " & Active & " WHERE PartnerID = '" & PartnerId & "'"

Okay, when we connect from Excel to Access, there is an option of record locking. Is there any chance that you have more than one user on this tool? It can also cause this issue if you kept open your database and executing commands from your Excel. You need to check connection string as well.

Here you go: [Date], 'Inbound' as Channel,'Peter' as [Name], [Peter_Inbound] as Sales union all [Date], 'Outbound' as Channel,'Peter' as [Name], [Peter_Outbound] as Sales union all [Date], 'Inbound' as Channel,'Andy' as [Name], [Andy_Inbound] as Sales union all [Date], 'Outbound' as...

Use another IIF() to specify a staff like this Activity = IIF([Staff]="YourSpecificStaff",IIF(Format([Start_Date],"ddd")="Fri","RDO","YourSecondChoce"),"YourSecondChoce")

Use UNION query to get your desired output.

I think you are using calculation on txtNettWeight control. If so, you won't be able to set null value in it. Always use Nz() in your calculation to obsolete the null value. Set null value only those are not calculated fields.

Try this: Activity = IIF(Format([Start_Date],"ddd")="Fri","RDO","YourSecondChoce")

I believe your database is corrupted and I assume you ran compact & repair command. To check, please create a simple make table query and see that runs for you or not. Try this for both tables. If you get any error, means you have some corrupted records in your table and you need to clean those...

Try this: SELECT [Meal - Recipes IngredientListQ].MealID, [Meal - Recipes IngredientListQ].IngredientID, [Meal - Recipes IngredientListQ].IngredientName, Sum([Meal - Recipes IngredientListQ].Qty) AS SumOfQty FROM [Meal - Recipes IngredientListQ] GROUP BY [Meal - Recipes IngredientListQ].MealID...

Hey, You need to change the datatype for AvailableMarks in Courses table from Text to Number. Somehow you have junk data in it which is why it's leading into an datatype conversion error.

Hey, Post your entire query. Seems like you are not following SQL rules.

Hi, Add this as WHERE clause in your query: IIF([Flag]=True,[Date of last review]=Date()-365,[Date of last review] <Dae()-365)=True

Hi, Your query is fine but make sure that [Forms]![MattersFileFrm]![MatterIdFld] has any value in it. You can check whether this reference is evaluating any value or not in Immediate window by '?[Forms]![MattersFileFrm]![MatterIdFld]'. Let us know what you see.

Hi, Use this formula: IIF([txtExpired],"Yes","No")

I would prefer two text boxes which will hold from and to date and use them in criteria. Dropdown will work too but that needs some more VBA coding and of course it won't be dynamic like text boxes.