Search results

I am looking at it now. It is a very cool tool, however, I am having a hard time understanding the implementation of such a tool. Would I save this just on the shared drive as well and add the database name that we have to the main screen and then it will auto back it up? Or do I need to copy...

It is backed up along with the rest of the shared drive at whatever intervals the company has set. Management, however, has requested that our own backup be made just in case anything happens to the original, it would be much faster and easier to access our own backup compared through going...

Hi RainLover- Was there supposed to be something attached to your last post? It just says "This was easy to find". What are you referring to?

RainLover - Thanks for the reply. If this is a shared database though (i.e. saved on a shared drive across our company) and is opened by different users on different machines would I still be able to use the task manager? Or could I create a separate database and save that to the same folder on...

Hi Forum - I have tried numerous searches for this topic but can't find anything specific for Access 2007. I would like to be able to write a script in my Access 2007 database to create an automatic backup in a specified folder at a specific time each night (i.e. 9 pm every night) and delete...

Nevermind. I misread your post a couple of times! I know understand what you are doing. I tested it and it works great. Thanks so much!:)

That makes a lot of sense. I would like to proceed with your method of pulling in the records. My one remaining question though is in your following post are you mixing in my method and your method? Would your method just be to use the following: If Not rstfiltered.EOF Then If Not...

Hi pbaldy - What does EOF mean? And what does testing for it do? Also, you say in parenthesis "less efficient". Is there a more efficient way to test for the two conditions? Thanks for your help!

Thanks pbaldy for your response. When you say add the criteria to the SQL above and test for EOF what do you mean? Sorry I am relatively new to VBA and DAO. Also, I fixed the bracket issue and tried the NoMatch function versus null and still am getting an error. The error is coming up on the...

Hello - I have a table in Access that I have a form saving new records to. Before this save occurs, I would like Access to check if the account number already exists and if the account does exist if it is outstanding. If both of those conditions are met I would like a message box to display...

Thank you, BigHappyDaddy. This solved my problem. That is good to know for the future to remove the "_" and end all if statements if trying to perform a nested if statement. Thanks again everyone for your help! :)

Thanks Ken for your response. Can you elaborate a little on your suggested method? I think I understand what you mean but I don't know what it would look like in code form. Do you mean that if the condition is false then go to the true part of the code? Sorry if the question is elementary, I'm...

Hi Forum - I have a module that saves a worksheet to an Access database. That part is working. Now I would like to add a couple of controls into the module to check for correct values. There is one field "Request Status" that is updated by the user as well as a "Last Modified Date" field that...

Thank you, Namliam. That makes a lot of sense. My one question is, when you do the debug.print for each of the fields, do those debug.prints print to the textboxes on the lookup form? If not automatically, is there a way to debug.print to a specific location on a form? Thanks again! EDIT: I...

Not sure if I should post a completely new thread or not on this issue, but because it is related I will just include it a continuation of this thread from earlier today.... As it can be seen the code I put together I am performing multiple Dlookups to pull in the data to the form from the...

I was actually able to figure it out! After much research I was able to find that if a textbox had a value in it previously using IsNull will not work properly for whatever reason. As a workaround, I then used Len(NZ(...)) to do a count of the number of characters in the textbox. If that was...

Hi Brian: I coded it with the three null tests at the beginning because I wasn't sure how to code it the way I logically thought it out - with saying if the first condition is not met skip to the next test. Is there functionality like that in VBA that I could employ here?

Pr2-eugin: Sorry, I know the code is clunky and difficult to follow! The basic flow of the process that I would like to follow is: 1. Check if CD# Input box is filled in. a. If No: Skip to step 2 b. If Yes: Check if that CD # is associated with a logged request. If No: Display...

Pr2-eugin: Sorry about that! Completely forgot to paste the code! I submitted a reply but it says that a moderator needs to approve it first. So hopefully that will appear on the thread soon! namilam: Thank you for your suggestion. Can you help me with an example of that that would look like...

My apologies! I completely forgot to paste it in! On Error Resume Next If IsNull(Me.cd_number_lookup) Then If IsNull(Me.tcsf_number_lookup) Then If IsNull(DLookup("[Packet #]", "tblclstrack", "[Packet #]=" & Forms![Form_Lookup].packet_number_lookup)) Then MsgBox...