Search results for query: *

With help from tek-tips users I have successfully created a function called CalculateAll that carries out a number of calculations based on a value in a recordreturning the results in an array from which I extract values to populate fields on a form at the on current event. calcfield(0)...

Easy one I am certain but I cannot solve it - I have a form based on a query and all works well but if the query returns no results I get a blank form - how can I prevent the form opening (or make it close) if there is no data present? I have tried Private Sub Form_Load() If...

I have a problem with Access after recent MS updates - images cannot be displayed on forms and i receive an error message saying that the images are too large. The code is VBA and is linked to the onCurrent event but as the code has previously worked perfectly well for 4+ years I am certain it...

Way out of my depth here so all help gratefully received. I have an application that requires multiple calculations on any particular record and my function takes details from the open form, calculates and returns the values in an array - works great. Problem I have now is that I would like to...

An old and until now reliable function has suddenly started to return an error "invalid procedure name or argument" Public Function nextdemand(per, dat) As Date Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Numbr As Integer Dim msg As String Numbr = 1 If per = "2"...

For the first time I am trying to use Like in VBA to do a flexible search on a database and to a point it works... but only to a point and I am sure that I must be missing something obvious. By way of explanation I am looking to open a form which contains a reference, a property address and a...

After 2 years my project suddenly wont work with graphic files and wont recognise jpg or if files to embed. Any ideas why and particularly why now?

For reasons I cannot fathom my call to Word has ceased to function the following code results in: compile error: user-defined type not defined. Private Sub Command18_Click() Dim objWord As Word.Application I am presumably missing something very obvious so any assistance welcomed

Stupid question time - is it possible to write to a file from a server to a local PC or write to a file on the server then download to the local PC using FTP functions. What I am looking to do is compare data held in an SQL database online with an Access equivalent on my laptop. The current...

Help - I am having a mental block - I have an input form where I can define search criteria and all works fine but I want to make the search a little more flexible so that I can search for parts of names - equivalent to like "*" & [enter detail] & "*" in a query. Assistance please. Current...

I am moving away from macros etc into the exciting new world of VBA but being self taught I am struggling with some of the basics for now. I have routines that open tables and move through the records which work perfectly well such as Set db = CurrentDb Set rst =...

I am using the replace command to remove html coding from a text file used as a memo field in another application which I am now using for my own purposes. Being very very new to code I have a list of replacements such as stripfile = replace(stripfile, "</font>", "") stripfile =...

I have a query that extracts data from text based memo fields (created by somebody else) originally designed to create html pages. My query strips out the html code using: stripfile = replace(stripfile, "</font>", "") I now want to take this further by introducing formatting depending on the...

I have two applications both of which use access to some degree and hold pretty much the same information but currently do totally different things. One is an application of my own and the other is a product supplied by a third party. I am looking to combine the databases by linking to their...

Very new to all this so please forgive any apparently silly questions or bad use of technical expressions. I have controls on a form which I wish to enable or disable depending on data content - for example no point displaying a picture box if no picture. On a single form I have happily...

I have to run same pages on a laptop and a high res monitor so I want to dynamically alter font sizes graphic dimensions etc depending on screen resolution. My solution so far is to read the screen height or width and call a PHP page with appropriate variables even to the extent of opening an...

I am having problems with reports on a tried & tested Access 2000 application when trying to run it under Vista. All other functions are fine but I can't view edit or even design reports - anybody had similar problems or have any solutions please.

I have an access 2000 application which we are asking to work under Vista. All seems well until we try to do anything with reports - we cannot run any existing reports or open any in design view. We cannot create new reports either. All other functions appear fine - any ideas please?

My site incorporates somebody elses page in an iframe - great when all is working well but they are having server problems which means their page is occasionally off-line. Is it possible to test whether the page is available and load an alternative page if it is not?

Is it possible to have hyperlinks to two URLS from one click? I have a page with two target frames and most of the time I update one or the other but I have one application which would be really effective if I could update frame 1 with one URL and frame 2 with a different one all from the click...