Search results

Works great, but.... Using the Dmax function in the control source was just what I needed and I added a criteria that let me select one of three accounts this database tracks. I'll be using this technique over and over again! Thank you. It let me erase the query (which had the DMax function)...

I have a database that essentially is a complete check printer and check register. I have a query (qryLastCheck) that returns the variable LastCheckNumPrinted which I would like to use as the starting point for automatically adding +1 for a new check. I also want to see this as a value on my...

I have a command button that runs an append query in its On_Click event. I need to make sure it is only clicked once. I've tried to make the button disabled or invisible, but I get the error message that I can't do that with the focus on the control. I'd like a simple solution that doesn't...

Assign virtual drive -- link is automatic Not elegant - just quick and dirty One way to do this is to write a very small autoexec.bat on the your home computer that assigns a subdirectory to a drive letter that matches the server. For example, keep the home copy FE/BE on a local drive such as...

Use a group query for your combo source Create a query from your table and group by the salutation. Use this as the datasource for the combobox. This will limit your combobox list to one occurence of each salutation. The advantage here is that if you get something unusual or unexpected (eg...

I am working on a school database which has two tables (tblStudents and tblParents). What I need is a field to link each student to his parents and each parent to their child. BUT, it's no longer one set of parents to a set of children. Many children have two (or more with foster care and/or...

Use both I have both versions on my computer because I have clients that use one or the other of the versions. Backend tables in Ac97 can be read easily in either version, but if you make changes using Ac2002 to an Ac97 front end, that front end becomes unusable in in Ac97. It can be...

VPN in this thread Follow this thread and it will eventually lead you to a possible solution using a VPN system if you have the system requirements in place. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53304&highlight=VPN

Try the old DOS subst command I don't know how you are "mapping" the z-drive to your local c-drive. I develop networked programs on my local computer by using the old DOS subst command to make a local directory mimic the network drive. For example, in a batch (.BAT) file I run the following...

Can be done, but not easy Ac2K has many more restrictions on multiuser changes to the database. The link below tells you all about it. When you get done reading it, you'll probably agree that WayneRyan's method may be the better way (or ONLY way!) to go...

Install 97 at home as well The downward conversion works but it is not without problems. I have had trouble with the linked table manager (assuming you are using a split database) and the calendar controls. If you install Ac97 first and then Ac2000 in separate directories, they co-exist nicely...

Split your database Why not split the tables and leave them in Ac97 format. You can then make either a Ac97 or Ac2K front end and link to the tables in the backend. Ac2K reads the old tables with no trouble and you can still make changes to the front end if you need to. Caution: Some...

Try this thread This is a known bug in early versions of Ac2K. Follow this thread for ways to get around it. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51536

Re-compile Try hitting Alt-F11 to open Debug and under Tools recompile the database. If it stops, you can sometimes get an idea what's wrong. I use this to find objects (eg command buttons etc.) on a form, but have forgotten to delete the On-Click code behind them.

Set Up Virtual Private Network If you are running Windows XP Professional, setting up the VPN can be done quite readily using the included wizard. This would give you a very fast and secure method to do what you want. I don't know how to do this (or even if you can) with other versions of...

I have just converted and compiled a major application from Ac 97 to Ac 2K. It has been installed on a network with linked tables on the network drive and front ends on individual computers. Users are getting 2 errors: Linked table manager won't open and many reports etc have "Unknown function...

Quick & Dirty Work around here I get the error when I copy, paste, and modify a report (usually to make a duplicate report that is similar to the first one) and then add a button to open the report. This puts an event procedure into code when I use the command button wizard. If I save and...

Found a free one I came across this free program on another board (don't remember which one) but the author name and free use permissions are included in the file I've attached. I've used it and it works fine. It still amazes me that there aren't more like it out there somewhere.

I may have mis-read what you want, but why not use the Form's On current event to tie the combobox to any changes in the bound field on the form. Example, if Combo01 is used to select an unbound record (in an AfterUpdate Event etc), put this in the On_Current Event for the form...

I've searched the archives and a seemingly simple solution still evades me. I have a report that essentially prints envelopes and has one textbox, control source=fldZip, that prints the USA zip code (5 or 5+4). I want to also print the postal barcode on the line below based on the value of...