Search results for query: *

Hi All What I have is a table with a list of Function, what I'm trying to do is loop through the table an CALL each Function in turn if it is marked as "Active". My idea was instead of Function names, have Macro names, these macros would contain the Function I want to run. I could...

All I've built a little apps which has the MS calander on it, the problem is that when I run it on either NT or Office 2000 machines the Days don't appear in the calander. I have had some success by coping my mscal.ocx file in to the problem machines but this doesn't work all the time. Can...

Hi all I have a apps that is currently used by 14 users. I have just tried to roll it out to a further 4 users but I'm getting a "Runtime error #6#, Overflow" messege on startup. Has many one come across this error before? Would it be something to so with the different build of...

Morning All In Excel you can use the following to return a true or False statement if a number is EVEN or not: =IsEven(3) - this returns False How can I do the same thing in code. I'm trying to use it within a Select Case or If statement. For Example: Select case !VersionNo case isEven...

Hi all I'm trying to build a frontend that connects to an Access db. The apps will receive data from the db as well as pass data to it, therefore I need the connection to be active all the time will the frontend is loaded. My question is : Is there a way dropping the users connection of...

Hi all Sorry if this is a stupid request.... I would like to store list of data from a recordset in an app I'm trying to build, and use it at a later date. I've been trying with arrays....is this the way forward? Any help would be use full PS I only want to open the rs once (on open)

How can I return a users NT or W2k login id to a form Many Thanks Jon

Can anyone help me I want to loop through a number of files within a DIR and open the one that has todays date @ the end + .txt Any Ideas Jon

Hi I have an Access db that is fed by data from a number of Excel forms in turn we then periodically feed this data into an Oracle db using a front-end in the Access db. Once this has occurred I want a tbl within Access to be updated with confirmation code which comes from the Oracle db...

Hi all I have a query that I wish to run but not open, how do I do this??? Thanks Jon

Hi all I have 2 queries, they both have the same amount of fields (Field A has the products name, and field 2 has the sum total of products bought). The data for each of these tables comes from different sources. Here's my problem I want to be able to take the results of 2 queries and find...

Hi all I was playing around with the properties on a form & I ticked the hide attribute. Now I can't seem to unhide the dame thing ..... Please help me Thanks Jon

Hi all I'm sure this is very easy but I'm ill and I just can't work it out!!! I need to update a table using data from a second table, so how do I use a SELCT statement in conjunction with an UPDATE statement. NB: I'm using an access database Please help, once this is sorted I can go...

Hi all Can you use IF statements with select statements so that, a error messege appears in place of the selected data if that data doesn't exist. Any help or pointer please Jon

Hi all What is the VBA code for removing forms and code from a project. I've managed to add them but I'm now stuck. Please help Thanks Jon

Hi all What I would like to do it reset the autonumber either at the start of the day or when it reaches 9999 . any idea people Thanks Jon

Hi all I would like to write some code that would to the same job as SaveAs\Export. I want to be able to save a tables contents as a .csv file. Can anyonr help me? Thanks Jon

Hi All I've got a table that contains a field which has dates in it. What I need is for those dates to been shown like YYYYMMDD (20010601) and not 06/01/01. The data comes from an Oracle database. How can I turn the inserted dates into the format I require. Thanks Jon

Hi all I'm trying to do a simple delete where statement using SQL in Access. The problem is that I want to delete everything that is not equal to todays date (system date). delete from tableA where Input_Date <> SYSTEM DATE How do I write system date? HELP THANKS Jon

HI ALL I'M A BIT NEW TO ACCESS SO SORRY ABOUT THIS REQUEST I HAVE 2 TABLES AND THROUGH OUT THE DAY I WISH TO UPDATE THE SECOND TABLE WITH NEW DATA IN THE FIRST TABLE. THE DATA HAS GOT A ID NUMBER, SO I WOULD LIKE TO DO SOMETHING LIKE THIS INSERT INTO TABLEA SELECT * FROM TABLE WHERE...