Search results for query: *

Hi, I have something rather strange going on: If I double-click on any .accdb to open, I end up getting a DDE time-out error. Doesn't matter if the files are local or on a server, split or one piece. If I start Access 2007 first and then 'file open' the same .accdb or any other .accdb, they...

Hi, For some reason on a few machines including mine, warnings seem to have been disabled - no prompts when running update, append queries and the like. Warnings work fine on other machines running the same database. This is Access 2007 Error checking is enabled with the exception of...

Hi, I posted this question in the Access Reports forum and while an alternative solution was posted, I am still curious as to if this can be done. I have an Ole field in an Access table with one bitmap embedded. What I would like to do is to be able to read the contents of the table field into...

Hello, I have an image stored as an ole Object in a table which changes periodically (for report logos). I would like to be able to use an unbound image control and use a lookup to display the image stored in the table. To date I have been unable to do this programmatically. My workaround has...

Hello, what I would like to do is open a front end and get the front end's physical location. Something like: Private Sub Form_Load() msgbox "I am located here: " & dir(me) 'my directory path End Sub ...but I don't quite know how to work that out. Thanks, dRahme

I don't know why this never occured to me, but instead of stacking buttons, change the button caption of one button and what it does: Dim ctl As Control Select Case Me.cmdInfo.Caption Case Is = "How It Works" For Each ctl In...

Hello, I have a bit of a cosmetic problem. I have an unbound form that loads another form on open. The other form has no borders and to the viewer this form appears as one single form. This all works as it should. The problem is, is there a method for placing the second form in a relative...

Hi, I am using NVU and am trying to install adsense on a web page. I followed the instructions from a wiki site and saved the adsense code from google as adsense.js, uploaded it, etc. What I don't understand is how to call it, in that I need to place the line of code that calls the js script...

Hi, is there an equivalent command to docmd.Maximize using html? There are some instances where I would like to open a page full screen, instead of minimized. Thanks, dRahme

Hello, I am trying to troubleshoot a query and it involves a cross-tab and I have little experience with cross-tabs The query I am trying to run is qryDrawingCurveActual : SELECT DrawingCurveActualTable.Date...

Hello, I am a little stuck. I dim a number of abbreviations as strings. I update various fields in a table based on these dim's. The routine works perfectly until I get to one that says 'where xyz = EL, which is a two character text code and then I get a data type mismatch. There are seven...

Hi, I am using NVU to practice with and this is probably a newbie question. My wife wants to list some twenty rose photos and display a large picture for each rose. I was thinking the way to do this would be to have one image frame and then populate it based on the picture selection.. Can I...

Hi, I am pretty much a newbie at this stuff and am using NVU to practice with. My question is, if you set a link to open in a new window, can you size the window to fit the graphic? A 6" Graphic contained within a 6" window so you don't see the dead space, for example. Thanks, drahme

Hi, management has fallen in love with pop-up calendars for the various forms that require a date entry. After making 5 of these, with the prospect of making many more, it occured to me that there may be a method for using the same calendar for several forms. The calendar would need to...

Hello, I have a small procedure that checks for the existance of a drive and directory: Dim objfso As New FileSystemObject If objfso.DriveExists("s:") Then If Dir("s:\Warranty\", vbDirectory) = "" Then Me.lblSdrive.Caption = "No Warranty Directory Installed on S...

Hello, I rarely use memo fields and inherited a table that contains a memo field. This memo field if set to Can Grow on a report will in some cases easily span the equivalent of two to three pages. It also locks up the report. The report is set to print one record per page. If I size the...

Hello, I would like to get away from outputting reports to snapshot format. Due to cost concerns and my vb limitations, I would like to output to pdf using a printer driver such as Pdf995 or Cutepdf if this is possible. Can someone point me in a direction where I might find some assistance...

Hello, I have a number of MS Access tables with hyperlinks to .pdf files. The links worked fine with Standard Version 6. With Standard Version 7 they do not. Adobe starts and then shuts down. If I reload Version 6 all works as it should.. I suspect this is a security issue of some sort but...

Hello, this is a new one for me. When I change the View in the database window to 'Details' the window goes blank. The vertical slide bar suggests the forms, queries, etc are still there but nothing is visible. If I flip to List or Icons, the files display properly. If I flip to Details, they...

Thought I'd pass this along - worked for me. I did some modifications to a 2002 db, got ready to ship it to the field as .mde and Access kept crashing on conversion to .mde. No obvious problems or reason for this. Decompiled as well - still crashed. Ran the performance analyzer & no problems...