Howdy folks, I know it's only Tuesday and I bet y'all are busier than a one-armed paper-hanger, but I need some help when you have some spare time. I have a...
j- If Unit is always a 5-digit value that follows the word "Unit" and a blank, then use: Unit: IIF(Instr([DEPT], "Unit ") > 0, Mid([DEPT], Instr([DEPT], "Unit...
I have some queries that for example in a date field I put [ENTER THE DATE]. After awhile, when I enter the date, it will come back and ask me the date a...
I have seen this happen sometimes for a paramter query used for a report - you get prompted more than once when the report opens. You can often avoid the...
I think that what you want to do is a bit too complicated for a query. It would be better to write a sub-routine. Just create a form with one command button on...
Guy, Thanks a bunch for the code and the instructions on where to put it. It looks like a lot of work on your part...but I do appreciate it. I'll give it a go....
Hi John, Does it mean the hosted Web Server or the Service Provider needs to have MDAC, and my MSFrontPage should include DAO and JET driver to be able to...
Arnold- Yes, the Web Server must support MDAC and the Front Page extensions. FrontPage already understands JET, but I believe it uses ADO under the covers to...
Dear all, I would like to have my *.MDB to be able to execute by itself on a machine that does not have Access2000 or XP. Previously John Viescas and some...
I just realized that I forgot the following code at the end of the code: rs.close Set rs = nothing Set dbs = nothing It just makes sure everything is cleaned...
John, A big thanks to you for given me a clearer picture so far...... Cheers! ~Arnold~ John Viescas <JohnV@...> wrote: Arnold- Yes, the Web Server must...
Arnold- The actual package you need to buy depends on the version of Access you're using. For versions 2002 and prior, there has always been a "Developer" ...
Dear John, So, what is your best recommendation; either to get license for Access2003 or 2002 (in OfficeXP Pro). Which is more feasible in terms of cost wise...
I want my ms acces front end refresh/reconect its linked table as it open. i'm using ms acces as back end database. Can anyone show me the code? thanks in...
Below is a combination of two lots of code that I was given some time ago. It sits in a module. It uses the OpenLink function to check if the tables are...
Thank you! for your time I'm making a table not a form or data access page, just a table. My problem was i have multiple department and under every department ...
Arnold- For 2003, you need Visual Studio Tools for the Microsoft Office System - $499 unless you have previously purchased a "developer toolkit." It does NOT...
Can't be done in a table. See also: http://www.mvps.org/access/lookupfields.htm .. which clearly says you should never define a lookup in a table. To do what...
Hi. I am new at this. I have a database and I need to create a form that the user can type in the (lastname) in a textbox and then click on a search button. ...
Dear All I have try to develop a program using access, and it's contains a module...I protect the module with a password but unfortunatelly I forgot the...
Thank you. but i still have problems. My beck end ms access data base is password protected. and there are more than one table to link. please give me addition...
The code I gave you will handle the linking of all tables that have previously been linked using the Database Linked Table Manager (Tools > Database Utilities...
Hi, First name the text field in your form as Lastname and open your query view, write in the criteria for Lastname as follows Forms![Formname]![Lastname],...
I am using my Office Developer package that I received over a year ago for the first time. I have created a runtime version of my application. The guide was...
Dear John, Boy! What happen to my current well run database, if I have to convert them by using "all the codings"? I mean by any chance I may screw up the...
The code does link through all the tables, but it doesn't supply a password. You can supply it as part of the Connect string in this statement: tdf.Connect =...
Arnold- To successfully package your application to be installed on a machine that does not have Access, your application must be prepared to run in Runtime ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
