Search results
-
R
Export grouped report - wron gropu names
Access 2007 and 2013 with Excel 2013 A weird behavior in exporting report I have a report with a group by a certain criteria (only one level group) Looks nice and neat but...:banghead: When i export the group to excel using DoCmd.OutputTo acOutputReport, reportname, acFormatXLS, theFilePath &... -
R
Keep focus on form
I have 2 forms Form A contains some action buttons Form B is trigered by one of Form A buttons by using a macro and should work like a popup form, with 3 choices. I want to prevent user to click outside form B until B is closed Form B must stay on top of A, and A should be visible but not... -
R
IIF statement with and/or
I have the following situation Select query with tons of formulas and calculations goes sluggish I started some optimization, and I am trying to remove as much calculated fields as I can One field of the query contains info about personal ID code. The first character in the code comes from... -
R
Question Import from excel workbook only if worksheet exists
Due to a transition between two versions of the database, in need to check if a worksheet exists in a workbook before import. I use DoCmd.TransferSpreadsheet Method to import data. If the worksheet is not present, access doesn't throw any error, but hang on the instruction related to the missing... -
R
Count Query from two tables
I have TableA with CityCode (indexed, no duplicates, Primary Key) CityType (duplicates ok) TableB, with CityCode (indexed, duplicates OK) StreetCode (indexed, No Duplicates, Primary Key) A One to Many relation between Tables on City Code In need to feed a cell table with the value of the... -
R
Calculated Fields Error
I have the following: A form containing a textbox [OrgIn] that takes values "", "OS ", "OF ", "OT " based on a combobox A query containing various fields from tables and calculated fieelds too. Query calculated Field: Age: .... Query calculated Field: Gender: ... Age and gender are not... -
R
3 table relationship
Table 1 contains State codes - Text - 2chr - Indexed - No Duplicates State names - Text Table 2 contains State Codes - text - 2 chr - Indexed - Duplicates OK City Codes - Numeric - Indexed - Duplicates OK - Format 000 City Name - text Table 3 contains Branch Code - Numeric - Indexed -... -
R
Not able to set date field to Null value
I have a form that runs a search query. I have an error trap set on a date field. If (DataErr = 2113) Then Select Case Screen.ActiveControl.Name Case "DA_Start" MsgBox "invalid date", vbExclamation Me.DA_Start. = Null End Select Response = acDataErrContinue End If End Sub This will pop up...