Search results

I have a report that should show all colors except the colors indicated in 5 fields. My filter (found in Report Property Sheet) for the report is this: color <> DLookUp("color1","tbl_color") and color <> DLookUp("color2","tbl_color") and color <> DLookUp("color3","tbl_color") and color <>...

How can I show all the chosen values in a multivalue combobox in a textbox? When only one value is chosen, this value appears in the textbox. But when more than one value is chosen, the textbox does not show anything.

I made my own right-click menu that has the Paste command. When a user right clicks on the form other than a text box and chooses Paste, Access will show the error message: The command or action 'Paste' isn't available now... I have tried including On Error (Fail) and Set Warnings (False) in...

Assuming an Access app has been deployed to a user. There is a field in a table that is hidden from the user. How can we modify the value of the hidden field?

My form has SEVERAL macros and I used the 'Convert Form's Macros to VB.' Sadly, the actions stopped working. So I created a simple form to try to figure out the error. I created a macro on a field's On Mouse Down event: Message Box. Macro worked fine. Then I used the Convert Form's Macros...

The code below by WatsonDyar works to limit number of records entered in a form. Private Sub Form_BeforeInsert(Cancel As Integer) If Me.NewRecord = True And Me.RecordsetClone.RecordCount = 3 Then MsgBox "Cannot add more than 3 rating officials. Press OK to continue.", vbOKOnly, "Maximum Number...

In the general tab of Table Property, there is the Validation Rule. What is the equivalent Event of this in forms? I cannot seem to make it work using On Current and Before Update in forms. I do not want the cursor to move on to the next record if the sum of field01 and field 02 is zero.

I have a form with 2 fields. If the data type entered is not the correct one entered for these fields, I would like to have a different message appear depending on which field trigerred the error. When I use the On Error event of the form, it applies to the whole form. How should I do this?

I have a form. I want to suppress this message: Do you want to suppress further error messages telling you why records cannot be pasted? I made my own message box and the latter successfully appears but after I click on OK the above message still appears.

I am creating an application using Access 2007. The user does not have Access. Should I download the Access Runtime 2007 or can I use Runtime versions higher than 2007?

Hi. I made my own Shortcut Menu (right click) on a report using a macro. I used runcommand - ExportExcel. When I right click on the report, this function is disabled but in the Print Preview Menu, the Excel Export is working. (Take a look at picture.)

I have disabled the following in Access Options: Navigation Pane, Allow Full Menus, Allow Default Shortcut Menus. I do not want users to have access to commands and right-click options. I have a report that opens in Print Preview. Users want to be able to see the look of the report first...

Example: Field name is companyname. companyname = hersheysintl.accdb For a user to be able to open this MS Access file, the name of the MS Access file should be hersheysintl.accdb. Otherwise, the file will not open. Is this doable?

how do i replace a character that is the 10th character from the right? 2nd character from the left, etc. i have read about sql STUFF function. does access have a similar function?

i am exporting a union query to a text file. i expect the cursor to be at the end of my data. instead, when i open the text file, the cursor is 2 rows away from the last row (with data). the export creates blank rows. the blank rows cause an error when i upload the text file to another...

i want to replace the text: ,"dummy" with null. this is my code: stemp = replace(stemp, ",""dummy""", "") it does not work. what is the correct code to deal with both the comma and the double quote? tia.

I need to export 2 queries to 1 csv file. The 2 queries do not have the same number of columns. I cannot use Union because this requires I have the same column numbers. I cannot make alias columns or null columns because the resulting exported file will have commas to signify a blank field...

hi. i copied this code from someone and did some changes. it works fine to export my query to a csv-formatted file. the Save File dialog box pops up. when i choose cancel, the 2522 run-time error message appears. what can i do to suppress this message? tia. Private Sub...

i want the report not to show data with zero balances. example: if my report has 10 line items and 3 of these line items have 0 balances, then the report should only show the 7 items that do not have 0 balances. (the report should use up 7 lines / rows only.) kindly see the attached report...

I have a database that has transactions since year 2009. I want the users to only be able to view and edit transactions that were entered in the last 6 days. I was initially able to do this by putting a filter in the Property Sheet section of the form and choosing Yes for Filter on Load...