Search results

Thank you, but I tried the second option suggested on the site you gave me but my new field only returns 0's. I have a PaymentID and a LoanID field that I said to count whenever they're not the same (which they never are) but for some reason it's not working. Below is the SQL I added into my...

I have a query that shows everything I want it to except give me a Descending count. I have my criteria on it and it's sorted the way I want, now I just want to add another column that begins at 1 and counts down from there. i.e. - If there are 5 records in my query, this new column will show...

Hello, I'm trying to take a couple Microsoft Word documents and put them into an Access Report. When I try to copy and paste, Access shrinks my page. What do I need to do in order to get it in there and keep it the same size? Thanks

Got it. Thank you very much, I got too frustrated and now I am again for trying to make it so complicated! Thank you much. Good day

Youre absolutely right, it could change from client to client, thank you. But now I'm having another problem with my code, even though there is an If statement that explictly states what I want it to look for, every record in my table is being updated. The data doesn't even fit my If statement...

thank you, both of you. I tried what bama suggested and it worked great, I just saw doc's posting when I went to reply and i'm going to try that as well. thanks again guys!

Hi everyone, I have a little problem. So i'm working on a DB where it keeps track of loans and if a balance is still unpaid after 10 days then a late fee of $100 is added to it. The code in red below I have running on Open of the form and it works but obviously it updates EVERY time you open the...

Maybe I spoke too soon, everything that you helped me with works, except the form still remembers the customer name entered and won't allow me to enter a different customer name until I close and re-open my form. The button that calls this has this code behind it: Me.Filter = "[CustomerName]...

SOS thank you very much, this works great!

Okay so 2 problems, first I want to apply a filter to a bound form that shows the dates that lie within a specific range. That range is the current year, current month and any day. I can't figure out the correct VBA for it, below is what I have. DoCmd.ApplyFilter , "[DateEnd] = Between...

I guess I tried to change too much. Paul, Dan and Rookie thank you all so much. For anyone else looking at this, I tried Dan's method and it worked also. Thanks again!

Paul, I'm doing something wrong, access says "Object doesn't support this property or method" when I try and run this code. Here is how I changed your code to fit for me: Dim rs As Object Dim lngBookmark As Long 'set a variable to the current record lngBookmark = Me.LoanID 'open the new form...

Paul, That worked thank you. One more question though, is there anyway that you know of to do this without filtering? For example if FormOne is on record 23 of 50 when you click the button to open FormTwo, FormTwo opens to record 23 of 50 as well. The reason I ask is because I have an If Else...

Hello Everyone, So I have 2 forms, nearly identical to each other. On the first form the user finds the record they want by the field "LoanID" and if they wish to edit the loan information they click a button which opens up the second form. What I need is for the second form to open up to the...

Okay, I see what happened. Thank you so much John, everything works perfectly!

John, thank you very much for this, it's very helpful! I'm trying right now to fit the code into access and am having a little trouble. First, the compiler highlights everything you call at the beginning of the code that has a comma after it: Public Function GetBillableDays(dteBegin As Date...

Great John thank you, this works to break up the months. Still leaves me with one problem that maybe you know how to solve. I need it to count the number of days that are in each of the CDate() provided months. So for example if the BeginDate is 5/20/2009 and the EndDate is 7/20/2009 it would...

Here is my problem. I have a lot of different fields that all revolve around two date fields, BeginDate and EndDate. The user enters information into both these fields along with other data. My problem is that I need the begin and endDates that they enter to be broken up by months. For example...

Why don't you run a DDL query? A Data Definition Language query edits tables, fields, rows, relationships from writing SQL. If you want to delete your MDP table using VBA then try this: docmd.setwarnings false 'so access wont prompt you when executing docmd.runsql ("DROP TABLE MDP;") 'if...

Brian- If I might pick your brain one more time please… On my form I have the fields CustomerID, LoanBeginDate, NoOfMonths (unbound, just used to calc LoanEndDate), PrincipleAmt, & InterestRate so when filled in I click the update button that runs VBA RunSQL code to automatically update the...