Search results

It's a whole new mindset I went through the transition you're talking about 4 years ago. I had written myriad applications in dBase (III+ &IV), some for commercial clients, but more and more people wanted to run Microsoft Office (and Access.) "Conversions" - even done manually - were not...

Thanks to everyone - here's the solution Thanks to all for the suggestions. I'm posting my final solution so that it might help others as well. What was apparently happening is that although the name selection combobox was being sorted alpha and was bound to the studentID field, the form had...

Thanks -- looking further I even pasted your attachment into my application and it didn't cure the problem. On its own, it works fine. I agree that maybe the problem lies elsewhere, perhaps on the Open or Load form event or the way I'm saving prior work even before shutdown. I've requeried...

checked column count The column count = 2. Width = 0" (hidden studentID);1" Bound column 1 RowSource as shown in Nouba's suggestion above.

Not yet Thanks for the reply. I understand where you're coming from and it sure looked like you had the solution. I tried it and I still get the same result. The StudentID is an autonumber. If I delete the lowest one on a trial basis, it goes to the next lowest etc. I can set the combobox...

I have a combobox that opens when a form opens. It has a studentID (hidden) and an expression for LastName&Firstname as shown in this SQL. I have it sorted alpha on the names. When the combo opens it is alpha but shows the name of the Lowest StudentID. I would like it to show the lowest ALPHA...

Uninstall XP first My new computer came with OfficeXP pre-installed but with the CD-ROM's still in their original shrinkwrap (Thank you, Gateway-some companies don't supply the copy). I uninstalled the whole OfficeXP and then installed 97, then 2000, and then re-installed the XP (from the...

Front end on server is sometimes only choice I created a system for teachers to create purchase orders and split it into FE/BE(tables). Both parts were put on a server. Teachers could access the front end from any one of the district's computers (over 400 in offices, labs, classrooms etc) so...

Can be done -- not easy This could be done easily in Ac97, but starting with Ac2000 things got much more complicated as Ac2000 was designed for a more robust environment. Try this link. It explains your problem and how to solve it. http://support.microsoft.com/default.aspx?scid=kb;EN-US;200290

Reply Rob.Mills input order I never used to apply RI, but I have in the last year and it has made life a lot easier. To see how useful it is, set it up on a system that has been running a few years without it and even if it has had the most careful input you can imagine, you will still have to...

A97 & XP Pro work fine When I upgraded to my new XP Pro computer, I had the Office 2002 bundle installed at a discount. Most of my clients still use either A97 or A2K. To get everything to work, I uninstalled the Office 2002 (before I registered it so I can use it later or on another...

I have an option group that adds shipping charges after all items are ordered. See below: Private Sub Frame95_Click() If Me!Frame95 = 1 Then Me!txtOrd_Shipping = 0 End If If Me!Frame95 = 2 Then Me!txtOrd_Shipping = Me!frmOrderDetailSub!Text19 * 0.1 'rem Text19 = total...

Check your joins Rather than get into a long discussion on how to send your project to this forum, the answer to your original question is to examine your join types in your queries. Altho you frequently use the first type, if you have a many to many relationship (or even one to many) this...

Not elegant - just quick and dirty One way to do this is to write a very small autoexec.bat on the user's computer that assigns a subdirectory to a drive letter on the server. For example, keep the user's FE/BE on a local drive such as C:\myprograms. If your network drive is F:, the batch...

Don't dismiss running both If you really need to keep some of the Access97, don't dismiss the idea of keeping both systems. I do it and it has caused no problems. Just install 97 first and then install 2K in a NEW directory. This prevents the override. Since your operation has the path in...

I tried to set up a 2 computer network at my house and somehow locked myself out of the linked table manager. When I try to link (or get external data) I get the message "You do not have access to the folder C:\Documents and Settings\Administrator\My Documents\*.mdb. See your administrator for...

Renaming helped, still not there yet I followed your advice. The renaming helped, but I couldn't simulate the path until I hooked up a spare computer as my simulated server and did the sharing on that one. I've been wanting to set up a network anyway to get my wife off my main computer and...

I have a database application that I write on a stand-alone computer and then ship and install on a network. The back-end is on the network server. I could simulate drive letters (F:, L:, N: etc) on the stand-alone and do the linking before I shipped the app to the network. Now I find I must...

Load 97 first The Knowledge Base has a number of suggestions, but the one that finally worked for me was to clear both from the computer and then load 97 first as a standard install. Then load the 2K but as a "Custom" install in a directory NOT "Office" (I made one up as Office2K). They...

I would like to open a report on the screen at about 90% zoom. Access has a zoom command, but it does not have the 90% setting, only 50-75-100-150-200 etc. For example the command below works for 75% in the OnClick event that opens a report. DoCmd.RunCommand acCmdZoom75 There is NO ac...