Search results

Pls note that this is more a VBA (Access) related question, but since my posting in the access forums didn't yield any results so far, someone suggested I'd more likely to get help for this in the VB Forum. Sorry for the cross posting, but I'd really like to solve this one asap) The Problem I...

Hi there, I have a medecine table with records already tagged in HTML, for example the field named Description: <h3>ABILIFY - <em>B-MS</em></h3> <p><em>Antipsychotic</em> <br /> For Adults. Oral Use. </p> ... I would like to be able to display this text on my form. Using Data Access Pages...

Hi there, I have a form with an imageframe and 2 buttons which allow the user to either Clip (Me.Im1.SizeMode = acOLESizeClip) or Stretch (Me.Im1.SizeMode = acOLESizeStretch) the image. In design view SizeMode is set to Clip. My prob is that when the user clicks Stretch, the image stretches...

Hi there, I copied the code from www.everythingaccess.com which should enable one to suppress the annoying security warning in outlook, but I can only get it to work if I start Outlook up beforehand. With OL not running I get a 438 error saying the object does not accept this method/property...

Hi there, THE GIVENS: The following query works fine: SELECT tblProjectSteps.ProjectID, tblProjectSteps.StepID,..., NZ(DSum("Total","tblPayments","ProjectID=" & [ProjectID] & " AND StepID =" & [StepID],0)+ NZ(DSum("Total","tblReceivables","ProjectID=" & [ProjectID] & " AND StepID =" &...

Hi there, I'm experementing these days with msde, since I feel it's time for me now to move to client/server developement. I upsized a test.mdb to msde (after all the recommended preps, mostly gleaned from this forum) and kept the fe in mdb format. All worked fine, but then I thought: what if I...

Hello there, I've lately come across some posts that condemn using lookup fields in tables. But how bad is this really? I mean it's quite a nifty feature, and it'd be really too bad if it hogs up resources, thus forcing us to leave it alone for performance considerations. I'd appreciate if...

Hi there, I have a form with the DataEntry property set to True. I suppose this guarantees that the (whole) rs of the underlying table is not loaded into memory. Say that, after I've filled in a new record this way and saved it, I want to go to a new record via "DoCmd.GoToRecord, , acNew"...

--Access 2003 winxp Pro SP2-- Hi there, this apparently simple problem had me stay up all night without finding the solution, neither by myself nor by searching this forum or the web. Say I have 2 loaded forms: TopForm and BottomForm. BottomForm has an unbound textbox txtRefValue, in which I...

Hi there, is it at all possible to use variables in sql? Please consider the following snippet: ... (WHERE [DateDue] < Date())... The idea is to return a recordset where the DateDue is prior to the current date. But sometimes I need the opposite, ie a recordset where DateDue is in the future...

Hi there, What happened with the Access Data Project sample (Northwind.adp) in Access 2007? I searched Microsoft for a download but couldn't find any; can anyone tell where to get one for Access 2007? Thanks, Jaime

Hi guys, I'm a bit confused: I know that opening a bound form will bring down the whole recordset. But if I create a parametered query as the recordsource, will it still bring down the whole recordset first and only afterwards cut down to the records matching the parameters? Example: I have a...

Hi folks, I need to generate a write instruction that writes strings to a file without appending string quotes to it and also allows me to put ; as a delimiter instead of just a comma. For example: Dim hFile As Long Dim v1 as string Dim v2 as string hFile = FreeFile v1 = "text1" v2 =...

Hi guys, I was looking for a way to trap err.number 3314 (when required field is null) before Jet generates its warning. I came across an old post from Rich (below), but I couldn't make it work as yet. In the calling form, under the Form_Error event I wrote the following: Dim f As Form Set f =...