Recent content by Villarreal68

Hello everyone, I'm amazed at the amount of knowledge you all dish out! This is the reason why I posted my question here. You all have different levels of knowledge and experience that I can use to make the best decision. Thank you all for your feedback! The_Doc_Man: I will definitively...

Colin thank you for your response. I'll take a look at the Youtube videos. Thank you for making reference to them.

Hello Colin thank you for responding. I would love to go into Java or PHP or some other programming language, but I was given the requirement that the training needed to be "Access Related". So I'm trying my best to learn something new and still make it relevant. So I figured I could learn SQL...

Hello everyone, I have been working with Access for some years now and I have created a few interesting and beneficial dbs for the company. I started with single user db, then multi user, then front-end and back-end dbs. I initially got started thanks to this forum and I don't think I would...

thank you jdraw. I'll take a look as soon as I get back to work on Tuesday. Off for a well deserved weekend. �� Have a great weekend!

Hello everyone, I have been tasked to create a Web Search Emulation of some sort. I'm wondering if I could do it with Access. Any thoughts, suggestions or recommendations are appreciated. I'm thinking if I create a start page with a search field where the user can enter any word they would...

Well I think I just fixed it in a different way than I was visualizing: I was visualizing some code in the On Click code to ignore when the sub-form was empty, but I just changed the code on the Double Click to go straight to the sub-form ID field. I hope this doesn't bite me later. :)...

Hello everyone, I have a dilema and I hope someone can help me... I have a simple event on the On Click of a sub-form in datasheet view. When someone single clicks the sub-form I have the following code: This code is sort of a pre-setup for a "Double-Click" which opens an Edit Window that...

Thank you Pbaldy!!!!! This was driving me insane! Question: How can I force the fields to NOT be seen as text, but rather number fields? Thanks again! Edit: Got it! I manually changed all fields to "General Number " format and that did it without the CCur. Thanks for your help Pbaldy!

Hello everyone, I've tried many things (compact and repair, Nz(,0), sum()) and I can't get it to work. I entered =[field1]+[field2] but it behaves like if I had entered =[Field1] & [Field2]. Yes instead of adding the numbers it just puts them together. For example: Field1=3 and Field2=5...

Pat, Thanks for responding. Interesting suggestion. I'm currently looking into that. I think it will work! Thank you!

Hello Spike and Pat, First thank you for respondig. Spike, The reason I was given the task was due to budgeting. Some research was done on some applications, but either cost or "not what we want" was the factor. One big issue with online apps is the fact that the network were this will...

Hello everyone, I've been seaching this site for some direction on previous posts, but I have not found what I'm looking for. I figure someone might be able to point me in the right direction. I posted in the General Forum because I'm not sure where to post it. I'm working on a scheduling...

Hello Paul, Thanks for replying. Well it looks like it's working (partially). This is what it is: There is a report built on C1ReportDesigner tapping into an SQLExpress database that needed to be modified to meet some new needs. I have never used C1ReportDesigner, so I was trying to apply...

Hello everyone, I'm working on an SQL Statment that has a month and year request, but I want to change it to request a date range. The statment is as follows: PARAMETERS [Enter Month] Integer, [Enter Year] Integer; SELECT vWorkOrders.StatusCode AS Status, vWorkOrders.StatusDescription...