Search results

That sounds interesting. Well in this case I dont have access to the codeo f the front end, but I can tell that it is using crystal reports. Does this mean I can drag their existing reports into Access and have a look? This will cut hours and hours off my work. How do I do this, what are the...

Yeah thats what I thought... however 'path' doesnt appear in the look up list for the application object... I tried using it anyway opentextfile(application.path + "\log.txt",8,0) for example, however I get a "Method of Data member not found" error.

In this case, there are no docs or anything. I do have access to the front end, but not the code or any developer options or help as such. Only actually using it as if I were a user of the system. So yeah that makes it a difficult project. If I wasnt able to at least use the front-end tho, I...

Ahh.. Yeah thanks.. my mind is blank today.. I knew it would be simple.. :D

Yeah I agree, there is no easy way. The main reason I started this topic was out of interest tho, just to see what other peoples thoughts on reverse engineering are, as I thought it'd make a good read. I am currently trying to get a database to have some extra reports. This is hard because...

Anyone that has had to reverse engineer an existing database should know that it can be a difficult and complicated task. Especially when you are dealing with a database that has been made in a less than desirable fashion (eg, poor relationships, no commenting, wierd tablenames and field...

This seems like an easy question, but i have no idea how to do it... If I have a field for the [costprice] and [soldprice], I can work out the profit by calculating [soldprice]-[costprice]. So, if costprice=60, soldprice=120... profit=60. In this case the profit margin was 100% of the...

openTextFile I am using a method called 'OpenTextFile' and it lets me append to a text file. Now I can log what is happening on the database... However one thing; as you'd expect you must specify the name and path of the textfile to append to eg "c:\textfile.txt". I was wondering if there is...

Hi.. Was wondering if it is possible to make it so you can save or copy the text from the immediate window into a text file or somewhere else in code???

i have another question.. is it possible to set a field so that if the number is less than 0 it is stored as 0 (ie so negative numbers are stored as zero)?

ah i see, it turns out i would have had to set the 'limit to list' value to false...

hey thats good... also it looks like you haveanswered another question i have been wanting to know for ages (changing colour for record depending on value). i will test it out.. thanks a lot!

I figured it out: =IIf(([recieved]-[ordered])>0,"+" & [recieved]-[ordered],[recieved]-[ordered]) Easy :)

Is it possible to format a number field so that a positive (+) symbol appears before a positive number, just like a negative (-) symbol appears before a negative number.

you said the coding is different in later versions of access? i have 2002, but I also work on 2000 format dbs often. Would the above code work on either of these?

i dont know, but i also would really like to be able to do that, so let me know too if you find out

what do you mean by "But when you go back to change the county for a previously entered state, the county combo has the values of the last entered state"? How are you going back to the previously entered state? Via the naviagtion buttons at the bottom of the form? Have you entered any code in...

a way...? well its a form, just with the default view as datasheet, sorry. i think i found a way to do it tho, by having the colour combo box type as value list, and then inserting the values from a related table in code (.additem) it seems to solve the problem.

oh yeah, heres the picture

I have two combo boxes on a form. one is products, the other is colours. products looks up all the products from the products table colours looks up all the colours that are related the the selected product. I set the row source for colour like this: SELECT colours.colourID...