Search results

I have a form with a combo box control that I want to disable for all current records to prevent accidental changes, but I need to enable it when a user adds a new record. Is there a way to detect if the current record is a new record so i can change the controls properties using VBA.

I have a text box in a report with the can grow property set to yes. It is unbound and I assign its contents using VBA using the "detail on print" event. All works fine as long as line spacing = 0cm. As soon as the value of the line spacing is increased (to anything other than 0) the control...

I am creating a database where the user stores filenames for images. I also need to store the width and height of the images in pixels. Is there any way to automatically obtain this information rather than having to browse for the file and look at the files properties?

I am trying to run a query in an Access Database from another program using ODBC. The query contains a user defined function and works fine when I run it in Access. When I try to run the same query externally via ODBC I get the following error: "ERROR 1 - [Microsoft][ODBC Microsoft Access...

I am trying to run a query in an Access Database from another program using ODBC. The query contains a user defined function and works fine when I run it in Access. When I try to run the same query externally via ODBC I get the following error: "ERROR 1 - [Microsoft][ODBC Microsoft Access...

Please Ignore this one it is an accidental duplicate, my attempt to post failed and invited me to refresh, but when I did I ended up with the same question posted twice. I am trying to run a query in an Access Database from another program using ODBC. The query contains a user defined...

I am using a common dialog API to allow users to attach multiple images to a record. I would like the common dialogue box to remember the last folder that was visited (like many windows programs do), so that next time it is used the user can select the next image from the folder they were in...

I have a simple table with two fields. Each record in the table signifies that that the value in field 1 is compatible with the value in field 2. Like this: F1 > Item 1; F2 > Item 2 F1 > Item 1; F2 > Item 5 F1 > Item 1; F2 > Item 6 F1 > Item 1; F2 > Item 9 F1 > Item 2; F2 > Item 4 F1 > Item 2...

I need to import the contents of a large "space" delimited file into an access database. The problem I have is some lines contain a comma and when they do the input # function splits them into seperate lines which messes up what I am doing. Is there any other way of importing a text file line...

I usually create split databases with tables seperated from forms, reports, queries etc. I need to be able to replicate one of my split database designs. Does anyone know if this is possible? Do I replicate the front end or back end? :confused:

I have a requirement to report improvement scores for each person for each month. Typical data is 1 may 2003 person 1 score 35 5 may 2003 person 1 score 38 8 may 2003 person 1 score 42 1 june 2003 person 1 score 49 5 june 2003 person 1 score 60 4 may 2003 person 2 score 24 6...

I have created a number of simple crosstab queries. Each has one set of column headings and one set of row heading. For example quantity of different case types handled by worker in one month. When I try to create a report on any of these queries, I am unable to. If I use the report wizard...

I have an array which holds dates as variants and I want to compare each with "real" dates held in a date field. My routine keeps throwing up a data missmatch error. Is there anything I can do to make them both look the same for a successful comparison.

I am designing a relational database for keeping appointment details. I have a parent table with person details and a child page with appointment details. A simplistic design of the two tables is shown below: tblPersonDetails PersonID: FirstName: LastName: InitialContactDate...

I am coming back to designing Access databases after a 3 year break. So I am very rusty. I need to be able to detect if the current record is a new record. I seam to recall this was very easy with a one line statement in the onCurrent event. But I just can't remember it and I am struggling to...

I have a number of tabbed pages on a form. Not all are needed at all times. I would like to be able to disable or make invisible non relavent tab pages depending upon the selection of a combo box outside the tab suing VBA. I am using Access 2000. Is this possible? If so could someone please...

I have a field for entering URL's and I would like to detect if a user accidentally types in a "space" character and either prompt them with a message box or replace the space with _ Does anyone know how I can detect the prescence of a space character in a string using VBA