Search results

You might have to set both the router and your computers (especially if laptops) to disable the wireless. Most laptops use some type of FN key sequence to toggle the wireless on and off.

I have a report that has 2 fields of interest. One is [AmtChk] and the other is [CheckNum] (an alpha text field). What I want to do is set a condition based on the first letter in [CheckNum] that changes the color of the [AmtChk]. This is used to flag different accounts. For example if a...

Make your personal computer act like the linked directory. Done properly you won't have to re-link if that is where your problem lies. Make a folder on your harddrive to copy the backend with the linked tables. Example: c:\Datafolder\Application_be.mdb From the DOS command line (or a simple...

I really don't understand what you are saying. My users are logged into a Novell network. Security is in the permissions they are given at that login. The program is used in a school district and only teachers and administrators have access to the directory where the program (both fe & be and...

I went to the Microsoft knowledge base (304408) and found a routine that automatically logs off users with a short warning. It works fine, but depends on the presence or absence of a small text file which is named chkfile.ozx. The file is referenced in a form timer function as follows: Dim...

Compact and Repair may not delete hammered record If you have the problem I alluded to above, the C&R may not fix it. Scan through your records on the "One" side and look for some weird characters or, maybe, ###### etc. Delete this record and then do the C & R. Depending on the error, I've...

Make your computer act like the linked directory Make a folder on your harddrive to copy the backend with the linked tables. Example: c:\Datafolder\Application_be.mdb From the DOS command line (or a simple .bat file) use the DOS subst command. Example: subst f: c:\DataFolder where f is...

This also would work: Criteria--> like [Input Shift 1,2,3 Blank=All]&"*"

Thank you This was just what I was looking for. I don't think I would have come up with the clever combination of 2 queries, the DCount function and a separate crosstab on my own. Very clever and elegant in its simplicity. I haven't run across anything like it before.

I am preparing mailing label for a political campaign. On my list of voters, many times two or more people are listed at a single address. By consolidating the labels (and postage) I am able to save a lot of money. I have written a query to group these names into those with 1,2, or 3 or...

I had this problem when network latency ( or some other as yet to be found problem) caused an "orphan" record on the many side to be created without a good corresponding one record. Once this broke the cascading relationship, the relationships disappeared. Solution was to go in and delete the...

I ran into similar problems with a number of "free" pdf writers I found on the web. I eventually bit the bullet and BOUGHT Adobe Professional Writer. They seem to have anticipated cross platform problems and solve them before you even know you had one. Sometimes, you really do get what you...

I had a similar problem in an ordering database. The user first put in company info (name, address etc.) and I generated a unique primary key with autonumbers for this order. This was then related (one to many) to an order details table with the items to be ordered. Each item had a...

Use the On Format of the report Assuming that all of the transactions are being shown in the Detail section of your report, set an event in the Detail Format for the report. I select by a date that is no earlier than a date I select in the form that I use to call the report. For example...

Simple fix I ran into this problem when I deleted some early records and their autonumbers (1-200 etc.) in a table of a few thousand. It started to put new autonumbers at about 100 and eventually crashed when existing autonumbers eventually caused duplicates. My autonumbers were not important...

Unless I'm missing something, it seems that if you wrote the system as part of your employment, used it when you were working and are being asked to "convert" it on your employer's time, you have little ground to complain. When the new system is implemented, it would be an opportunity for you...

Front end on the desktop would be better but... The reason I keep the front-end on the server is that this application serves a school district with 5 schools and many hundreds of computers that are found in offices, classrooms and labs. Only selected personnel can create orders, but they can...

I have an orders database using Ac2K. Main tables are: tblOrders: Has OrderID which is autonumber, key index (no duplicates) tblOrderDetail: Has OrderDetailID --long integer Tables are related in one to many relationships on OrderID-OrderDetailID with both cascades set. Database is split with...

I have a table with the following fields for each record: StudentID CsrID Average FinalExam For most StudentID/CsrID there are two records, one with the Average and a null FinalExam, one with the FinalExam and a null Average. If there is no FinalExam, no record is...

I have an application running on a network with 5-10 simultaneous users. Main tables are "Orders" and "OrderDetails" in a one to many relationship with integrity set. For some reason (possibly network problems) a few "OrderDetails" got created without corresponding "Orders" in spite of the...