update queries

  1. G

    Access Update Query Issue with blank date fields

    I am trying to update from one table with a short text field that has dates, blanks and "N/A" values to a table with a date type field . Using the following in the update query: Update To: DateValue(IIf([Table1DateText]![DateText]="N/A",#12/31/2100#,[Table1DateText]![DateText])). Works fine...
  2. H

    Excel VBA Connection

    Hi all, Hoping someone can guide me or help me? I have an excel work book which has multiple MSSQL queries which pulls data and puts it in to tables for reports. The issue I have is I have created an update button (refreash all basicly) however I have to keep entering the password. I know I...
  3. W

    CurrentDb.Execute returning 'Too few parameters' error.

    I have been building a Sub in a standalone database and have run into an issue with running a query native to the same database. I have in the same sub as part of an If function, another CurrentDb.Execute and it works fine; however, when it gets to the next part of the Sub, the secondary...
  4. A

    Update query- Access 2010 Win7

    Hello, I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where...
  5. B

    Good and Free Online Access Training - Update Queries

    Currently, my skill set is average in Access. I leverage the tool for my own analytics (ie. pulling in tables and using queries to slice and dice the data). I'd like to learn how to use update queries and also how to build a database "front end" intended for other people to use. Any good...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top