Search results

Cheers Rural Guy;)

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?

did the database start life in aprevious version of access. All my access 2000 databases cannot be made mdes in access 2003 unless they have first be converted to access 2003 databases.

Keith I was using qryTwo as the ODBC one. If I use qryOne, that was how I started off when I first had the problem.

I created two queries, qryOne as follows: SELECT tblProjects.CH_CODE, tblProjects.CH_NAME, replace_chr13([CH_DESCRIPTION]) AS Address FROM tblProjects; Then made another query based on this one (qryTwo) I then tried to connect to qryTwo externally using ODBC. qryTwo is as follows: SELECT...

Thanks Keith I fear you may be right, but I just tried your method of using the user defined function in one query and then creating a pass through query with it and I still get the same error. Does anyone know a way of replacing a SQL Char(13) in a string with a "," without using a user...

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 spent quite a lot of time searching. I have found solutions for not counting weekends, solutions for not counting standard "bank" holidays. But I am yet to see a solution for user defined holidays. My solution is certainly too slow, with 100 records and an average difference between...

Brianwarnock I implemented your method and it works fine! Having looked at Ancientones method, i can see how that would work also, so will probably do that next! Thanks for all your help. Sametch:)

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...

This post is probably getting a little long, which I am not knocking because some useful stuff has come out of it. But if I take it back to the start the real issue I have is this: For a table which has a list of start and end dates (there could be thousands of them) I need to be able to...

Yeh Right! I just about coped with trig at school, never could manage, circles and things, so i'll leave that one to you then Mile-O-Phile;)