Search results

Use a sub query to delete, like this: DELETE [Master Asset List].AssetID FROM [Master Asset List] WHERE ((([Master Asset List].AssetID) In (SELECT [Master Asset List].AssetID FROM [Master Asset List] LEFT JOIN [Asset Versions List] ON [Master Asset List].AssetID = [Asset Versions List].AssetID...

This happens when the connection between the front end and backend is broken. Here's an example. A database is kept on an external hard drive. The database is opened and works fine until we accidentally bump the external hard drive (there seems to be a loose connection there somewhere). The...

First create a saved query that will calculate the SUM(SalePriceTotal) FROM TblCalc Save this query and use it in the vba code as I show below. ------------------------ Dim SQLPay As String Dim SQLToTable As String Dim SQLMoney As Variant Dim curSum As Currency 'SQLPay and SQLToTbl work fine...

I can see from the sql just posted that there is something called buy/sell. Now a name with a backslash in it is just not acceptable to ms access. When you are naming table and queries, stick to using the 26 letters of the alphabet, the digits 0 to 9 and the underscore character. Any other...

The exact steps needed will vary depending on your application. Do you know how to set the start up options from the File Menu under current database? This is where you set the start up form, hide the navigation pane, restrict the menus and shortcut menus and set the custom ribbon for your app.

It's possible to restrict their access using a login form that captures the name and password of users. You would create a table to store the users' name and their password and your login form would verify the user name and password against this table when users login. Once users have logged...

If this query is feeding a form or report, you can set the format of the text box to short date ( or other date format) in the form/report. If you want to format the result when you view the query, you can try using the format function as shown below, but it doesn't always work as you expect...

1. Create a separate query to use as a table in the next query. Call this query 'qryInventoryPart1'. Here is the sql: SELECT tblInventory.ID, tblTransactionID.[Card ID] FROM tblInventory LEFT JOIN tblTransactionID ON tblInventory.ID = tblTransactionID.[Card ID]; 2. Create the next query: SELECT...

This is what I do. Check if the excel report file already exists and if it does I delete it. If I get an error deleting it, my error handler shows the user a message. -------------------- Public Function DupFileName(strFile As String) As Boolean On Error GoTo FunctionErr 'check if file exists...

In reply to "can you normally keep relationships after renaming tables?", the answer is no. Once you rename a table, its relationships need to be reconstructed.

Use 2 bound textboxes - 1 for the date last modified and the other for the user. Include both the date last modified and the user in the query for the form. Make the control source for the date text box the last modified date and for the user text box the control source will be the user field...

Delete the data from the existing table. If you have several tables involved, you will need to delete child records before the parent records. Create an append query/ies to copy the data from the new table to the existing table. To stay with the scenario of renaming the tables: keep a picture...

(IIf(Len([Extra Transit Days] >0, +"_"+[Extra Transit Days],Null)) You can search help on the IIf function in Access.

Create a query based on the table of Call data. Include only those fields that are mandatory. You want all rows where any of the columns of the query are null. In the query designer of the query already created with only the mandatory fields, in the criteria row of the 1st colum put Is...

Create a query joining both the tables. In the 'call data' column, in the criteria row put Is Null OR "" to pick up all rows where there is no entry for call data. You also need to put in criteria for the column that defines whether 'call data' is mandatory - set the criteria so only mandatory...

DoCmd.SetWarnings False will turn off the display of the message DoCmd.SetWarnings True will turn it back on. This property applies to the database. So before you run the query, set warnings to false and when finished the query turn it back on again.

You can use the built - in function called DateDiff - in a form's textbox as control source, in a query or in vba code. Access help explains how to use it.

A record in the main form will be saved when you move to the subform - assuming you are using the link master and link child to link the subform to the parent form. I suggest that you remove any code from the On Focus event for the tab control and just check that the parent record does save in...

Me.FamilyID = [Forms]![Family Directory]![FamilyID]

Yes, I see that the scrollbar is very close to the delete button. Can you perhaps get what you want by changing the setting for the horizontal anchor for that delete button - make it left and hopefully the delete button won't get pushed so hard up against the scroll bar.