Search results

It seems i found it The group name is a local (report) calculated field. It is not coming from the query. Access displays properly the report, but when data is exported, the above output comes out. The workaround is to calculate the field inside the query and pull it into the report. But if you...

No such situation Please explain what do you think may produce this output while exporting the report

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 &...

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...

My workaround was this I created an expression filed in the query Sex: IIf(Left([Membri_Partid]![CNP],1) Mod 2=0,2,1) and filtered it with Like IIf([Forms]![Cautare_Membru_Frm].[Gender]=0,"*",[Forms]![Cautare_Membru_Frm].[Gender]) Nice and smooth, without those tons of IIf's I am trying now...

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...

On a second thought I deliver the application as .accdr in order to give access to all users without having them forced to install Ms Access. Anyway, they must (at least) download and install Access Runtime. Now... Is there a component or something that may be embedded in the accdr file, or...

I should, but what error to trap since none is thrown up by access :banghead:... If i get the tiniest error message or behavior other then the stall, the problem is solved. But I have none...

CJ, both links indicates that Excel must be installed in order to use the component...

yes... checked No error handler that may mask the message DoCmd.SetWarnings True Set some progress beeps to check where i loose control The SOB is hanging on the DoCmd.Transfersheet that contains the name of the missing spreadshett...

Don't have any idea how to achieve this without opening the wb... early or late binding are both opening the object, yet I don't know if any of these processes are possible without having excel installed on the machine (as I told you, there is a slight possibility that the user don't have office...

The problem comes from that "open workbook" part. In order to use this approach, the user must have office installed and also must have the proper version of excel. The database is running in runtime mode, in order to avoid any Access version conflicts and to be able to import/export data...

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...

Table 1 PK [CityCode]___Type 001_________A 002_________A 003_________B 004_________B 005_________A 006_________B Table 1 FK______________________PK CityCode___Street________[Street Code] 001_______Main__________ 001.1 001_______51'st__________001.2 001_______52'nd_________ 001.3...

an unbound form field ...

let me restate... In need to feed a cell table with the count of the records in table B, Column StreetCode, under condition "CityType = 'Large'" from Table A. Again, the two tables are related via CityCode.

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...

Age and gender are localy calculated fields, not part of a table. Age: Formula based on table cells Gender: ... that is the problem

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...

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 -...