Search results

Sorry for asking...why would you need to open the same database 2x on one machine at the same time? Just wondering

Maximum...see the screenies I posted. Look this word doc i just attached didnt either...

I am going nuts here, am I not able to compress mdb files with Winzip. I have trying to do this for 2hours now and it does not work. The zip file is the same size as the original mdb file... Anyone have any thoughts on this...

I had thought about that due to the fact of how I was doing it, regarding numbers and text in a dropdown and using functions counting that. I will do that. Thanks for the suggestion.

Thanks. I use this on Excel but seems to be different. =IF(ISERROR((L4-L6)/L6),(L4*100%),((L4-L6)/L6)) Now I tried this instead: =IIf(isNumeric([TimeFrame])=True,DateAdd("m",[Time Frame],Now()),"N/A") Because the Time Frame is just numbers 1-60 in a dropdown box. It also has the "Closed...

Well been thinking... You know with all the spam here, we should make a game out of it somehow, cause I have a feeling its not going to stop or be taken care of anytime soon. Hell who ever ever replies to it first gets 10pts, 2nd =7pts...blah blah... Then cause since this is a Access...

Well its prob a little insulting and such...but yea...check out the new one, make a better one and then make them pay for it!!!!haha

Hello, I have a "Estimated Closing" area on my form. It takes the closing months and adds it to the now() function. Now when you select time frame, it works fine. However I also have "Closed Sale" and "Lost Sale" in that list as well and when chosen i get this "#Error" because its text...

Thank you. That did it. I am rather new and really appreciate it. Thanks.

Thanks for answers. Ok, I tried to check out the examples on that lesbans but they wouldnt open. So is this on the right path: Like "*" & [Forms]![frmMain]![txtSearch2] & "*" & Format("Amount","$#,##0") Thanks as well for help. What would that be called, I assume its under "format" when...

Ok. Then here is where I am trying to prevent it from showing in my frmmain: This is my query search which is for my frmmain: This is the design of that: Would this be the area where I could change that, somewhere within these? Thanks.

Hello, Dont understand what is controlling these decimals. I dont need any decimals for this database. The currency is talking bout money in 1000's and the probability is whole numbers. Here is where I cant get the decimals to stop: I have tried different things but no luck...anyone...

Thank you for the response. That does take care of this, making the ID appear as the text, but it also makes this dropdown box not work. I have then tried to change this to several different things with no success. I have tried to change the bound to on that column but am stuck. Seems as...

Ok thought I had it, but have another issue. When I select the classification in Client Information it works just fine. However on the list in and in the database it uses the ID and not the words. I have tried everything, and dont know why it is doing this. It is the only one that is putting...

Nevermind Bob....ugh found my issue. Sorry and thank you for trying to help me through this. My masterlocation should be: \\nas\trustdivision\DivsionShare\Monthly Tracking\Pipeline Report NOT: \\nas\trustdivision\DivsionShare\Pipeline Report IT WORKS GREAT NOW!!! Thanks for the help I...

Oops sorry, Ok. I have the screenshots from my s-masterlocation. The first one is from the shared drive which holds my master. The second copy is from my local FE copy on C: Drive. Ok. It doesnt actually delete my copy untill I double click the "UpdateFEdb Command script" that shows up in...

Ok. The master FE/BE and MDE are located here: \\nas\trustdivision\DivsionShare\Pipeline Report FOLDER I have copied the FE MDE to my C: Drive here: C:\Databases\Pipeline Reports FOLDER When I use my shortcut that opens my local copy on C: Drive, it deletes my copy and does not copy a new...

Hello, Ok. I redid the Auto Update Install via the gui. I now get the following. SEE ATTACHED SCREENSHOTS in ZIP It gives me the pop up saying that my FE is out of date. It closes. Deletes my old FE on my C: Drive and doesnt not copy the new one. I have attached screenshots for further...

Ok I now have it set up like the above and for some reason the Auto Update Utility isnt working. Here is my s_masterlocation: \\nas\trustdivision\DivsionShare\Monthly Tracking\Pipeline Report Any idea for somethign to try? I think I have everything setup ok...anyone know regarding how this...

I bet it will grow on you in due time....:D