Search results

Our company (~1600 users) has many Access 2003 (mdb) files, that contain plenty of VBA and ADO via SQL Server. Currently they work OK in Office 2007. But the company is moving to Office 2010. Has anybody experience with mdbs in Office 2010 environment? Any problems? Thanks

Not exactly. I added <br> tags to separate lines into strBody and <i> for signature. It looks perfect. Thank you again

Minty - just this line - properties in red tells Outlook that it is HTML format. With mMail .To = strAddress .CC = strCC .Subject = strSubject .BodyFormat = olFormatHTML .HTMLBody = strBody .Send End With arnelgp - good suggestion, I did not...

Our Access 2003 application generates emails by using VBA. The sending part of the code looks like that: Set mMail = appOutlook.CreateItem(olMailItem) With mMail .To = strAddress .CC = strCC .Subject = strSubject .Body = strBody .Send End With Our...

It's solved - on current we read the value of case# and the rest is easy. Thank you for your help? Uncle and arnelgp! Your friend valeryk2000

OK. I'll try it later (now busy with turkey stuff :-)

No, I did not. Can you give me a snippet?

Uncle, You got it right. We have case# on the form. List box has related button 'Save Selections'. Selections (Item ID) are inserted into table tblCaseItems ((c) - Gizmo ;-). If the user clicks the button again - the first step is Delete from tblCaseItems where case#= current case# and then -...

The table has two fields - many-to-one - Case # may have many item IDs.

We have a multiselect list box. User can select several items and insert them into a table (two fields, item ID and case ID) using Currentdb.execute "insert into ...". Later, when the user select the case again, how to make items selected according to the item IDs from the table? Thanks

I fixed the problem removing tblFollowup and adding its fields to the main table. Without this join the form revived. Thanks

Yes it can. But new fields do not have values because of the numb controls. I'll try to redesign the whole thing tomorrow and I'll let you know when (not IF!) it's fixed. Thanks

No, I created controls from scratch. There is no VBA - just a query

Hi, my form consited of 4 pages and controlled by query (joined 2 tables). I added a new table to the query and another page to the form . This page contains several controls (option, check boxes, combo boxes, text boxes) with source - fields of a new table added to the query. None of the...

To skikelp: This is the query (returns one unit to each EncounterNumber - no duplicates!): ============ SELECT EncounterNumber, Unit FROM (SELECT t.EncounterNumber, Unit FROM tblPatientUnits AS t INNER JOIN (SELECT tblPatientUnits.EncounterNumber, min(tblPatientUnits.DateOfEntry) AS MinDate...

This is my query: =============== UPDATE tblMortalityReview INNER JOIN qryInitialUnit ON tblMortalityReview.EncounterNumber = qryInitialUnit.EncounterNumber SET tblMortalityReview.InitialUnit = qryInitialUnit.Unit; ============== Why it is not "updatable"? Thanks

You are right. I changed the module name and it works now! Thanks

I inherited Access 2003 database with autoexec on startup. It already contained RunCode function - it worked OK. I added a new function - and within the macro it is OK. However the macro stucks at this point with the popup: "The expression you entered has a function name that database can't...

And ... is there a way to assign recordset fields to controls (sorry for being so stupid)? THanks

I work with SQL Server 2008 with Access 2007 front end (using ADO). I can easily populate form controls using recordset. It does not look like I can do the same with reports. May be I am missing something? Thanks people