Search results for query: *

Nice Bob....Thanks!!!! I took your advice and went with the Recordset option. Have a star bud. Charles

Bob, You seem to know what I'm trying to do. I've created a form that has 2 combo boxes and one text box. The second combo box is based on the results of combo box one. I want the text in the text box to be taken from a seperate table based on what is chosen in combo box 2(the source data...

Hello, I have tried to populate a text box based off what is selected from one of my combo boxes. I used help from this link http://www.tek-tips.com/viewthread.cfm?SQID=431685&SPID=702&newpid=702&page=3 The information worked fine except that the data that shows up in the text box isn't...

Jeremy, gave you a star thanks again!!

Alrighty... thanks Jeremy... you put me on to the right path. I actually had to uncheck the missing References on the list because it was causing some sort of conflict. I appreciate the assistance. Thanks again

Thanks for replying so quickly Steve. I get an error message: Function is not available in expressions in query expression 'Left([Mname],1) I have tried repairing and compacting and Access says the operation completed successfully. Thanks

Hello.... I'm trying to extract the first letter of a Middle Name field for use on a report. In a query I set the field to MiddleName: Left([Mname],1) Then on the report based on the query created above I created a text field and set it's control source to MiddleName This was working...

Sorry for not getting back to you sooner.... Thank you very much for your help Lonnie! It worked perfectly! I've been out of this for a bit so it's like learning it all over. Thanks again

Hello... I'm trying to create a check box that when checked will open a picture window on the form that can be linked to that person's photo. The box needs to remain hidden on all other records except the one(s) where the check box is checked. Any help would be appreciated. Thanks

Bill, I managed to get the database to work. The problem was indeed the References. The common dialog was not referenced and so I had to get the comdlg32.ocx file and install it. I do not use the designer version of Access so I imagine the libraries are not being taken along with the...

Thanks for the reply Que.... what would have to be altered to allow this code to work with a unified database? Thanks again Charles

Bill thanks again for your help.... you did help me out partially that's what the star was for. I was wondering if I might be having reference problems. What are the references that the database should be showing? Thanks Charles

Bill, Let me first thank you for responding to my post with a very indepth and informative coverage of the Common Dialog. I will show you the code I am using. This code is begun when a command button is clicked and opens a dialog box allowing the user to select the path to an outside...

I created a database on a machine that had Windows 98 using Office 2000. I took this database to a Windows XP machine that has Office 2000 and the Common Dialog box button that I had made does not work. Can anyone tell me why and how to correct this problem? Will this happen if I install the...

CMoore thanks for the reply .... I tried the SendKeys macro you suggested but that just allows the user to save the form that's open and not the entire database. I would like a way to save or back-up the entire database the individual is working in from the click of a button. Thanks

I would like to make a button on a form (or toolbar) that will open a drive box and allow the user to save/backup the database they are working on to the path of their choosing. Any help would be appreciated Thanks

Allanon, That coding worked but when the second table is being imported I get an error message saying that object tbSoldierIMPORT already exists. Could this be because there's no coding telling it to create the second table in the database I'm importing to? Thanks Charles

Allanon, Works Great!!!! I'm learning.... just one more obstacle for me to overcome. The table I'm importing has a table it shares information with. Can I import that table along with the main table? If so how? Thanks Charles

Allanon, I pasted all of the following into a module but changed the names of a couple of files. The OnClick works.. it opens the dialog box and allows me to choose the database I want to use. After selecting the database to import from I get the following error: Microsoft Jet Database...

Thanks again Allanon. Linking the tables would work great but I'd have to have a way to allow the user to choose the path to get to the Access 97 Database. What I have done is made an updated Office 2000 version of an Office 97 database currently in use. I made an installation program for the...