Search results

Hi All! I have Access 97 client and server databases linked together. My system is setup so the database is aware of how many users are currently logged in so Ill know when it is being used exclusively. What I want is some code to check every week that a repair and compact has been performed...

Hi All! This to me seems absolutely bizzare! It happens in both Access 97 and Access 2003 so I know its not a version issue. I have a Access database with a link table to a spreadsheet. I have written a query which displays data from this link table which filters out blank rows, the...

This Is My Log On Code......... This is my log on code and there is a similar on for logging off. In built is a check to see if the system still thinks a user is logged on when the log on date is not today (ie they crashed out!) as each user should shut down each night. It utilises a further...

Hi All! I have written a call log system in Access 97 for a busy customer help desk. Now I never bind any of my forms as I like to use VBA code to verify the entry first before writing it to the table. However, every now and then that million to one shot occasion occurs where 2 help desk...

Any help most appreciated! I have a Access 2003 database I am developing which has a table called "tbl_users" in which I have the fields: user name(text), network id(text), status(yes/no), long on time (date/time), log on date(date/time), log off time(date/time), log off date(date/time). When...

In The Usa? Ive always wanted to visit the states so pay me to come fix it!!!! Failing that one thing I find that usually helps with multi user access environments is NEVER bind forms. Use VBA to write records back to the database once the code has verified the data is ok. I have wrote a...

Dear Readers! I have been developing Access databases for a number of years now but naively even though I use a number of database and recordset calls repeatedly within those databases I define them each time ie: DIM MYDB AS DATABASE SET MYDB = CURRENTDB() DIM MYTABLE AS RECORDSET SET...

This Is How! Create the following function: DIM MYDB AS DATABASE DIM SOURCE AS RECORDSET DIM TARGET AS RECORDSET SET MYDB = CURRENTDB() SET SOURCE = MYDB.OPENRECORDSET("{name of table A}") SET TARGET = MYDB.OPENRECORDSET("{name of table B}") SOURCE.MOVEFIRST DO UNTIL SOURCE.EOF...

Many Thanks! Thank you very much for your assistance Ill give it a try! Regards.

Hi All! Can anyone help with the following problem? When clicking a button on a form the code behind that button minimizes that form and loads a second form which just has a label on it stating "Please Wait........" and then my database carries out a number of functions. However, it takes a...

I Would........ I would create a query based on the table listing all of the record numbers in ascending order. Change the autonumber field concerned to a number, long field. When writing a record: DIM MYDB AS DATABASE DIM SOURCE AS RECORDSET DIM TARGET AS RECORDSET SET MYDB = CURRENTDB()...

Try This! OK so you have a order table...Purchase Order Number, Quantity. Create a label table and purchase order number selection form possibly with a combo box listing all purchase order numbers then put this code behine a print labels button on that form. DIM MYDB AS DATABASE DIM SOURCE AS...

Controlling Data Entered By Code This is really where unbound forms come into there own. If you create a save record button as apposed to having a bound form allowing you to create data straight away into a table you can code this button to check each field prior to writting to the table...

Try This............. I would have a second hidden field generating a auto number. Then within a query check for the length of this auto number field and add the correct number of leading zeros and insert into the the field you want to display.... IF LEN([AUTO NUMBER FIELD])=1,"000" & [AUTO...

Is it possible to import the objects from a Access 2000 format MSE file into a blank mdb file access database? Is there a clever gismo to do this? Help! Regards, DALIEN51

Using Access 97 I wish to create an ID number on a form and then click a button wich creates a matching folder name within my windows folder structure. Also this needs to check if the folder already exists and so in this case to take no action. I have also got a button which opens a Microsoft...

The Answer Is................. The reason is one of your objects isnt ticked in your reference list at home. Within the code view under debug i think it is you will find an objects list or reference list. There will be an item not ticked at home that you have ticked at work. So check which...

I have been tasked with amending a database written by my predeccesor in Microsoft Access 97. However, he has not prefixed any of his tables, queries or forms or report names which I was always taught was fundemental to database design. I want tbl_ before each table name, Qry_ before each...

Yes You Can Turn Them Off! Either call the query from a macro and insert a line before the call of your query "setwarnings" and set to false. or In code "docmd.setwarnings" false if in code. Regards, NEIL

Could You...........? Hi, Just a thought, could you not write an update query for each field which you run in turn after the import exchanging #num for null? Regards, NEIL