Search results

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...

What??? - I logged in to congratulate him on his MVP recognition here: http://blogs.msdn.com/access/archive/2010/01/15/access-mvp-recognition.aspx Well we all have dreams to fullfill and responsabilities to attend to. I would like to thank you Bob for all the help you offered me on my...

Hello everyone, I'm working on a database for a friend that is an older person (technically challenged) and I'm trying to make it as easy aspoisslbe for him. I've run into an issue that I cant figure out how to solve. The following code works perfect (thanks to all the code in this site's...

Sorry to have confused you. When I re-read your comment and found the following quoted text: I realized I may have just reiterated what you had already stated. So I deleted the post right away thiking that maybe noone had seen it already...notthinking that you would have received an email...

I figured a way to resolve the issue. i'm not sure if its the best way, but it works. here's what I did: I added a textbox called [txtTotalAsignedList] that gave a total count of the AsignedList listbox then I added another textbox called [txtAvailableSeats] that did the math of...

Hello Scooterbug, Thanks for the response. Yes I figure I would have to do a compare to acomplish this, but I'm not sure how to code that. Would something like this is the way to go?: Dim varitem As Variant Dim varitem1 As Variant Dim count As Integer Dim count1 As Integer Dim rsCM As...