Search results for query: *

SESaskDFC and ifix1, Yes that is it thanks a lot. I just could not remember. Tofias1

Hello, to all and thanks for looking at my problem in advance. I can't for the life of me remember the Run command to change the setting in the startup menu i.e. regedit etc. If anyone could refresh my memory it would be greatly appreciated. Thanks Tofias1

Sorry for being so late in my reply but thanks to all of you who answered my question. All responses were greatly appreciated and have a great weekend. Tofias1

Hello, and as always I would like to say thank you in advance to everyone who takes a look at my question. A tiff file is opened by the Document Imaging File that is provide with Office XP. Now here lies my question. What other application can open a tiff file other than the one provided (if...

KUZZ, Try using Me.FLAG.Value = 1 and the same for Frame59 also get rid of the brackets. It sounds like Access is not recognizing those fields to that form. Hope this helps also put Me. in front of the visibles too. This should work because the code looks right in the first part however the...

zrobinso, I had the same problem and solved it through VB. What I did was lock the form from resizing. Then once the form opened another one I minimized the main form. Then on Close of form opened I restored the Main form. The code is as follows. 'open form through button. Sub buttons...

at51178, Hey this will work if you want to set the search by Text2 the code will place the action of the search in the text2. However, I am not sure why you would want to type anything in text1 if it is already in text2. The setfocus will take care of it so if there is sugar in text2 and you...

mrtauntaun, I am pretty sure that you can only run an append query once. Then what happens is it just re-enters the same data into the tbl. You could take all the data from your db and put it into a Excel sheet with column headings and add the other data into the sheet and then import the...

LiamOC, If I understand your question correctly you can link the table from the closed mdb to the open one. Once that is done you create querries to view the data. That is one way to do it. Also see Microsoft Help about linking tables. This will show you the correct way to do it. Hope...

SBendBuckeye, Hey, I tried calling the ArchiveDate() from the File_Description Lost Focus and wouldn't you know. It worked. Although I thought there would be an easier way but this works. Private Sub ArchiveDate_Click() Dim Holdvalue As String Dim FutureDate As Date Holdvalue =...

SBendBuckeye, Hey thanks for all the help. I have tried testing the code by changing the field values. That did not work either but I will try the other events to see if they work. So I will keep you posted (no pun intended) Tofias1

SBendBuckeye, Thanks again, Here it is. Private Sub File_Description_AfterUpdate() Dim FutureDate As Date FutureDate = #12/31/2099# If Me.File_Description.Value = "Perm File" Then ExpectedArchiveDate = FutureDate Else ExpectedArchiveDate = "" End If...

SBendBuckeye, I have tried it again and to my dismay no luck. The code only works on the on click event. I also tried on the Forms After Update but that did not work either causing a lot of problems. I thought at first it would work on the Form_Current too but again no luck. Should I go...

SBendBuckeye, Thanks for the reply. I have tried to do that but it does not seem to work. Here is another question for you as to why this may not be working. I probably should have said this in my 1'st post. The File_Description field is set to a predefined tbl. With a set of desciptions...

Hello to everyone who takes a look at my question and thanks in advance. I have written this code for a date field. Once the value of one field changes I would like the value of the date field to default to a set date. So once the field 'File_Description' = "Perm File". This will...

redaccess, Try this code behind your button. It should work just fine. Private Sub "ButtonName"_Click() 'button name without quotes stDocName = "Form to open" 'With quotes DoCmd.RunCommand acCmdSaveRecord 'Forces form to save record DoCmd.Minimize 'Minimzes the form...

FancyPrairie, Thanks again. I will test this out and let you know how it worked. Tofias1

Divinedar0956, You need to go to the Tools option within Mircrosoft VBA code builder. Choose References then scroll down the list and choose Microsoft DAO 3.6 Object Library. This should work. Also check on Help within the code builder and type in recordset and it will explain to you why you...

FancyPrairie, Thanks for the response. After doing more research I found out how to protect the db using that option. On the other hand you brought up a great point about having the user create their own reports. Where would I find info on implementing code like that? I have a lot of VBA...

CVigil, Can this also be done by spliting the database? Tofias1